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

* Your Email Address
* Spam protection	Enter the letters below: ..__ .__..__ .___ \|\| \\| \|[ __[__ \__\|\|__/\|__\|[_./\|
Comment	>> 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.
Attachment
Watch this ticket