Owncloud File Sharing for users and groups not working

Troubleshooting
1

Hello together,

I just downloaded the latest DietPi image for a Raspberry 3 B+ and installed the Owncloud from DietPi-software menu.

So far this was a very easy job - thanks for providing this very easy interface :slight_smile:


Owncloud is working in general, I can run admin page, create a second user and so on…

Everything running fine, but if I try to share some folders using the webinterface, there is no response.

Using the Desktop app I get there at least a failure message:

An exeption occurred while executing "SELECT DISTINCT a. 'id…
SQLSTATE[42000]: Syntax error or access violation 1253 COLLATION ‘utf8mb4_general_ci’ is not valid for CHARACTER SET ‘utf8’
(see attachement)
DesktopFailureOwncloudSharing.PNG
what could be the reason for this problem. Is it because some locales are set wrongly ?

Thx a lot

2

Found a sollution for now:

in the /var/www/owncloud/config/config.php there is a setting

‘mysql.utf8mb4’ => true,

just comment this line and it works out.


BTW: if you are using owncloud from another network ( e.g. by using some dyndns ) this file is the right place to add your network adress :slight_smile:

3

Found this

https://stackoverflow.com/questions/25852239/collation-utf8-general-ci-is-not-valid-for-character-set-latin1