[horde] ActiveSync stops syncing mail with SQL error

[Michael Polenske]

On 19.02.2015 15:02, Michael J Rubinsky wrote:
>
> 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.
>

Hi Michael,

I deleted my account on the mobile and created a new one. Just enabled 
mail sync for last 3 days. In mobile I cannot see any mail in main 
inbox-folder. Created a clean logfile - shall I post it here or send you 
directly ?

Cheers - Michael