(I also changed the temporary directory path in the config.php, since there seems to be a bug in NextcloudPi installer, which puts crap in there, but thats another story.)
Now I have Nextcloud 14.0.4.2 running. I finished the setup and was able to login.
Ok, now the problem:
Most things seem to work, but when I’m logged in as admin, to manage users does not work. When I open the user settings, I get this:
No users show up. Notice the error message on the top.
The weird thing is: I can create users. As you can see, I have 2 users (I created one and the admin). But the users are not displayed. It says “No users in here”, but there are 2.
To list users with occ/ncc command also doesn’t work:
@nachoparker I have never seen this before, but can confirm the issue on a fresh install.
Ran the curl installer this morning on Rpi3 with fresh Raspbian light and get the same result. A used curl installer yesterday too, on a i7 fresh Debian9 minimal tools, turns out this has same misbehavior, for which I include ncp-report.
Error message at top of NC Admin page, I can create users, but they dont get listed initially or when you click everyone. They do receive email when their account has been created. They also get listed when you click on the group they have been assigned to. Without group assigned, they vanish and can not be listed. I assigned a group to the vanished user in the database and becomes list-able in that group.
NC Log message starts with :
Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘SELECT uid, displayname FROM oc_usersu LEFT JOIN oc_preferencesp 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[42000]: Syntax error or access violation: 1253 COLLATION ‘utf8mb4_general_ci’ is not valid for CHARACTER SET ‘utf8’