[horde] ActiveSync stops syncing mail with SQL error
Michael Polenske
m.polenske at web.de
Thu Feb 19 18:51:24 UTC 2015
On 02/19/2015 07:36 PM, Michael J Rubinsky wrote:
>
> Quoting Michael J Rubinsky <mrubinsk at horde.org>:
>
>> Quoting Michael J Rubinsky <mrubinsk at horde.org>:
>>
>>> Quoting Michael Polenske <michael at polenske.net>:
>>>
>>>> On 02/19/2015 04:49 PM, Michael J Rubinsky wrote:
>>>>>
>>>>> 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.
>>>>>
>>>>>
>>>>>
>>>>
>>>> Hi Michael,
>>>> logfile attached.
>>>>
>>>> Many thanks - Michael
>>>>
>>>> --
>>>> ### gesendet mit meinem AtariXL ###
>>>
>>> What client is this? It looks *badly* broken.
>
> Nevermind. I see that it's an iPhone. Must be one of the new
> generations, as the device id format has changed. I can test more
> later, when I have access to an iPhone 6.
>
>
>
>
>
Hi Michael,
sorry, it's an older Iphone 5 (non-S), latest IOS (8.1.3 I guess), and
since last Saturday it worked without any problems.
Funny thing is that subfolders are syncronized correctly, also Calendar,
Adressbook etc.
Hmmm, strange.
Cheers - Michael
More information about the horde
mailing list