[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 | gsnerf at gsnerf.de
  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       |
+Neue Anlage      | ErrorContact.vcf
------------------------------------------------------------------------------


gsnerf at gsnerf.de (2011-04-03 10:58) hat geschrieben:

Hi there, sorry for the delay was kind of busy this week.
Following this comes the complete error message form the horde log  
including the specific sql statement. I also attached the test vcard  
with which I produced said error. This currently happens with Postgres  
8.4 running, but I guess this will be a problem with other versions as  
well (as has been said in the linked mailing list entries).

Apr 03 12:48:09 HORDE [error] [turba] DB Error: unknown error: SELECT  
object_id, owner_id, object_type, object_members, object_uid,  
object_firstname, object_lastname, object_middlenames,  
object_nameprefix, object_namesuffix, object_alias, object_bday,  
object_photo, object_phototype, object_homestreet, object_homepob,  
object_homecity, object_homeprovince, object_homepostalcode,  
object_homecountry, object_workstreet, object_workpob,  
object_workcity, object_workprovince, object_workpostalcode,  
object_workcountry, object_tz, object_email, object_homephone,  
object_workphone, object_cellphone, object_fax, object_pager,  
object_title, object_role, object_company, object_logo,  
object_logotype, object_category, object_notes, object_url,  
object_freebusyurl, object_pgppublickey, object_smimepublickey FROM  
turba_objects WHERE (owner_id = 'gsnerf at gsnerf.de' AND  
(((object_nameprefix ILIKE '%Postgres%' OR object_nameprefix ILIKE  
'%Error%' OR (object_nameprefix = '' OR object_nameprefix IS NULL))  
AND (object_firstname ILIKE '%Postgres%' OR object_firstname ILIKE  
'%Error%' OR (object_firstname = '' OR object_firstname IS NULL)) AND  
(object_middlenames ILIKE '%Postgres%' OR object_middlenames ILIKE  
'%Error%' OR (object_middlenames = '' OR object_middlenames IS NULL))  
AND (object_lastname ILIKE '%Postgres%' OR object_lastname ILIKE  
'%Error%' OR (object_lastname = '' OR object_lastname IS NULL)) AND  
(object_namesuffix ILIKE '%Postgres%' OR object_namesuffix ILIKE  
'%Error%' OR (object_namesuffix = '' OR object_namesuffix IS NULL)))  
AND object_lastname ILIKE '%Postgres Error%' AND object_homephone  
ILIKE '%12345678%' AND object_homestreet ILIKE '%Road
City\\, State 54321%' AND object_email ILIKE '%postgres at error.net%'  
AND object_photo ILIKE '%?PNG

')) [nativecode=ERROR:  operator does not exist: bytea ~~* unknown
ZEILE 2: ...ail ILIKE '%postgres at error.net%' AND object_photo ILIKE '%?P...