I’m on the latest version of Nextcloud 19. I’ve enabled mysql4-byte support following the documentation :
Nextcloud works fine, but when I’ve done the repair process i’ve had the error message you see on the screenshot. Is this something I should worry about ?
Users list is empty because of a problem with the query. I have this message in the log :
Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘SELECT
u LEFT JOIN
p ON (
uid) AND (
appid = ‘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 ASC LIMIT 25’ with params ["%%", “%%”, “%%”]: SQLSTATE: Syntax error or access violation: 1253 COLLATION ‘utf8mb4_general_ci’ is not valid for CHARACTER SET ‘utf8’
Could it be related to the error above ?
It’s my mistake. I haven’t noticed that Centos was shipped with Mariadb 5.5. After upgrading to Mariadb 10.5 and running the occ repair command, everything works fine. No more error message.