1054 Unknown column 'product_canon_category_id' in 'field list'

[MAD King]

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.

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

[stAn99]

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

[MAD King]

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]

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]

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]

See the post above for solution