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”}