I am running a fresh Nextcloud 14.0.4 install on a shared hosting server (automatic installation through my webhoster).
I imported the database from a nextcloud installation (updated to 14.0.4) on another server and copied the data directory.
Everything seems to work fine, except for the users list.
“Everyone” can’t be displayed, all other user groups are listed as expected (I am logged in as admin).
When I click on “Everyone” (which has the correct number of users displayed next to it in the side bar), it says “No user available” and I get an error message on the top “There has been an error with your request. It can’t be continued” (rough translation from German “Es ist ein Fehler bei der Anfrage aufgetreten. Es kann nicht fortgefahren werden.”)
While this error message is not exactly specific, maybe someone here has encountered (and solved?) something similar or can point me in the right direction?
As I said, I am using a webhoster, I have access via FTP and phpMyAdmin.
Many thanks in advance for your help!
Oh, thanks for the hint. I found out two things (I can’t yet make any sense of myself, though):
In the Nextloud log:
Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'SELECT `uid`, `displayname` FROM `oc_users` `u` LEFT JOIN `oc_preferences` `p` ON (`userid` = `uid`) AND (`appid` = 'settings') AND (`configkey` = 'email') WHERE (`uid` COLLATE utf8mb4_general_ci LIKE ?) OR (`displayname` COLLATE utf8mb4_general_ci LIKE ?) OR (`configvalue` COLLATE utf8mb4_general_ci LIKE ?) ORDER BY `uid_lower` ASC LIMIT 25 OFFSET 0' with params ["%%", "%%", "%%"]: SQLSTATE: Syntax error or access violation: 1253 COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8'
In the browser console:
GET https://domain.tld/ocs/v2.php/cloud/users/details?offset=0&limit=25&search= 404 (Not Found)
When I try to open that URL in the browser, I get a message “Access denied. CSRF check failed”.
That file has the access permissions 644.
Is there something you can make sense of?
Many thanks for your help!
This seems to be the root cause. I don’t understand that collation stuff myself (don’t know to much about databases), but I read something about that in the forum and in the admin guide.
If I’m not mistaken, your old database (and therefor your DB backup) was created/ setup with utf8mb4, but the new database uses UTF8 only. So the database requires some configuration changes I guess.
The admin guide doesn’t load/ open right now, so I searched the forum. What I found is the following, but stop doing anything unless you are absolutely sure what you are doing:
My suggestion is: find out your DB configuration regarding “utf8” and “utf8mb4…” to be sure which of both applies to your backed up database and which to your current database. From there we figure what which way of conversion is the best. And maybe someone else in the forum has more expertise in databases than me and can advise what to do exactly
Dear perdittmann, I have the same problem like you.
Unfortunately I have no idea how to change these settings.
My nextcloud is installed on an Ubuntu 18.04 server who’s based in VMware
I’m using the apache2 webserver.
Can you tell me how to access the settings “side”?
sorry to see that didn’t work out for you. I am beyond newbie when it comes to Linux, I run Nextcloud on a hosted webserver …
You did this for the table “oc_activity” – maybe try “oc_users” instead (if you have the same problem I had – no users displayed).
But I am already a bit out of my depth here myself. So take all this with a grain of salt …
This guide on enabling MySQL 4-bit support helps me too. On a fresh installed Nextcloud 18 with apache2 and MariaDB on Ubuntu 18.04 LTS, I had the same problem with empty userlist and it is working now!