Tickets :: Comment on [#13338] Activesync: Column 'sync

* Your Email Address
* Spam protection	Enter the letters below: . ..___..__..__ . \ / \| [__][ __ \| \/ \| \| \|[_./\__\|
Comment	> 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@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"] > >
Attachment
Watch this ticket

Saved Queries