VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Topic started by: MAD King on September 20, 2018, 20:01:17 PM

Title: 1054 Unknown column 'product_canon_category_id' in 'field list'
Post by: MAD King 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.

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

Title: Re: 1054 Unknown column 'product_canon_category_id' in 'field list'
Post by: stAn99 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
Title: Re: 1054 Unknown column 'product_canon_category_id' in 'field list'
Post by: MAD King 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 ?
Title: Re: 1054 Unknown column 'product_canon_category_id' in 'field list'
Post by: AndiLiesfeld 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
Title: Re: 1054 Unknown column 'product_canon_category_id' in 'field list'
Post by: MAD King on September 20, 2018, 23:08:31 PM
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
Title: Re: 1054 Unknown column 'product_canon_category_id' in 'field list'
Post by: AH on September 21, 2018, 09:48:01 AM
See the post above for solution