Przy wyszukiwaniu firmy wywalają się takie błędy:
Type: E_USER_ERROR (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('%','chemirol','%') OR f__first_name LIKE CONCAT('%','chemirol','%')")

File: /.../crm/libs/adodb/adodb-errorhandler.inc.php

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('%','chemirol','%') OR f__first_name LIKE CONCAT('%','chemirol','%')\") ", "/.../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('%','chemirol','%') OR f__first_name LIKE CONCAT('%','chemirol','%')", false, Object (ADODB_mysqlt), "SELECT id, id FROM contact_data_1 WHERE false OR f_last_name LIKE CONCAT('%','chemirol','%') OR f__first_name LIKE CONCAT('%','chemirol','%')", 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('%','chemirol','%') OR f__first_name LIKE CONCAT('%','chemirol','%')\") "))

File: /.../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('%','chemirol','%') OR f__first_name LIKE CONCAT('%','chemirol','%')\") ", 256)

File: /.../crm/libs/adodb/adodb.inc.php

    line 1043

    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('%','chemirol','%') OR f__first_name LIKE CONCAT('%','chemirol','%')", false, "Object (ADODB_mysqlt)")

File: /.../crm/libs/adodb/adodb.inc.php

    line 1018

    function called: _Execute("SELECT id, id FROM contact_data_1 WHERE false OR f_last_name LIKE CONCAT('%','chemirol','%') OR f__first_name LIKE CONCAT('%','chemirol','%')", false)

File: /.../crm/libs/adodb/adodb.inc.php

    line 1392

    function called: Execute("SELECT id, id FROM contact_data_1 WHERE false OR f_last_name LIKE CONCAT('%','chemirol','%') OR f__first_name LIKE CONCAT('%','chemirol','%')", null)

[PHP core called function]

    function called: GetAssoc("SELECT id, id FROM contact_data_1 WHERE false OR f_last_name LIKE CONCAT('%','chemirol','%') OR f__first_name LIKE CONCAT('%','chemirol','%')", null)

File: /.../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('%','chemirol','%') OR f__first_name LIKE CONCAT('%','chemirol','%')", null))

File: /.../crm/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php

    line 1130

    function called: GetAssoc("SELECT id, id FROM contact_data_1 WHERE false OR f_last_name LIKE CONCAT('%','chemirol','%') OR f__first_name LIKE CONCAT('%','chemirol','%')")

File: /.../crm/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php

    line 1296

    function called: build_query("company", Array ("CONCAT('%','chemirol','%')", "CONCAT('%','chemirol','%')", "CONCAT('%','chemirol','%')", "chemirol", "CONCAT('%','chemirol','%')", "CONCAT('%','chemirol','%')"), false, Array ())

File: /.../crm/modules/Utils/RecordBrowser/RecordBrowser_0.php

    line 800

    function called: get_records_count("company", Array ("CONCAT('%','chemirol','%')", "CONCAT('%','chemirol','%')", "CONCAT('%','chemirol','%')", "chemirol", "CONCAT('%','chemirol','%')", "CONCAT('%','chemirol','%')"), false, Array (Array (#3)))

File: /.../crm/modules/Utils/RecordBrowser/RecordBrowser_0.php

    line 296

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

[PHP core called function]

    function called: body()

File: /.../crm/include/module.php

    line 793

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

File: /.../crm/include/module.php

    line 713

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

File: /.../crm/modules/CRM/Contacts/Contacts_0.php

    line 74

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

[PHP core called function]

    function called: body()

File: /.../crm/include/module.php

    line 793

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

File: /.../crm/include/module.php

    line 713

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

File: /.../crm/modules/Base/Box/Box_0.php

    line 146

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

File: /.../crm/include/epesi.php

    line 213

    function called: body()

File: /.../crm/include/epesi.php

    line 258

    function called: go(Object (Base_Box))

File: /.../crm/process.php

    line 32

    function called: process("_qf__libs_qf_f7ae799118d879c155abf8fc6eacd914=&submited=1&show_all_pressed=0&submit_search=Szukaj&search=chemirol&show_all=Poka%C5%BC%20wszystko&__action_module__=%2FBase_Box%7C0%2FCRM_Contacts%7Cmain_7607d4ee5000460fd6bed0f6ff2328fa%2FUtils_RecordBrowser%7Ccompany%2FUtils_GenericBrowser%7Ccompany", false)

Type: E_USER_ERROR (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('%','chemirol','%') OR f__first_name LIKE CONCAT('%','chemirol','%')")

File: /.../crm/libs/adodb/adodb-errorhandler.inc.php

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('%','chemirol','%') OR f__first_name LIKE CONCAT('%','chemirol','%')\") ", "/.../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('%','chemirol','%') OR f__first_name LIKE CONCAT('%','chemirol','%')", false, Object (ADODB_mysqlt), "SELECT id, id FROM contact_data_1 WHERE false OR f_last_name LIKE CONCAT('%','chemirol','%') OR f__first_name LIKE CONCAT('%','chemirol','%')", 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('%','chemirol','%') OR f__first_name LIKE CONCAT('%','chemirol','%')\") "))

File: /.../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('%','chemirol','%') OR f__first_name LIKE CONCAT('%','chemirol','%')\") ", 256)

File: /.../crm/libs/adodb/adodb.inc.php

    line 1043

    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('%','chemirol','%') OR f__first_name LIKE CONCAT('%','chemirol','%')", false, "Object (ADODB_mysqlt)")

File: /.../crm/libs/adodb/adodb.inc.php

    line 1018

    function called: _Execute("SELECT id, id FROM contact_data_1 WHERE false OR f_last_name LIKE CONCAT('%','chemirol','%') OR f__first_name LIKE CONCAT('%','chemirol','%')", false)

File: /.../crm/libs/adodb/adodb.inc.php

    line 1392

    function called: Execute("SELECT id, id FROM contact_data_1 WHERE false OR f_last_name LIKE CONCAT('%','chemirol','%') OR f__first_name LIKE CONCAT('%','chemirol','%')", null)

[PHP core called function]

    function called: GetAssoc("SELECT id, id FROM contact_data_1 WHERE false OR f_last_name LIKE CONCAT('%','chemirol','%') OR f__first_name LIKE CONCAT('%','chemirol','%')", null)

File: /.../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('%','chemirol','%') OR f__first_name LIKE CONCAT('%','chemirol','%')", null))

File: /.../crm/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php

    line 1130

    function called: GetAssoc("SELECT id, id FROM contact_data_1 WHERE false OR f_last_name LIKE CONCAT('%','chemirol','%') OR f__first_name LIKE CONCAT('%','chemirol','%')")

File: /.../crm/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php

    line 1296

    function called: build_query("company", Array ("CONCAT('%','chemirol','%')", "CONCAT('%','chemirol','%')", "CONCAT('%','chemirol','%')", "chemirol", "CONCAT('%','chemirol','%')", "CONCAT('%','chemirol','%')"), false, Array ())

File: /.../crm/modules/Utils/RecordBrowser/RecordBrowser_0.php

    line 800

    function called: get_records_count("company", Array ("CONCAT('%','chemirol','%')", "CONCAT('%','chemirol','%')", "CONCAT('%','chemirol','%')", "chemirol", "CONCAT('%','chemirol','%')", "CONCAT('%','chemirol','%')"), false, Array (Array (#3)))

File: /.../crm/modules/Utils/RecordBrowser/RecordBrowser_0.php

    line 296

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

[PHP core called function]

    function called: body()

File: /.../crm/include/module.php

    line 793

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

File: /.../crm/include/module.php

    line 713

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

File: /.../crm/modules/CRM/Contacts/Contacts_0.php

    line 74

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

[PHP core called function]

    function called: body()

File: /.../crm/include/module.php

    line 793

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

File: /.../crm/include/module.php

    line 713

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

File: /.../crm/modules/Base/Box/Box_0.php

    line 146

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

File: /.../crm/include/epesi.php

    line 213

    function called: body()

File: /.../crm/include/epesi.php

    line 258

    function called: go(Object (Base_Box))

File: /.../crm/include/epesi.php

    line 281

    function called: process("__action_module__=%2FBase_Box%7C0%2FCRM_Contacts%7Cmain_7607d4ee5000460fd6bed0f6ff2328fa%2FUtils_RecordBrowser%7Ccompany%2FUtils_GenericBrowser%7Ccompany&__location=1399445710", false, true)

File: /.../crm/process.php

    line 32

    function called: process("_qf__libs_qf_f7ae799118d879c155abf8fc6eacd914=&submited=1&show_all_pressed=0&submit_search=Szukaj&search=chemirol&show_all=Poka%C5%BC%20wszystko&__action_module__=%2FBase_Box%7C0%2FCRM_Contacts%7Cmain_7607d4ee5000460fd6bed0f6ff2328fa%2FUtils_RecordBrowser%7Ccompany%2FUtils_GenericBrowser%7Ccompany", false)
Nie analizowałem jeszcze tych błędów. Może to jest jakiś związek z błędami które pojawiały się przy wyszukiwaniu w kontaktach. Opisane to było w wątku http://forum.epesibim.com/viewtopic.php?f=25&t=2415. Nadal aktualne jest pytanie: czy w celu uzyskania podziału firmy na oddziały zdefiniować grupy użytkowników, czy poziomy uprawnień użytkowników, czy jedno i drugie? (a może należy to rozwiązać całkiem inaczej - jak?).
Dziękuję, Pozdrawiam, camel
Epesi ENS | Epesi Academy | epesi.cloud PaaS | GitHub

Help Me! | Download from SourceForge
