News:

Support the VirtueMart project and become a member

Main Menu

CANNOT DISPLAY PRODUCTS

Started by jimsake, June 06, 2012, 11:47:59 AM

Previous topic - Next topic

jimsake

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
people are too smart not to believe in God, but too stupid not to believe on themselves..

Merry

Jimsake,

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

Merry
Answer is probably from my VirtueMart 2 User Manual ebook, includes FREE updates. FREE Admin Menu Cheatsheet, Quick Install Guide & 30-Minute Quick Setup Guide http://showmeguides.com/

jimsake

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?
people are too smart not to believe in God, but too stupid not to believe on themselves..

jimsake

people are too smart not to believe in God, but too stupid not to believe on themselves..

PRO

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


jimsake

SOLVED

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

jimsake

people are too smart not to believe in God, but too stupid not to believe on themselves..