News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

Product clone database bug

Started by bubster, July 19, 2012, 01:08:42 AM

Previous topic - Next topic

bubster

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.

bubster

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`

Agaton

I get exactly the same thing, any solution?

bubster

Hi spike1968

No solution yet.

Any assiatnce would be appreciated.

Regards,

Agaton

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