Author Topic: error 1054 after update to VM 3.4.0  (Read 373 times)

aLioneL

  • Beginner
  • *
  • Posts: 15
error 1054 after update to VM 3.4.0
« on: September 20, 2018, 10:02:39 am »
Bonjour,
I've just update my VirtueMart to 3.4.0 from my Joomla 3.8.12
And I've got a problem with products : impossible to update product
==> error 1054 : Unknown column 'product_canon_category_id' in 'field list'
I don't know what to do :-(
Thanks by advance for your help
LioneL

AH

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 2811
  • VirtueMart Version: 3.4
Re: error 1054 after update to VM 3.4.0
« Reply #1 on: September 20, 2018, 10:58:06 am »
Check your database product table

virtuemart_products

There should be a field product_canon_category_id in this table
regards
A

Joomla 3.8.13
php 7.1

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9726
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: error 1054 after update to VM 3.4.0
« Reply #2 on: September 20, 2018, 11:04:33 am »
In the tools is a table updater, which should do the job for you.
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

aLioneL

  • Beginner
  • *
  • Posts: 15
Re: error 1054 after update to VM 3.4.0
« Reply #3 on: November 05, 2018, 19:03:03 pm »
it was ...and it is
the Simple Image Gallery Pro from JoomlWorks that poses problem
I desactivated its button ...but I don't think all is ok like this ;-(