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[42000]: 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.