Nextcloud version (eg, 12.0.2): 18.0.3
Operating system and version (eg, Ubuntu 17.04): Ubuntu 18.04
Apache or nginx version (eg, Apache 2.4.25): nginx
PHP version (eg, 7.1): 7.2
SQL: MariaDB
The issue you are facing:
Hi,
I have a fresh installed NC (installed without any additional apps) that is up and running.
Steps to replicate it:
- When I go into Settings -> Users, I get a failure message, that there was an error during the request and continuing would not be possible (original message in German: “Es ist ein Fehler bei der Anfrage aufgetreten. Es kann nicht fortgefahren werden.”)
- While sharing content via link works fine, sharing content with another user doesn’t work, because no other user is found.
What did I try:
It seems as if the problem was discussed already in another thread. Due to the fact that I don’t have MyPHP Admin installed, I tried to go the “hard” way, following at first the “MARIA DB” part of the official documentation and then follow the “Enabling MySQL 4-byte support” setps from the same document.
As a database noob, it seems to me as if the Maria DB parts works well:
MariaDB [INFORMATION_SCHEMA]> SELECT NAME, SPACE, FILE_FORMAT FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME like "nextcloud%";
+---------------------------------------+-------+-------------+
| NAME | SPACE | FILE_FORMAT |
+---------------------------------------+-------+-------------+
| nextcloud/oc_accounts | 143 | Barracuda |
| nextcloud/oc_activity | 144 | Barracuda |
But when I get to step 7 of the overall guide, I receive the following errors:
/var/www/nextcloud# sudo -u www-data php occ maintenance:repair
Nextcloud is in maintenance mode - no apps have been loaded
- Repair MySQL collation
- Change row format for oc_addressbooks ...
- Change collation for oc_addressbooks ...
In AbstractMySQLDriver.php line 106:
An exception occurred while executing 'ALTER TABLE `oc_addressbooks` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;':
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
In PDOStatement.php line 119:
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
In PDOStatement.php line 117:
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
maintenance:repair [--include-expensive]
I’m a bit confused which way I should go next. So any help would be really appreciated!
If you see any misconfiguration in the logs feel free to let me know. It’s the first time I installed NC on my virtual server.
BR,
Toni
P.S. Full backup available, so could start right back from the fresh installed NC again.
The output of your Nextcloud log in Admin > Logging:
Error no app in context Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'ALTER TABLE `oc_addressbooks` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;': SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
2020-04-10T16:39:53+0200
Error no app in context 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' with params ["%%", "%%", "%%"]: SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8'
2020-04-10T16:31:26+0200
Error no app in context 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' with params ["%%", "%%", "%%"]: SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8'
2020-04-10T16:30:48+0200
Error no app in context 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' with params ["%%", "%%", "%%"]: SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8'
2020-04-10T16:30:21+0200
Error core 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 500 OFFSET 500' with params ["%%", "%%", "%%"]: SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8'
2020-04-10T16:30:21+0200
Error index Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'SELECT * FROM `oc_comments` WHERE (`message` COLLATE utf8mb4_general_ci LIKE ?) AND (`object_type` = ?) ORDER BY `creation_timestamp` DESC, `id` DESC LIMIT 100' with params ["%%", "files"]: SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8'
2020-04-10T16:30:16+0200
Error no app in context 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' with params ["%%", "%%", "%%"]: SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8'
2020-04-10T16:22:30+0200
Error no app in context 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' with params ["%%", "%%", "%%"]: SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8'
2020-04-10T16:19:27+0200
Error no app in context 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' with params ["%%", "%%", "%%"]: SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8'
2020-04-10T16:19:13+0200
Error no app in context 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 200' with params ["%sonja%", "%sonja%", "%sonja%"]: SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8'
2020-04-10T16:18:36+0200
Fatal webdav 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' with params ["%sonja%", "%sonja%", "%sonja%"]: SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8'
2020-04-10T16:18:35+0200
Error no app in context Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'ALTER TABLE `oc_addressbooks` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;': SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
2020-04-10T16:15:48+0200
Error no app in context Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'ALTER TABLE `oc_addressbooks` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;': SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
2020-04-10T16:02:15+0200
Error no app in context 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' with params ["%%", "%%", "%%"]: SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8'
2020-04-10T15:37:52+0200
Error index Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'SELECT * FROM `oc_comments` WHERE (`message` COLLATE utf8mb4_general_ci LIKE ?) AND (`object_type` = ?) ORDER BY `creation_timestamp` DESC, `id` DESC LIMIT 100' with params ["%%", "files"]: SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8'
2020-04-10T15:37:44+0200
Fatal webdav 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' with params ["%jdo%", "%jdo%", "%jdo%"]: SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8'
2020-04-10T15:37:30+0200
Error no app in context 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 200' with params ["%jdo%", "%jdo%", "%jdo%"]: SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8'
2020-04-10T15:37:30+0200
Fatal webdav 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' with params ["%jdo+%", "%jdo+%", "%jdo+%"]: SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8'
2020-04-10T15:37:29+0200
Error no app in context 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 200' with params ["%jdo+%", "%jdo+%", "%jdo+%"]: SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8'
2020-04-10T15:37:29+0200
Error no app in context 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 200' with params ["%jdo%", "%jdo%", "%jdo%"]: SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8'
2020-04-10T15:37:27+0200
Fatal webdav 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' with params ["%jdo%", "%jdo%", "%jdo%"]: SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8'
2020-04-10T15:37:27+0200
Error no app in context 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 200' with params ["%j%", "%j%", "%j%"]: SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8'
2020-04-10T15:37:26+0200
Fatal webdav 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' with params ["%j%", "%j%", "%j%"]: SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8'
2020-04-10T15:37:26+0200
Fatal webdav 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' with params ["%jdo%", "%jdo%", "%jdo%"]: SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8'
2020-04-10T15:37:01+0200
Error no app in context 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 200' with params ["%jdo%", "%jdo%", "%jdo%"]: SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8'
2020-04-10T15:37:00+0200
Error index Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'SELECT * FROM `oc_comments` WHERE (`message` COLLATE utf8mb4_general_ci LIKE ?) AND (`object_type` = ?) ORDER BY `creation_timestamp` DESC, `id` DESC LIMIT 100' with params ["%%", "files"]: SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8'
2020-04-10T15:36:42+0200
Error no app in context 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' with params ["%%", "%%", "%%"]: SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8'
2020-04-10T15:36:11+0200
Error no app in context 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' with params ["%%", "%%", "%%"]: SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8'
2020-04-10T15:36:07+0200
Error no app in context 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' with params ["%%", "%%", "%%"]: SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8'
2020-04-10T15:35:57+0200
Error no app in context 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 200' with params ["%sonja%", "%sonja%", "%sonja%"]: SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8'
2020-04-10T15:35:46+0200
Fatal webdav 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' with params ["%sonja%", "%sonja%", "%sonja%"]: SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8'
2020-04-10T15:35:46+0200
Error no app in context 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' with params ["%%", "%%", "%%"]: SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8'
2020-04-10T15:34:04+0200
Error no app in context 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' with params ["%%", "%%", "%%"]: SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8'
2020-04-10T15:33:56+0200
Fatal webdav Doctrine\DBAL\Exception\UniqueConstraintViolationException: An exception occurred while executing 'INSERT INTO `oc_calendars` (`principaluri`, `uri`, `synctoken`, `transparent`, `components`, `displayname`, `calendarcolor`) VALUES(?, ?, ?, ?, ?, ?, ?)' with params ["principals\/users\/jdo", "contact_birthdays", 1, 0, "VEVENT", "Contact birthdays", "#FFFFCA"]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'principals/users/jdo-contact_birthdays' for key 'calendars_index'
2020-04-10T15:22:42+0200
Fatal webdav Doctrine\DBAL\Exception\UniqueConstraintViolationException: An exception occurred while executing 'INSERT INTO `oc_calendars` (`principaluri`, `uri`, `synctoken`, `transparent`, `components`, `displayname`, `calendarcolor`) VALUES(?, ?, ?, ?, ?, ?, ?)' with params ["principals\/users\/jdo", "contact_birthdays", 1, 0, "VEVENT", "Contact birthdays", "#FFFFCA"]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'principals/users/jdo-contact_birthdays' for key 'calendars_index'
-- had to stop here due to character limitation in a post
The output of your config.php file in /path/to/nextcloud
(make sure you remove any identifiable information!):
<?php
$CONFIG = array (
'memcache.local' => '\\OC\\Memcache\\APCu',
'instanceid' => '----------',
'passwordsalt' => '----------',
'secret' => '----------',
'trusted_domains' =>
array (
0 => '----------',
),
'datadirectory' => '/var/www/nextcloud/data',
'dbtype' => 'mysql',
'version' => '18.0.3.0',
'overwrite.cli.url' => 'https:—————‚,
'dbname' => 'nextcloud',
'dbhost' => 'localhost',
'dbport' => '',
'dbtableprefix' => 'oc_',
'dbuser' => 'mrnextcloud',
'dbpassword' => '----------',
'installed' => true,
'maintenance' => false,
'mysql.utf8mb4' => true,
);
The output of your Apache/nginx/system log in /var/log/nextcloud.error
:
cat /var/log/nginx/nextcloud.error
2020/04/07 20:50:29 [error] 26125#26125: *745 access forbidden by rule, client: 176.199.---.---, server: subdomain.domain.de, request: "GET /data/.ocdata?t=1586292629051 HTTP/1.1", host: "subdomain.domain.de"
2020/04/07 21:16:55 [error] 26126#26126: *1453 access forbidden by rule, client: 176.199.---.---, server: subdomain.domain.de, request: "GET /data/.ocdata?t=1586294215770 HTTP/1.1", host: "subdomain.domain.de"
2020/04/07 21:24:23 [error] 26126#26126: *1689 access forbidden by rule, client: 176.199.---.---, server: subdomain.domain.de, request: "GET /data/.ocdata?t=1586294663577 HTTP/1.1", host: "subdomain.domain.de"
2020/04/07 21:32:16 [error] 26126#26126: *1862 access forbidden by rule, client: 176.199.---.---, server: subdomain.domain.de, request: "GET /data/.ocdata?t=1586295136557 HTTP/1.1", host: "subdomain.domain.de"
2020/04/07 21:32:36 [error] 4624#4624: *8 access forbidden by rule, client: 176.199.---.---, server: subdomain.domain.de, request: "GET /data/.ocdata?t=1586295156607 HTTP/1.1", host: "subdomain.domain.de"
2020/04/07 21:33:08 [error] 4625#4625: *44 access forbidden by rule, client: 176.199.---.---, server: subdomain.domain.de, request: "GET /data/.ocdata?t=1586295186771 HTTP/1.1", host: "subdomain.domain.de"
2020/04/07 21:35:44 [error] 4625#4625: *115 access forbidden by rule, client: 176.199.---.---, server: subdomain.domain.de, request: "GET /data/.ocdata?t=1586295344058 HTTP/1.1", host: "subdomain.domain.de"
2020/04/07 21:35:48 [error] 4625#4625: *143 access forbidden by rule, client: 176.199.---.---, server: subdomain.domain.de, request: "GET /data/.ocdata?t=1586295348679 HTTP/1.1", host: "subdomain.domain.de"
2020/04/07 21:40:37 [error] 4625#4625: *242 access forbidden by rule, client: 176.199.---.---, server: subdomain.domain.de, request: "GET /data/.ocdata?t=1586295637350 HTTP/1.1", host: "subdomain.domain.de"
2020/04/07 21:41:49 [error] 5431#5431: *1 access forbidden by rule, client: 176.199.---.---, server: subdomain.domain.de, request: "GET /data/.ocdata?t=1586295709769 HTTP/1.1", host: "subdomain.domain.de"
2020/04/07 21:42:03 [error] 5431#5431: *8 access forbidden by rule, client: 176.199.---.---, server: subdomain.domain.de, request: "GET /data/.ocdata?t=1586295723533 HTTP/1.1", host: "subdomain.domain.de"
2020/04/07 21:49:37 [error] 409#409: *59 access forbidden by rule, client: 176.199.---.---, server: subdomain.domain.de, request: "GET /data/.ocdata?t=1586296177829 HTTP/1.1", host: "subdomain.domain.de"
2020/04/07 21:49:50 [error] 408#408: *56 access forbidden by rule, client: 176.199.---.---, server: subdomain.domain.de, request: "GET /data/.ocdata?t=1586296190719 HTTP/1.1", host: "subdomain.domain.de"
2020/04/07 21:53:34 [error] 408#408: *179 access forbidden by rule, client: 176.199.---.---, server: subdomain.domain.de, request: "GET /data/.ocdata?t=1586296414265 HTTP/1.1", host: "subdomain.domain.de"
2020/04/07 22:04:12 [error] 409#409: *538 access forbidden by rule, client: 176.199.---.---, server: subdomain.domain.de, request: "GET /data/.ocdata?t=1586297052254 HTTP/1.1", host: "subdomain.domain.de"
2020/04/07 22:04:29 [error] 408#408: *539 access forbidden by rule, client: 176.199.---.---, server: subdomain.domain.de, request: "GET /data/.ocdata?t=1586297069547 HTTP/1.1", host: "subdomain.domain.de"
2020/04/07 22:08:31 [error] 1999#1999: *5 access forbidden by rule, client: 176.199.---.---, server: subdomain.domain.de, request: "GET /data/.ocdata?t=1586297311847 HTTP/1.1", host: "subdomain.domain.de"
2020/04/07 22:14:47 [error] 1999#1999: *1 access forbidden by rule, client: 176.199.---.---, server: subdomain.domain.de, request: "GET /data/.ocdata?t=1586297687685 HTTP/1.1", host: "subdomain.domain.de"
2020/04/07 22:21:43 [error] 2637#2637: *24 access forbidden by rule, client: 176.199.---.---, server: subdomain.domain.de, request: "GET /data/.ocdata?t=1586298103190 HTTP/1.1", host: "subdomain.domain.de"
2020/04/07 22:24:53 [error] 2733#2733: *11 access forbidden by rule, client: 176.199.---.---, server: subdomain.domain.de, request: "GET /data/.ocdata?t=1586298293159 HTTP/1.1", host: "subdomain.domain.de"
2020/04/07 22:33:43 [error] 419#419: *65 access forbidden by rule, client: 176.199.---.---, server: subdomain.domain.de, request: "GET /data/.ocdata?t=1586298823674 HTTP/1.1", host: "subdomain.domain.de"
2020/04/07 22:36:27 [error] 419#419: *196 access forbidden by rule, client: 176.199.---.---, server: subdomain.domain.de, request: "GET /data/.ocdata?t=1586298987945 HTTP/1.1", host: "subdomain.domain.de"
2020/04/07 22:52:58 [error] 419#419: *792 access forbidden by rule, client: 176.199.---.---, server: subdomain.domain.de, request: "GET /data/.ocdata?t=1586299978349 HTTP/1.1", host: "subdomain.domain.de"
2020/04/10 14:25:32 [error] 409#409: *261 access forbidden by rule, client: 176.199.---.---, server: subdomain.domain.de, request: "GET /data/.ocdata?t=1586528732306 HTTP/1.1", host: "subdomain.domain.de"