Witam.
Na początku kilka słów:
1. mam tabelę w CommonData o nazwie producent - Tam trzymam listę producentów
2. Z tabeli procentów tworzę listę rozwijalną <select> w sales opportunity
To tak krótko, ale jeśli chcę posortować po producencie system wywala mi błąd, nie może znaleść tabeli Producent_data_1, a powinien odnieść się do tabeli "utils_commondata_tree" w któej zapisani są producenci:
who=1
type=256
message=mysqlt error: [1146: Table 'epesi.Producent_data_1' doesn't exist] in EXECUTE("SELECT r.* FROM premium_salesopportunity_data_1 AS r WHERE r.active=1 AND (true) ORDER BY (SELECT rdt.f___common__ FROM premium_salesopportunity_data_1 AS rd LEFT JOIN Producent_data_1 AS rdt ON rdt.id=rd.f_producent WHERE r.id=rd.id) ASC LIMIT 0,50")

error file=/var/www/epesi/libs/adodb/adodb-errorhandler.inc.php
error line=77

error backtrace:
[PHP core called function]
    function called: handle_epesi_error(256, "mysqlt error: [1146: Table 'epesi.Producent_data_1' doesn't exist] in EXECUTE(\"SELECT r.* FROM premium_salesopportunity_data_1 AS r WHERE r.active=1 AND (true) ORDER BY (SELECT rdt.f___common__ FROM premium_salesopportunity_data_1 AS rd LEFT JOIN Producent_data_1 AS rdt ON rdt.id=rd.f_producent WHERE r.id=rd.id) ASC LIMIT 0,50\")
", "/var/www/epesi/libs/adodb/adodb-errorhandler.inc.php", 77, Array ("mysqlt", "EXECUTE", 1146, "Table 'epesi.Producent_data_1' doesn't exist", "SELECT r.* FROM premium_salesopportunity_data_1 AS r WHERE r.active=1 AND (true) ORDER BY (SELECT rdt.f___common__ FROM premium_salesopportunity_data_1 AS rd LEFT JOIN Producent_data_1 AS rdt ON rdt.id=rd.f_producent WHERE r.id=rd.id) ASC LIMIT 0,50", false, Object (ADODB_mysqlt), "SELECT r.* FROM premium_salesopportunity_data_1 AS r WHERE r.active=1 AND (true) ORDER BY (SELECT rdt.f___common__ FROM premium_salesopportunity_data_1 AS rd LEFT JOIN Producent_data_1 AS rdt ON rdt.id=rd.f_producent WHERE r.id=rd.id) ASC LIMIT 0,50", false, "mysqlt error: [1146: Table 'epesi.Producent_data_1' doesn't exist] in EXECUTE(\"SELECT r.* FROM premium_salesopportunity_data_1 AS r WHERE r.active=1 AND (true) ORDER BY (SELECT rdt.f___common__ FROM premium_salesopportunity_data_1 AS rd LEFT JOIN Producent_data_1 AS rdt ON rdt.id=rd.f_producent WHERE r.id=rd.id) ASC LIMIT 0,50\")
"))

File: /var/www/epesi/libs/adodb/adodb-errorhandler.inc.php
    line 77
    function called: trigger_error("mysqlt error: [1146: Table 'epesi.Producent_data_1' doesn't exist] in EXECUTE(\"SELECT r.* FROM premium_salesopportunity_data_1 AS r WHERE r.active=1 AND (true) ORDER BY (SELECT rdt.f___common__ FROM premium_salesopportunity_data_1 AS rd LEFT JOIN Producent_data_1 AS rdt ON rdt.id=rd.f_producent WHERE r.id=rd.id) ASC LIMIT 0,50\")
", 256)

File: /var/www/epesi/libs/adodb/adodb.inc.php
    line 1071
    function called: ADODB_Error_Handler("mysqlt", "EXECUTE", 1146, "Table 'epesi.Producent_data_1' doesn't exist", "SELECT r.* FROM premium_salesopportunity_data_1 AS r WHERE r.active=1 AND (true) ORDER BY (SELECT rdt.f___common__ FROM premium_salesopportunity_data_1 AS rd LEFT JOIN Producent_data_1 AS rdt ON rdt.id=rd.f_producent WHERE r.id=rd.id) ASC LIMIT 0,50", false, "Object (ADODB_mysqlt)")

File: /var/www/epesi/libs/adodb/adodb.inc.php
    line 1027
    function called: _Execute("SELECT r.* FROM premium_salesopportunity_data_1 AS r WHERE r.active=1 AND (true) ORDER BY (SELECT rdt.f___common__ FROM premium_salesopportunity_data_1 AS rd LEFT JOIN Producent_data_1 AS rdt ON rdt.id=rd.f_producent WHERE r.id=rd.id) ASC LIMIT 0,50")

File: /var/www/epesi/libs/adodb/drivers/adodb-mysql.inc.php
    line 591
    function called: Execute("SELECT r.* FROM premium_salesopportunity_data_1 AS r WHERE r.active=1 AND (true) ORDER BY (SELECT rdt.f___common__ FROM premium_salesopportunity_data_1 AS rd LEFT JOIN Producent_data_1 AS rdt ON rdt.id=rd.f_producent WHERE r.id=rd.id) ASC LIMIT 0,50", Array ())

[PHP core called function]
    function called: SelectLimit("SELECT r.* FROM premium_salesopportunity_data_1 AS r WHERE r.active=1 AND (true) ORDER BY (SELECT rdt.f___common__ FROM premium_salesopportunity_data_1 AS rd LEFT JOIN Producent_data_1 AS rdt ON rdt.id=rd.f_producent WHERE r.id=rd.id) ASC", "50", 0, Array ())

File: /var/www/epesi/include/database.php
    line 455
    function called: call_user_func_array(Array (Object (ADODB_mysqlt), "SelectLimit"), Array ("SELECT r.* FROM premium_salesopportunity_data_1 AS r WHERE r.active=1 AND (true) ORDER BY (SELECT rdt.f___common__ FROM premium_salesopportunity_data_1 AS rd LEFT JOIN Producent_data_1 AS rdt ON rdt.id=rd.f_producent WHERE r.id=rd.id) ASC", "50", 0, Array (#0)))

File: /var/www/epesi/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php
    line 1298
    function called: SelectLimit("SELECT r.* FROM premium_salesopportunity_data_1 AS r WHERE r.active=1 AND (true) ORDER BY (SELECT rdt.f___common__ FROM premium_salesopportunity_data_1 AS rd LEFT JOIN Producent_data_1 AS rdt ON rdt.id=rd.f_producent WHERE r.id=rd.id) ASC", "50", 0, Array ())

File: /var/www/epesi/modules/Utils/RecordBrowser/RecordBrowser_0.php
    line 933
    function called: get_records("premium_salesopportunity", Object (Utils_RecordBrowser_Crits), Array (), Array (Array (#3)), Array ("50", 0), false)

File: /var/www/epesi/modules/Utils/RecordBrowser/RecordBrowser_0.php
    line 320
    function called: show_data(Object (Utils_RecordBrowser_Crits), Array (), Array ())

[PHP core called function]
    function called: body()

File: /var/www/epesi/include/module.php
    line 880
    function called: call_user_func_array(Array (Object (Utils_RecordBrowser), "body"), Array ())

File: /var/www/epesi/include/module.php
    line 800
    function called: get_html_of_module(Object (Utils_RecordBrowser), null, null)

File: /var/www/epesi/modules/Premium/SalesOpportunity/SalesOpportunity_0.php
    line 37
    function called: display_module("Object (Utils_RecordBrowser)")

[PHP core called function]
    function called: body()

File: /var/www/epesi/include/module.php
    line 880
    function called: call_user_func_array(Array (Object (Premium_SalesOpportunity), "body"), Array ())

File: /var/www/epesi/include/module.php
    line 800
    function called: get_html_of_module(Object (Premium_SalesOpportunity), null, null)

File: /var/www/epesi/modules/Base/Box/Box_0.php
    line 142
    function called: display_module("Object (Premium_SalesOpportunity)")

File: /var/www/epesi/include/epesi.php
    line 239
    function called: body()

File: /var/www/epesi/include/epesi.php
    line 284
    function called: go(Object (Base_Box))

File: /var/www/epesi/process.php
    line 41
    function called: process("__action_module__=%2FBase_Box%7C0%2FPremium_SalesOpportunity%7Cmain_0%2FUtils_RecordBrowser%7Cpremium_salesopportunity%2FUtils_GenericBrowser%7Cpremium_salesopportunity&%2FBase_Box%7C0%2FPremium_SalesOpportunity%7Cmain_0%2FUtils_RecordBrowser%7Cpremium_salesopportunity%2FUtils_GenericBrowser%7Cpremium_salesopportunity_change_order=Producer", "")
Modyfikacja SalesOpportunity była wykonywana prez Was, dotyczyła pojedyńczego wyboru klienta. Jest zaszyta w kodzie modułu więc nie mogę przeprowadzić aktualizacji do nowej wersji modułu.
Epesi ENS | Epesi Academy | epesi.cloud PaaS | GitHub

Help Me! | Download from SourceForge
