[Tickets #11742] Re: 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
  Updated By         | Jan Schneider <jan at horde.org>
  Summary            | ActiveSync Horde5 errors on PostgreSQL
  Queue              | Synchronization
  Version            | Git master
  Type               | Bug
-State              | Unconfirmed
+State              | Feedback
-Priority           | 3. High
+Priority           | 2. Medium
  Milestone          |
  Patch              |
-Owners             |
+Owners             | Jan Schneider, Michael Rubinsky
------------------------------------------------------------------------------


Jan Schneider <jan at horde.org> (2012-11-22 12:36) wrote:

> 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'.

Please try if what I committed fixed this.

> 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.

In this case the UID could indeed be a string, AFAICS. I wonder where  
it's getting an integer from. Michael may provide some insight, after  
his vacation.