Author Topic: Table Structure NOT UPDATED after VM2>>3 upgrade  (Read 258 times)

AhoyIT

  • Beginner
  • *
  • Posts: 30
Table Structure NOT UPDATED after VM2>>3 upgrade
« on: May 09, 2017, 16:13:40 pm »
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

  • 3rd party VirtueMart Developer
  • Hero Member
  • *
  • Posts: 7441
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 2.6.22 & 3.2.2
Re: Table Structure NOT UPDATED after VM2>>3 upgrade
« Reply #1 on: May 09, 2017, 16:50:43 pm »
why? what are the problems?
GJC Web Design
VirtueMart and Joomla Developers - php developers http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 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
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

AhoyIT

  • Beginner
  • *
  • Posts: 30
Re: Table Structure NOT UPDATED after VM2>>3 upgrade
« Reply #2 on: May 09, 2017, 16:58:48 pm »
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

  • 3rd party VirtueMart Developer
  • Hero Member
  • *
  • Posts: 7441
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 2.6.22 & 3.2.2
Re: Table Structure NOT UPDATED after VM2>>3 upgrade
« Reply #3 on: May 09, 2017, 17:21:47 pm »
and when u run the table updater after dropping it in a clean install?
GJC Web Design
VirtueMart and Joomla Developers - php developers http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 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
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

AhoyIT

  • Beginner
  • *
  • Posts: 30
Re: Table Structure NOT UPDATED after VM2>>3 upgrade
« Reply #4 on: May 09, 2017, 17:27:02 pm »
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

  • Beginner
  • *
  • Posts: 30
Re: Table Structure NOT UPDATED after VM2>>3 upgrade
« Reply #5 on: May 09, 2017, 17:37:01 pm »
p.s.

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

AhoyIT

  • Beginner
  • *
  • Posts: 30
Re: Table Structure NOT UPDATED after VM2>>3 upgrade
« Reply #6 on: May 10, 2017, 11:26:02 am »
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

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 8986
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Table Structure NOT UPDATED after VM2>>3 upgrade
« Reply #7 on: May 15, 2017, 11:56:15 am »
The tableupdater does NOT delete columns! It just renames some. So your old columns stay there
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

AhoyIT

  • Beginner
  • *
  • Posts: 30
Re: Table Structure NOT UPDATED after VM2>>3 upgrade
« Reply #8 on: May 15, 2017, 12:18:15 pm »
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

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 8986
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Table Structure NOT UPDATED after VM2>>3 upgrade
« Reply #9 on: May 15, 2017, 12:32:13 pm »
" which OLD column relates to a new one"

That is wrong
"It just renames some."

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

AhoyIT

  • Beginner
  • *
  • Posts: 30
Re: Table Structure NOT UPDATED after VM2>>3 upgrade
« Reply #10 on: May 15, 2017, 12:49:23 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.