[horde] ActiveSync stops syncing mail with SQL error

[Michael J Rubinsky]

Quoting Michael Polenske <m.polenske at web.de>:

> On 19.02.2015 12:31, Jan Schneider wrote:
>>
>> Zitat von Michael Polenske <m.polenske at web.de>:
>>
>>> Good morning,
>>> since a few days I cannot see new mails on my mobile device  
>>> (iphone). When I go to webinterface or use Outlook 2013 everything  
>>> seems to be fine. I activated logging für ActiveSync and can see a  
>>> SQL error if I start to sync with my mobile device:
>>> 2015-02-19T10:22:52+01:00 ERR: HORDE SQL QUERY FAILED:  
>>> SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate  
>>> entry '{54e5ab5b-f94c-4ffb-911b-2d8ec0a82a03}3' for key 'PRIMARY'
>>>        INSERT INTO horde_activesync_state (sync_key, sync_data, sync_devid,
>>> [.....]
>>>      }}', 1424337772) [pid 11662 on line 204 of  
>>> "/usr/share/php5/PEAR/Horde/Db/Adapter/Pdo/Base.php"]
>>> Calendar, Addressbook and also Mail-Subfolders are synced  
>>> correctly, only the Main-Inbox-Folder stops syncronising. Horde  
>>> was updated with "pear upgrade -a -B -c horde" to latest version.
>>>
>>> Any hint/advise ?
>>
>> See the ActiveSync FAQ
>>
>
> Hi Jan,
>
> thanks for the hint, oversaw in first step the "KnownIssues" part at  
> the end ;-) Good, the SQL-Error seems to be normal. But I'm stillö  
> not able to sync newer mails on my mobile device. Since it works on  
> Outlook2013 and in Webinterface, I assume that ActiveSync may not be  
> the problem. Any other idea what can be the "showstopper" ? Which  
> part of which log do you need to give me a hint where to find the  
> problem ?

Try recreating the activesync account on the client. If it still  
persists, since I have no idea where your issue is, I would need the  
entire sync log from the start of the new account creation, up until  
the email stops syncing.

-- 
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: smime.p7s
Type: application/pkcs7-signature
Size: 5869 bytes
Desc: S/MIME Signature
URL: <http://lists.horde.org/archives/horde/attachments/20150219/aa6b0edb/attachment.bin>