Database Errors - Nextcloud 15

[Ben2003]

Hello,

Database errors appear in the log:

Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘SELECT uid, displayname FROM oc_users u LEFT JOIN oc_preferences p 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?

[j-ed]

Syntax error or access violation: 1253 COLLATION ‘utf8mb4_general_ci’ is not valid for CHARACTER SET ‘utf8’

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.

Nextcloud 14 Upgrade - Users database not working properly

Hi. I upgraded my server, and some things are not working corectly. There are a few things that I observed. 1.Every user can log into their account ok, but in the admin/Users it shows “No Users in here”. But I can see the list of the users in the group tabs. 2.Sharing is not working. If one user does not have any “personal” files, but just shares from other users, those are gone, and the sync client gives an error. If I remove the “folder sync connection” and try to make it again, the share is…

[Ben2003]

Hello,

Thanks for the information.

The problem is that the occ command can not be started because no shell is available.

A separate php file with the occ command is not executed, as the internal rules redirect access to the php file.

There is only one file manager on the web server for creating and editing any files.

In addition, commands can be made directly to the database via phpMyAdmin.

Can someone explain to me how the occ command can be executed through the web interface?

[j-ed]

The OCC Web app might be an option for you.

[Ben2003]

Hello,

Thank you for the brilliant reference to OCC Web.