Hey guys I'm having a problem when trying to search through contacts.
Basically I've added a whole bunch of people into here, I've also added filterable fields through the "Record Browser" in the Administration Panel. I'm not sure if this last part is relevant but I don't recall this happening until sometime after I added these in.
I try to search using the allocated search box in the contacts section, this error comes up when I search for something that should be found. When I enter a fake name that doesn't exist on the list no error comes up but of course it filters down to nothing.
Type: 256

Message: postgres7 error: [-1: ERROR: operator does not exist: integer ~~* integer LINE 1: ...name IS NOT NULL)) OR (false OR (r.f_company_name ILIKE 192 ... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.] in EXECUTE("SELECT COUNT(*) FROM contact_data_1 AS r WHERE active=1 AND ((false OR (r.f_last_name ILIKE '%'||'young'||'%' AND r.f_last_name IS NOT NULL)) OR (false OR (r.f_first_name ILIKE '%'||'young'||'%' AND r.f_first_name IS NOT NULL)) OR (false OR (r.f_company_name ILIKE 192 AND r.f_company_name IS NOT NULL)) OR (false OR (r.f_work_phone ILIKE '%'||'young'||'%' AND r.f_work_phone IS NOT NULL)) OR (false OR (r.f_mobile_phone ILIKE '%'||'young'||'%' AND r.f_mobile_phone IS NOT NULL)) OR (false OR (r.f_city ILIKE '%'||'young'||'%' AND r.f_city IS NOT NULL)) OR false) AND (((NOT (false OR (r.f_permission = '2' AND r.f_permission IS NOT NULL)) OR created_by = 1)) OR ((false OR (r.f_login = '1' AND r.f_login IS NOT NULL))))")

File: /var/www/libs/adodb/adodb-errorhandler.inc.php

Line=77

error backtrace:

[PHP core called function]

    function called: handle_epesi_error(256, "postgres7 error: [-1: ERROR: operator does not exist: integer ~~* integer LINE 1: ...name IS NOT NULL)) OR (false OR (r.f_company_name ILIKE 192 ... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.] in EXECUTE(\"SELECT COUNT(*) FROM contact_data_1 AS r WHERE active=1 AND ((false OR (r.f_last_name ILIKE '%'||'young'||'%' AND r.f_last_name IS NOT NULL)) OR (false OR (r.f_first_name ILIKE '%'||'young'||'%' AND r.f_first_name IS NOT NULL)) OR (false OR (r.f_company_name ILIKE 192 AND r.f_company_name IS NOT NULL)) OR (false OR (r.f_work_phone ILIKE '%'||'young'||'%' AND r.f_work_phone IS NOT NULL)) OR (false OR (r.f_mobile_phone ILIKE '%'||'young'||'%' AND r.f_mobile_phone IS NOT NULL)) OR (false OR (r.f_city ILIKE '%'||'young'||'%' AND r.f_city IS NOT NULL)) OR false) AND (((NOT (false OR (r.f_permission = '2' AND r.f_permission IS NOT NULL)) OR created_by = 1)) OR ((false OR (r.f_login = '1' AND r.f_login IS NOT NULL))))\") ", "/var/www/libs/adodb/adodb-errorhandler.inc.php", 77, Array ("postgres7", "EXECUTE", -1, "ERROR: operator does not exist: integer ~~* integer LINE 1: ...name IS NOT NULL)) OR (false OR (r.f_company_name ILIKE 192 ... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.", "SELECT COUNT(*) FROM contact_data_1 AS r WHERE active=1 AND ((false OR (r.f_last_name ILIKE '%'||'young'||'%' AND r.f_last_name IS NOT NULL)) OR (false OR (r.f_first_name ILIKE '%'||'young'||'%' AND r.f_first_name IS NOT NULL)) OR (false OR (r.f_company_name ILIKE 192 AND r.f_company_name IS NOT NULL)) OR (false OR (r.f_work_phone ILIKE '%'||'young'||'%' AND r.f_work_phone IS NOT NULL)) OR (false OR (r.f_mobile_phone ILIKE '%'||'young'||'%' AND r.f_mobile_phone IS NOT NULL)) OR (false OR (r.f_city ILIKE '%'||'young'||'%' AND r.f_city IS NOT NULL)) OR false) AND (((NOT (false OR (r.f_permission = '2' AND r.f_permission IS NOT NULL)) OR created_by = 1)) OR ((false OR (r.f_login = '1' AND r.f_login IS NOT NULL))))", false, Object (ADODB_postgres7), "SELECT COUNT(*) FROM contact_data_1 AS r WHERE active=1 AND ((false OR (r.f_last_name ILIKE '%'||'young'||'%' AND r.f_last_name IS NOT NULL)) OR (false OR (r.f_first_name ILIKE '%'||'young'||'%' AND r.f_first_name IS NOT NULL)) OR (false OR (r.f_company_name ILIKE 192 AND r.f_company_name IS NOT NULL)) OR (false OR (r.f_work_phone ILIKE '%'||'young'||'%' AND r.f_work_phone IS NOT NULL)) OR (false OR (r.f_mobile_phone ILIKE '%'||'young'||'%' AND r.f_mobile_phone IS NOT NULL)) OR (false OR (r.f_city ILIKE '%'||'young'||'%' AND r.f_city IS NOT NULL)) OR false) AND (((NOT (false OR (r.f_permission = '2' AND r.f_permission IS NOT NULL)) OR created_by = 1)) OR ((false OR (r.f_login = '1' AND r.f_login IS NOT NULL))))", false, "postgres7 error: [-1: ERROR: operator does not exist: integer ~~* integer LINE 1: ...name IS NOT NULL)) OR (false OR (r.f_company_name ILIKE 192 ... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.] in EXECUTE(\"SELECT COUNT(*) FROM contact_data_1 AS r WHERE active=1 AND ((false OR (r.f_last_name ILIKE '%'||'young'||'%' AND r.f_last_name IS NOT NULL)) OR (false OR (r.f_first_name ILIKE '%'||'young'||'%' AND r.f_first_name IS NOT NULL)) OR (false OR (r.f_company_name ILIKE 192 AND r.f_company_name IS NOT NULL)) OR (false OR (r.f_work_phone ILIKE '%'||'young'||'%' AND r.f_work_phone IS NOT NULL)) OR (false OR (r.f_mobile_phone ILIKE '%'||'young'||'%' AND r.f_mobile_phone IS NOT NULL)) OR (false OR (r.f_city ILIKE '%'||'young'||'%' AND r.f_city IS NOT NULL)) OR false) AND (((NOT (false OR (r.f_permission = '2' AND r.f_permission IS NOT NULL)) OR created_by = 1)) OR ((false OR (r.f_login = '1' AND r.f_login IS NOT NULL))))\") "))

File: /var/www/libs/adodb/adodb-errorhandler.inc.php

    line 77

    function called: trigger_error("postgres7 error: [-1: ERROR: operator does not exist: integer ~~* integer LINE 1: ...name IS NOT NULL)) OR (false OR (r.f_company_name ILIKE 192 ... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.] in EXECUTE(\"SELECT COUNT(*) FROM contact_data_1 AS r WHERE active=1 AND ((false OR (r.f_last_name ILIKE '%'||'young'||'%' AND r.f_last_name IS NOT NULL)) OR (false OR (r.f_first_name ILIKE '%'||'young'||'%' AND r.f_first_name IS NOT NULL)) OR (false OR (r.f_company_name ILIKE 192 AND r.f_company_name IS NOT NULL)) OR (false OR (r.f_work_phone ILIKE '%'||'young'||'%' AND r.f_work_phone IS NOT NULL)) OR (false OR (r.f_mobile_phone ILIKE '%'||'young'||'%' AND r.f_mobile_phone IS NOT NULL)) OR (false OR (r.f_city ILIKE '%'||'young'||'%' AND r.f_city IS NOT NULL)) OR false) AND (((NOT (false OR (r.f_permission = '2' AND r.f_permission IS NOT NULL)) OR created_by = 1)) OR ((false OR (r.f_login = '1' AND r.f_login IS NOT NULL))))\") ", 256)

File: /var/www/libs/adodb/adodb.inc.php

    line 1043

    function called: ADODB_Error_Handler("postgres7", "EXECUTE", -1, "ERROR: operator does not exist: integer ~~* integer LINE 1: ...name IS NOT NULL)) OR (false OR (r.f_company_name ILIKE 192 ... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.", "SELECT COUNT(*) FROM contact_data_1 AS r WHERE active=1 AND ((false OR (r.f_last_name ILIKE '%'||'young'||'%' AND r.f_last_name IS NOT NULL)) OR (false OR (r.f_first_name ILIKE '%'||'young'||'%' AND r.f_first_name IS NOT NULL)) OR (false OR (r.f_company_name ILIKE 192 AND r.f_company_name IS NOT NULL)) OR (false OR (r.f_work_phone ILIKE '%'||'young'||'%' AND r.f_work_phone IS NOT NULL)) OR (false OR (r.f_mobile_phone ILIKE '%'||'young'||'%' AND r.f_mobile_phone IS NOT NULL)) OR (false OR (r.f_city ILIKE '%'||'young'||'%' AND r.f_city IS NOT NULL)) OR false) AND (((NOT (false OR (r.f_permission = '2' AND r.f_permission IS NOT NULL)) OR created_by = 1)) OR ((false OR (r.f_login = '1' AND r.f_login IS NOT NULL))))", false, "Object (ADODB_postgres7)")

File: /var/www/libs/adodb/adodb.inc.php

    line 1018

    function called: _Execute("SELECT COUNT(*) FROM contact_data_1 AS r WHERE active=1 AND ((false OR (r.f_last_name ILIKE '%'||'young'||'%' AND r.f_last_name IS NOT NULL)) OR (false OR (r.f_first_name ILIKE '%'||'young'||'%' AND r.f_first_name IS NOT NULL)) OR (false OR (r.f_company_name ILIKE 192 AND r.f_company_name IS NOT NULL)) OR (false OR (r.f_work_phone ILIKE '%'||'young'||'%' AND r.f_work_phone IS NOT NULL)) OR (false OR (r.f_mobile_phone ILIKE '%'||'young'||'%' AND r.f_mobile_phone IS NOT NULL)) OR (false OR (r.f_city ILIKE '%'||'young'||'%' AND r.f_city IS NOT NULL)) OR false) AND (((NOT (false OR (r.f_permission = '2' AND r.f_permission IS NOT NULL)) OR created_by = 1)) OR ((false OR (r.f_login = '1' AND r.f_login IS NOT NULL))))", false)

File: /var/www/libs/adodb/adodb.inc.php

    line 1430

    function called: Execute("SELECT COUNT(*) FROM contact_data_1 AS r WHERE active=1 AND ((false OR (r.f_last_name ILIKE '%'||'young'||'%' AND r.f_last_name IS NOT NULL)) OR (false OR (r.f_first_name ILIKE '%'||'young'||'%' AND r.f_first_name IS NOT NULL)) OR (false OR (r.f_company_name ILIKE 192 AND r.f_company_name IS NOT NULL)) OR (false OR (r.f_work_phone ILIKE '%'||'young'||'%' AND r.f_work_phone IS NOT NULL)) OR (false OR (r.f_mobile_phone ILIKE '%'||'young'||'%' AND r.f_mobile_phone IS NOT NULL)) OR (false OR (r.f_city ILIKE '%'||'young'||'%' AND r.f_city IS NOT NULL)) OR false) AND (((NOT (false OR (r.f_permission = '2' AND r.f_permission IS NOT NULL)) OR created_by = 1)) OR ((false OR (r.f_login = '1' AND r.f_login IS NOT NULL))))", Array ())

[PHP core called function]

    function called: GetOne("SELECT COUNT(*) FROM contact_data_1 AS r WHERE active=1 AND ((false OR (r.f_last_name ILIKE '%'||'young'||'%' AND r.f_last_name IS NOT NULL)) OR (false OR (r.f_first_name ILIKE '%'||'young'||'%' AND r.f_first_name IS NOT NULL)) OR (false OR (r.f_company_name ILIKE 192 AND r.f_company_name IS NOT NULL)) OR (false OR (r.f_work_phone ILIKE '%'||'young'||'%' AND r.f_work_phone IS NOT NULL)) OR (false OR (r.f_mobile_phone ILIKE '%'||'young'||'%' AND r.f_mobile_phone IS NOT NULL)) OR (false OR (r.f_city ILIKE '%'||'young'||'%' AND r.f_city IS NOT NULL)) OR false) AND (((NOT (false OR (r.f_permission = '2' AND r.f_permission IS NOT NULL)) OR created_by = 1)) OR ((false OR (r.f_login = '1' AND r.f_login IS NOT NULL))))", Array ())

File: /var/www/include/database.php

    line 480

    function called: call_user_func_array(Array (Object (ADODB_postgres7), "GetOne"), Array ("SELECT COUNT(*) FROM contact_data_1 AS r WHERE active=1 AND ((false OR (r.f_last_name ILIKE '%'||'young'||'%' AND r.f_last_name IS NOT NULL)) OR (false OR (r.f_first_name ILIKE '%'||'young'||'%' AND r.f_first_name IS NOT NULL)) OR (false OR (r.f_company_name ILIKE 192 AND r.f_company_name IS NOT NULL)) OR (false OR (r.f_work_phone ILIKE '%'||'young'||'%' AND r.f_work_phone IS NOT NULL)) OR (false OR (r.f_mobile_phone ILIKE '%'||'young'||'%' AND r.f_mobile_phone IS NOT NULL)) OR (false OR (r.f_city ILIKE '%'||'young'||'%' AND r.f_city IS NOT NULL)) OR false) AND (((NOT (false OR (r.f_permission = '2' AND r.f_permission IS NOT NULL)) OR created_by = 1)) OR ((false OR (r.f_login = '1' AND r.f_login IS NOT NULL))))", Array (#0)))

File: /var/www/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php

    line 1233

    function called: GetOne("SELECT COUNT(*) FROM contact_data_1 AS r WHERE active=1 AND ((false OR (r.f_last_name ILIKE '%'||'young'||'%' AND r.f_last_name IS NOT NULL)) OR (false OR (r.f_first_name ILIKE '%'||'young'||'%' AND r.f_first_name IS NOT NULL)) OR (false OR (r.f_company_name ILIKE 192 AND r.f_company_name IS NOT NULL)) OR (false OR (r.f_work_phone ILIKE '%'||'young'||'%' AND r.f_work_phone IS NOT NULL)) OR (false OR (r.f_mobile_phone ILIKE '%'||'young'||'%' AND r.f_mobile_phone IS NOT NULL)) OR (false OR (r.f_city ILIKE '%'||'young'||'%' AND r.f_city IS NOT NULL)) OR false) AND (((NOT (false OR (r.f_permission = '2' AND r.f_permission IS NOT NULL)) OR created_by = 1)) OR ((false OR (r.f_login = '1' AND r.f_login IS NOT NULL))))", Array ())

File: /var/www/modules/Utils/RecordBrowser/RecordBrowser_0.php

    line 759

    function called: get_records_count("contact", Array ("'%'||'young'||'%'", "'%'||'young'||'%'", "'%'||'young'||'%'", "'%'||'young'||'%'", "'%'||'young'||'%'", "'%'||'young'||'%'", "young"), false, Array (Array (#3), Array (#3)))

File: /var/www/modules/Utils/RecordBrowser/RecordBrowser_0.php

    line 274

    function called: show_data(Array (), Array (), Array ("ASC", "ASC"))

[PHP core called function]

    function called: body()

File: /var/www/include/module.php

    line 793

    function called: call_user_func_array(Array (Object (Utils_RecordBrowser), "body"), Array ())

File: /var/www/include/module.php

    line 713

    function called: get_html_of_module(Object (Utils_RecordBrowser), null, null)

File: /var/www/modules/CRM/Contacts/Contacts_0.php

    line 74

    function called: display_module("Object (Utils_RecordBrowser)")

[PHP core called function]

    function called: body()

File: /var/www/include/module.php

    line 793

    function called: call_user_func_array(Array (Object (CRM_Contacts), "body"), Array ())

File: /var/www/include/module.php

    line 713

    function called: get_html_of_module(Object (CRM_Contacts), null, null)

File: /var/www/modules/Base/Box/Box_0.php

    line 145

    function called: display_module("Object (CRM_Contacts)")

File: /var/www/include/epesi.php

    line 209

    function called: body()

File: /var/www/include/epesi.php

    line 265

    function called: go(Object (Base_Box))

File: /var/www/process.php

    line 32

    function called: process("__action_module__=%2FBase_Box%7C0%2FCRM_Contacts%7Cmain_0%2FUtils_RecordBrowser%7Ccontact%2FUtils_GenericBrowser%7Ccontact&%2FBase_Box%7C0%2FCRM_Contacts%7Cmain_0%2FUtils_RecordBrowser%7Ccontact%2FUtils_GenericBrowser%7Ccontact_adv_search=1", false)
Epesi ENS | Epesi Academy | epesi.cloud PaaS | GitHub

Help Me! | Download from SourceForge
