[horde] Kronolith SQLSTATE error

[Andreas Mauser]

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