Hi Christian No, I have utf8mb3. I started with SOGo version 2 back then. Can I convert it?
I solved the problem by having the user delete the account on their iPhone and set it up again. Regards, Daniel Am Donnerstag, dem 13.11.2025 um 13:57 +0100 schrieb Christian Mack: > Hello > > Did you create that mysql database with utf8mb4 character set? > character-set-server = utf8mb4 > > > Kind regards, > Christian Mack > > Am 08.11.25 um 10:56 schrieb Daniel Betschart ([email protected]): > > Dear all, > > > > When an event is added to the calendar from an iPhone, the > > following > > error messages appear in sogo.log: > > > > Nov 08 10:11:59 sogod [84608]: 83.150.40.7 "PUT > > /SOGo/dav/myuser/Calendar/personal/zg-R690b5eb2e04a4.ics HTTP/1.1" > > 401 0/2241 0.002 - - 0 - 13 > > > > Nov 08 10:11:59 sogod [84608]: <0x0x55939f34c1e0[GCSFolder]> > > ERROR(-[GCSFolder > > writeContent:fromComponent:container:toName:baseVersion:]): cannot > > insert content : <MySQL4Exception: 0x55939f464080> > > NAME:ExecutionFailed REASON:Incorrect string value: > > '\xF0\x9F\xA9\xB9 |...' for column > > `sogo`.`sogomyuser0045c80c255_quick`.`c_title` at row 1 > > Nov 08 10:11:59 sogod [84608]: [ERROR] > > <0x55939f60a700[SOGoAppointmentObject]:zg-R690b5eb2e04a4.ics> write > > failed: <MySQL4Exception: 0x55939f464080> NAME:ExecutionFailed > > REASON:Incorrect string value: '\xF0\x9F\xA9\xB9 |...' for column > > `sogo`.`sogomyuser0045c80c255_quick`.`c_title` at row 1 > > Nov 08 10:11:59 sogod [84608]: 83.150.40.7 "PUT > > /SOGo/dav/myuser/Calendar/personal/zg-R690b5eb2e04a4.ics HTTP/1.1" > > 500 0/2241 0.028 - - 0 - 14 > > The entry is therefore not created in the calendar. If an entry is > > deleted on the iPhone, it is deleted from the calendar on the > > server after synchronization. > > > > The user also has an iPad; if they create an appointment there, it > > is > > synchronized, and the error message does not appear. > > > > Both Apple devices are running iOS 18.7.1. > > > > Best Regards, > > Daniel > > > -- > Christian Mack > Universität Konstanz > Kommunikations-, Informations-, Medienzentrum (KIM) > Abteilung IT-Dienste Forschung, Lehre, Infrastruktur > 78457 Konstanz > +49 7531 88-4416
