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

[bugs at horde.org]

BITTE NICHT AUF DIESE NACHRICHT ANTWORTEN. NACHRICHTEN AN DIESE  
E-MAIL-ADRESSE WERDEN NICHT GELESEN.

Ticket-URL: http://bugs.horde.org/ticket/9725
------------------------------------------------------------------------------
  Ticket           | 9725
  Aktualisiert Von | torben at dannhauer.info
  Zusammenfassung  | vCard (3.0) that contains a photo can't be imported when
                   | using postgres
  Warteschlange    | Turba
  Version          | 2.3.5
  Typ              | Bug
  Status           | Feedback
  Priorität        | 2. Medium
  Milestone        |
  Patch            |
  Zuständige       |
------------------------------------------------------------------------------


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

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