Forums

EMERGENCY after using "Designer Content"

Permalink
Hoping someone can help here.

I have been using Designer Content the new block from Jordanlev and following the documentation to delete tables in the database after building new blocks to remove the old settings.

I did this and now can't access 'Sitewide Settings' or 'Add Functionality'. The site is still working thank goodness.

I need to clear the cache but can't get it.

Getting this error trying to reach "Sitewide Settings"

mysql error: [2006: MySQL server has gone away] in EXECUTE("select cfValue from Config where cfKey = 'MARKETPLACE_SITE_URL_TOKEN'")
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 cfValue from Config where cfKey = \'MARKETPLACE_SITE_URL_TOKEN\'")\n\n#0 /home/candylan/public_html/updates/concrete5.4.1.1/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw(\'mysql\', \'EXECUTE\', 2006, \'MySQL server ha...\', \'select cfValue ...\', false, Object(ADODB_mysql))\n#1 /home/candylan/public_html/updates/concrete5.4.1.1/concrete/libraries/3rdparty/adodb/adodb.inc.php(993): ADOConnection->_Execute(\'select cfValue ...\')\n#2 /home/candylan/public_html/updates/concrete5.4.1.1/concrete/libraries/3rdparty/adodb/adodb.inc.php(1605): ADOConnection->Execute(\'select cfValue ...\', Array)\n#3 [internal function]: ADOConnection->GetRow(\'select cfValue ...\', Array)\n#4 /home/candylan/public_html/update in /home/candylan/public_html/updates/concrete5.4.1.1/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78


Getting this error reaching 'Add Functionality'.
An unexpected error occurred.
mysql error: [2006: MySQL server has gone away] in EXECUTE("select * from Packages where pkgIsInstalled = 1 order by pkgDateInstalled asc")
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 * from Packages where pkgIsInstalled = 1 order by pkgDateInstalled asc")\n\n#0 /home/candylan/public_html/updates/concrete5.4.1.1/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw(\'mysql\', \'EXECUTE\', 2006, \'MySQL server ha...\', \'select * from P...\', false, Object(ADODB_mysql))\n#1 /home/candylan/public_html/updates/concrete5.4.1.1/concrete/libraries/3rdparty/adodb/adodb.inc.php(1012): ADOConnection->_Execute(\'select * from P...\', false)\n#2 /home/candylan/public_html/updates/concrete5.4.1.1/concrete/libraries/3rdparty/adodb/adodb.inc.php(761): ADOConnection->Execute(\'select * from P...\', false)\n#3 [internal function]: ADOConnection->Query(\'select * from P...\')\n#4 /home/candylan/public_html/u in /home/candylan/public_html/updates/concrete5.4.1.1/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78


can anyone help this is quite serious.



Nige
nige
 
dwayneparton replied on at Permalink Reply
dwayneparton
I don't know if this will help but from what I read that error can occur for a couple of reasons. Here is a post that talks about it. Hope you get it fixed.

http://www.vbulletin.com/forum/showthread.php/43505-MySQL-server-go...
jordanlev replied on at Permalink Reply
jordanlev
I believe Nige was able to sort this out. Just for future reference, here are some other links about the issue:

http://stackoverflow.com/questions/2232150/pdo-mysql-server-has-gon...
http://stackoverflow.com/questions/1801794/mysql-server-has-gone-aw...
http://stackoverflow.com/questions/1980004/2006-mysql-server-has-go...
http://stackoverflow.com/questions/4455100/mysql-server-has-gone-aw...
http://stackoverflow.com/questions/1884111/sudden-mysql-server-has-...

I'm not sure why this happened to him exactly. He may have accidentally deleted the wrong table (I've since added a big scary warning to the Designer Content docs about always backing up your database before doing this). Or it could have just been some strange confluence of things, like the server tried to connect to the db at the exact time he was deleting a table and the connection got lost somehow (which I imagine a server reboot would fix, but this might not be possible depending on the kind of web hosting you have). Very strange.
nige replied on at Permalink Reply
nige
UPDATE TO ALL THIS:

This issue is NOT related to the Designer Content Block.

OR Anything that I did to the database.

I found a link here:

https://www.concrete5.org/community/forums/chat/mysql-has-gone-away-...

that gave a similar error and it mentioned it may be a hosting issue.

SO I tested a couple of my other sites and yes they were giving the same errors!

At this stage I think this is a hosting issue. I've contacted my host and they are looking into it.

I hope this helps for future reference.

Nige
DWD replied on at Permalink Reply
Nige-

I can confirm this as I had a client on Godaddy experience the same issue.

-Dave