Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘SELECT uid, displayname FROM oc_usersu LEFT JOIN oc_preferencesp ON (userid = 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 OFFSET 0’ with params ["%%", “%%”, “%%”]: SQLSTATE: Syntax error or access violation: 1253 COLLATION ‘utf8mb4_general_ci’ is not valid for CHARACTER SET ‘utf8’
Does anyone know how these bugs can be eliminated?
In a first attempt I would recommend to use the nice little magnifying glass in the upper right corner of the screen to search the forum for related issues
You will see that your question has already been asked multiple times, more or less with different SQL queries, and therefore it is very likely that they contain an answer on your question, e.g.