[horde] Kronolith SQLSTATE error

[Louis-Philippe Allard]

  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?
  Louis-Philippe Allard
lp.allard.1 at gmail.com
Sent using Horde Groupware on GNU/Linux