Owncloud File Sharing for users and groups not working Topic is solved

Having issues with your DietPi installation, or, found a bug? Post it here.
Post Reply
rmw.ralf
Posts: 2
Joined: Thu Jan 30, 2020 11:38 am

Owncloud File Sharing for users and groups not working

Post by rmw.ralf »

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 :-)


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
rmw.ralf
Posts: 2
Joined: Thu Jan 30, 2020 11:38 am

Re: Owncloud File Sharing for users and groups not working

Post by rmw.ralf »

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 :-)
Post Reply