[Tickets #13338] Re: Activesync: Column 'sync_key' cannot be null

[noreply at bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/13338
------------------------------------------------------------------------------
  Ticket             | 13338
  Updated By         | software-horde at interfasys.ch
  Summary            | Activesync: Column 'sync_key' cannot be null
  Queue              | Horde Groupware Webmail Edition
  Version            | 5.2.0
  Type               | Bug
  State              | Feedback
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


software-horde at interfasys.ch (2014-07-09 21:25) wrote:

OK, I've found something

2014-07-09T23:19:32+02:00 INFO: [56058]  
Horde_Core_ActiveSync_Driver::authenticate() attempt for user at domain.tld
2014-07-09T23:19:33+02:00 INFO: [56058] FOLDERUPDATE request received  
for user user at domain.tld
2014-07-09T23:19:33+02:00 INFO: [56058] Device entry exists for  
BB1234ABCD, updating userAgent and version.
2014-07-09T23:19:33+02:00 INFO: [56058] Request being handled for  
device: BB1234ABCD, Supporting protocol version: 14.1, Using  
Horde_ActiveSync v2.16.9
2014-07-09T23:19:33+02:00 INFO: [56058] GET VARIABLES: Array
(
     [Cmd] => FolderUpdate
     [DeviceType] => BlackBerry
     [User] => user at domain.tld
     [DeviceId] => BB1234ABCD
)

2014-07-09T23:19:33+02:00 INFO: [BB1234ABCD] Handling  
FOLDER[CREATE|DELETE|CHANGE] command.
2014-07-09T23:19:33+02:00 DEBUG: [56058] I  <FolderHierarchy:FolderUpdate>
2014-07-09T23:19:33+02:00 DEBUG: [56058] I   <FolderHierarchy:SyncKey>
2014-07-09T23:19:33+02:00 DEBUG: [56058] I      
{53944bbf-adf4-4bd1-b3ca-24b2904cae96}3
2014-07-09T23:19:33+02:00 DEBUG: [56058] I   </FolderHierarchy:SyncKey>
2014-07-09T23:19:33+02:00 DEBUG: [56058] I   <FolderHierarchy:ServerEntryId>
2014-07-09T23:19:33+02:00 DEBUG: [56058] I     Ncf4f9a88
2014-07-09T23:19:33+02:00 DEBUG: [56058] I   </FolderHierarchy:ServerEntryId>
2014-07-09T23:19:33+02:00 DEBUG: [56058] I   <FolderHierarchy:ParentId>
2014-07-09T23:19:33+02:00 DEBUG: [56058] I     0
2014-07-09T23:19:33+02:00 DEBUG: [56058] I   </FolderHierarchy:ParentId>
2014-07-09T23:19:33+02:00 DEBUG: [56058] I   <FolderHierarchy:DisplayName>
2014-07-09T23:19:33+02:00 DEBUG: [56058] I     Notepad of user at domain.tld
2014-07-09T23:19:33+02:00 DEBUG: [56058] I   </FolderHierarchy:DisplayName>
2014-07-09T23:19:33+02:00 DEBUG: [56058] I  </FolderHierarchy:FolderUpdate>
2014-07-09T23:19:33+02:00 INFO: [56058] Loading state for synckey  
{53944bbf-adf4-4bd1-b3ca-24b2904cae96}3
2014-07-09T23:19:33+02:00 ERR: [56058] Could not find state for  
synckey {53944bbf-adf4-4bd1-b3ca-24b2904cae96}3.
2014-07-09T23:19:33+02:00 INFO: [56058] Collection without id found:  
a:1:{s:8:"serverid";N;}
2014-07-09T23:19:33+02:00 INFO: [56058] Updating serverid in folder  
state. Setting  for .
2014-07-09T23:19:33+02:00 INFO: [56058] Replacing SYNC_CACHE entry for  
user user at domain.tld and device BB1234ABCD:  
a:11:{s:18:"confirmed_synckeys";a:0:{}s:17:"lasthbsyncstarted";b:0;s:17:"lastsyncendnormal";b:0;s:9:"timestamp";s:10:"1404940773";s:4:"wait";b:0;s:10:"hbinterval";b:0;s:7:"folders";a:1:{s:0:"";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";N;}}s:9:"hierarchy";b:0;s:11:"collections";a:0:{}s:13:"pingheartbeat";b:0;s:14:"synckeycounter";a:0:{}}
2014-07-09T23:19:33+02:00 DEBUG: [56058] O  <FolderHierarchy:FolderUpdate>
2014-07-09T23:19:33+02:00 DEBUG: [56058] O   <FolderHierarchy:Status>
2014-07-09T23:19:33+02:00 DEBUG: [56058] O    9
2014-07-09T23:19:33+02:00 DEBUG: [56058] O   </FolderHierarchy:Status>
2014-07-09T23:19:33+02:00 DEBUG: [56058] O  </FolderHierarchy:FolderUpdate>
2014-07-09T23:19:33+02:00 INFO: [56058] Saving state:  
a:8:{i:0;N;i:1;O:21:"Horde_Db_Value_Binary":1:{s:5:"value";s:0:"";}i:2;s:10:"BB1234ABCD";i:3;i:0;i:4;s:10:"foldersync";i:5;s:18:"user at domain.tld";i:6;i:0;i:7;i:1404940773;}
2014-07-09T23:19:33+02:00 NOTICE: [56058] Previous request processing  
for synckey  failed to be accepted by the client, removing previous  
state and trying again.
2014-07-09T23:19:33+02:00 ERR: SQLSTATE[23000]: Integrity constraint  
violation: 1048 Column 'sync_key' cannot be null