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	> 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@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@error.net%' > AND object_photo ILIKE '%?PNG > > ')) [nativecode=ERROR: operator does not exist: bytea ~~* unknown > ZEILE 2: ...ail ILIKE '%postgres@error.net%' AND object_photo ILIKE '%?P... >
Attachment
Watch this ticket

Saved Queries