[Tickets #11742] ActiveSync Horde5 errors on PostgreSQL

[bugs at horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/11742
------------------------------------------------------------------------------
  Ticket             | 11742
  Created By         | horde at albasoft.com
  Summary            | ActiveSync Horde5 errors on PostgreSQL
  Queue              | Synchronization
  Version            | Git master
  Type               | Bug
  State              | Unconfirmed
  Priority           | 3. High
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


horde at albasoft.com (2012-11-22 09:55) wrote:

I'm running ActiveSync on Groupware 5.0.1 using postgresql-8.4.9 as  
default backend.
I have activated email sync with 12.1 version. There are some errors  
related to data typing.

horde_activesync_mailmap.sync_read is defined as 'integer', but code  
tries to insert a boolean ('t') instead of integer, and so it fails.  
Errors disappear if I change table column data type to 'boolean'.

Something similar happens with horde_activesync_mailmap.message_uid,  
defined as 'string' (or char var 255 on pgsql) and code tries to  
insert an integer. I think this duplicates email on each sync. Errors  
disappear if I change table column data type to 'integer', and email  
sync works as expected.

Where's the problem, data type definition or code?

This is device log for both cases:
------------------
2012-11-22T10:34:51+01:00 DEBUG: I      <Modify>
2012-11-22T10:34:51+01:00 DEBUG: I       <ServerEntryId>
2012-11-22T10:34:51+01:00 DEBUG: I        206679
2012-11-22T10:34:51+01:00 DEBUG: I       </ServerEntryId>
2012-11-22T10:34:51+01:00 DEBUG: I       <Data>
2012-11-22T10:34:51+01:00 DEBUG: I        <POOMMAIL:Read>
2012-11-22T10:34:51+01:00 DEBUG: I         1
2012-11-22T10:34:51+01:00 DEBUG: I        </POOMMAIL:Read>
2012-11-22T10:34:51+01:00 DEBUG: I       </Data>
2012-11-22T10:34:51+01:00 DEBUG: Updating state during flags
2012-11-22T10:34:51+01:00 ERR: SQLSTATE[22P02]: Invalid text  
representation: 7 ERROR:  invalid input syntax for integer: "t"
LÍNEA 1: ...c0a80102}281', 'androidcxxxxxxxxxx', 'INBOX', 'username', 't')

------------------

2012-11-12T22:39:31+01:00 DEBUG: [32445] Found 3 message changes in INBOX.
2012-11-12T22:39:31+01:00 DEBUG: [32445] Checking for PIM initiated changes.
2012-11-12T22:39:31+01:00 DEBUG: _isPIMChange: 205157, Array
(
     [read] => 1
     [flagged] => 0
)
, flags
2012-11-12T22:39:31+01:00 ERR: SQLSTATE[42883]: Undefined function: 7  
ERROR:  operator does not exist: character varying = integer
LINEA 1: ...sync_devid = 'androidcxxxxxxxxxx' AND message_uid = 205157 A...
------------------