Course Booking -> SqlException (v15.25)

[Steven]

Hello everybody,

currently booking a course does not work. Can anyone help me with this error?

< see log in attachment >

-------- System ----------------------
OLAT version 15.25
Debian 10
MySQL Version: 10.3.25-MariaDB

-------- Browser Error ------------

Fehlernummer: I211-J
Vorheriger Business Pfad:  https://olat.domain.net/url/RepositoryEntry/3309568/Settings/0/Access/0
Business Pfad:  https://olat.domain.net/url/RepositoryEntry/3309568
Datum und Zeit: 21.10.2020 08:41
---------------------------------------------

[Florian Gnägi]

Hi Steve

Looks like you have a DB schema or encoding problem or too large texts or strange characters somewhere (e.g. \x80 is some non-printable thing): 

Data truncation: Incorrect string value: '\xF0\x9F\x90\xB1\xE2\x80...' for column `www-olat1_openolat_db`.`o_mail`.`body` 

Please note that MariaDB ist not officially supported. It might work, but we do not test it. We recommend using Postgres. 

Cheers

Florian

--
--
Sie erhalten diese Nachricht, weil Sie Mitglied sind von Google
Groups-Gruppe "OpenOlat".
Für das Erstellen von Beiträgen in dieser Gruppe senden Sie eine E-Mail
an open...@googlegroups.com
Um sich von dieser Gruppe abzumelden, senden Sie eine E-Mail an
openolat+u...@googlegroups.com
Weitere Optionen finden Sie in dieser Gruppe unter
http://groups.google.com/group/openolat?hl=de
-------------------------------------------------------------------------------------------------------------------
OpenOlat - infinite learning - http://www.openolat.org
---
You received this message because you are subscribed to the Google Groups "OpenOlat" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openolat+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/openolat/28aa657d-d6fe-4971-95dd-ea95bd36c56en%40googlegroups.com.
<olat.log>

--------------------------------------------------------------------

professional services for the e-learning system OpenOlat

hosting - operating - support - development - mobile - consulting

--------------------------------------------------------------------

www.frentix.com | www.openolat.com 

frentix  GmbH

Florian Gnägi, Geschäftsführer

Okenstrasse 6

CH-8037 Zürich, Switzerland

tel://+41-43-544-9000

dir://+41-43-544-9001

fax://+41-43-544-9009

Find me on wire skype twitter xing linkedin 

--------------------------------------------------------------------

[Stéphane Rossé]

Hi Steven

It's probably some Emojis in the description (or the title) of the course, or in the booking method. The utf8 encoding used by MySQL/MariaDB doesn't accept all possible utf8 characters. Sadly, the part it doesn't accept is not well defined and is dependent of the encoding and the version of MySQL/MariaDB. A solution is to use utf8mb4 as encoding, or to move to PostgreSQL.

Best regards

Stéphane Rossé

[Steven]

Hi Stéphane,

Hi Florian,

yes, the course included emojis **Outch**. 

I will migrate to Postgre SQL.

Thanks for your help!