VirtueMart Forum

VirtueMart 2 + 3 + 4 => Installation, Migration & Upgrade => Topic started by: adg on July 16, 2012, 10:06:51 AM

Title: Problem at updating to the version 2.0.8c
Post by: adg on July 16, 2012, 10:06:51 AM
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!
Title: Re: Problem at updating to the version 2.0.8c
Post by: juicedsgn on July 16, 2012, 10:59:07 AM
I have the same problem.
Any idea ?

Juice
Title: Re: Problem at updating to the version 2.0.8c
Post by: bubster on July 18, 2012, 11:57:04 AM
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.
Title: Re: Problem at updating to the version 2.0.8c
Post by: bubster on July 18, 2012, 12:46:34 PM
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?
Title: Re: Problem at updating to the version 2.0.8c
Post by: bubster on July 18, 2012, 12:48:39 PM
I have just updated to 2.0.8e and the error remains.
Title: Re: Problem at updating to the version 2.0.8c
Post by: bubster on July 18, 2012, 13:48:08 PM
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?
Title: Re: Problem at updating to the version 2.0.8c
Post by: adg on July 18, 2012, 16:19:44 PM
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
Title: Re: Problem at updating to the version 2.0.8c
Post by: usovdm on October 09, 2012, 11:40:22 AM
My solution of this problem: http://forum.virtuemart.net/index.php?topic=108517.0 (http://forum.virtuemart.net/index.php?topic=108517.0)