Re: Invalid byte sequence when accepting event

Zitat von Jan Schneider <[email protected]>:

> Zitat von [email protected]:
>
>> 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:"[email protected]";a:3:{s:10:"attendance";i:1;s:8:"response
>>          ";i:1;s:4:"name";s:16:"[email protected]";}s:21:"[email protected]"
>>           
>> ;a:3:{s:10:"attendance";i:1;s:8:"response";i:1;s:4:"name";s:16:"J▒rg
>>          xxxx";}s:17:"[email protected]";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?

Regards

Andreas


-- 
kronolith mailing list
Frequently Asked Questions: http://wiki.horde.org/FAQ
To unsubscribe, mail: [email protected]