[kronolith] Invalid byte sequence when accepting event

[Michael J Rubinsky]

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?

The funny thing is, ActiveSync is supposed to transmit UTF-8 data  
exclusively anyway...


> Regards
>
> Andreas
>
>
> -- 
> kronolith mailing list
> Frequently Asked Questions: http://wiki.horde.org/FAQ
> To unsubscribe, mail: kronolith-unsubscribe at lists.horde.org



-- 
mike
The Horde Project
http://www.horde.org
https://www.facebook.com/hordeproject
https://www.twitter.com/hordeproject
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-keys
Size: 9272 bytes
Desc: PGP Public Key
URL: <https://lists.horde.org/archives/kronolith/attachments/20170727/cf194a2a/attachment-0002.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 821 bytes
Desc: PGP Digital Signature
URL: <https://lists.horde.org/archives/kronolith/attachments/20170727/cf194a2a/attachment-0003.bin>