Fatal error: Uncaught exception 'ADODB_Exception'

Permalink March 13, 2013 at 1:45 PM

I got database error message constantly like every first try in everyday
When I refresh the page, website is normally coming up.

I talked to hosting company hostzil.la and they say there's nothing wrong

Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [2006: MySQL server has gone away] in EXECUTE("SHOW TABLES") ' in /home/hyanggio/public_html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /home/hyanggio/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw('mysql', 'EXECUTE', 2006, 'MySQL server ha...', 'SHOW TABLES', false, Object(ADODB_mysql)) #1 /home/hyanggio/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(1012): ADOConnection->_Execute('SHOW TABLES', false) #2 /home/hyanggio/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(2273): ADOConnection->Execute('SHOW TABLES') #3 /home/hyanggio/public_html/concrete/libraries/3rdparty/adodb/drivers/adodb-mysql.inc.php(72): ADOConnection->MetaTables(false, false) #4 /home/hyanggio/public_html/concrete/startup/exceptions.php(7): ADODB_mysql->MetaTables() #5 [internal function]: Concrete5_Exception_Handler(Object(ADODB_Exception)) #6 {main} thrown in /home/hyanggio/public_html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78

johnsmart replied on May 14, 2013 at 2:54 pm Permalink Reply

Had a very similar issue, and this worked for me:

ronyDdeveloper told me:
Try to put the below code to your roots index.php file.

ini_set('mysql.connect_timeout', 300);
ini_set('default_socket_timeout', 300);

And I also amended my etc/my.cnf (yours may be in a different location, back up before playing with server files) changing the following lines:
query_cache_limit=16M
query_cache_size=256M
...
max_connections=5000

I did this, and the problem vanished - but I only did this a couple of hours ago!