[horde] ActiveSync stops syncing mail with SQL error

Jan Schneider jan at horde.org
Thu Feb 19 11:31:20 UTC 2015

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

Jan Schneider
The Horde Project

More information about the horde mailing list