błąd w szukaniu w firmach

camel

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

ajb

W Firmie jest jakieś pole gdzie wybiera się kontakt?
Jeśli tak, to znam ten błąd 🙂 To jest błąd związany z definicją pola. Trzeba wejść w interfejs zarządzania polami, edytować to pole kontaktu i usunąć spację po przecinku w param
Jest pewnie

Last Name, First Name

a powinno być

Last Name,First Name

Poprawiałem ten błąd, ale nie pamiętam teraz kiedy dokładnie to było.

[quote="camel":3txuobj0] 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?).[/quote:3txuobj0]
To zależy od sytuacji i od rekordsetu. Generalnie i jedno i drugie, bo daje to więcej kontroli.

Pozdrawiam,
Adam

camel

[quote="ajb":3osbnozj]W Firmie jest jakieś pole gdzie wybiera się kontakt?[/quote:3osbnozj]W Firmach nie ma pola kontakt! Szukanie odbywa się w Firmach, a w logu są błędy dotyczące pól f__first_name i f__last_name których w firmach nie ma. Nie wiem o co chodzi...
[quote="ajb":3osbnozj]To zależy od sytuacji i od rekordsetu. Generalnie i jedno i drugie, bo daje to więcej kontroli.[/quote:3osbnozj]Tak, żeby wyższy poziom dawał większą kontrolę, to miałem zrobione właśnie przy zastosowaniu grup i poziomów uprawnień. Problemy pojawiły się przy wyszukiwaniach kontaktów i firm. Nie udało mi się zrobić żeby kontakty i związane zdarzenia nie były widoczne dla grup równoległych.
Nie wiem czy w zrozumiały sposób uda się opisać problem:
Teraz po dodaniu, kontakt znika bo nie ma przypisanej domyślnie żadnej grupy i użytkownik nie może tego poprawić, bo nie widzi tego rekordu.
Jak zrobić aby kontakt dodawany przez użytkownika podgrupy czy oddziału firmy miał od razu zdefiniowaną dostępność dla tej grupy?

Epesi ENS | Epesi Academy | epesi.cloud PaaS | GitHub

Help Me! | Download from SourceForge