Update from v5.6.2.1 to v5.6.3.1 failure
Permalink
Hi there,
I logged into our companies c5 admin area and saw a message something along the lines of:
"Current Version 5.6.2.1
An update is available. Click below to update to 5.6.3.1"
It was also warning me to backup the db... which I did via phpmyadmin (since the c5 backup kept failing due to same old timing out problem with its built in backup function).
Anyway, after backing up I ran the update... but immediately got this message:
with the option to re-run the script - which I'm guessing is probably pointless until I work out why it failed...
If I now go to the update page, it says:
"Currently Running 5.6.2.1
No updates available."
So now that it failed to update to the latest version, it's no longer aware of the newer version??
Anyone got any ideas how to fix this? has anyone else run into this and found a way around it?
Any help would be greatly appreciated...
I logged into our companies c5 admin area and saw a message something along the lines of:
"Current Version 5.6.2.1
An update is available. Click below to update to 5.6.3.1"
It was also warning me to backup the db... which I did via phpmyadmin (since the c5 backup kept failing due to same old timing out problem with its built in backup function).
Anyway, after backing up I ran the update... but immediately got this message:
An Unexpected Error occurred while upgrading: #0 /var/www/clients/client1/web1/web/updates/concrete5.6.3.1_updater/concrete/libraries/3rdparty/adodb/adodb.inc.php(1074): adodb_throw('mysqlt', 'EXECUTE', 1142, 'INDEX command d...', 'DROP INDEX cDat...', false, Object(ADODB_mysqlt)) #1 /var/www/clients/client1/web1/web/updates/concrete5.6.3.1_updater/concrete/libraries/3rdparty/adodb/adodb.inc.php(1049): ADOConnection->_Execute('DROP INDEX cDat...', false) #2 /var/www/clients/client1/web1/web/updates/concrete5.6.3.1_updater/concrete/libraries/3rdparty/adodb/adodb-datadict.inc.php(378): ADOConnection->Execute('DROP INDEX cDat...') #3 /var/www/clients/client1/web1/web/updates/concrete5.6.3.1_updater/concrete/libraries/3rdparty/adodb/adodb-xmlschema03.inc.php(1737): ADODB_DataDict->ExecuteSQLArray(Array, false) #4 /var/www/clients/client1/web1/web/updates/concrete5.6.3.1_updater/concrete/core/models/package.php(207): adoSchema->ExecuteSchema() #5 /var/www/clients/client1/web1/web/updates/concrete5.6.3.1_updater/concrete/core/controllers/single_pages/upgrade.php(230): Concrete5_Model_Package::installDB('/var/www/allotz...') #6 /var/www/clients/client1/web1/web/updates/concrete5.6.3.1_updater/concrete/core/controllers/single_pages/upgrade.php(251): Concrete5_Controller_Upgrade->refreshDatabaseTables(Array) #7 /var/www/clients/client1/web1/web/updates/concrete5.6.3.1_updater/concrete/core/controllers/single_pages/upgrade.php(44): Concrete5_Controller_Upgrade->do_upgrade() #8 [internal function]: Concrete5_Controller_Upgrade->view('tools', 'required', 'upgrade') #9 /var/www/clients/client1/web1/web/updates/concrete5.6.3.1_updater/concrete/core/libraries/controller.php(267): call_user_func_array(Array, Array) #10 /var/www/clients/client1/web1/web/updates/concrete5.6.3.1_updater/concrete/core/libraries/controller.php(237): Concrete5_Library_Controller->runTask('view', Array) #11 /var/www/clients/client1/web1/web/updates/concrete5.6.3.1_updater/concrete/core/libraries/view.php(774): Concrete5_Library_Controller->setupAndRun() #12 /var/www/clients/client1/web1/web/updates/concrete5.6.3.1_updater/concrete/tools/upgrade.php(6): Concrete5_Library_View->render('/upgrade') #13 /var/www/clients/client1/web1/web/updates/concrete5.6.3.1_updater/concrete/startup/tools_upgrade_check.php(9): include('/var/www/client...') #14 /var/www/clients/client1/web1/web/updates/concrete5.6.3.1_updater/concrete/dispatcher.php(105): require('/var/www/client...') #15 /var/www/clients/client1/web1/web/concrete/startup/updated_core_check.php(7): require('/var/www/client...') #16 /var/www/clients/client1/web1/web/concrete/dispatcher.php(25): require('/var/www/client...') #17 /var/www/clients/client1/web1/web/index.php(2): require('/var/www/client...') #18 {main}
with the option to re-run the script - which I'm guessing is probably pointless until I work out why it failed...
If I now go to the update page, it says:
"Currently Running 5.6.2.1
No updates available."
So now that it failed to update to the latest version, it's no longer aware of the newer version??
Anyone got any ideas how to fix this? has anyone else run into this and found a way around it?
Any help would be greatly appreciated...
I think you must upgrade to 5.6.3 before 5.6.3.1.
When I tried to update from 5.6.2.1 to 5.6.3.1, all I got was a blank screen.
Do I have to update to 5.6.3 first? Can this be done within the website like previous updates?
Do I have to update to 5.6.3 first? Can this be done within the website like previous updates?
Firstly, chances are if you got that error message, you may be stuck somewhere in between upgrades. It's possible that part of the upgrade ran, and other parts didn't and you just aren't seeing side effects of the pieces that didn't yet.
That said you should probably roll your database back to the previous version of c5, and change your /config/site.php file to point back to the old version. Any time there is an error involved it's better to roll back and start from something you know is clean rather than continue for some period of time only to find that the next update fails for some reason and then the issue becomes compounded.
I would roll back to your 5.6.2.1 database and modify your config file as well. Then I would try and go through a manual upgrade process.
That said you should probably roll your database back to the previous version of c5, and change your /config/site.php file to point back to the old version. Any time there is an error involved it's better to roll back and start from something you know is clean rather than continue for some period of time only to find that the next update fails for some reason and then the issue becomes compounded.
I would roll back to your 5.6.2.1 database and modify your config file as well. Then I would try and go through a manual upgrade process.
I have had this happen on quiet a few occasions when upgrading from 5.6.2.1 to 5.6.3.1.
In some cases I had to reload the database back in and clear the upgrade path in the site.php file.
The problem seems to stem from downloading the upgrade via the dashboard. It seems to take forever and then an error message appears.
My work around in the end is to manually upload a good copy of the 5.6.3.1 upgrade directly into the upgrades folder using FTP. Rather than downloading it via Dashboard.
Then once uploaded, upgrade the site using the dashboard. Just make sure you back up the DB before you do this and also make sure the copy of the 5.6.3.1 upgrade folder is complete with all the files included.
Hope this helps.
In some cases I had to reload the database back in and clear the upgrade path in the site.php file.
The problem seems to stem from downloading the upgrade via the dashboard. It seems to take forever and then an error message appears.
My work around in the end is to manually upload a good copy of the 5.6.3.1 upgrade directly into the upgrades folder using FTP. Rather than downloading it via Dashboard.
Then once uploaded, upgrade the site using the dashboard. Just make sure you back up the DB before you do this and also make sure the copy of the 5.6.3.1 upgrade folder is complete with all the files included.
Hope this helps.
