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 not visible in the users account.
3.I can’t make any new users.
4.In the users tab i get the error " An error occured during the request. Unable to proceed."

  • Ubuntu 18.04
  • Nextcloud 14.0.0
  • Apache/2.4.29 (Ubuntu)
  • Database client version: libmysql - mysqlnd 5.0.12-dev
  • PHP extension: mysqli[
  • PHP version: 7.2.9-1+ubuntu18.04.1+deb.sury.org+1

Any ideas?

Best regards from Transylvania,
Paul

Can you check your logfiles? Then make sure that the sharing app is enabled and that sharing is allowed by the admin (check admin page).

This is the last part of my nextcloud.log file.
{“reqId”:“9OrfB31FO1hWvDm0fpG3”,“level”:0,“time”:“2018-09-24T08:39:32+00:00”,“remoteAddr”:“10.0.0.1”,“user”:"–",“app”:“cron”,“method”:“GET”,“url”:"/nextcloud/cron.php",“message”:“Run OC\Command\CommandJob job with ID 1358”,“userAgent”:“Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.106 Safari/537.36”,“version”:“14.0.0.19”}
{“reqId”:“9OrfB31FO1hWvDm0fpG3”,“level”:0,“time”:“2018-09-24T08:39:32+00:00”,“remoteAddr”:“10.0.0.1”,“user”:"–",“app”:“cron”,“method”:“GET”,“url”:"/nextcloud/cron.php",“message”:“Finished OC\Command\CommandJob job with ID 1358 in 0 seconds”,“userAgent”:“Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.106 Safari/537.36”,“version”:“14.0.0.19”}
{“reqId”:“beyMavZFMBxSz0o0SLSE”,“level”:3,“time”:“2018-09-24T08:39:41+00:00”,“remoteAddr”:“10.0.0.1”,“user”:“paul”,“app”:“no app in context”,“method”:“GET”,“url”:"/nextcloud/ocs/v1.php/apps/files_sharing/api/v1/sharees?format=json&search=ac&perPage=200&itemType=folder",“message”:{“Exception”:“Doctrine\DBAL\Exception\DriverException”,“Message”:“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 OFFSET 0’ with params [”%ac%", “%ac%”, “%ac%”]:\n\nSQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION ‘utf8mb4_general_ci’ is not valid for CHARACTER SET ‘utf8’",“Code”:0,“Trace”:[{“file”:"/var/www/xxxxxxxxxx.com/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php",“line”:128,“function”:“convertException”,“class”:“Doctrine\DBAL\Driver\AbstractMySQLDriver”,“type”:"->",“args”:[“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 OFFSET 0’ with params [”%ac%", “%ac%”, “%ac%”]:\n\nSQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION ‘utf8mb4_general_ci’ is not valid for CHARACTER SET ‘utf8’",{“errorInfo”:[“42000”,1253,“COLLATION ‘utf8mb4_general_ci’ is not valid for CHARACTER SET ‘utf8’”],“class”:“Doctrine\DBAL\Driver\PDOException”}]},{“file”:"/var/www/xxxxxxxxxx.com/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php",“line”:855,“function”:“driverExceptionDuringQuery”,“class”:“Doctrine\DBAL\DBALException”,“type”:"::",“args”:[{“class”:“Doctrine\DBAL\Driver\PDOMySql\Driver”},{“errorInfo”:[“42000”,1253,“COLLATION ‘utf8mb4_general_ci’ is not valid for CHARACTER SET ‘utf8’”],“class”:“Doctrine\DBAL\Driver\PDOException”},“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 OFFSET 0”,{“1”:"%ac%",“2”:"%ac%",“3”:"%ac%"}]},{“file”:"/var/www/xxxxxxxxxx.com/nextcloud/lib/private/DB/Connection.php",“line”:195,“function”:“executeQuery”,“class”:“Doctrine\DBAL\Connection”,“type”:"->",“args”:[“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 OFFSET 0”,{“1”:"%ac%",“2”:"%ac%",“3”:"%ac%"},{“1”:2,“2”:2,“3”:2},null]},{“file”:"/var/www/xxxxxxxxxx.com/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php",“line”:206,“function”:“executeQuery”,“class”:“OC\DB\Connection”,“type”:"->",“args”:[“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 OFFSET 0”,{“1”:"%ac%",“2”:"%ac%",“3”:"%ac%"},{“1”:2,“2”:2,“3”:2}]},{“file”:"/var/www/xxxxxxxxxx.com/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",“line”:214,“function”:“execute”,“class”:“Doctrine\DBAL\Query\QueryBuilder”,“type”:"->",“args”:[]},{“file”:"/var/www/xxxxxxxxxx.com/nextcloud/lib/private/User/Database.php",“line”:278,“function”:“execute”,“class”:“OC\DB\QueryBuilder\QueryBuilder”,“type”:"->",“args”:[]},{“file”:"/var/www/xxxxxxxxxx.com/nextcloud/lib/private/User/Manager.php",“line”:258,“function”:“getDisplayNames”,“class”:“OC\User\Database”,“type”:"->",“args”:[“ac”,200,0]},{“file”:"/var/www/xxxxxxxxxx.com/nextcloud/lib/private/Collaboration/Collaborators/UserPlugin.php",“line”:79,“function”:“searchDisplayName”,“class”:“OC\User\Manager”,“type”:"->",“args”:[“ac”,200,0]},{“file”:"/var/www/xxxxxxxxxx.com/nextcloud/lib/private/Collaboration/Collaborators/Search.php",“line”:65,“function”:“search”,“class”:“OC\Collaboration\Collaborators\UserPlugin”,“type”:"->",“args”:[“ac”,200,0,{“class”:“OC\Collaboration\Collaborators\SearchResult”}]},{“file”:"/var/www/xxxxxxxxxx.com/nextcloud/apps/files_sharing/lib/Controller/ShareesAPIController.php",“line”:194,“function”:“search”,“class”:“OC\Collaboration\Collaborators\Search”,“type”:"->",“args”:[“ac”,[0,1,6,4],true,200,0]},{“file”:"/var/www/xxxxxxxxxx.com/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",“line”:166,“function”:“search”,“class”:“OCA\Files_Sharing\Controller\ShareesAPIController”,“type”:"->",“args”:[“ac”,“folder”,1,200,null,true]},{“file”:"/var/www/xxxxxxxxxx.com/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",“line”:99,“function”:“executeController”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->",“args”:[{“class”:“OCA\Files_Sharing\Controller\ShareesAPIController”},“search”]},{“file”:"/var/www/xxxxxxxxxx.com/nextcloud/lib/private/AppFramework/App.php",“line”:118,“function”:“dispatch”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->",“args”:[{“class”:“OCA\Files_Sharing\Controller\ShareesAPIController”},“search”]},{“file”:"/var/www/xxxxxxxxxx.com/nextcloud/lib/private/AppFramework/Routing/RouteActionHandler.php",“line”:47,“function”:“main”,“class”:“OC\AppFramework\App”,“type”:"::",“args”:[“OCA\Files_Sharing\Controller\ShareesAPIController”,“search”,{“class”:“OC\AppFramework\DependencyInjection\DIContainer”},{"_route":“ocs.files_sharing.ShareesAPI.search”}]},{“function”:"__invoke",“class”:“OC\AppFramework\Routing\RouteActionHandler”,“type”:"->",“args”:[{"_route":“ocs.files_sharing.ShareesAPI.search”}]},{“file”:"/var/www/xxxxxxxxxx.com/nextcloud/lib/private/Route/Router.php",“line”:297,“function”:“call_user_func”,“args”:[{“class”:“OC\AppFramework\Routing\RouteActionHandler”},{"_route":“ocs.files_sharing.ShareesAPI.search”}]},{“file”:"/var/www/xxxxxxxxxx.com/nextcloud/ocs/v1.php",“line”:82,“function”:“match”,“class”:“OC\Route\Router”,“type”:"->",“args”:["/ocsapp/apps/files_sharing/api/v1/sharees"]}],“File”:"/var/www/xxxxxxxxxx.com/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php",“Line”:115,“Previous”:{“Exception”:“Doctrine\DBAL\Driver\PDOException”,“Message”:“SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION ‘utf8mb4_general_ci’ is not valid for CHARACTER SET ‘utf8’”,“Code”:“42000”,“Trace”:[{“file”:"/var/www/xxxxxxxxxx.com/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php",“line”:847,“function”:“execute”,“class”:“Doctrine\DBAL\Driver\PDOStatement”,“type”:"->",“args”:[]},{“file”:"/var/www/xxxxxxxxxx.com/nextcloud/lib/private/DB/Connection.php",“line”:195,“function”:“executeQuery”,“class”:“Doctrine\DBAL\Connection”,“type”:"->",“args”:[“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 OFFSET 0”,{“1”:"%ac%",“2”:"%ac%",“3”:"%ac%"},{“1”:2,“2”:2,“3”:2},null]},{“file”:"/var/www/xxxxxxxxxx.com/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php",“line”:206,“function”:“executeQuery”,“class”:“OC\DB\Connection”,“type”:"->",“args”:[“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 OFFSET 0”,{“1”:"%ac%",“2”:"%ac%",“3”:"%ac%"},{“1”:2,“2”:2,“3”:2}]},{“file”:"/var/www/xxxxxxxxxx.com/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",“line”:214,“function”:“execute”,“class”:“Doctrine\DBAL\Query\QueryBuilder”,“type”:"->",“args”:[]},{“file”:"/var/www/xxxxxxxxxx.com/nextcloud/lib/private/User/Database.php",“line”:278,“function”:“execute”,“class”:“OC\DB\QueryBuilder\QueryBuilder”,“type”:"->",“args”:[]},{“file”:"/var/www/xxxxxxxxxx.com/nextcloud/lib/private/User/Manager.php",“line”:258,“function”:“getDisplayNames”,“class”:“OC\User\Database”,“type”:"->",“args”:[“ac”,200,0]},{“file”:"/var/www/xxxxxxxxxx.com/nextcloud/lib/private/Collaboration/Collaborators/UserPlugin.php",“line”:79,“function”:“searchDisplayName”,“class”:“OC\User\Manager”,“type”:"->",“args”:[“ac”,200,0]},{“file”:"/var/www/xxxxxxxxxx.com/nextcloud/lib/private/Collaboration/Collaborators/Search.php",“line”:65,“function”:“search”,“class”:“OC\Collaboration\Collaborators\UserPlugin”,“type”:"->",“args”:[“ac”,200,0,{“class”:“OC\Collaboration\Collaborators\SearchResult”}]},{“file”:"/var/www/xxxxxxxxxx.com/nextcloud/apps/files_sharing/lib/Controller/ShareesAPIController.php",“line”:194,“function”:“search”,“class”:“OC\Collaboration\Collaborators\Search”,“type”:"->",“args”:[“ac”,[0,1,6,4],true,200,0]},{“file”:"/var/www/xxxxxxxxxx.com/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",“line”:166,“function”:“search”,“class”:“OCA\Files_Sharing\Controller\ShareesAPIController”,“type”:"->",“args”:[“ac”,“folder”,1,200,null,true]},{“file”:"/var/www/xxxxxxxxxx.com/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",“line”:99,“function”:“executeController”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->",“args”:[{“class”:“OCA\Files_Sharing\Controller\ShareesAPIController”},“search”]},{“file”:"/var/www/xxxxxxxxxx.com/nextcloud/lib/private/AppFramework/App.php",“line”:118,“function”:“dispatch”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->",“args”:[{“class”:“OCA\Files_Sharing\Controller\ShareesAPIController”},“search”]},{“file”:"/var/www/xxxxxxxxxx.com/nextcloud/lib/private/AppFramework/Routing/RouteActionHandler.php",“line”:47,“function”:“main”,“class”:“OC\AppFramework\App”,“type”:"::",“args”:[“OCA\Files_Sharing\Controller\ShareesAPIController”,“search”,{“class”:“OC\AppFramework\DependencyInjection\DIContainer”},{"_route":“ocs.files_sharing.ShareesAPI.search”}]},{“function”:"__invoke",“class”:“OC\AppFramework\Routing\RouteActionHandler”,“type”:"->",“args”:[{"_route":“ocs.files_sharing.ShareesAPI.search”}]},{“file”:"/var/www/xxxxxxxxxx.com/nextcloud/lib/private/Route/Router.php",“line”:297,“function”:“call_user_func”,“args”:[{“class”:“OC\AppFramework\Routing\RouteActionHandler”},{"_route":“ocs.files_sharing.ShareesAPI.search”}]},{“file”:"/var/www/xxxxxxxxxx.com/nextcloud/ocs/v1.php",“line”:82,“function”:“match”,“class”:“OC\Route\Router”,“type”:"->",“args”:["/ocsapp/apps/files_sharing/api/v1/sharees"]}],“File”:"/var/www/xxxxxxxxxx.com/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php",“Line”:107,“Previous”:{“Exception”:“PDOException”,“Message”:“SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION ‘utf8mb4_general_ci’ is not valid for CHARACTER SET ‘utf8’”,“Code”:“42000”,“Trace”:[{“file”:"/var/www/xxxxxxxxxx.com/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php",“line”:105,“function”:“execute”,“class”:“PDOStatement”,“type”:"->",“args”:[null]},{“file”:"/var/www/xxxxxxxxxx.com/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php",“line”:847,“function”:“execute”,“class”:“Doctrine\DBAL\Driver\PDOStatement”,“type”:"->",“args”:[]},{“file”:"/var/www/xxxxxxxxxx.com/nextcloud/lib/private/DB/Connection.php",“line”:195,“function”:“executeQuery”,“class”:“Doctrine\DBAL\Connection”,“type”:"->",“args”:[“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 OFFSET 0”,{“1”:"%ac%",“2”:"%ac%",“3”:"%ac%"},{“1”:2,“2”:2,“3”:2},null]},{“file”:"/var/www/xxxxxxxxxx.com/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php",“line”:206,“function”:“executeQuery”,“class”:“OC\DB\Connection”,“type”:"->",“args”:[“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 OFFSET 0”,{“1”:"%ac%",“2”:"%ac%",“3”:"%ac%"},{“1”:2,“2”:2,“3”:2}]},{“file”:"/var/www/xxxxxxxxxx.com/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",“line”:214,“function”:“execute”,“class”:“Doctrine\DBAL\Query\QueryBuilder”,“type”:"->",“args”:[]},{“file”:"/var/www/xxxxxxxxxx.com/nextcloud/lib/private/User/Database.php",“line”:278,“function”:“execute”,“class”:“OC\DB\QueryBuilder\QueryBuilder”,“type”:"->",“args”:[]},{“file”:"/var/www/xxxxxxxxxx.com/nextcloud/lib/private/User/Manager.php",“line”:258,“function”:“getDisplayNames”,“class”:“OC\User\Database”,“type”:"->",“args”:[“ac”,200,0]},{“file”:"/var/www/xxxxxxxxxx.com/nextcloud/lib/private/Collaboration/Collaborators/UserPlugin.php",“line”:79,“function”:“searchDisplayName”,“class”:“OC\User\Manager”,“type”:"->",“args”:[“ac”,200,0]},{“file”:"/var/www/xxxxxxxxxx.com/nextcloud/lib/private/Collaboration/Collaborators/Search.php",“line”:65,“function”:“search”,“class”:“OC\Collaboration\Collaborators\UserPlugin”,“type”:"->",“args”:[“ac”,200,0,{“class”:“OC\Collaboration\Collaborators\SearchResult”}]},{“file”:"/var/www/xxxxxxxxxx.com/nextcloud/apps/files_sharing/lib/Controller/ShareesAPIController.php",“line”:194,“function”:“search”,“class”:“OC\Collaboration\Collaborators\Search”,“type”:"->",“args”:[“ac”,[0,1,6,4],true,200,0]},{“file”:"/var/www/xxxxxxxxxx.com/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",“line”:166,“function”:“search”,“class”:“OCA\Files_Sharing\Controller\ShareesAPIController”,“type”:"->",“args”:[“ac”,“folder”,1,200,null,true]},{“file”:"/var/www/xxxxxxxxxx.com/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",“line”:99,“function”:“executeController”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->",“args”:[{“class”:“OCA\Files_Sharing\Controller\ShareesAPIController”},“search”]},{“file”:"/var/www/xxxxxxxxxx.com/nextcloud/lib/private/AppFramework/App.php",“line”:118,“function”:“dispatch”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->",“args”:[{“class”:“OCA\Files_Sharing\Controller\ShareesAPIController”},“search”]},{“file”:"/var/www/xxxxxxxxxx.com/nextcloud/lib/private/AppFramework/Routing/RouteActionHandler.php",“line”:47,“function”:“main”,“class”:“OC\AppFramework\App”,“type”:"::",“args”:[“OCA\Files_Sharing\Controller\ShareesAPIController”,“search”,{“class”:“OC\AppFramework\DependencyInjection\DIContainer”},{"_route":“ocs.files_sharing.ShareesAPI.search”}]},{“function”:"__invoke",“class”:“OC\AppFramework\Routing\RouteActionHandler”,“type”:"->",“args”:[{"_route":“ocs.files_sharing.ShareesAPI.search”}]},{“file”:"/var/www/xxxxxxxxxx.com/nextcloud/lib/private/Route/Router.php",“line”:297,“function”:“call_user_func”,“args”:[{“class”:“OC\AppFramework\Routing\RouteActionHandler”},{"_route":“ocs.files_sharing.ShareesAPI.search”}]},{“file”:"/var/www/xxxxxxxxxx.com/nextcloud/ocs/v1.php",“line”:82,“function”:“match”,“class”:“OC\Route\Router”,“type”:"->",“args”:["/ocsapp/apps/files_sharing/api/v1/sharees"]}],“File”:"/var/www/xxxxxxxxxx.com/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php",“Line”:105}},“CustomMessage”:"–"},“userAgent”:“Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.106 Safari/537.36”,“version”:“14.0.0.19”}

The sharing app is enabled and ok, but something got messed up in the Users part of the Database.
Each user can log in and see it’s files ok. But as an admin, I can’t see them listed, I can’t add users, and I can;t share files with existing users.

Did you try to find something about this error?

Thank you very much. I explored the problem with Collation and found the culprit.
I used the tutorial here to fix Collation https://confluence.atlassian.com/confkb/mysql-collation-repair-database-level-changes-670958163.html
and afterwards deleted the line
‘mysql.utf8mb4’ => true, from config.php
after I removed it, all went well.

Thanks

2 Likes

why did you have to remove that line?

are we saying that the instructions here are not valid anymore?

https://docs.nextcloud.com/server/14/admin_manual/configuration_database/mysql_4byte_support.html

If you installed with curl, I am thinking that your mysql was not properly configured, but disabling utf8mb4 doesn’t seem like a solution to me.

Thank you all for (raising and providing) the answer/solution.

I got the same problem, and googled to this thread.

I upgraded from nc 13.x to 14.0.6.0, the current stable release. I didn’t notice the variable in config.php ( ‘mysql.utf8mb4’ = true) because this variable does not exist in the prev ver, say v13.0.6, the first ver I’ve installed if I recall the value correctly.

I later on upgraded via production channel to v14.0.4 or maybe v14.0.2.0. Everything goes well, no syntax errors, no user disappearing, or integrated email app connection lost issues. But after a few days ago I referred to the manual about database configuration and added the 'mysql.utf8mb4' = true, the logging information constantly showed error msg when I tried to read emails from email app.

I didn’t take a look at the user module but followed thread starter’s step, it produced the same errors, ie. user disappeared from the list.

Now, I removed ‘mysql.utf8mb4’ = true and everything goes back to normal, at least it looks like it was before.

My guess is, the problem is somewhat related to MySQL version, mine always 5.5.6x, with the following my.cnf config, and the upgrade operation as v14 config.php is slightly different from v13 which doesn’t include mysql.utf8mb4 line.

[mysqld]
character-set-server = utf8mb4
collation-server = utf8mb4_general_ci
transaction_isolation = READ-COMMITTED
binlog_format = ROW
innodb_large_prefix=on
innodb_file_format=barracuda
innodb_file_per_table=1
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

I have a new idea about the this.

@paulmocan is using MySQL v5.0, and mine is v5.5.6. I’ve tried to convert collation to utf8mb4 (via collation-server = utf8mb4_general_ci) in phpMyAdmin after addming ‘mysql.utf8mb4’ = true in the config.php, which is preferred by @nachoparker , but failed. The phpMyAdmin told something wrong with the table (or something related I cannot recall).

This brings me to the thinking that since the problem is somewhat related to utf8mb4, could that be the consequence of low MySQL version? Perhaps upgrading to, say MySQL 5.7 or even v8 or MariaDB 10 could solve the problem of not being able to convert all the data to utf8mb4?


update:

I tried again, converting all data to utf8mb4, by clicking the operations tab in phpMyAdmin, and Collation - Change all tables collation - Change all tables column collation, and was prompted wtih

1 errors were found during analysis.

    Missing comma before start of a new alter operation. (near "CHARACTER SET" at position 41)

SQL query: Edit Edit

ALTER TABLE `oc_addressbooks` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci

MySQL said: Documentation
#1071 - Specified key was too long; max key length is 767 bytes

#1071 - Specified key was too long; max key length is 767 bytes is the problem. I guess if this can be solved by upgrading (my best guess), the real problem will be solved.

I have this same issue when following the official documentation. Three exceptions occur with that result so the repair fails. Disabling mysql.utf8mb4 fixes it for me as well.