vmError: TableProduct_prices::store failed

[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?... 

[jenkinhill]

@Limonbay see http://forum.virtuemart.net/index.php?topic=79800

[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!

[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.

[Limonbay]

To the guy who sent me the private message: No, I still haven't found a solution to this. 

[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]