Database connection error after manual update to v6
Development and Programming
My site was on version 5.4.3. I tried performing the auto update to v6, but an error occurred and then I got message that it would rollback to 5.4.3. I then tried to update manually to v6, and now when I try to go to site or control panel I get this message:
Exception Caught There was a database connection error or a problem with a query. Log in as a super admin or enable debugging for more information. mysqli_connection.php:114
I checked the database access details in the config file, and those look fine. Anyone have other thoughts on how to fix this? In case this gives any clues, I am posting the error I got when I tried the auto-update (redacted).
Thank you in advance for any assistance!
The error tells you it could not find a table which means something broke during the upgrade.
Try deleting the installation folder completely on the server, then upload it again and try to see if you can upgrade.
If that does not work, then try re-uploading all your v5 files from your local installation to the server again, overwritten the v6 failed upgrade.
Thank you for that advice. I copied up my old files and have successfully rolled back to 5.4.3. I tried again to run the automatic update to v6, and received the same error messages again (see the image in my original post.)
Does the table ee_cookie_settings exists in your database?
No, it does not.
Any recommendations for how to add this table to the database? (I imagine it needs the exact field structure.)
I don’t know if this table is supposed to be in version 5, and you don’t have it (reason upgrade is failing in that case) or it’s a new table shipped on version 6 and the installer is failing to create it as a new table.
I would suggest installing a new test site using version 5 (new) and check it.
If you want to create the table, just use your favorite database tool, the one you use to manage your databases, for example most hosting providers provide PHPmyAdmin or you can use something like Dbeaver.
If the table exists in version 5, then copy the table from your test installation to your live database.
If it does not exist, then upgrade is failing for another reason as it’s not being able to create it on the upgrade process. Maybe some add-on? Did you try to disable all add-ons before the upgrade?
Also what PHP and MySQL version are running?
We are having the same exact issue.
What was the resolution for this? Did it ever get fixed?