VirtueMart Forum

VirtueMart 2 + 3 + 4 => Product creation => Topic started by: bubster on July 19, 2012, 01:08:42 AM

Title: Product clone database bug
Post by: bubster on July 19, 2012, 01:08:42 AM
Hi I'm using VM 2.0.8e with Istraxx quantity plugin installed.

When i try to clone a product with the plugin enabled I get a database error:

vmError: VmTableData::store failed - Unknown column 'id' in 'field list' SQL=INSERT INTO `n57vi_virtuemart_products_en_gb` (`virtuemart_product_id`,`product_name`,`product_s_desc`,`product_desc`,`metadesc`,`metakey`,`customtitle`,`slug`,`id`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`)

As I understand Virtuemart is attempting to write data for;

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

These columns do not exist in virtuemart_products.

When I disable Istraxx quantity plugin, products can be cloned.

I understand cloning seems to be an issue with several other users also.

Could any help me with a workaround to clear this error so I can complete my website.

Any help much appreciated. Thank you.
Title: Re: Product clone database bug
Post by: bubster on July 20, 2012, 14:32:05 PM
Quick question please.

Would it be ok to add the following fields to my database to clear the issue?


'created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`
Title: Re: Product clone database bug
Post by: Agaton on July 26, 2012, 18:34:32 PM
I get exactly the same thing, any solution?
Title: Re: Product clone database bug
Post by: bubster on July 30, 2012, 12:15:10 PM
Hi spike1968

No solution yet.

Any assiatnce would be appreciated.

Regards,
Title: Re: Product clone database bug
Post by: Agaton on July 30, 2012, 13:12:43 PM
Hi Bubster,

Sorry I have nothing yet, I will let you know when I have a solution, unfortunately the developer is not answering my questions, so I will be working out a solution for myself.

Cheers
Martyn