[kronolith] Invalid byte sequence when accepting event

[lst_hoe02 at kwsoft.de]

Zitat von Michael J Rubinsky <mrubinsk at horde.org>:

> Quoting lst_hoe02 at kwsoft.de:
>
>> Zitat von Jan Schneider <jan at horde.org>:
>>
>>> Zitat von lst_hoe02 at kwsoft.de:
>>>
>>>> Hello,
>>>>
>>>> today we got the following error when trying to accept a invite  
>>>> from one Horde user to another :
>>>>
>>>> Jul 26 16:31:47 webmail HORDE: [kronolith] SQL QUERY FAILED:  
>>>> SQLSTATE[22021]: Character not in repertoire: 7 ERROR:  invalid  
>>>> byte sequence fo                                                   
>>>>                                               r encoding "UTF8":  
>>>> 0xf6 0x72 0x67 0x20
>>>>      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
>>>>        ('m3S_DfjWK-KhdFuqJQHNyCH',
>>>>         
>>>> '040000008200E00074C5B7101A82E00800000000170A59505D5FCE41AA27C7A904474
>>>>        D1B100000009378262B6DF6AC4ABEF0A516E6103476', 'xxxx',
>>>>        'Führungsrunde', '', '', NULL, '', 0, 2,
>>>>         
>>>> 'a:3:{s:16:"xxxx at kwsoft.de";a:3:{s:10:"attendance";i:1;s:8:"response
>>>>        ";i:1;s:4:"name";s:16:"xxxx at kwsoft.de";}s:21:"xxxx at kwsoft.de"
>>>>         
>>>> ;a:3:{s:10:"attendance";i:1;s:8:"response";i:1;s:4:"name";s:16:"J▒rg
>>>>        xxxx";}s:17:"xxxx at kwsoft.de";a:3:{s:10:"attendance";i:1;s:8:
>>>>        "response";i:1;s:4:"name";s:14:"xxxx xxxx";}}', 'a:0:{}',
>>>>        1501079507, '2017-11-23 08:00:00', '2017-11-23 16:00:00',  
>>>> 0, 15, 'N;',
>>>>        0, 'xxxx') [pid 32203 on line 236 of  
>>>> "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
>>>>
>>>>
>>>> For sure it looks like the display name is not properly encoded,  
>>>> but can soemone explain how to avoid this Problem. All the  
>>>> Horde/Kronolith are at latest versions and the database used ist  
>>>> PostgreSQL. Browser used from the failing Client is Chrome on  
>>>> Windows OS.
>>>>
>>>> Thanks for any hints
>>>>
>>>> Andreas
>>>
>>> We would probably have to normalize any external data to UTF-8  
>>> before storing to the backend.
>>
>> Hm, yes. Further investigation showed that the invite was created  
>> by Windows 10 Mail App tied with ActiveSync to the horde  
>> installation. It looks like the display name of the attendee is not  
>> properly encoded. I can send the raw E-Mail invite to some  
>> developer if this would help?
>
>
> Can you please create a ticket on bugs.horde.org as well? I will  
> look at this.
>

A Ticket for Kronolith or ActiveSync or Horde? Do you need some  
example invite?

Thanks

Andreas