OwnCloud 10.3.2 Calendar: Cannot read property 'users' of undefined

Server
,
1

Hello,

I just moved my OwnCloud 10.3.2 to Docker (official Docker Image) and everything works just fine, except on little issue with the Calendar Plugin. The Calendar works fine in general, but when I want to share a Calendar and then want to search for a Username, I get the following error message in the JS console:

app.min.js?v=cc2439de0cda44800dcb5fbfeb2474b9:1 Uncaught TypeError: Cannot read property 'users' of undefined
    at Object.<anonymous> (app.min.js?v=cc2439de0cda44800dcb5fbfeb2474b9:1)
    at Object.<anonymous> (jquery.min.js?v=cc2439de0cda44800dcb5fbfeb2474b9:2)
    at j (jquery.min.js?v=cc2439de0cda44800dcb5fbfeb2474b9:2)
    at Object.fireWith [as resolveWith] (jquery.min.js?v=cc2439de0cda44800dcb5fbfeb2474b9:2)
    at x (jquery.min.js?v=cc2439de0cda44800dcb5fbfeb2474b9:4)
    at XMLHttpRequest.<anonymous> (jquery.min.js?v=cc2439de0cda44800dcb5fbfeb2474b9:4)

I see that a JS AJAX call is being made when I type a username into the input field and I can see from the following API response:

itemsperpage: ""
message: "An exception occurred while executing 'SELECT DISTINCT a.`id` AS `id`, `user_id`, `lower_user_id`, `display_name`, `email`, `last_login`, `backend`, `state`, `quota`, `home` FROM `oc_accounts` a LEFT JOIN `oc_account_terms` t ON a.`id` = t.`account_id` WHERE (`lower_user_id` LIKE ?) OR (`display_name`  COLLATE utf8mb4_general_ci LIKE ?) OR (`email`  COLLATE utf8mb4_general_ci LIKE ?) OR (t.`term` LIKE ?) ORDER BY `display_name` ASC LIMIT 200 OFFSET 0' with params ["%ks%", "%ks%", "%ks%", "%ks%"]:↵↵SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8'"
status: "failure"
statuscode: 996
totalitems: ""

So it looks like something is wrong with the database encoding?

Does anyone has a hint what could be wrong and how to fix it?

Thanks, Marc

2

Ok, I think I solved it by myself by runnig this command

occ db:convert-mysql-charset

after chaning some MySQL/MariaDB InnoDB settings.

Here is the documentation I found:

https://doc.owncloud.org/server/10.3/admin_manual/configuration/database/linux_database_configuration.html

https://doc.owncloud.com/server/admin_manual/configuration/database/db_conversion.html

1 Like