[horde] ActiveSync stops syncing mail with SQL error

[Michael Polenske]

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 ?

Many thanks - Michael