[horde] ActiveSync stops syncing mail with SQL error

[Michael J Rubinsky]

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

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

You can send it to me directly if you like.

-- 
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/89f6ab64/attachment.bin>