After creating a new mariadb database
CREATE DATABASE nextcloud CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES ON nextcloud. TO ‘user’@‘localhost’ IDENTIFIED BY ‘password’;*
FLUSH privileges;
and issuing
sudo -u www-data php occ db:convert-type --password=“password” --all-apps mysql user localhost nextcloud
I get the following output:
Creating schema in new database
oc_accounts
2/2 [============================] 100%oc_activity
364/364 [============================] 100%oc_activity_mq
0 [>---------------------------]oc_addressbookchanges
159/159 [============================] 100%oc_addressbooks
2/2 [============================] 100%oc_appconfig
176/176 [============================] 100%oc_authtoken
9/9 [============================] 100%oc_bruteforce_attempts
11/11 [============================] 100%oc_calendar_invitations
0 [>---------------------------]oc_calendar_reminders
0 [>---------------------------]oc_calendar_resources
0 [>---------------------------]oc_calendar_resources_md
0 [>---------------------------]oc_calendar_rooms
0 [>---------------------------]oc_calendar_rooms_md
0 [>---------------------------]oc_calendarchanges
100/100 [============================] 100%oc_calendarobjects
49/49 [============================] 100%oc_calendarobjects_props
0/105 [>---------------------------] 0%
In AbstractMySQLDriver.php line 106:
An exception occurred while executing ‘INSERT INTO oc_calendarobjects_props (id, calendarid, objectid, nam e, parameter, value, calendartype) VALUES(?, ?, ?, ?, ?, ?, ?)’ with params [“1”, “3”, “1”, “SUMMARY”, null,
“\ud83c\udf82 Heidrun Koppisch (1943)”, “0”]:
SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xF0\x9F\x8E\x82 H…’ for column nextclou d.oc_calendarobjects_props.value at row 1
In PDOStatement.php line 119:
SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xF0\x9F\x8E\x82 H…’ for column nextclou d.oc_calendarobjects_props.value at row 1
In PDOStatement.php line 117:
SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xF0\x9F\x8E\x82 H…’ for column nextclou d.oc_calendarobjects_props.value at row 1
What can I do?