Virtuemart products not showing

vincentochus
Inactive member
Topic Author
New Member

11 years 3 weeks ago #34849 by vincentochus

Virtuemart products not showing was created 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 to join the conversation.

milos
Support Staff
Moderator

11 years 3 weeks ago #34856 by milos

Replied by milos on topic Virtuemart products not showing

Hi,

After update, you should run this SQL query using PHPMYADMIN:

Code:

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 to join the conversation.

vincentochus
Inactive member
Topic Author
New Member

11 years 2 weeks ago #34883 by vincentochus

Replied by vincentochus on topic Virtuemart products not showing

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 to join the conversation.

ivan.milic
Support Staff
Moderator

11 years 2 weeks ago #34893 by ivan.milic

Replied by ivan.milic on topic Virtuemart products not showing

Post contents of table #_virtuemart_configs so we can see if you applied scripts correctly

Please Log in to join the conversation.

vincentochus
Inactive member
Topic Author
New Member

11 years 2 weeks ago #34902 by vincentochus

Replied by vincentochus on topic Virtuemart products not showing

Okay, hereby attached

Please Log in to join the conversation.

ivan.milic
Support Staff
Moderator

11 years 2 weeks ago #34907 by ivan.milic

Replied by ivan.milic on topic Virtuemart products not showing

nothing attached? just post config column value as clear text

Please Log in to join the conversation.

Time to create page: 0.141 seconds