1054 Unknown column 'product_canon_category_id' in 'field list'

Started by MAD King, September 20, 2018, 20:01:17 PM

Previous topic - Next topic

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.

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

Joomla! 4.4.5
VirtueMart 4.2.12 11012

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
----
RuposTel.com
www.rupostel.com
Your customized checkout solution for Virtuemart

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 ?
Joomla! 4.4.5
VirtueMart 4.2.12 11012

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 :


Quote from: stAn99 on September 20, 2018, 21:18:09 PM

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
Joomla! 4.4.5
VirtueMart 4.2.12 11012

AH

Regards
A

Joomla 4.4.5
php 8.1