I am facing a serious issue with Joomla version 1.7.
MySQL server has gone away
I am using the shopping cart platform Virtuemart. When I placed an order, the order confirmation message page is messed up and the order email has no product info etc.
The query causing trouble is:
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 <= '2014-05-21 05:56:53') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2014-05-21 05:56:53') AND m.access IN (1,1,2) AND m.client_id = 0 AND (mm.menuid = 0 OR mm.menuid <= 0) ORDER BY m.position, m.ordering
Last week the site was working fine.
Also I don't have privileges to update its version to the latest :(.
So basically should I report this issue to server admin or is there a coding solution?
EDIT : SOLVED
This is issue is due to mysql query execution time, Server Admin able to increase the limit and the issue was fixed.