Ticket modified by camel camel at 2010/05/26 19:08
Tracking System: Bugs
Category: Addressbook
Version: Trunk
Status: Pending
Resolution: None
Completed: 0%
Priority: 5 - medium
Created By: camel camel
Assigned to: Ralf Becker
Summary: #2604 - if search for an item -> SQL error
hi…
if you go to addressbook -> then enter a value in field: search -> and press SEARCH then SQL error (postgresql)
(trying via last trunk)
the same erro happen if you try it on INFOLOG
Database error
Invalid SQL: SELECT COUNT(*) FROM egw_addressbook LEFT JOIN egw_addressbook_extra ON egw_addressbook.contact_id=egw_addressbook_extra.contact_id WHERE contact_tid=‘n’ AND account_id IS NULL AND contact_tid != ‘D’ AND egw_addressbook.contact_owner != 0 AND (egw_addressbook.contact_owner=5002 OR contact_private=0 AND egw_addressbook.contact_owner IN (-5000,5002,0) OR egw_addressbook.contact_owner IS NULL) AND (((( CONCAT(CAST(COALESCE(n_family,’’) AS char),CAST(COALESCE(n_given,’’) AS char),CAST(COALESCE(n_middle,’’) AS char),CAST(COALESCE(n_prefix,’’) AS char),CAST(COALESCE(n_suffix,’’) AS char),CAST(COALESCE(n_fn,’’) AS char),CAST(COALESCE(n_fileas,’’) AS char),CAST(COALESCE(contact_bday,’’) AS char),CAST(COALESCE(org_name,’’) AS char),CAST(COALESCE(org_unit,’’) AS char),CAST(COALESCE(contact_title,’’) AS char),CAST(COALESCE(contact_role,’’) AS char),CAST(COALESCE(contact_assistent,’’) AS char),CAST(COALESCE(contact_room,’’) AS char),CAST(COALESCE(adr_one_street,’’) AS
char),CAST(COALESCE(adr_one_street2,’’) AS char),CAST(COALESCE(adr_one_locality,’’) AS char),CAST(COALESCE(adr_one_region,’’) AS char),CAST(COALESCE(adr_one_postalcode,’’) AS char),CAST(COALESCE(adr_one_countryname,’’) AS char),CAST(COALESCE(contact_label,’’) AS char),CAST(COALESCE(adr_two_street,’’) AS char),CAST(COALESCE(adr_two_street2,’’) AS char),CAST(COALESCE(adr_two_locality,’’) AS char),CAST(COALESCE(adr_two_region,’’) AS char),CAST(COALESCE(adr_two_postalcode,’’) AS char),CAST(COALESCE(adr_two_countryname,’’) AS char),CAST(COALESCE(tel_work,’’) AS char),CAST(COALESCE(tel_cell,’’) AS char),CAST(COALESCE(tel_fax,’’) AS char),CAST(COALESCE(tel_assistent,’’) AS char),CAST(COALESCE(tel_car,’’) AS char),CAST(COALESCE(tel_pager,’’) AS char),CAST(COALESCE(tel_home,’’) AS char),CAST(COALESCE(tel_fax_home,’’) AS char),CAST(COALESCE(tel_cell_private,’’) AS char),CAST(COALESCE(tel_other,’’) AS char),CAST(COALESCE(tel_prefer,’’) AS char),CAST(COALESCE(contact_email,’’) AS
char),CAST(COALESCE(contact_email_home,’’) AS char),CAST(COALESCE(contact_url,’’) AS char),CAST(COALESCE(contact_url_home,’’) AS char),CAST(COALESCE(contact_freebusy_uri,’’) AS char),CAST(COALESCE(contact_calendar_uri,’’) AS char),CAST(COALESCE(contact_note,’’) AS char),CAST(COALESCE(contact_geo,’’) AS char),CAST(COALESCE(contact_pubkey,’’) AS char),CAST(COALESCE(egw_addressbook_extra.contact_value,’’) AS char)) LIKE ‘%123%’) ))):
ERROR: function concat(character, character, character, character, character, character, character, character, character, character, character, character, character, character, character, character, character, character, character, character, character, character, character, character, character, character, character, character, character, character, character, character, character, character, character, character, character, character, character, character, character, character, character, character, character, character, character, character) does not exist
LINE 1: …R egw_addressbook.contact_owner IS NULL) AND (((( CONCAT(CAS…
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
Comment by camel camel at 2010/05/26 19:08:
well the CONCAT error seems to be fixed, but … the SEARCH doesn’t find anything …
any idea ?
to test: > INFOLOG -> field: Search -> enter a pattern like:
“a”, then click search, and it doesn’t find anything
Comment by camel camel at 2010/05/18 16:15:
additional: the search doesn’t work for Resources, Project Manager, Tracker
Linked entries:
http://www.egroupware.org/egroupware/index.php?menuaction=tracker.tracker_ui.edit&tr_id=2604&no_popup=1