VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Topic started by: xoxolo on January 09, 2013, 14:14:05 PM

Title: [solved] Panic mode: after last update... Some prices displayed call for price
Post by: xoxolo on January 09, 2013, 14:14:05 PM
Hi everyone,
After making the update to the last release on a working state install, some price aren't displayed, instead, I have Call for price...
In the back end, everything looks perfect.
Can't see any solution, help...

Thanks a lot! For your time and answer!

Olivier
Title: Re: Panic mode: after last update... Some prices displayed call for price
Post by: Milbo on January 09, 2013, 15:35:41 PM
Check the products, do NOT enter any shoppergroup if you use only one price.
Virtuemart rule #1 if you mean "all", enter "nothing".
Title: Re: Panic mode: after last update... Some prices displayed call for price
Post by: xoxolo on January 09, 2013, 15:58:51 PM
Thanks for your update Milbo, after a close check, all my products are set exactly the same.
No shoppergroup set.
Any other clue?

Thanks for your time!

Olivier

I can post screenshots if needed.
Title: Re: Panic mode: after last update... Some prices displayed call for price
Post by: gpessoa on January 09, 2013, 16:18:48 PM
I had the same problem and solved it with a SQL update on DB
I had set shoppergroup on virtuemart_product_prices to null
Title: Re: Panic mode: after last update... Some prices displayed call for price
Post by: xoxolo on January 09, 2013, 17:06:16 PM
Hello gpessoa,

Thanks for your input, love what I read!!!
Can you help me a bit throughtout the process?

Thanks a lot!

Olivier
Title: Re: Panic mode: after last update... Some prices displayed call for price
Post by: gpessoa on January 09, 2013, 17:15:20 PM
Use phpMyAdmin or other tool. You may/ can find it on your cpanel
Go to your DB, and run the following SQL command:
UPDATE `jos_virtuemart_product_prices` SET `virtuemart_shoppergroup_id` = NULL
Title: Re: Panic mode: after last update... Some prices displayed call for price
Post by: xoxolo on January 09, 2013, 17:43:27 PM
I own you 1 guys, thanks a lot, special mention to gpessoa, you rock!
Made my day, probably my week!!!
Thanks a lot!

Olivier
;D
Title: Re: Panic mode: after last update... Some prices displayed call for price
Post by: xoxolo on January 11, 2013, 21:54:52 PM
@gpessoa

Everything works well based on my original question, now my shopping cart doesn't work, is it logical?
Thanks for your help!

Olivier
Title: Re: Panic mode: after last update... Some prices displayed call for price
Post by: xoxolo on January 12, 2013, 01:30:42 AM
Activating the SEO of Virtuemart did it...
Thanks anyway.

Olivier