Execution of a query to the database failed - MySQL server has gone away

Manager works fine. Getting this error when browing website, any ideas

« Execution of a query to the database failed - MySQL server has gone away »
SQL: SELECT DISTINCT sc.id, sc.menutitle, sc.pagetitle, sc.introtext, sc.menuindex, sc.published, sc.hidemenu, sc.parent, sc.isfolder, sc.description, sc.alias, sc.longtitle, sc.type,if(sc.type=\\\’reference\\\’,sc.content,\\\’\\\’) as content, sc.template, sc.link_attributes FROM `acmesys_website`.`modx_site_content` sc LEFT JOIN `acmesys_website`.`modx_document_groups` dg ON dg.document = sc.id WHERE sc.published=1 AND sc.deleted=0 AND (sc.privateweb=0) AND sc.hidemenu=0 AND sc.id IN (1,194,37,267,144,171,75,178,145,36,76,169,147,156) GROUP BY sc.id ORDER BY sc.menuindex ASC ;\\n

Thanks in advance.

Try my patch for a while:
http://modxcms.com/forums/index.php/topic,42274.0.html

Quote from: goldsky at Nov 23, 2009, 12:22 PM

Try my patch for a while:
http://modxcms.com/forums/index.php/topic,42274.0.html

That Jira image verification just won’t let me in.

@goldsky

Applied your patch. Nice but seems some queries take too long to respond causing the server error. Reverted to ver 1.0.0 and everything seems to be chugging along fine.

"MySQL server has gone away" may come from wrong query-close connection to database.
Try to disable your snippets (the custom ones) one at the time, refresh your browser.
Sometimes it happens because of them.
This reading may give you a hint something else.

Quote from: goldsky at Nov 25, 2009, 11:16 PM

"MySQL server has gone away" may come from wrong query-close connection to database.
Try to disable your snippets (the custom ones) one at the time, refresh your browser.
Sometimes it happens because of them.
This reading may give you a hint something else.

Thank you for those links. Increasing wait_timeout to 120secs from 15secs in my.cnf resolved this issue. Issue use to occur when we clicked on a new link (non-cached) while the existing page was still loading.

good to hear you’ve sorted it out.