[Tickets #13338] 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
  Created 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              | Unconfirmed
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


software-horde at interfasys.ch (2014-07-09 17:30) wrote:

I have many accounts which have now stopped syncing. I have removed  
them from Horde and re-initiated a sync from the device.

The accounts now show as being provisioned but still don't sync.

The ones which have problems are the ones which sync more than email.

Here is what I see in the logs:
2014-07-09T18:13:09+02:00 ERR: HORDE SQL QUERY FAILED:  
SQLSTATE[23000]: Integrity constraint violation: 1048 Column  
'sync_key' cannot be null
	INSERT INTO horde_activesync_state (sync_key, sync_data, sync_devid,
	  sync_mod, sync_folderid, sync_user, sync_pending, sync_timestamp)
	  VALUES (NULL, '', 'BB1234ABCD', 0, 'foldersync', 'user at domain.tld',
	  '', 1404922389) [pid 34839 on line 204 of  
"/php/Horde/Db/Adapter/Pdo/Base.php"]
2014-07-09T18:13:09+02:00 ERR: HORDE Returning HTTP 500 while handling  
FolderUpdate command. [pid 34839 on line 159 of "/horde/rpc.php"]
2014-07-09T18:13:09+02:00 ERR: HORDE Error in communicating with  
ActiveSync server: SQLSTATE[23000]: Integrity constraint violation:  
1048 Column 'sync_key' cannot be null [pid 34839 on line 162 of  
"/php/Horde/Rpc/ActiveSync.php"]
2014-07-09T18:13:09+02:00 ERR: HORDE #0  
/php/Horde/Db/Adapter/Pdo/Base.php(234):  
Horde_Db_Adapter_Pdo_Base->execute('INSERT INTO hor...', Array, NULL)
#1 /php/Horde/ActiveSync/State/Sql.php(348):  
Horde_Db_Adapter_Pdo_Base->insert('INSERT INTO hor...', Array)
#2 /php/Horde/ActiveSync/Request/FolderCreate.php(223):  
Horde_ActiveSync_State_Sql->save()
#3 /php/Horde/ActiveSync/Request/Base.php(253):  
Horde_ActiveSync_Request_FolderCreate->_handle()
#4 /php/Horde/ActiveSync.php(880): Horde_ActiveSync_Request_Base->handle()
#5 /php/Horde/Rpc/ActiveSync.php(143):  
Horde_ActiveSync->handleRequest('FolderUpdate', 'BB1234ABCD')
#6 /horde/rpc.php(159): Horde_Rpc_ActiveSync->getResponse(NULL)
#7 {main} [pid 34839 on line 162 of "/php/Horde/Rpc/ActiveSync.php"]