VirtueMart Forum

VirtueMart 2 + 3 + 4 => Administration & Configuration => Topic started by: jimsake on June 06, 2012, 11:47:59 AM

Title: CANNOT DISPLAY PRODUCTS
Post by: jimsake on June 06, 2012, 11:47:59 AM
Hi there,
i am using a lot of VM sites in a single server and in my last site i take this error

"Error loading module MySQL server has gone away SQL=SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN jos_extensions AS e ON e.element = m.module AND e.client_id = m.client_id WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2012-06-06 09:33:11') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2012-06-06 09:33:11') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 470 OR mm.menuid <= 0) ORDER BY m.position, m.ordering "

when i click in the category icon to show me its products
url is http://marios2.smart-market.gr/joomla_e/index.php/ttttttt
where ttttttt is the category and the module is VMCATEGORY
when i click the module button in the menu-->all categories appears and when i clickin the cat icon i take the above message

any suggestion?

thanks in advance
jimsake
Title: Re: CANNOT DISPLAY PRODUCTS
Post by: Merry on June 06, 2012, 21:15:30 PM
Jimsake,

Short answer is a file is corrupt. Keep testing to see what other errors you get and let us know.

Merry
Title: Re: CANNOT DISPLAY PRODUCTS
Post by: jimsake on June 06, 2012, 22:05:05 PM
In this url  http://virt2.smart-sites.gr/joomla_4/index.php/mycats/111111
i take the error despite in this url http://www.smart-market.gr/joomla/index.php/en/9/housholditems
which i taki no errors
I have built the layout by the same way
maybe the key is the "/9" (the number of the category)
??????
As i told i have many installations in the same domain server as subdomains and i have the suspicion that they conflict..
any idea?
Title: Re: CANNOT DISPLAY PRODUCTS
Post by: jimsake on June 07, 2012, 16:19:11 PM
???
Title: Re: CANNOT DISPLAY PRODUCTS
Post by: PRO on June 07, 2012, 16:39:19 PM
Quote from: jimsake on June 06, 2012, 11:47:59 AM

"Error loading module MySQL server has gone away


check the server load, and status

also, make sure the sites not hacked

Title: Re: CANNOT DISPLAY PRODUCTS
Post by: jimsake on June 09, 2012, 13:33:53 PM
SOLVED

My hoster had a problem with the SQL server, so they fix it and my problem solved
thanks for the interest

jimsake