Update remotely from 9.3.9 to 9.4.1, I got the following error

Installation
1

Please let me know.

When I tried to update remotely from 9.3.9 to 9.4.1, I got the following error.

An exception occurred while executing ‘ALTER TABLE Logs ADD CID INT UNSIGNED DEFAULT NULL’:
SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name ‘cID’.

It is unclear whether this is actually an error.

The update was successful on a development site with a similar configuration.

When viewing Home, the following error occurred and neither administrators nor guests could view the site.

Cannot obtain permission key for view_debug_error_information.
/public_html/updates/concrete-cms-9.4.1-remote-updater/concrete/src/Permission/Checker.php (line 70)

My site will recover, but there will be problems with future updates.

2

Additional information:
The operational site was updated in “maintenance mode.”

3

Adding the cID column in the Logs table is transient and can be ignored.

How errors get shown is now managed by permissions.

If you go to task permissions in the dashboard you will find “View Debug Error Information” near the bottom of the list. Try setting it to “Administrators”. It doesn’t really matter what you set it at, or even if it ends up as None, as long as it gets saved and that should create the missing key.

4

John. Thanks.
I guess I’m not seeing the error information I need.

Unfortunately, I’m also unable to view the dashboard. Error below.
“Unable to get permission key for view_debug_error_information”

5

You could try repeating the update through the CLI with the ‘force’ option.

6

Would SSH be more flexible?
This is my first time doing this so I’m not confident, but I’ll look into it and give it a try.

Thank you.

7

SSH and CLI avoids a lot of CMS code, so will dodge most errors.

I suspect your site is in a small cascade. A minor error is occurring, but it can’t report it because the permission key for reporting doesn’t exist. And you can’t create the permission key because of the error that prevents you from getting to the page that would do so.

1 Like
8

I restored the config folder and database from 9.3.9 before the update.

Attempt to assignproperty"cPathFetchIsCanonical"on null

I created a separate thread for this.