Przy wyszukiwaniu w firmach występuje podany niżej błąd.
Ten sam błąd występuje jeżeli otwarty jest moduł firm i szukamy w oknie szybkiego szukania.
Jeżeli szukamy tego samego ciągu w oknie szybkiego szukania na stronie głównej - błędów nie ma.
who=20
type=256
message=mysqlt error: [1054: Unknown column 'f__first_name' in 'where clause'] in EXECUTE("SELECT id, id FROM contact_data_1 WHERE false OR f_last_name LIKE CONCAT('%','korab','%') OR f__first_name LIKE CONCAT('%','korab','%')")
error file=/home/floeusa/public_html/crm/libs/adodb/adodb-errorhandler.inc.php
error line=77
error backtrace:
[PHP core called function]
function called: handle_epesi_error(256, "mysqlt error: [1054: Unknown column 'f__first_name' in 'where clause'] in EXECUTE(\"SELECT id, id FROM contact_data_1 WHERE false OR f_last_name LIKE CONCAT('%','korab','%') OR f__first_name LIKE CONCAT('%','korab','%')\")
", "/home/floeusa/public_html/crm/libs/adodb/adodb-errorhandler.inc.php", 77, Array ("mysqlt", "EXECUTE", 1054, "Unknown column 'f__first_name' in 'where clause'", "SELECT id, id FROM contact_data_1 WHERE false OR f_last_name LIKE CONCAT('%','korab','%') OR f__first_name LIKE CONCAT('%','korab','%')", false, Object (ADODB_mysqlt), "SELECT id, id FROM contact_data_1 WHERE false OR f_last_name LIKE CONCAT('%','korab','%') OR f__first_name LIKE CONCAT('%','korab','%')", false, "mysqlt error: [1054: Unknown column 'f__first_name' in 'where clause'] in EXECUTE(\"SELECT id, id FROM contact_data_1 WHERE false OR f_last_name LIKE CONCAT('%','korab','%') OR f__first_name LIKE CONCAT('%','korab','%')\")
"))
File: /home/floeusa/public_html/crm/libs/adodb/adodb-errorhandler.inc.php
line 77
function called: trigger_error("mysqlt error: [1054: Unknown column 'f__first_name' in 'where clause'] in EXECUTE(\"SELECT id, id FROM contact_data_1 WHERE false OR f_last_name LIKE CONCAT('%','korab','%') OR f__first_name LIKE CONCAT('%','korab','%')\")
", 256)
File: /home/floeusa/public_html/crm/libs/adodb/adodb.inc.php
line 1074
function called: ADODB_Error_Handler("mysqlt", "EXECUTE", 1054, "Unknown column 'f__first_name' in 'where clause'", "SELECT id, id FROM contact_data_1 WHERE false OR f_last_name LIKE CONCAT('%','korab','%') OR f__first_name LIKE CONCAT('%','korab','%')", false, "Object (ADODB_mysqlt)")
File: /home/floeusa/public_html/crm/libs/adodb/adodb.inc.php
line 1049
function called: _Execute("SELECT id, id FROM contact_data_1 WHERE false OR f_last_name LIKE CONCAT('%','korab','%') OR f__first_name LIKE CONCAT('%','korab','%')", false)
File: /home/floeusa/public_html/crm/libs/adodb/adodb.inc.php
line 1423
function called: Execute("SELECT id, id FROM contact_data_1 WHERE false OR f_last_name LIKE CONCAT('%','korab','%') OR f__first_name LIKE CONCAT('%','korab','%')", null)
[PHP core called function]
function called: GetAssoc("SELECT id, id FROM contact_data_1 WHERE false OR f_last_name LIKE CONCAT('%','korab','%') OR f__first_name LIKE CONCAT('%','korab','%')", null)
File: /home/floeusa/public_html/crm/include/database.php
line 460
function called: call_user_func_array(Array (Object (ADODB_mysqlt), "GetAssoc"), Array ("SELECT id, id FROM contact_data_1 WHERE false OR f_last_name LIKE CONCAT('%','korab','%') OR f__first_name LIKE CONCAT('%','korab','%')", null))
File: /home/floeusa/public_html/crm/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php
line 1165
function called: GetAssoc("SELECT id, id FROM contact_data_1 WHERE false OR f_last_name LIKE CONCAT('%','korab','%') OR f__first_name LIKE CONCAT('%','korab','%')")
File: /home/floeusa/public_html/crm/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php
line 1330
function called: build_query("company", Array ("CONCAT('%','korab','%')", "CONCAT('%','korab','%')", "CONCAT('%','korab','%')", "korab", "CONCAT('%','korab','%')", "CONCAT('%','korab','%')"), false, Array ())
File: /home/floeusa/public_html/crm/modules/Utils/RecordBrowser/RecordBrowser_0.php
line 799
function called: get_records_count("company", Array ("CONCAT('%','korab','%')", "CONCAT('%','korab','%')", "CONCAT('%','korab','%')", "korab", "CONCAT('%','korab','%')", "CONCAT('%','korab','%')"), false, Array (Array (#3)))
File: /home/floeusa/public_html/crm/modules/Utils/RecordBrowser/RecordBrowser_0.php
line 287
function called: show_data(Array (), Array (), Array ("ASC"))
[PHP core called function]
function called: body()
File: /home/floeusa/public_html/crm/include/module.php
line 793
function called: call_user_func_array(Array (Object (Utils_RecordBrowser), "body"), Array ())
File: /home/floeusa/public_html/crm/include/module.php
line 713
function called: get_html_of_module(Object (Utils_RecordBrowser), null, null)
File: /home/floeusa/public_html/crm/modules/CRM/Contacts/Contacts_0.php
line 74
function called: display_module("Object (Utils_RecordBrowser)")
[PHP core called function]
function called: body()
File: /home/floeusa/public_html/crm/include/module.php
line 793
function called: call_user_func_array(Array (Object (CRM_Contacts), "body"), Array ())
File: /home/floeusa/public_html/crm/include/module.php
line 713
function called: get_html_of_module(Object (CRM_Contacts), null, null)
File: /home/floeusa/public_html/crm/modules/Base/Box/Box_0.php
line 146
function called: display_module("Object (CRM_Contacts)")
File: /home/floeusa/public_html/crm/include/epesi.php
line 241
function called: body()
File: /home/floeusa/public_html/crm/include/epesi.php
line 286
function called: go(Object (Base_Box))
File: /home/floeusa/public_html/crm/process.php
line 36
function called: process("__action_module__=%2FBase_Box%7C0%2FCRM_Contacts%7Cmain_77382a65a7df68e4dccc01ee8070a86a%2FUtils_RecordBrowser%7Ccompany%2FUtils_GenericBrowser%7Ccompany&%2FBase_Box%7C0%2FCRM_Contacts%7Cmain_77382a65a7df68e4dccc01ee8070a86a%2FUtils_RecordBrowser%7Ccompany%2FUtils_GenericBrowser%7Ccompany_next=1", false)
