Can't display users / Sharing not possible

aecklers · April 10, 2020, 2:57pm

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"

Paradox551 · April 10, 2020, 3:04pm

Have you verified if this is fixed in 19 beta2? If so it’s probably being backported to 18.0.3.

aecklers · April 10, 2020, 3:10pm

No. Not really sure what to do here, to get everything up and running.

Paradox551 · April 10, 2020, 3:12pm

The same way you installed your current instance. If you’re using docker etc though probably not possible.

aecklers · April 10, 2020, 4:29pm

For being honest I dont’t get the context between 19 beta 2 and my actual issue.

I’m using a virtual server with nginx, MariaDB and PHP 7.2, no docker included.

Paradox551 · April 10, 2020, 4:33pm

Okay so your issue occurs on 19 beta 2? I do not have any of those issues on it.

aecklers · April 11, 2020, 6:06pm

Well, an update is actually not possible, (probably) due to the same reason. Initializing the update works well. Running through the list

…
Delete old files
Move new files in place
Keep maintenance mode active?
Done

works without any error. When the installation process starts after that, I get the following error message:

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

Detaillierte Protokollmeldungen (translation: Detailed protocol)

Das Update ist fehlgeschlagen. Bitte melde dieses Problem an die Nextcloud Community. (translation: Updated failed. Please report this problem to the Nextcloud Community).

Any ideas?

BR
Toni

aecklers · April 11, 2020, 6:19pm

Got it.

Adding these lines to the /etc/my.cnf let the installation go foward:

innodb_large_prefix=1
innodb_large_prefix=true
innodb_file_per_table=true
innodb_file_format=barracuda

In Nextcloud 19.0.0 beta 2 everything (although sharing) works finde now. Just rolling back to NC 18 to see if this fixes the issue too.

Update:
Works with 19.0.0 beta 2 but not with 18.0.3

Update II:
After logging in to the console again, I had to comment those lines out of the my.cnf due to the error that appeared after typing in “mariadb” to get the mariadb prompt:

$ mariadb
mariadb: unknown variable 'innodb_large_prefix=true'

aecklers · April 11, 2020, 7:42pm

Fixed it.

I didn’t mark this thread as solved because I’m not sure if this will run me into further issues later, e.g. while updating. Would be interesting if someone with a bit more knowledge than I could comment on that.

Here is the solution I used.

Using this official guide, beginning with the part MariaDB 10.2 or earlier part.
Continue - as suggested in the documentation - with 3. of the MySQL part (-> Restart the MySQL server in case you changed the configuration in step 1…)
At point 6, the following command gives the failure message written somewhere above:
sudo -u www-data php occ maintenance:repair
Edit the /etc/mysql/my.cnf and add the following lines:
innodb_large_prefix=1
innodb_large_prefix=true
innodb_file_per_table=true
innodb_file_format=barracuda
Restart MySQL server
Run the command from abova again. Now it might work:
sudo -u www-data php occ maintenance:repair
Restart server
When I want to open the MariaDB interface by typing in mariadb I receive the following error: -bash: maraidb: command not found, so I uncommented the 4 lines I added before from my /etc/mysql/my.cnf file.