[Tickets #9725] Re: vCard (3.0) that contains a photo can't be imported when using postgres

[bugs at horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/9725
------------------------------------------------------------------------------
  Ticket             | 9725
  Updated By         | sr at parabola.me.uk
  Summary            | vCard (3.0) that contains a photo can't be imported
                     | when using postgres
  Queue              | Turba
  Version            | 2.3.5
  Type               | Bug
  State              | Feedback
  Priority           | 2. Medium
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


torben at dannhauer.info (2011-05-10 17:43) wrote:

> When importing a vcard turba checks if the contained contacts are  
> already present in the database so it does not double contacts on  
> import. In the sql select statement of this check there is an ILIKE  
> comparison on the field 'object_photo' which is of type bytea.
> This is not valid in postgres and leads to the following error:
>
> ERROR:  operator does not exist: bytea ~~* unknown
>
> See the following entry in the postgres mailing list on this error:  
> http://archives.postgresql.org/pgsql-admin/2009-09/msg00041.php
>
> I suggest to either correctly cast the entry into something that can  
> be compared, or simply remove the check for the photo as I don't  
> think this is a check that has any value to the task of finding  
> double entries.
>
> PS: sorry if this is already reported and fixed in the turba query,  
> I couldn't find a similar entry

This error occures also during sync, if a mobile device tries to sync  
a newly created contact bakc to horde.

Therfore it is a show stopper for syncing.