High amount of page load errors

Permalink
This is the latest in a string of errors.
It came as a response to the guest book page.

An unexpected error occurred.
mysql error: [2006: MySQL server has gone away] in EXECUTE("select CollectionVersionBlocks.isOriginal, BlockTypes.pkgID, CollectionVersionBlocks.cbOverrideAreaPermissions, CollectionVersionBlocks.cbDisplayOrder, Blocks.bIsActive, Blocks.bID, Blocks.btID, bName, bDateAdded, bDateModified, bFilename, btHandle, Blocks.uID from CollectionVersionBlocks inner join Blocks on (CollectionVersionBlocks.bID = Blocks.bID) inner join BlockTypes on (Blocks.btID = BlockTypes.btID) where CollectionVersionBlocks.arHandle = 'Main' and CollectionVersionBlocks.cID = '70' and (CollectionVersionBlocks.cvID = '5' or CollectionVersionBlocks.cbIncludeAll=1) and CollectionVersionBlocks.bID = '46'")

Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [2006: MySQL server has gone away] in EXECUTE("insert into Logs (logType, logText, logIsInternal) values ('exceptions', 'Exception Occurred: mysql error: [2006: MySQL server has gone away] in EXECUTE("select CollectionVersionBlocks.isOriginal, BlockTypes.pkgID, CollectionVersionBlocks.cbOverrideAreaPermissions, CollectionVersionBlocks.cbDisplayOrder,\n Blocks.bIsActive, Blocks.bID, Blocks.btID, bName, bDateAdded, bDateModified, bFilename, btHandle, Blocks.uID from CollectionVersionBlocks inner join Blocks on (CollectionVersionBlocks.bID = Blocks.bID)\n inner join BlockTypes on (Blocks.btID = BlockTypes.btID) where CollectionVersionBlocks.arHandle = \'Main\' and CollectionVersionBlocks.cID = \'70\' and (CollectionVersionBlocks.cvID = \'5\' or CollectionVersionBlocks.cbIncludeAll=1) and CollectionVersionBlocks.bID = \'46\'")\n\n#0 /hermes/bosweb/web201/b2019/ipg.nailglamz/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_th in /hermes/bosweb/web201/b2019/ipg.nailglamz/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78


What does this mean????????

Jdial
 
codingpenguins replied on at Permalink Reply
This is most likely not a concrete5 error, but more of your query. I got this fromhttp://bogdan.org.ua/2008/12/25/how-to-fix-mysql-server-has-gone-aw... when I googled it. Are your guestbook records huge? If so you might need to increase the wait time or by increasing packet size (read below).

Server timed out and closed the connection. How to fix: check that wait_timeout variable in your mysqld’s my.cnf configuration file is large enough. On Debian: sudo nano /etc/mysql/my.cnf, set wait_timeout = 600 seconds (you can tweak/decrease this value when error 2006 is gone), then sudo /etc/init.d/mysql restart. I didn’t check, but the default value for wait_timeout might be around 28800 seconds (8 hours).

Server dropped an incorrect or too large packet. If mysqld gets a packet that is too large or incorrect, it assumes that something has gone wrong with the client and closes the connection. You can increase the maximal packet size limit by increasing the value of max_allowed_packet in my.cnf file. On Debian: sudo nano /etc/mysql/my.cnf, set max_allowed_packet = 64M (you can tweak/decrease this value when error 2006 is gone), then sudo /etc/init.d/mysql restart.