Site broken during offline build - Please help me.
Permalink
Hi, I am currently working on a site building it offline, this morning I added a block that was an image viewer but should not have been placed into the block I tried placing it into. Anyway the result was I lost the EDIT and DASHBOARD buttons on my Home page. They were still there on all other pages, just the home page where I had inserted this image plugin block.
I tried to go back in my versions and restore from backup, I have since completely removed and re setup a fresh Concrete5 install and used the myPHP import database function to import the backed up SQL database but I keep getting this error.
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysqlt error: [2006: MySQL server has gone away] in EXECUTE("SELECT TABLE_NAME, CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=SCHEMA()") ' in /Applications/MAMP/htdocs/concrete5.6.2.1/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /Applications/MAMP/htdocs/concrete5.6.2.1/concrete/libraries/3rdparty/adodb/adodb.inc.php(1074): adodb_throw('mysqlt', 'EXECUTE', 2006, 'MySQL server ha...', 'SELECT TABLE_NA...', false, Object(ADODB_mysqlt)) #1 /Applications/MAMP/htdocs/concrete5.6.2.1/concrete/libraries/3rdparty/adodb/adodb.inc.php(1049): ADOConnection->_Execute('SELECT TABLE_NA...', false) #2 /Applications/MAMP/htdocs/concrete5.6.2.1/concrete/libraries/3rdparty/adodb/adodb.inc.php(2334): ADOConnection->Execute('SELECT TABLE_NA...') #3 /Applications/MAMP/htdocs/concrete5.6.2.1/concrete/libraries/3rdparty/adodb/drivers/adodb-mysql.inc.php(150): ADOConnection->MetaTables(false, fa in /Applications/MAMP/htdocs/concrete5.6.2.1/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
To the best of my knowledge and multiple attempts to get this working I have reinstalled all plugins and the theme I was using and of course named everything exactly the same.
I am under a lot of pressure and this will be invaluable to learn how to fix for now and the future.
Thanks!
I tried to go back in my versions and restore from backup, I have since completely removed and re setup a fresh Concrete5 install and used the myPHP import database function to import the backed up SQL database but I keep getting this error.
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysqlt error: [2006: MySQL server has gone away] in EXECUTE("SELECT TABLE_NAME, CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=SCHEMA()") ' in /Applications/MAMP/htdocs/concrete5.6.2.1/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /Applications/MAMP/htdocs/concrete5.6.2.1/concrete/libraries/3rdparty/adodb/adodb.inc.php(1074): adodb_throw('mysqlt', 'EXECUTE', 2006, 'MySQL server ha...', 'SELECT TABLE_NA...', false, Object(ADODB_mysqlt)) #1 /Applications/MAMP/htdocs/concrete5.6.2.1/concrete/libraries/3rdparty/adodb/adodb.inc.php(1049): ADOConnection->_Execute('SELECT TABLE_NA...', false) #2 /Applications/MAMP/htdocs/concrete5.6.2.1/concrete/libraries/3rdparty/adodb/adodb.inc.php(2334): ADOConnection->Execute('SELECT TABLE_NA...') #3 /Applications/MAMP/htdocs/concrete5.6.2.1/concrete/libraries/3rdparty/adodb/drivers/adodb-mysql.inc.php(150): ADOConnection->MetaTables(false, fa in /Applications/MAMP/htdocs/concrete5.6.2.1/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
To the best of my knowledge and multiple attempts to get this working I have reinstalled all plugins and the theme I was using and of course named everything exactly the same.
I am under a lot of pressure and this will be invaluable to learn how to fix for now and the future.
Thanks!
And 1 more error code being thrown up.
An unexpected error occurred.
mysqlt error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Ⱥ]XB)r' at line 1] in EXECUTE("Ⱥ]XB)r�")
An unexpected error occurred.
mysqlt error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Ⱥ]XB)r' at line 1] in EXECUTE("Ⱥ]XB)r�")
I don't have an answer but whenever I see that 'mySQL has gone away' error, it is the host server that is at fault. I would put a tech support call in and see if they have been having database problems lately. Who are you hosting with?
It isn't hosted yet. Just building it offline through MAMP.
It could be that your dev system needs to set the mysql server running so php and concrete5 can use it.
Outside of concrete5, check that mysql is actually running.
It may also be that your you are logged in as a different user on your dev system and do not have the right privileges. Though I would expect that to give a different error message.
Another thing to check is you have not specified the server/username/password correctly in your setup (or config/site.php) or that you have done something with the database since that makes config/site invalid.
Outside of concrete5, check that mysql is actually running.
It may also be that your you are logged in as a different user on your dev system and do not have the right privileges. Though I would expect that to give a different error message.
Another thing to check is you have not specified the server/username/password correctly in your setup (or config/site.php) or that you have done something with the database since that makes config/site invalid.
I could be wrong but, if you imported the database, did you also import/over-write the password in the database?
Assuming that is the case, the fix is to do some database magic to extract the hashed password from your working database and put it into the site.php, which you sometimes have to do when when migrating a site from one server to another.
https://www.concrete5.org/documentation/how-tos/developers/recoverin...
Assuming that is the case, the fix is to do some database magic to extract the hashed password from your working database and put it into the site.php, which you sometimes have to do when when migrating a site from one server to another.
https://www.concrete5.org/documentation/how-tos/developers/recoverin...
Thank you everyone for taking the time to reply. I still don't know and have started over again.
Error
SQL query:
INSERT INTO CollectionVersionBlocks VALUES(1,1,24,'Sidebar',0,1,0,0) ,(1,1,25,'Sidebar',1,1,0,0) ,(1,1,26,'Main',0,1,0,0) ,(1,1,27,'Header Image',0,1,0,0) ,(1,2,24,'Sidebar',0,0,0,0) ,(1,2,25,'Sidebar',1,0,0,0) ,(1,2,26,'Main',0,0,0,0) ,(1,2,27,'Header Image',0,0,0,0) ,(1,2,48,'Main',1,1,0,0) ,(1,3,24,'Sidebar',0,0,0,0) ,(1,3,25,'Sidebar',1,0,0,0) ,(1,3,26,'Main',0,0,0,0) ,(1,3,27,'Header Image',0,0,0,0) ,(1,4,24,'Sidebar',0,0,0,0) ,(1,4,25,'Sidebar',1,0,0,0) ,(1,4,26,'Main',0,0,0,0) ,(1,4,27,'Header Image',0,0,0,0) ,(1,4,49,'Main',1,1,0,0) ,(1,5,24,'Sidebar',0,0,0,0) ,(1,5,25,'Sidebar',1,0,0,0) ,(1,5,49,'Main',1,0,0,0) ,(1,6,24,'Sidebar',0,0,0,0) ,(1,6,25,'Sidebar',1,0,0,0) ,(1,6,49,'Main',0,0,0,0) ,(1,6,50,'Header Image',0,1,0,0) ,(1,7,24,'Sidebar',0,0,0,0) ,(1,7,25,'Sidebar',1,0,0,0) ,(1,7,50,'Header Image',0,0,0,0) ,(1,8,24,'Sidebar',0,0,0,0) ,(1,8,25,'Sidebar',1,0,0,0) ,(1,8,51,'Header',0,1,0,0) ,(1,9,24,'Sidebar',0,0,0,0) ,(1,9,25,'Sidebar',1,0,0[...]
MySQL said: Documentation
#2006 - MySQL server has gone away