Database failure while upgrading from 7.11.3 to 7.12.2

đź’¬ General Discussion
1

Hi.

I’m upgrading my SuiteCRM version 7.11.3 to 7.12.2.

The first step “System Check” - shows an error on the screen “Database failure. Please refer to suitecrm.log for details.”

upgradeWizard.log file has this:

Mon, 03 Jan 2022 05:44:54 +0000 [UpgradeWizard] - Upgrade started. At start.php
Mon, 03 Jan 2022 05:44:54 +0000 [UpgradeWizard] - at unlinkUWTempFiles()
Mon, 03 Jan 2022 05:44:54 +0000 [UpgradeWizard] - finished!
Mon, 03 Jan 2022 05:44:54 +0000 [UpgradeWizard] - resetting $_SESSION
Mon, 03 Jan 2022 05:44:59 +0000 [UpgradeWizard] - setting session variables...
Mon, 03 Jan 2022 05:44:59 +0000 [UpgradeWizard] - [At systemCheck.php]
Mon, 03 Jan 2022 05:44:59 +0000 [UpgradeWizard] - Starting file permission check...
Mon, 03 Jan 2022 05:45:40 +0000 [UpgradeWizard] - Finished file permission check.
Mon, 03 Jan 2022 05:45:40 +0000 [UpgradeWizard] - Starting database permissions check...
Mon, 03 Jan 2022 05:45:40 +0000 [UpgradeWizard] - Checking CREATE TABLE permissions...
Mon, 03 Jan 2022 05:45:40 +0000 [UpgradeWizard] - cannot CREATE TABLE!
Mon, 03 Jan 2022 05:45:40 +0000 [UpgradeWizard] - Checking INSERT INTO permissions...
Mon, 03 Jan 2022 05:45:40 +0000 [UpgradeWizard] - cannot INSERT INTO!
Mon, 03 Jan 2022 05:45:40 +0000 [UpgradeWizard] - Checking UPDATE TABLE permissions...
Mon, 03 Jan 2022 05:45:40 +0000 [UpgradeWizard] - cannot UPDATE TABLE!
Mon, 03 Jan 2022 05:45:40 +0000 [UpgradeWizard] - Checking SELECT permissions...
Mon, 03 Jan 2022 05:45:40 +0000 [UpgradeWizard] - cannot SELECT!
Mon, 03 Jan 2022 05:45:40 +0000 [UpgradeWizard] - Checking DELETE FROM permissions...
Mon, 03 Jan 2022 05:45:40 +0000 [UpgradeWizard] - cannot DELETE FROM!
Mon, 03 Jan 2022 05:45:40 +0000 [UpgradeWizard] - Checking ALTER TABLE ADD COLUMN permissions...
Mon, 03 Jan 2022 05:45:40 +0000 [UpgradeWizard] - cannot ADD COLUMN!
Mon, 03 Jan 2022 05:45:40 +0000 [UpgradeWizard] - Checking ALTER TABLE CHANGE COLUMN permissions...
Mon, 03 Jan 2022 05:45:40 +0000 [UpgradeWizard] - cannot CHANGE COLUMN!
Mon, 03 Jan 2022 05:45:40 +0000 [UpgradeWizard] - Checking ALTER TABLE DROP COLUMN permissions...
Mon, 03 Jan 2022 05:45:40 +0000 [UpgradeWizard] - cannot DROP COLUMN!
Mon, 03 Jan 2022 05:45:40 +0000 [UpgradeWizard] - Checking DROP TABLE permissions...
Mon, 03 Jan 2022 05:45:40 +0000 [UpgradeWizard] - cannot DROP TABLE!
Mon, 03 Jan 2022 05:45:40 +0000 [UpgradeWizard] - Finished database permissions check.
Mon, 03 Jan 2022 05:51:54 +0000 [UpgradeWizard] - setting session variables...
Mon, 03 Jan 2022 05:51:54 +0000 [UpgradeWizard] -

What are your suggestions?

Thanks in advance!

2

Based on the error log it looks like your database user doesn’t have the ability to edit the tables. Do you have any other issues with making changes to the database, like for example creating fields in studio?

I would first check if you are able to make changes manually to the database using the username/password stored in the config.php

4

Thanks @samus-aran

Let me check those permissions.