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

vmError: TableProduct_prices::store failed

Started by Limonbay, February 07, 2013, 14:06:48 PM

Previous topic - Next topic

Limonbay

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

Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

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

Limonbay

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

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
Lowestoft, Suffolk, UK

Retired from forum life November 2023

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

Limonbay

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

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]