Author Topic: vmError: TableProduct_prices::store failed  (Read 2522 times)

Limonbay

  • Jr. Member
  • **
  • Posts: 54
  • Piercing life
    • Piercings
vmError: TableProduct_prices::store failed
« on: February 07, 2013, 14:06:48 pm »
I cannot see the prices on the products. But I cannot even save the products on manual edition. Every time I try to save (on any pruduct) I get this:

vmError: TableProduct_prices::store failed - Unknown column 'product_price_publish_up' in 'field list' SQL=UPDATE `miz0d_virtuemart_product_prices` SET `virtuemart_product_id`='21',`virtuemart_shoppergroup_id`='2',`product_price`='150.00000',`override`='0',`product_override_price`='0.00000',`product_tax_id`='0',`product_discount_id`='0',`product_currency`='144',`product_price_publish_up`='',`product_price_publish_down`='',`price_quantity_start`='0',`price_quantity_end`='0',`created_on`='',`created_by`='0',`modified_on`='2013-02-07 13:01:16',`modified_by`='756' WHERE `virtuemart_product_price_id`='21'

Any idea?...  :-\
Piercings y complementos
http://www.limonbay.com
Joomla 2.5.14
Virtuemart 2.0.24

jenkinhill

  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 28021
  • Always on vacation
    • Jenkin Hill Internet
Re: vmError: TableProduct_prices::store failed
« Reply #1 on: February 07, 2013, 15:28:36 pm »
Kelvyn

Jenkin Hill Internet,
Lowestoft, Suffolk, UK

Unsolicited PMs/emails will be ignored.

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

Currently using VirtueMart 3.8.7 10374 on Joomla 3.9.24 PHP 7.4.12

Limonbay

  • Jr. Member
  • **
  • Posts: 54
  • Piercing life
    • Piercings
Re: vmError: TableProduct_prices::store failed
« Reply #2 on: February 07, 2013, 17:06:04 pm »
Hi Jenkinhill. Thanks for the information, I had forgotten to update my footer information in my VM forum profile.
My Joomla version is as seen down here.

Any idea about the error mentioned above?
mError: TableProduct_prices::store failed - Unknown column 'product_price_publish_up' in 'field list'

Thanks!
Piercings y complementos
http://www.limonbay.com
Joomla 2.5.14
Virtuemart 2.0.24

jenkinhill

  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 28021
  • Always on vacation
    • Jenkin Hill Internet
Re: vmError: TableProduct_prices::store failed
« Reply #3 on: February 07, 2013, 18:05:29 pm »
No idea, but it has nothing to do with the title of the thread you replied to so I'm making a new thread.
Kelvyn

Jenkin Hill Internet,
Lowestoft, Suffolk, UK

Unsolicited PMs/emails will be ignored.

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

Currently using VirtueMart 3.8.7 10374 on Joomla 3.9.24 PHP 7.4.12

Limonbay

  • Jr. Member
  • **
  • Posts: 54
  • Piercing life
    • Piercings
Re: vmError: TableProduct_prices::store failed
« Reply #4 on: February 24, 2013, 15:33:07 pm »
To the guy who sent me the private message: No, I still haven't found a solution to this.  :-\
Piercings y complementos
http://www.limonbay.com
Joomla 2.5.14
Virtuemart 2.0.24

maxi1973

  • Jr. Member
  • **
  • Posts: 68
Re: vmError: TableProduct_prices::store failed
« Reply #5 on: April 04, 2013, 15:36:22 pm »
You have to add two lines in the table xxxxx_virtuemart_product_prices as shown in the image attached. It worked for me after import from 1.1.9 to 2.0.x

[attachment cleanup by admin]