Database Errors - Nextcloud 15

#1

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?

#2

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 :wink:
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.

#3

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?

#4

The OCC Web app might be an option for you.

#5

Hello,

Thank you for the brilliant reference to OCC Web.