Hello,
On Joomla2.5, after upgrading VM2.6.8 to VM3.2.1 and running all TOOLS apps ("Remove old vm2 inherited customfields", "Update vm2 order format of customfields to vm3 format", "Install or if necessary update tables") - Table structure is still not updated to native VM3.X.
Any idea?
The VM works, but still it doesn't enable to COPY VM DB to a new JOOMLA install (With a clean VM3.21).
why? what are the problems?
A couple of examples:
- "Unknown column 'limit_list_start' in 'field list'" on table "virtuemart_categories"
- "Unknown column 'perms' in 'field list'" on table "virtuemart_vmusers"
Belive this is the table list
virtuemart_adminmenuentries
virtuemart_categories
virtuemart_categories_en_gb
virtuemart_category_categories
virtuemart_category_medias
virtuemart_configs
virtuemart_medias
virtuemart_product_categories
virtuemart_product_medias
virtuemart_product_prices
virtuemart_products
virtuemart_products_en_gb
virtuemart_vendor_medias
virtuemart_vendors
virtuemart_vendors_en_gb
and when u run the table updater after dropping it in a clean install?
The clean install i get the VM3.21 on the go ... Issue is with the upgrade form VM2.68 to VM3.21 in the exisiting install and after runing "table updater" is still remains in old structure and thus i cant copy to new install.
(New install is a QUICKSTART of J|VM tmplate)
p.s.
My source VM is version 2.6.8 which isnt on the download section - Can that be the issue?
Update:
A. I've updated source from J2.5.8/VM2.6.8 to J3.4.1\VM3.0.9 and used VM DB TOOLS to fix.
B. Source is a out-of-the-box QUICKINSTALL of J3.4.1\VM3.0.9
C. Still there is a missmatch in a few VM tables, which doesnt enable full copy
Q's: Can i delete target VM table structure & copy source table STRUCTURE\DATA as is? Would that work? And how can i fix stracutre later on?
The tableupdater does NOT delete columns! It just renames some. So your old columns stay there
Quote from: Milbo on May 15, 2017, 11:56:15 AM
The tableupdater does NOT delete columns! It just renames some. So your old columns stay there
OK - But when i try to MIGRATE it doesnt know which OLD column relates to a new one .. Had to loose some data.
" which OLD column relates to a new one"
That is wrong
"It just renames some."
Quote from: Milbo on May 15, 2017, 12:32:13 PM
" which OLD column relates to a new one"
That is wrong
"It just renames some."
OK - So something went wrong, as the "upgraded VM" with "renamed fields" & when i copied the DB to a new install w/ the same J/VM version failed to work.