Error migrating NC 17.0.2 from sqlite to mysql/mariadb

🚧 Installation
,
1

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?

2

The encoding looks strange. Can you find the original entries in your sqlite database? Parts look like smileys in unicode: https://apps.timwhitlock.info/emoji/tables/unicode

3

They are. Birthday cakes. It looks like entries from the “Contact birthdays” calendar. Which I assume is created by NextCloud?

4

Yes, Nextcloud automatically generates a birthday calendar from your contact records. As usually you this function is described in the Nextcloud user manual.

5

Ok, now I know where the Unicode chars come from. That does not really solve the question, how to migrate.

6

same problem in version 21.0.1
still there.
Is there any solution?