Upgraded virtuemart and no prices in cart

Hi There, We upgraded virtuemart to 2.0.14 but not our cart does not show the prices or total in the cart. Anyone please help?

Thanks

Did you update the template also ? Please switch to default template like Beez and check whether the prices are visible in default view.

Thanks for your reply, we have not upgraded the gavick template as we made some css changes. We swapped the template to beez and still no prices are showing in the cart. Hope this helps.

I've also just updated the gavick template and still no prices in showing in the cart.

So you have a common problem with VirtueMart, sometimes the database update goes wrong and as a result you can't see product prices. Please try to use fix described here >> http://www.gavick.com/magazine/developer-update-11.html

Thanks for your reply, i have tried the sql query

UPDATE '(PREFIX)_virtuemart_product_prices' SET 'virtuemart_shoppergroup_id'=NULL WHERE 1

but get an sql error

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''myprefixhere_virtuemart_product_prices' SET 'virtuemart_shoppergroup_id'=NULL WHERE 1' at line 1

Everything else appears to be fine except the prices in the checkout.. any other idea?

You need to replace myprefix with YOUR prefix. Your current database prefix you can find in root/configuration.php file.