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)
