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
DesktopFailureOwncloudSharing.PNG (11.91 KiB) Viewed 1194 times
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