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

bugs at horde.org bugs at horde.org
Fri May 20 14:05:13 UTC 2011


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.

More information about the bugs mailing list