[horde] Kronolith SQLSTATE error

[Andreas Mauser]

Okay, better read carefully.

I changed horde’s database encoding to utf8mb4 in conf.php:

$conf['sql']['charset'] = 'utf8mb4';

And now it works.

Thanks :)
Andreas

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

> 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-s
> ncs
> 
> 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
> 
> --
> Horde mailing list
> Frequently Asked Questions: http://horde.org/faq
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org