[horde] Kronolith SQLSTATE error

[Andreas Mauser]

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?

Best regards,
Andreas