update from 8.5.2 to 8.5.4 or 8.5.5 fails - Doctrine \ DBAL \ Exception \ DriverException ?
I am in charge of a website running concrete5 version 8.5.2. Trying to update to version 8.5.4 by replacing directly the concrete core folder on the server throws an error.
I tried also to update to version 8.5.5, either by replacing directly the concrete core folder on the server and also by running the update routine through the dashboard. Both ways throw the same former error as trying to update to version 8.5.4.
Fortunately restoring with the backup I had made before update trial worked.
Strangely the same updates from version 8.5.2 to 8.5.4 and further to 8.5.5 on another website, which is hosted by the same provider, ran smoothly through without any problems.
I attach for documentation the following files:
- 20200924-C5-8-5-4-update-issue.png => screenshot of the error message
- 20210321-C5-8-5-5-update-issue.png => screenshot of the error message
- 20210325-C5-environment-natalesapone.pdf => environment informations in the dashboard of the running website before update trial
- 20210321-C5-8-5-5-update-issue.txt => underlying html-code of the error message
- 20210321-php-info-natalesapone.txt => underlying html-code of the php environment of the website
I am no programmer or developer, so I don’t understand exactly what the problem is. It seems to have to do somehow with the database?
Any help or comment will be greatly appreciated.
Personally, having a server, I always duplicate the site and the database and I create a subdomain which points to the new version on which I apply this update. If all goes well, I point the domain to this new version and I keep the old one for a few days on the server, the time to make sure there are no hidden problems.
- Turn off and then clear the cache
- Put Doctrine into development mode (dashboard search for 'Entities')
- Run the search index all job
- Run the update from the CLI
You could also swap the theme to Elemental during update and use my Extreme Clean addon to clean up first, so the update has minimal data to chew through (https://c5magic.co.uk/addons/extreme-clean... ).
However, as your issue is within Express, I suspect none of the above will help.
You may be able to trick it by manually making the equivalent table alteration, so the update doesn't have to. Or doing such may cause further complications :-(
I speak german, do only sporadically website-work and english abbreviations this way are not very familiar to me, sorry
Unfortunately I’m not really familiar with command-line-work, so there's the chance to make more damage than success ... I'll see, what I can do.
I will be back to give feedback, when I tried some things, but it will take some time ;-)
Somehow monitoring this thread didn’t work; I didn’t get an email telling me about your posts. Came back today occasionally and saw your posts, thanks! Will come back after trying some of your advices.
With a backup of the live website running version 8.5.2 I installed it into a subdomain in order to run the trials in the subdomain, just in case something would break seriously, maybe even preventing to restore it out of the backup.
Following the advice before trying to update to version 8.5.5 everytime I turned off and cleared cache, put doctrine in development mode and ran the search index all job. Neither replacing the concrete directory directly through controlpanel PLESK, nor going through dashboard updating routine, nor running the update from the CLI worked. Everytime it threw the already known same error, see the attached screenshot of the CLI-log (20210418-c5-CLI-update-failure-log.png).
Reading the error message it seems to have to do something with ‚foreign keys‘ in the database. Without having read the whole release notes of version 8.5.3 I read by chance the last note of it saying ‚Add ForeignKeyFixer and c5:database:foreignkey:fix CLI command (thanks mlocati)‘. I had already thought before to try updating the versions ‚step-by-step‘, e.g. from the running 8.5.2 first to 8.5.3 and only then to 8.5.4 and further to 8.5.5. So I tried this too by replacing the concrete directory directly through controlpanel PLESK with version 8.5.3. It threw again the same error message, see the attached screenshot of the browser window depicting ‚version 8.5.3. / installed version 8.5.2‘ (20210419-c5-CLI-update-failure-screenshot.png).
So any other idea or suggestion is still very much appreciated, thanks.
I raised PHP memory limit from 256 MB to 512 MB on the server ... the installation went through then.
Maybe it's worth a try.
In fact, I have two add-ons on the website, where the update doesn’t work: Login/Logout Link (1.0) and Simple Gallery (1.0.7). Could that create the problem in updating the database, as the error message definitely points to a database problem?