I activated the server-side encryption a long time ago. I would like to deactivat for upgrade to NC21.
I currently have Nexcloud 20.0.14 installed at a web hoster. On the server I have no root access. I can administrate the db with myphpadmin.
I have upgraded the MySql database from 5.7 to version 8 from the web host.
Unfortunately I always get error messages when trying to disable the old server side encryption. According to your documentation I should check with occ encryption:scan:legacy-format if I can decrypt the data.
When I execute the command, I get the error:
In AbstractMySQLDriver.php line 106:
An exception occurred while executing ‘SELECT uid, displayname FROM oc _users u LEFT JOIN oc_preferences p ON (userid = uid) AND (appi d = ‘settings’) AND (configkey = ‘email’) WHERE (uid COLLATE utf8mb4_
general_ci LIKE ?) OR (displayname COLLATE utf8mb4_general_ci LIKE ?) OR
(configvalue COLLATE utf8mb4_general_ci LIKE ?) ORDER BY uid_lower AS
C LIMIT 500’ with params ["%%", “%%”, “%%”: ]
SQLSTATE[42000: Syntax error or access violation: 1253 COLLATION ‘utf8mb4_ ]
general_ci’ is not valid for CHARACTER SET ‘utf8mb3’.
It seems that the oc_users table is affected.
Unfortunately, no solution found has worked so far.
How do I get this solved?