more mysql errors… help, dashboard stuck in weird "text" mode since two days ago!
Permalink
error is…
mysql error: [2006: MySQL server has gone away] in EXECUTE("select Collections.cID, Pages.cID as pcID from Collections left join Pages on Collections.cID = Pages.cID where Collections.cHandle = 'uID=1'")
PHP Error Message
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 Collections.cID, Pages.cID as pcID from Collections left join Pages on Collections.cID = Pages.cID where Collections.cHandle = \'uID=1\'\")\n\n#0 /home/a4385449/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(918): adodb_throw(\'mysql\', \'EXECUTE\', 2006, \'MySQL server ha...\', \'select Collecti...\', false, Object(ADODB_mysql))\n#1 /home/a4385449/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(874): ADOConnection->_Execute(\'select Collecti...\')\n#2 /home/a4385449/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(645): ADOConnection->Execute(\'select Collecti...\', Array)\n#3 /home/a4385449/public_html/concrete/libraries/database.php(62): ADOConnection->Query(\'select Collecti...\', Array)\n#4 [internal in /home/a4385449/public_html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
any idea? i'm stumped. do i have to restart the mysql db? how would i do that?
mysql error: [2006: MySQL server has gone away] in EXECUTE("select Collections.cID, Pages.cID as pcID from Collections left join Pages on Collections.cID = Pages.cID where Collections.cHandle = 'uID=1'")
PHP Error Message
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 Collections.cID, Pages.cID as pcID from Collections left join Pages on Collections.cID = Pages.cID where Collections.cHandle = \'uID=1\'\")\n\n#0 /home/a4385449/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(918): adodb_throw(\'mysql\', \'EXECUTE\', 2006, \'MySQL server ha...\', \'select Collecti...\', false, Object(ADODB_mysql))\n#1 /home/a4385449/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(874): ADOConnection->_Execute(\'select Collecti...\')\n#2 /home/a4385449/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(645): ADOConnection->Execute(\'select Collecti...\', Array)\n#3 /home/a4385449/public_html/concrete/libraries/database.php(62): ADOConnection->Query(\'select Collecti...\', Array)\n#4 [internal in /home/a4385449/public_html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
any idea? i'm stumped. do i have to restart the mysql db? how would i do that?
Did you find an answer to this please? - I've got the same issue.
it's a server problem. ask your hosting provider. the problem occurs on 000webhost.com
Thanks redtype - I'm taking it up with supanames.co.uk & will come back to this thread with any relevant stuff.
Now fixed. For info - I contacted host provider supanames.co.uk - owing to a firewall setting it appears the software was failing to connect to ip: I understand they added a script which has resolved the issue.
that's part of the server and there's no single answer to your question. it depends on your operating system, your setup and a lot of minor things.
do you have phpmyadmin? does it work?
is this your own server? do you have a server admin? (I hope you do have one)..