Author Topic: 1054 Unknown column 'product_canon_category_id' in 'field list'  (Read 1432 times)

MAD King

  • Jr. Member
  • **
  • Posts: 327
  • VirtueMart Version: Latest
1054 Unknown column 'product_canon_category_id' in 'field list'
« on: September 20, 2018, 20:01:17 pm »
Hello,

after updating to VM 3.4.0 with the latest AIO on Joomla 3.8.12, I get this error when trying to save a product.

Quote
An error has occurred.
1054 Unknown column 'product_canon_category_id' in 'field list'


stAn99

  • Contributing Developer
  • Jr. Member
  • *
  • Posts: 81
    • One Page Checkout for Virtuemart 2
Re: 1054 Unknown column 'product_canon_category_id' in 'field list'
« Reply #1 on: September 20, 2018, 21:18:09 pm »
hello, when you updated VM, did you get any errors during the update process, such as "generic table updater not found" ?

i suggest to install the zip once again over your installation.

vm team leader suggests to use "vm db tools" and click "update tables"

in my opinion since i believe you got an error during the installation the "db tools" may still be using some of your previous vm files and thus i personally believe it's more reliable to install it just once again (without uninstall)

best regards, stan
----
RuposTel.com
www.rupostel.com
Your customized checkout solution for Virtuemart

MAD King

  • Jr. Member
  • **
  • Posts: 327
  • VirtueMart Version: Latest
Re: 1054 Unknown column 'product_canon_category_id' in 'field list'
« Reply #2 on: September 20, 2018, 21:40:25 pm »
Do you mean the whole package?

com_virtuemart.3.4.0.9935_package_or_extract.zip

with everything inside or just the

com_virtuemart.3.4.0.9935_ext_aio.zip ?

AndiLiesfeld

  • Beginner
  • *
  • Posts: 1
  • A beginner
Re: 1054 Unknown column 'product_canon_category_id' in 'field list'
« Reply #3 on: September 20, 2018, 22:48:12 pm »
Hello. Sorry if my English is a little bad but i am from austria.

I have the same Problem. But i have installed the VirtueMart a few days ago. At the first time i can save new Products without Problems - but since today i have this error.


Greets
Andi

MAD King

  • Jr. Member
  • **
  • Posts: 327
  • VirtueMart Version: Latest
Re: 1054 Unknown column 'product_canon_category_id' in 'field list'
« Reply #4 on: September 20, 2018, 23:08:31 pm »
I am from Bavaria, Germany  :)

Mine is working again.
Follow this :


 

i suggest to install the zip once again over your installation.

vm team leader suggests to use "vm db tools" and click "update tables"

in my opinion since i believe you got an error during the installation the "db tools" may still be using some of your previous vm files and thus i personally believe it's more reliable to install it just once again (without uninstall)

best regards, stan

AH

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 2870
  • VirtueMart Version: 3.4
Re: 1054 Unknown column 'product_canon_category_id' in 'field list'
« Reply #5 on: September 21, 2018, 09:48:01 am »
See the post above for solution
regards
A

Joomla 3.9.1
php 7.1