I am trying to switch from sqlite3 to mariadb v11.6.
I used the suggested db creating this: Database configuration — Nextcloud latest Administration Manual latest documentation
This gives me an error when trying to use db:convert-type:
In DbalException.php line 56:
An exception occurred while executing a query: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xF0\x9F\x8E\x82 L…’ for column nextcloud.oc_calen darobjects_props.value at row 1
In ExceptionConverter.php line 129:
An exception occurred while executing a query: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xF0\x9F\x8E\x82 L…’ for column nextcloud.oc_calen darobjects_props.value at row 1
In Exception.php line 24:
SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xF0\x9F\x8E\x82 L…’ for column nextcloud.oc_calendarobjects_props.value at row 1
In Statement.php line 130:
SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xF0\x9F\x8E\x82 L…’ for column nextcloud.oc_calendarobjects_props.value at row 1
Used AI to check what this is. Fixed it. Still same errors.
