[horde] Kronolith SQLSTATE error

[Andreas Mauser]

1. November 2022 20:02, "Andreas Mauser" <andreas at mauser.info> schrieb:

> Hi Louis-Philippe
> 
> 1. November 2022 19:45, "Louis-Philippe Allard" <lp.allard.1 at gmail.com> schrieb:
> 
>> Quoting Andreas Mauser <andreas at mauser.info>:
>> 
>>> Hi,
>>> 
>>> To add the error from horde.log, if it gives more clue to this. I
>>> would be happy to get a hint in the right direction. It's strange.
>>> 
>>> 2022-11-01T19:28:25+01:00 ERR: HORDE [kronolith] SQL QUERY FAILED:
>>> SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string
>>> value: '\xF0\x9F\x99\x82\x0D\x0A...' for column
>>> `horde-db`.`kronolith_events`.`event_description` at row 1
>>> INSERT INTO kronolith_events (event_id, event_uid, event_creator_id,
>>> event_title, event_description, event_location, event_timezone,
>>> event_url, event_private, event_status, event_attendees,
>>> event_resources, event_modified, event_start, event_end,
>>> event_allday,
>>> event_alarm, event_alarm_methods, event_recurtype,
>>> calendar_id) VALUES
>>> ('axnB3ONHXHjVRP5or-5ArAg',
>>> 
>>> '040000008200E00074C5B7101A82E0080000000053431C2D35EDD8010000000000000
>>> 0001000000025308DEBCEE74848934D63A4084799AC', 'andreas',
>>> 'Andreas Meeting', 'Good afternoon gentlemen, I am sending over a
>>> meeting.\r\n\r\nIf there would be any questions, let me know.
>>> 🙂\r\n\r\n__________________________________________________________
>>> ______________________\r\nMicrosoft Teams meeting\r\nJoin on your
>>> computer, mobile app or room device\r\nClick here to join the
>>> 
>>> meeting<https://teams.microsoft.com/l/meetup-join/MeetingLink>\r\nMeeting
>>> ID: 384 851 052
>>> 509\r\nPasscode: Nu9n8W\r\nDownload
>>> 
>>> Teams<https://www.microsoft.com/en-us/microsoft-teams/download-app> |
>>> Join on the
>>> 
>>> web<https://www.microsoft.com/microsoft-teams/join-a-meeting>\r\nLearn
>>> More<https://aka.ms/JoinTeamsMeeting> | Meeting
>>> 
>>> options<https://teams.microsoft.com/meetingOptions/Options>\r\n______________________
>>> 
>>> __________________________________________________________', '',
>>> NULL,
>>> '', 0, 2,
>>> 'a:3:{s:23:\"email at email.com\";a:3:{s:10:\"attendance\";i:1;s:
>>> 8:\"response\";i:1;s:4:\"name\";s:11:\"Name of
>>> Attendee\";}s:28:\"email at email.com\";a:3:{s:10:\"attendanc
>>> e\";i:1;s:8:\"response\";i:1;s:4:\"name\";s:16:\"Name of
>>> Attendee\";}s:16:\"info at mauser.info\";a:3:{s:10:\"attendance\";i:1;s:8
>>> :\"response\";i:1;s:4:\"name\";s:16:\"info at mauser.info\";}}',
>>> 'a:0:{}', 1667327305, '2022-11-04 10:00:00', '2022-11-04
>>> 11:00:00', 0,
>>> 15, 'N;', 0, '2_RCyf8sDOJtK_dYHEU9hw3') [pid 2677684 on
>>> line 243 of "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
>>> 
>>> Thank you,
>>> Andreas
>>> 
>>> 31. Oktober 2022 21:24, "Andreas Mauser" <andreas at mauser.info> schrieb:
>> 
>> Hi,
>> 
>> this is new to me:
>> 
>> SQLSTATE(22007)
>> Invalid datetime format 1366 incorrect string value for column
>> kronolith_events
>> 
>> It happens when I import an .ics from a UK company, I beliueve the
>> guy is located sowhere in
>> croatia.
>> 
>> Can you please help what to do because the entry doesnt show up in
>> kronolith.
>> 
>> Thank you and Best regards,
>> Andreas
>> 
>> --
>> Horde mailing list
>> Frequently Asked Questions: http://horde.org/faq
>> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>>> --
>>> Horde mailing list
>>> Frequently Asked Questions: http://horde.org/faq/To unsubscribe,
>>> mail: horde-unsubscribe at lists.horde.org
>> 
>> Andreas,
>> 
>> Im not an expert but short of simply observing, and until more
>> experienced users reply, could it be possible that the ICS file you
>> are trying to import doesnt support (or hasnt been prepared) with
>> UTF-8 ? Inspect the data and try other formats perhaps?
> 
> I am not in control of that. This ics comes from some company I am in contact with. They may not
> even know what to change.
> 
> How could I solve this on my end?
> 

And, I found this from Ralf Lang:

https://www.ralf-lang.de/2021/01/27/davx5-caldav-may-break-with-unicode-symbols-in-horde-kronolith-syncs/

Which I did, but with no success. I mean, the commands did complete successful, but then the ics import failed with same error.

Best regards,
Andreas