× Discussion about "Cosmetics" Joomla/VirtueMart template.

Virtuemart products not showing

More
5 years 7 months ago #34849 by vincentochus
Hi, The virtuemart products stopped showing on the front end but I don't understand why? Check it out at www.lavashq.com .

let me know how I can send you the login credentials for backend if you want to go in

Please Log in or Create an account to join the conversation.

More
5 years 7 months ago #34856 by milos
Hi,

After update, you should run this SQL query using PHPMYADMIN:
UPDATE #__virtuemart_configs
SET
  config = REPLACE(config,"p.product_name","l.product_name");
  
UPDATE #__virtuemart_configs
SET
  config = REPLACE(config,"m.mf_name","l.mf_name");  

UPDATE #__virtuemart_configs
SET
  config = REPLACE(config,"c.category_name","l.category_name");

In this code, you should change #__ with your database table prefix.

Regards
Milos

Please Log in or Create an account to join the conversation.

More
5 years 7 months ago #34883 by vincentochus
I did the SQL query as instructed but still did not do the trick. The products are still not showing. is there a way I can send you admin credentials to have a look?

Please Log in or Create an account to join the conversation.

More
5 years 7 months ago #34893 by ivan.milic
Post contents of table #_virtuemart_configs so we can see if you applied scripts correctly

Please Log in or Create an account to join the conversation.

More
5 years 7 months ago #34902 by vincentochus
Okay, hereby attached

Please Log in or Create an account to join the conversation.

More
5 years 7 months ago #34907 by ivan.milic
nothing attached? just post config column value as clear text

Please Log in or Create an account to join the conversation.

Moderators: milos
Time to create page: 0.104 seconds