[kronolith] Invalid byte sequence when accepting event

[Michael J Rubinsky]

Quoting 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?

In the Synchronization queue would be great, but I can move it where  
ever you place it. A sample invite would also be helpful.

>
> Thanks
>
> 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/1d806dc9/attachment.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/1d806dc9/attachment-0001.bin>