[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         | Michael Rubinsky <mrubinsk at horde.org>
  Summary            | ActiveSync Horde5 errors on PostgreSQL
  Queue              | Synchronization
  Version            | Git master
  Type               | Bug
-State              | Feedback
+State              | Resolved
  Priority           | 2. Medium
  Milestone          |
  Patch              |
  Owners             | Jan Schneider, Michael Rubinsky
------------------------------------------------------------------------------


Michael Rubinsky <mrubinsk at horde.org> (2012-12-02 22:26) wrote:

>>> 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.
>
> This one is left.

For the mailmap table, message_uid is the IMAP UID of the message, so  
it is indeed an integer.

Fixed in Git.