[Tickets #12154] ActiveSync: SQL error with HTC Sensation

[noreply at bugs.horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/12154
------------------------------------------------------------------------------
  Ticket             | 12154
  Created By         | Thomas Jarosch <thomas.jarosch at intra2net.com>
  Summary            | ActiveSync: SQL error with HTC Sensation
  Queue              | Horde Framework Packages
  Version            | Git master
  Type               | Bug
  State              | Unconfirmed
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


Thomas Jarosch <thomas.jarosch at intra2net.com> (2013-04-03 12:49) wrote:

Hi,

I'm just playing around with ActiveSync, a HTC Sensation phone and the  
code from git master (HEAD).

This is what I get in the logs when I add the account on the phone:

2013-04-03T14:43:16+02:00 ERR: HORDE [horde] SQL QUERY FAILED:  
SQLSTATE[23000]: Integrity constraint violation: 19  
horde_activesync_device.device_agent may not be NULL
         UPDATE horde_activesync_device SET device_properties =
            
'a:5:{s:14:"Settings:Model";s:17:"HTCSensationZ710e";s:11:"Settings:OS
           ";s:13:"Android 4.0.3";s:21:"Settings:FriendlyName";s:19:"HTC
           Sensation
            
Z710e";s:13:"Settings:IMEI";s:16:"************3379";s:20:"Settings:Pho
           neNumber";s:13:"Not Available";}', device_agent = NULL  
WHERE device_id
           = 'HTC6C4153F09B63EAC481259E1F2E139' [pid 474 on line 553  
of "/datastore/DEVEL/horde/framework/Db/lib/Horde/Db/Adapter/Base.php"]


The phone seems to sync fine though.

Cheers,
Thomas