Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end

[ggarmo]

Hello All,

I am having a similar issue. I cannot save any product prices whatsoever. I know the database is communicating because if i change in phpmyadmin it reflects in backend and frontend. However, whenever i try to save from administrator nothing happens. I have fixed shopper group to NULL as it was all messed up after an update. My main reason for trying to figure this out is because I believe it is related to my issue of when you try to visit the cart I get this error:

 Fatal error: Call to undefined method VirtueMartModelProduct::getProductPrices() in /com_virtuemart/helpers/cart.php on line 1288

After the update to 2.0.18 then downgrade to 2.0.16 because of major issues we arent even operational anymore. Entire site is basically useless.

[ggarmo]

realized that when the cart is empty everything works fine. it's only if there are products in the cart. any ideas>

[rishard]

Joomla 2.5.8, VirtueMart 2.0.18.

After upgrade VirtueMart 2.0.18a does not show the price to not authorized buyers. Advise what to do?

[ocean1]

Same over here, the price is gone
When logged in we see the price again

[jenkinhill]

Check the shopper group set to show the prices to. If prices should be shown to all site users then the group should be left as "Please Select".


[attachment cleanup by admin]

[rishard]

Check the shopper group set to show the prices to. If prices should be shown to all then the group should be left as Please Select.

I'm sorry, how do I find this tab?

[jenkinhill]

That is the Product Editor, Product Information tab.

[rishard]

That is the Product Editor, Product Information tab.

OK, this works!
Thank you
Tell please, how I should act, if it is a lot of products?
I should as to edit everyone?

P.S. Joomla 2.5.8, VirtueMart 2.0.18a, php 5.3.15.

[ocean1]

I found it

[77777]

maybe u can share your progress with others... i am having the same problem, prices are not displayed, dont know what to do...

[rishard]

maybe u can share your progress with others... i am having the same problem, prices are not displayed, dont know what to do...

The solution is found, description here. Sorry, the article is in russian language. But the syntax of the sql-query is read easily.

[77777]

helped,thanks

[Milbo]

maybe u can share your progress with others... i am having the same problem, prices are not displayed, dont know what to do...

The solution is found, description here. Sorry, the article is in russian language. But the syntax of the sql-query is read easily.

Thank you, the sql is

Code: [Select]

UPDATE #__virtuemart_shoppergroups SET `default` = 0 WHERE `default` = 1
Of course replace +_ with your table prefix. But this is not a real solution. You have then no standard shoppergroup. You should set a new default shoppergroup then.

The problem is imho that people have stored prices with shoppergroups.

[jenkinhill]

I have used this to fix sites where the user wrongly stored shoppergroup specific prices: 

UPDATE ###_virtuemart_product_prices   SET virtuemart_shoppergroup_id=NULL

[Hubbitus]

Of course replace +_ with your table prefix. But this is not a real solution.

Really it is dirty hack.

You have then no standard shoppergroup. You should set a new default shoppergroup then.

No! The key there to do not have default group on import because if it exists it had picked up by CVSI importer.