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.
