[horde] Kronolith SQLSTATE error

Tue Nov 1 19:57:28 UTC 2022

  Quoting Andreas Mauser <andreas at mauser.info>:

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

I was goinna propose that you modify mariadb's config to use utf8mb4..  
Glad to see that its working.  I've seen many posts to the maillist in  
the last few months about issues related to this setting.... 
  Louis-Philippe Allard
lp.allard.1 at gmail.com
Sent using Horde Groupware on GNU/Linux