| Summary | DB Error when doing ActiveSync sync |
| Queue | Horde Framework Packages |
| Queue Version | Git master |
| Type | Bug |
| State | Resolved |
| Priority | 1. Low |
| Owners | mrubinsk (at) horde (dot) org |
| Requester | slusarz (at) horde (dot) org |
| Created | 08/10/2010 (5420 days ago) |
| Due | |
| Updated | 08/11/2010 (5419 days ago) |
| Assigned | 08/10/2010 (5420 days ago) |
| Resolved | 08/11/2010 (5419 days ago) |
| Github Issue Link | |
| Github Pull Request | |
| Milestone | |
| Patch | No |
State ⇒ Resolved
this should be fixed now.
Make sure we record the user when updating the map table. Fixes
Bug: 9168.http://git.horde.org/diff.php/framework/ActiveSync/lib/Horde/ActiveSync/Connector/Importer.php?rt=horde-git&r1=fc0ca8d332b41545fdf26ed418d225b11697a516&r2=580f432a92cc6058b01bc6c83cdc6236a6858f0c
http://git.horde.org/diff.php/framework/ActiveSync/lib/Horde/ActiveSync/State/Base.php?rt=horde-git&r1=862303712a43f93d8adec384c8149a1345ea0f98&r2=580f432a92cc6058b01bc6c83cdc6236a6858f0c
http://git.horde.org/diff.php/framework/ActiveSync/lib/Horde/ActiveSync/State/File.php?rt=horde-git&r1=862303712a43f93d8adec384c8149a1345ea0f98&r2=580f432a92cc6058b01bc6c83cdc6236a6858f0c
http://git.horde.org/diff.php/framework/ActiveSync/lib/Horde/ActiveSync/State/History.php?rt=horde-git&r1=862303712a43f93d8adec384c8149a1345ea0f98&r2=580f432a92cc6058b01bc6c83cdc6236a6858f0c
State ⇒ Assigned
Version ⇒ Git master
Priority ⇒ 1. Low
Type ⇒ Bug
Summary ⇒ DB Error when doing ActiveSync sync
Queue ⇒ Synchronization
Milestone ⇒
Patch ⇒ No
State ⇒ Unconfirmed
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@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@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.