Invalid SQL: SELECT COUNT(*) FROM egw_addressbook WHERE contact_tid='n' AND (egw_addressbook.contact_owner=6 OR contact_private=0 AND egw_addressbook.contact_owner IN (-1,6,0) OR egw_addressbook.contact_owner IS NULL) AND (n_family ILIKE '%@%' OR n_given ILIKE '%@%' OR n_middle ILIKE '%@%' OR n_prefix ILIKE '%@%' OR n_suffix ILIKE '%@%' OR n_fn ILIKE '%@%' OR n_fileas ILIKE '%@%' OR contact_bday ILIKE '%@%' OR org_name ILIKE '%@%' OR org_unit ILIKE '%@%' OR contact_title ILIKE '%@%' OR contact_role ILIKE '%@%' OR contact_assistent ILIKE '%@%' OR contact_room ILIKE '%@%' OR adr_one_street ILIKE '%@%' OR adr_one_street2 ILIKE '%@%' OR adr_one_locality ILIKE '%@%' OR adr_one_region ILIKE '%@%' OR adr_one_postalcode ILIKE '%@%' OR adr_one_countryname ILIKE '%@%' OR contact_label ILIKE '%@%' OR adr_two_street ILIKE '%@%' OR adr_two_street2 ILIKE '%@%' OR adr_two_locality ILIKE '%@%' OR adr_two_region ILIKE '%@%' OR adr_two_postalcode ILIKE '%@%' OR adr_two_countryname ILIKE '%@%' OR tel_work ILIKE '%@%' OR tel_cell ILIKE '%@%' OR tel_fax ILIKE '%@%' OR tel_assistent ILIKE '%@%' OR tel_car ILIKE '%@%' OR tel_pager ILIKE '%@%' OR tel_home ILIKE '%@%' OR tel_fax_home ILIKE '%@%' OR tel_cell_private ILIKE '%@%' OR tel_other ILIKE '%@%' OR tel_prefer ILIKE '%@%' OR contact_email ILIKE '%@%' OR contact_email_home ILIKE '%@%' OR contact_url ILIKE '%@%' OR contact_url_home ILIKE '%@%' OR contact_freebusy_uri ILIKE '%@%' OR contact_calendar_uri ILIKE '%@%' OR contact_note ILIKE '%@%' OR contact_geo ILIKE '%@%' OR contact_pubkey ILIKE '%@%' OR contact_etag ILIKE '%@%' OR contact_uid ILIKE '%@%'):
ERROR: operator does not exist: integer ~~* unknown
LINE 1: ...@%' OR contact_pubkey ILIKE '%@%' OR contact_etag ILIKE '%@%...
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
When I do a new message and click in the address icon a have this error because the
contact_etag filed in (contact_etag ILIKE '%@%') is not varchar but integer.
egroupware 1.6 rc2 + postgresql
