VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Topic started by: Limonbay on February 07, 2013, 14:06:48 PM

Title: vmError: TableProduct_prices::store failed
Post by: Limonbay 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?...  :-\
Title: Re: vmError: TableProduct_prices::store failed
Post by: jenkinhill on February 07, 2013, 15:28:36 PM
@Limonbay see http://forum.virtuemart.net/index.php?topic=79800
Title: Re: vmError: TableProduct_prices::store failed
Post by: Limonbay 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!
Title: Re: vmError: TableProduct_prices::store failed
Post by: jenkinhill 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.
Title: Re: vmError: TableProduct_prices::store failed
Post by: Limonbay 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.  :-\
Title: Re: vmError: TableProduct_prices::store failed
Post by: maxi1973 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]