News:

Looking for documentation? Take a look on our wiki

Main Menu

Table Structure NOT UPDATED after VM2>>3 upgrade

Started by AhoyIT, May 09, 2017, 16:13:40 PM

Previous topic - Next topic

AhoyIT

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).

GJC Web Design

GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

AhoyIT

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

GJC Web Design

and when u run the table updater after dropping it in a clean install?
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

AhoyIT

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)

AhoyIT

p.s.

My source VM is version 2.6.8 which isnt on the download section - Can that be the issue?

AhoyIT

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?

Milbo

The tableupdater does NOT delete columns! It just renames some. So your old columns stay there
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

AhoyIT

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.

Milbo

" which OLD column relates to a new one"

That is wrong
"It just renames some."

Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

AhoyIT

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.