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

[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/9153
------------------------------------------------------------------------------
  Ticket           | 9153
  Aktualisiert Von | torben at dannhauer.info
  Zusammenfassung  | BYTEA DB escaping for postgres driver
  Warteschlange    | Horde Framework Packages
  Version          | Git master
  Typ              | Bug
  Status           | Resolved
  Priorität        | 3. High
  Milestone        | 4.0
  Patch            |
  Zuständige       | Chuck Hagenbuch, Jan Schneider, Michael Slusarz
------------------------------------------------------------------------------


torben at dannhauer.info (2011-05-11 06:48) hat geschrieben:

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 at 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