Tickets :: Comment on [#9153] BYTEA DB escaping for postgres driver

* Your Email Address
* Spam protection	Enter the letters below: .__ . .__ __ .__ \| \\| [__)/ `[__) \|__/\|___\| \\__.[__)
Comment	> Hi Michael, > > thanks for your fast reply! > > I Horde throws the following error: > > > May 10 19:07:15 jonathan HORDE: HORDE [turba] SQL QUERY FAILED: > SQLSTATE[42883]: Undefined function: 7 FEHLER: Operator existiert > nicht: bytea ~~* unknown#012ZEILE 1: ..._cellphone ILIKE '%012 > 3777777%' AND object_photo ILIKE '%%'...#012 > ^#012TIP: Kein Operator stimmt > mit dem angegebenen Namen und den Argumenttypen überein. Sie müssen > möglicherweise ausdrückliche Typumwandlungen hinzufügen. > #012#011SELECT object_id, owner_id, object_type, object_members, > object_uid,#012#011 object_firstname, object_lastname, > object_middlenames,#012#011 object_nameprefix, object_namesuffix, > object_alias, object_bday,#012#011 object_photo, object_phototype, > object_homestreet, object_homepob,#012#011 object_homecity, > object_homeprovince, object_homepostalcode,#012#011 > object_homecountry, object_workstreet, object_workpob,#012#011 > object_workcity, object_workprovince, object_workpostalcode,#012#011 > object_workcountry, object_tz, object_email, > object_homephone,#012#011 object_workphone, object_cellphone, > object_fax, object_pager,#012#011 object_title, object_role, > object_company, object_logo,#012#011 object_logotype, > object_category, object_notes, object_url,#012#011 > object_freebusyurl, object_pgppublickey, object_smimepublickey > FROM#012#011 turba_objects WHERE (owner_id = 'torben@dannhauer.de' > AND#012#011 (((object_nameprefix ILIKE '%Test2nn,%' OR > object_nameprefix ILIKE#012#011 '%Test2v%' OR (object_nameprefix = > '' OR object_nameprefix IS NULL))#012#011 AND (object_firstname > ILIKE '%Test2nn,%' OR object_firstname ILIKE#012#011 '%Test2v%' OR > (object_firstname = '' OR object_firstname IS NULL)) AND#012#011 > (object_middlenames ILIKE '%Test2nn,%' OR object_middlenames > ILIKE#012#011 '%Test2v%' OR (object_middlenames = '' OR > object_middlenames IS NULL))#012#011 AND (object_lastname ILIKE > '%Test2nn,%' OR object_lastname ILIKE#012#011 '%Test2v%' OR > (object_lastname = '' OR object_lastname IS NULL)) AND#012#011 > (object_namesuffix ILIKE '%Test2nn,%' OR object > > As consequence it fails to sync the contacts (kronolith sync with > iPad works fine). > > For me it looks like a problem with bytea but of course I do not know > exactly.. Do have an idea what could cause the trouble? > > Thank you very much, > > Torben >
Attachment
Watch this ticket

Saved Queries