[Tickets #9168] DB Error when doing ActiveSync sync

[bugs at horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/9168
------------------------------------------------------------------------------
  Ticket             | 9168
  Created By         | Michael Slusarz <slusarz at horde.org>
  Summary            | DB Error when doing ActiveSync sync
  Queue              | SyncML
  Type               | Bug
  State              | Unconfirmed
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


Michael Slusarz <slusarz at horde.org> (2010-08-10 16:12) wrote:

Seeing this:

2010-08-10T14:08:54-06:00 DEBUG: HORDE [horde] SQL QUERY FAILED:  
SQLSTATE[23502]: Not null violation: 7 ERROR:  null value in column  
"sync_user" violates not-null constraint
         INSERT INTO horde_activesync_map (message_uid, sync_modtime, sync_key,
           sync_devid, sync_folderid) VALUES
           ('20090625180456.190336qq0eefomug at bigworm.curecanti.org',  
1281470934,
           '{232b6f88-93a4-40f4-8f85-a427b24674f8}61', 'androidc544188419',
           'Contacts') [pid 31162 on line 749 of  
"/disk2/src/horde/framework/Db/lib/Horde/Db/Adapter/Base.php"]
2010-08-10T14:08:54-06:00 DEBUG: HORDE [horde] SQL
         INSERT INTO horde_activesync_map (message_uid, sync_modtime, sync_key,
           sync_devid, sync_folderid) VALUES
           ('20090625180456.190336qq0eefomug at bigworm.curecanti.org',  
1281470934,
           '{232b6f88-93a4-40f4-8f85-a427b24674f8}61', 'androidc544188419',
           'Contacts') [pid 31162 on line 749 of  
"/disk2/src/horde/framework/Db/lib/Horde/Db/Adapter/Base.php"]
2010-08-10T14:08:54-06:00 ERR: HORDE [horde] SQLSTATE[23502]: Not null  
violation: 7 ERROR:  null value in column "sync_user" violates  
not-null constraint [pid 31162 on line 256 of  
"/disk2/src/horde/framework/ActiveSync/lib/Horde/ActiveSync/State/History.php"]

Looking at line 256, I don't see a reference to sync_user, but it  
looks like it is defined as a NOT NULL column in the table definition.