Update Error

Permalink
Hi-

I just tried to update my concrete5 installation from 5.6.0.2 to 5.6.2.1 and received the following error:

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

Thankfully my website is still up and running just fine.

The site is hosted on webhostinghub. Per the directions on their site I went into my dashboard / System and Settings and selected the option to Update Concrete5. The next screen showed that I was running 5.6.0.2 and showed the current update to be 5.6.2.1 . I selected download . After about 2 mintues I received the above error message. When I now go into Update Concrete5 it says:

Make sure you backup your database before updating.
An update is available. Click below to update to 5.6.2.1.

Any suggestions on how I should proceed?

I will note that I updated my development server manually without any difficulties -- simply downloading 5.6.1.2 and unzipping the files into a tmp directory, copying all the files in the tmp concrete directory to my concrete directory and then going into the Update Concrete5 option in the dashboard and clicking update.

Thanks in advance for any help

 
JohntheFish replied on at Permalink Reply
JohntheFish
It could be that, fortunately for you, the upgrade timed out between downloading the upgrade zip file and actually installing the upgrade. Hence you probably have a download of the upgrade that is partially or fully unzipped, but not installed, so your current version of c5 is still working correctly.

Using FTP or from your host account control panel, browse to the updates directory and check if the zip had been downloaded (and unzipped).

The danger on continuing with the upgrade from this stage is that the files for the upgrade may be only partially unzipped. If you were to proceed you could end up with a broken site.

From your host control panel (ie not from the c5 dashboard), you can repeat the unzipping of the upgrade zip file, to make sure all the files within it have been correctly extracted to the updates directory of your site. You could also upload the updates directory files from your development system, but that would be painfully slow.

With that confirmed, you can then safely click the upgrade button within concrete5. As it says on the dashboard page, before doing so you should always make a full database backup and ideally also a full files backup of your site.
dgreer replied on at Permalink Reply
Thanks for the quick reply.

There is no zip file in the updates directory. There is a directory under updates called concrete5.6.2.1_updater . Under that directory is a concrete directory and the file index.html.

For safety sake I will take your advice and unzip a new copy of the 5.6.2.1 update into the directory to make sure I have all the correct files.

Am I correct in saying once that is done I simply go into the Concrete5 Dashboard and choose Update Concrete5 under the Backup and Restore section? Does selecting this option copy the files from concrete5.6.2.1_updater to my website's concrete directory and then perform any needed database updates, etc?

Thank you