Jak wejdziemy w konkretny ASSET TYPE to przy wyszukiwaniu prostym jest błąd:
who=1
type=256
message=mysqlt error: [1054: Unknown column 'r_premium_assets_0.f_asset_id'
in 'where clause'] in EXECUTE("SELECT COUNT(*) FROM premium_assets_3_data_1
AS r WHERE r.active=1 AND (((EXISTS (SELECT 1 FROM premium_assets_data_1
AS r_premium_assets_0 WHERE r_premium_assets_0.active=1 AND
((r_premium_assets_0.f_asset_id LIKE '%avcc%' AND
r_premium_assets_0.f_asset_id IS NOT NULL) AND ((true) OR ((true)))) AND
r.f_asset_id = r_premium_assets_0.id))) OR ((r.f_sn LIKE '%avcc%' AND
r.f_sn IS NOT NULL)) OR ((r.f_kurier LIKE '%avcc%' AND r.f_kurier IS NOT
NULL))) LIMIT 1")
who=1
type=256
message=mysqlt error: [1054: Unknown column 'r_premium_assets_0.f_asset_id' in 'where clause'] in EXECUTE("SELECT COUNT(*) FROM premium_assets_3_data_1 AS r WHERE r.active=1 AND (((EXISTS (SELECT 1 FROM premium_assets_data_1 AS r_premium_assets_0 WHERE r_premium_assets_0.active=1 AND ((r_premium_assets_0.f_asset_id LIKE '%avcc%' AND r_premium_assets_0.f_asset_id IS NOT NULL) AND ((true) OR ((true)))) AND r.f_asset_id = r_premium_assets_0.id))) OR ((r.f_sn LIKE '%avcc%' AND r.f_sn IS NOT NULL)) OR ((r.f_kurier LIKE '%avcc%' AND r.f_kurier IS NOT NULL))) LIMIT 1")
error file=/home/itr24/domains/test.pl/private_html/epesi/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 'r_premium_assets_0.f_asset_id' in 'where clause'] in EXECUTE(\"SELECT COUNT() FROM premium_assets_3_data_1 AS r WHERE r.active=1 AND (((EXISTS (SELECT 1 FROM premium_assets_data_1 AS r_premium_assets_0 WHERE r_premium_assets_0.active=1 AND ((r_premium_assets_0.f_asset_id LIKE '%avcc%' AND r_premium_assets_0.f_asset_id IS NOT NULL) AND ((true) OR ((true)))) AND r.f_asset_id = r_premium_assets_0.id))) OR ((r.f_sn LIKE '%avcc%' AND r.f_sn IS NOT NULL)) OR ((r.f_kurier LIKE '%avcc%' AND r.f_kurier IS NOT NULL))) LIMIT 1\")
", "/home/itr24/domains/test.pl/private_html/epesi/libs/adodb/adodb-errorhandler.inc.php", 77, Array ("mysqlt", "EXECUTE", 1054, "Unknown column 'r_premium_assets_0.f_asset_id' in 'where clause'", "SELECT COUNT() FROM premium_assets_3_data_1 AS r WHERE r.active=1 AND (((EXISTS (SELECT 1 FROM premium_assets_data_1 AS r_premium_assets_0 WHERE r_premium_assets_0.active=1 AND ((r_premium_assets_0.f_asset_id LIKE '%avcc%' AND r_premium_assets_0.f_asset_id IS NOT NULL) AND ((true) OR ((true)))) AND r.f_asset_id = r_premium_assets_0.id))) OR ((r.f_sn LIKE '%avcc%' AND r.f_sn IS NOT NULL)) OR ((r.f_kurier LIKE '%avcc%' AND r.f_kurier IS NOT NULL))) LIMIT 1", false, Object (ADODB_mysqlt), "SELECT COUNT() FROM premium_assets_3_data_1 AS r WHERE r.active=1 AND (((EXISTS (SELECT 1 FROM premium_assets_data_1 AS r_premium_assets_0 WHERE r_premium_assets_0.active=1 AND ((r_premium_assets_0.f_asset_id LIKE '%avcc%' AND r_premium_assets_0.f_asset_id IS NOT NULL) AND ((true) OR ((true)))) AND r.f_asset_id = r_premium_assets_0.id))) OR ((r.f_sn LIKE '%avcc%' AND r.f_sn IS NOT NULL)) OR ((r.f_kurier LIKE '%avcc%' AND r.f_kurier IS NOT NULL))) LIMIT 1", false, "mysqlt error: [1054: Unknown column 'r_premium_assets_0.f_asset_id' in 'where clause'] in EXECUTE(\"SELECT COUNT() FROM premium_assets_3_data_1 AS r WHERE r.active=1 AND (((EXISTS (SELECT 1 FROM premium_assets_data_1 AS r_premium_assets_0 WHERE r_premium_assets_0.active=1 AND ((r_premium_assets_0.f_asset_id LIKE '%avcc%' AND r_premium_assets_0.f_asset_id IS NOT NULL) AND ((true) OR ((true)))) AND r.f_asset_id = r_premium_assets_0.id))) OR ((r.f_sn LIKE '%avcc%' AND r.f_sn IS NOT NULL)) OR ((r.f_kurier LIKE '%avcc%' AND r.f_kurier IS NOT NULL))) LIMIT 1\")
"))
File: /home/itr24/domains/test.pl/private_html/epesi/libs/adodb/adodb-errorhandler.inc.php
line 77
function called: trigger_error("mysqlt error: [1054: Unknown column 'r_premium_assets_0.f_asset_id' in 'where clause'] in EXECUTE(\"SELECT COUNT(*) FROM premium_assets_3_data_1 AS r WHERE r.active=1 AND (((EXISTS (SELECT 1 FROM premium_assets_data_1 AS r_premium_assets_0 WHERE r_premium_assets_0.active=1 AND ((r_premium_assets_0.f_asset_id LIKE '%avcc%' AND r_premium_assets_0.f_asset_id IS NOT NULL) AND ((true) OR ((true)))) AND r.f_asset_id = r_premium_assets_0.id))) OR ((r.f_sn LIKE '%avcc%' AND r.f_sn IS NOT NULL)) OR ((r.f_kurier LIKE '%avcc%' AND r.f_kurier IS NOT NULL))) LIMIT 1\")
", 256)
File: /home/itr24/domains/test.pl/private_html/epesi/libs/adodb/adodb.inc.php
line 1071
function called: ADODB_Error_Handler("mysqlt", "EXECUTE", 1054, "Unknown column 'r_premium_assets_0.f_asset_id' in 'where clause'", "SELECT COUNT(*) FROM premium_assets_3_data_1 AS r WHERE r.active=1 AND (((EXISTS (SELECT 1 FROM premium_assets_data_1 AS r_premium_assets_0 WHERE r_premium_assets_0.active=1 AND ((r_premium_assets_0.f_asset_id LIKE '%avcc%' AND r_premium_assets_0.f_asset_id IS NOT NULL) AND ((true) OR ((true)))) AND r.f_asset_id = r_premium_assets_0.id))) OR ((r.f_sn LIKE '%avcc%' AND r.f_sn IS NOT NULL)) OR ((r.f_kurier LIKE '%avcc%' AND r.f_kurier IS NOT NULL))) LIMIT 1", false, "Object (ADODB_mysqlt)")
File: /home/itr24/domains/test.pl/private_html/epesi/libs/adodb/adodb.inc.php
line 1027
function called: _Execute("SELECT COUNT(*) FROM premium_assets_3_data_1 AS r WHERE r.active=1 AND (((EXISTS (SELECT 1 FROM premium_assets_data_1 AS r_premium_assets_0 WHERE r_premium_assets_0.active=1 AND ((r_premium_assets_0.f_asset_id LIKE '%avcc%' AND r_premium_assets_0.f_asset_id IS NOT NULL) AND ((true) OR ((true)))) AND r.f_asset_id = r_premium_assets_0.id))) OR ((r.f_sn LIKE '%avcc%' AND r.f_sn IS NOT NULL)) OR ((r.f_kurier LIKE '%avcc%' AND r.f_kurier IS NOT NULL))) LIMIT 1")
File: /home/itr24/domains/test.pl/private_html/epesi/libs/adodb/drivers/adodb-mysql.inc.php
line 591
function called: Execute("SELECT COUNT(*) FROM premium_assets_3_data_1 AS r WHERE r.active=1 AND (((EXISTS (SELECT 1 FROM premium_assets_data_1 AS r_premium_assets_0 WHERE r_premium_assets_0.active=1 AND ((r_premium_assets_0.f_asset_id LIKE ? AND r_premium_assets_0.f_asset_id IS NOT NULL) AND ((true) OR ((true)))) AND r.f_asset_id = r_premium_assets_0.id))) OR ((r.f_sn LIKE ? AND r.f_sn IS NOT NULL)) OR ((r.f_kurier LIKE ? AND r.f_kurier IS NOT NULL))) LIMIT 1", Array ("%avcc%", "%avcc%", "%avcc%"))
File: /home/itr24/domains/test.pl/private_html/epesi/libs/adodb/drivers/adodb-mysql.inc.php
line 256
function called: SelectLimit("SELECT COUNT(*) FROM premium_assets_3_data_1 AS r WHERE r.active=1 AND (((EXISTS (SELECT 1 FROM premium_assets_data_1 AS r_premium_assets_0 WHERE r_premium_assets_0.active=1 AND ((r_premium_assets_0.f_asset_id LIKE ? AND r_premium_assets_0.f_asset_id IS NOT NULL) AND ((true) OR ((true)))) AND r.f_asset_id = r_premium_assets_0.id))) OR ((r.f_sn LIKE ? AND r.f_sn IS NOT NULL)) OR ((r.f_kurier LIKE ? AND r.f_kurier IS NOT NULL)))", 1, -1, Array ("%avcc%", "%avcc%", "%avcc%"))
[PHP core called function]
function called: GetOne("SELECT COUNT(*) FROM premium_assets_3_data_1 AS r WHERE r.active=1 AND (((EXISTS (SELECT 1 FROM premium_assets_data_1 AS r_premium_assets_0 WHERE r_premium_assets_0.active=1 AND ((r_premium_assets_0.f_asset_id LIKE ? AND r_premium_assets_0.f_asset_id IS NOT NULL) AND ((true) OR ((true)))) AND r.f_asset_id = r_premium_assets_0.id))) OR ((r.f_sn LIKE ? AND r.f_sn IS NOT NULL)) OR ((r.f_kurier LIKE ? AND r.f_kurier IS NOT NULL)))", Array ("%avcc%", "%avcc%", "%avcc%"))
File: /home/itr24/domains/test.pl/private_html/epesi/include/database.php
line 505
function called: call_user_func_array(Array (Object (ADODB_mysqlt), "GetOne"), Array ("SELECT COUNT(*) FROM premium_assets_3_data_1 AS r WHERE r.active=1 AND (((EXISTS (SELECT 1 FROM premium_assets_data_1 AS r_premium_assets_0 WHERE r_premium_assets_0.active=1 AND ((r_premium_assets_0.f_asset_id LIKE ? AND r_premium_assets_0.f_asset_id IS NOT NULL) AND ((true) OR ((true)))) AND r.f_asset_id = r_premium_assets_0.id))) OR ((r.f_sn LIKE ? AND r.f_sn IS NOT NULL)) OR ((r.f_kurier LIKE ? AND r.f_kurier IS NOT NULL)))", Array (#3)))
File: /home/itr24/domains/test.pl/private_html/epesi/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php
line 1247
function called: GetOne("SELECT COUNT(*) FROM premium_assets_3_data_1 AS r WHERE r.active=1 AND (((EXISTS (SELECT 1 FROM premium_assets_data_1 AS r_premium_assets_0 WHERE r_premium_assets_0.active=1 AND ((r_premium_assets_0.f_asset_id LIKE %s AND r_premium_assets_0.f_asset_id IS NOT NULL) AND ((true) OR ((true)))) AND r.f_asset_id = r_premium_assets_0.id))) OR ((r.f_sn LIKE %s AND r.f_sn IS NOT NULL)) OR ((r.f_kurier LIKE %s AND r.f_kurier IS NOT NULL)))", Array ("%avcc%", "%avcc%", "%avcc%"))
File: /home/itr24/domains/test.pl/private_html/epesi/modules/Utils/RecordBrowser/RecordBrowser_0.php
line 906
function called: get_records_count("premium_assets_3", Object (Utils_RecordBrowser_Crits), false, Array ())
File: /home/itr24/domains/test.pl/private_html/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(Array (), Array ())
File: /home/itr24/domains/test.pl/private_html/epesi/include/module.php
line 898
function called: call_user_func_array(Array (Object (Utils_RecordBrowser), "body"), Array (Array (#0), Array (#0)))
File: /home/itr24/domains/test.pl/private_html/epesi/include/module.php
line 818
function called: get_html_of_module(Object (Utils_RecordBrowser), Array (Array (#0), Array (#0)), null)
File: /home/itr24/domains/test.pl/private_html/epesi/modules/Premium/Assets/Assets_0.php
line 69
function called: display_module(Object (Utils_RecordBrowser), Array (Array (#0), Array (#0)))
[PHP core called function]
function called: details("premium_assets_3", "NULL")
File: /home/itr24/domains/test.pl/private_html/epesi/modules/Utils/TabbedBrowser/TabbedBrowser_0.php
line 120
function called: call_user_func_array(Array (Object (Premium_Assets), "details"), Array ("premium_assets_3", "NULL"))
File: /home/itr24/domains/test.pl/private_html/epesi/modules/Utils/TabbedBrowser/TabbedBrowser_0.php
line 100
function called: display_contents(Array (3, Array (#2), Array (#2), false), 3, true)
[PHP core called function]
function called: body()
File: /home/itr24/domains/test.pl/private_html/epesi/include/module.php
line 898
function called: call_user_func_array(Array (Object (Utils_TabbedBrowser), "body"), Array ())
File: /home/itr24/domains/test.pl/private_html/epesi/include/module.php
line 818
function called: get_html_of_module(Object (Utils_TabbedBrowser), null, null)
File: /home/itr24/domains/test.pl/private_html/epesi/modules/Premium/Assets/Assets_0.php
line 49
function called: display_module(Object (Utils_TabbedBrowser))
[PHP core called function]
function called: body()
File: /home/itr24/domains/test.pl/private_html/epesi/include/module.php
line 898
function called: call_user_func_array(Array (Object (Premium_Assets), "body"), Array ())
File: /home/itr24/domains/test.pl/private_html/epesi/include/module.php
line 818
function called: get_html_of_module(Object (Premium_Assets), null, null)
File: /home/itr24/domains/test.pl/private_html/epesi/modules/Base/Box/Box_0.php
line 142
function called: display_module(Object (Premium_Assets))
File: /home/itr24/domains/test.pl/private_html/epesi/include/epesi.php
line 246
function called: body()
File: /home/itr24/domains/test.pl/private_html/epesi/include/epesi.php
line 291
function called: go(Object (Base_Box))
File: /home/itr24/domains/test.pl/private_html/epesi/include/epesi.php
line 314
function called: process("action_module=%2FBase_Box%7C0%2FPremium_Assets%7Cmain_0%2FUtils_RecordBrowser%7Cpremium_assets_3%2FUtils_GenericBrowser%7Cpremium_assets_3&__location=1456848675.2656", false, true)
File: /home/itr24/domains/test.pl/private_html/epesi/include/epesi.php
line 314
function called: process("action_module=%2FBase_Box%7C0%2FPremium_Assets%7Cmain_0%2FUtils_RecordBrowser%7Cpremium_assets_3%2FUtils_GenericBrowser%7Cpremium_assets_3&__location=1456848675.229", false, true)
File: /home/itr24/domains/test.pl/private_html/epesi/process.php
line 41
function called: process("_qflibs_qf_a00214360d9774122e76db4d67c13753=&submited=1&show_all_pressed=0&submit_search=Szukaj&search=avcc&show_all=Poka%C5%BC%20wszystko&action_module__=%2FBase_Box%7C0%2FPremium_Assets%7Cmain_0%2FUtils_RecordBrowser%7Cpremium_assets_3%2FUtils_GenericBrowser%7Cpremium_assets_3", false)