News:

Looking for documentation? Take a look on our wiki

Main Menu

Problem at updating to the version 2.0.8c

Started by adg, July 16, 2012, 10:06:51 AM

Previous topic - Next topic

adg

Hi!
After updating to the version 2.0.8c, I have received the following problem:
At products copying I view:
Error: VmTableData::store failed - Unknown column 'id' in 'field list' SQL=INSERT INTO `hcpaq_virtuemart_products_ru_ru` (`virtuemart_product_id`,`product_name`,`product_s_desc`,`product_desc`,`metadesc`,`metakey`,`customtitle`,`slug`,`id`,`param`,`value`,`intvalue`,`ordering`,`published`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`)

If I create new product, problems are not present

Please help me!

juicedsgn


bubster

Good day,

I am also experiencing the same problem. Cannot clone products.

vmError: VmTableData::store failed - Unknown column 'id' in 'field list' SQL=INSERT INTO `n57vi_virtuemart_products_en_gb`

Any help much appreciated.

bubster

Looking through the sql tables in virtuemart_products I can see only columns for;

`virtuemart_product_id`
`product_name`
`product_s_desc`
`product_desc`
`metadesc`
`metakey`
`customtitle`
`slug`

When cloning a product, somehow Virtuemart is attempting to write data for;

'created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`

Obviously these columns do not exist which is why an error is showing.

Could anyone please advise where this information is coming from please?

bubster

I have just updated to 2.0.8e and the error remains.

bubster

I've located the problem by disabling plugins.

IStraxx Quantity plugin appears to be causing the issue. When enabled, I cannot clone products. Any help with this please?

adg

Bubster, Thanks for idea! I have disconnected at myself plug-in Virtuemart 2 multiple customfield plugin and all works. Colleagues search for bad plug-ins

usovdm