Author Topic: Problem at updating to the version 2.0.8c  (Read 3374 times)

adg

  • Beginner
  • *
  • Posts: 3
Problem at updating to the version 2.0.8c
« 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!

juicedsgn

  • Beginner
  • *
  • Posts: 3
Re: Problem at updating to the version 2.0.8c
« Reply #1 on: July 16, 2012, 10:59:07 am »
I have the same problem.
Any idea ?

Juice

bubster

  • Beginner
  • *
  • Posts: 19
Re: Problem at updating to the version 2.0.8c
« Reply #2 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.

bubster

  • Beginner
  • *
  • Posts: 19
Re: Problem at updating to the version 2.0.8c
« Reply #3 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?

bubster

  • Beginner
  • *
  • Posts: 19
Re: Problem at updating to the version 2.0.8c
« Reply #4 on: July 18, 2012, 12:48:39 pm »
I have just updated to 2.0.8e and the error remains.

bubster

  • Beginner
  • *
  • Posts: 19
Re: Problem at updating to the version 2.0.8c
« Reply #5 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?

adg

  • Beginner
  • *
  • Posts: 3
Re: Problem at updating to the version 2.0.8c
« Reply #6 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

usovdm

  • 3rd party VirtueMart Developer
  • Beginner
  • *
  • Posts: 16
Re: Problem at updating to the version 2.0.8c
« Reply #7 on: October 09, 2012, 11:40:22 am »