Error loading module MySQL server has gone away

Question

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

I already checked many sites and joomla forum almost every topic related to this issue is saying server mysql time out issue. here , here and this

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.

Answer 1

It's a MySQL issue. It may be:

• MySQL Bug
• MySQL Internal Inconsistency
• MySQL Load Restriction / Timeout

Since error is MySQL server has gone away, the connection is closed, and the MySQL process may have died. It's not a coding issue at Joomla level.

Check with your hosting support. If I have this error in my server, I run a check on the database to solve any inconsistency, and update MySQL to the latest version.