Epesi wer1,7,2
menu-> crm->zarządzaj listami->jakaś lista dynamiczna->List Crits->update list powoduje błąd i listy się nieuaktualniają:

Pozdrawiam Marek

who=1
type=256
message=mysqlt error: [2013: Lost connection to MySQL server during query] in EXECUTE("INSERT INTO premium_listmanager_element_data_1 (active, created_by, created_on, f_active, f_list_name, f_record_type, f_record_id, f_votes) SELECT 1, 1, '2016-10-11 12:56:11', 1, 15, 'company', r.id, '1' FROM company_data_1 AS r WHERE r.active=1 AND ((NOT ((r.f_group LIKE '%\\_competitor\\_%' AND r.f_group IS NOT NULL))) AND (((NOT ((r.f_permission = '2' AND r.f_permission IS NOT NULL))) OR (r.created_by = 1)) OR ((r.id = 1)))) AND r.id NOT IN (SELECT led.f_record_id FROM premium_listmanager_element_data_1 led WHERE f_list_name=15 AND f_record_type='company')")

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

error backtrace:
[PHP core called function]
function called: handle_epesi_error(256, "mysqlt error: [2013: Lost connection to MySQL server during query] in EXECUTE(\"INSERT INTO premium_listmanager_element_data_1 (active, created_by, created_on, f_active, f_list_name, f_record_type, f_record_id, f_votes) SELECT 1, 1, '2016-10-11 12:56:11', 1, 15, 'company', r.id, '1' FROM company_data_1 AS r WHERE r.active=1 AND ((NOT ((r.f_group LIKE '%\\_competitor\\%' AND r.f_group IS NOT NULL))) AND (((NOT ((r.f_permission = '2' AND r.f_permission IS NOT NULL))) OR (r.created_by = 1)) OR ((r.id = 1)))) AND r.id NOT IN (SELECT led.f_record_id FROM premium_listmanager_element_data_1 led WHERE f_list_name=15 AND f_record_type='company')\")
", "/epesi/libs/adodb/adodb-errorhandler.inc.php", 77, Array ("mysqlt", "EXECUTE", 2013, "Lost connection to MySQL server during query", "INSERT INTO premium_listmanager_element_data_1 (active, created_by, created_on, f_active, f_list_name, f_record_type, f_record_id, f_votes) SELECT 1, 1, '2016-10-11 12:56:11', 1, 15, 'company', r.id, '1' FROM company_data_1 AS r WHERE r.active=1 AND ((NOT ((r.f_group LIKE '%\\_competitor\\%' AND r.f_group IS NOT NULL))) AND (((NOT ((r.f_permission = '2' AND r.f_permission IS NOT NULL))) OR (r.created_by = 1)) OR ((r.id = 1)))) AND r.id NOT IN (SELECT led.f_record_id FROM premium_listmanager_element_data_1 led WHERE f_list_name=15 AND f_record_type='company')", false, Object (ADODB_mysqlt), "INSERT INTO premium_listmanager_element_data_1 (active, created_by, created_on, f_active, f_list_name, f_record_type, f_record_id, f_votes) SELECT 1, 1, '2016-10-11 12:56:11', 1, 15, 'company', r.id, '1' FROM company_data_1 AS r WHERE r.active=1 AND ((NOT ((r.f_group LIKE '%\\_competitor\\%' AND r.f_group IS NOT NULL))) AND (((NOT ((r.f_permission = '2' AND r.f_permission IS NOT NULL))) OR (r.created_by = 1)) OR ((r.id = 1)))) AND r.id NOT IN (SELECT led.f_record_id FROM premium_listmanager_element_data_1 led WHERE f_list_name=15 AND f_record_type='company')", false, "mysqlt error: [2013: Lost connection to MySQL server during query] in EXECUTE(\"INSERT INTO premium_listmanager_element_data_1 (active, created_by, created_on, f_active, f_list_name, f_record_type, f_record_id, f_votes) SELECT 1, 1, '2016-10-11 12:56:11', 1, 15, 'company', r.id, '1' FROM company_data_1 AS r WHERE r.active=1 AND ((NOT ((r.f_group LIKE '%\\_competitor\\%' AND r.f_group IS NOT NULL))) AND (((NOT ((r.f_permission = '2' AND r.f_permission IS NOT NULL))) OR (r.created_by = 1)) OR ((r.id = 1)))) AND r.id NOT IN (SELECT led.f_record_id FROM premium_listmanager_element_data_1 led WHERE f_list_name=15 AND f_record_type='company')\")
"))

File: /epesi/libs/adodb/adodb-errorhandler.inc.php
line 77
function called: trigger_error("mysqlt error: [2013: Lost connection to MySQL server during query] in EXECUTE(\"INSERT INTO premium_listmanager_element_data_1 (active, created_by, created_on, f_active, f_list_name, f_record_type, f_record_id, f_votes) SELECT 1, 1, '2016-10-11 12:56:11', 1, 15, 'company', r.id, '1' FROM company_data_1 AS r WHERE r.active=1 AND ((NOT ((r.f_group LIKE '%\\_competitor\\_%' AND r.f_group IS NOT NULL))) AND (((NOT ((r.f_permission = '2' AND r.f_permission IS NOT NULL))) OR (r.created_by = 1)) OR ((r.id = 1)))) AND r.id NOT IN (SELECT led.f_record_id FROM premium_listmanager_element_data_1 led WHERE f_list_name=15 AND f_record_type='company')\")
", 256)

File: /epesi/libs/adodb/adodb.inc.php
line 1071
function called: ADODB_Error_Handler("mysqlt", "EXECUTE", 2013, "Lost connection to MySQL server during query", "INSERT INTO premium_listmanager_element_data_1 (active, created_by, created_on, f_active, f_list_name, f_record_type, f_record_id, f_votes) SELECT 1, 1, '2016-10-11 12:56:11', 1, 15, 'company', r.id, '1' FROM company_data_1 AS r WHERE r.active=1 AND ((NOT ((r.f_group LIKE '%\\_competitor\\_%' AND r.f_group IS NOT NULL))) AND (((NOT ((r.f_permission = '2' AND r.f_permission IS NOT NULL))) OR (r.created_by = 1)) OR ((r.id = 1)))) AND r.id NOT IN (SELECT led.f_record_id FROM premium_listmanager_element_data_1 led WHERE f_list_name=15 AND f_record_type='company')", false, "Object (ADODB_mysqlt)")

File: /epesi/libs/adodb/adodb.inc.php
line 1027
function called: Execute("INSERT INTO premium_listmanager_element_data_1 (active, created_by, created_on, f_active, f_list_name, f_record_type, f_record_id, f_votes) SELECT 1, 1, '2016-10-11 12:56:11', 1, 15, 'company', r.id, '1' FROM company_data_1 AS r WHERE r.active=1 AND ((NOT ((r.f_group LIKE '%\\_competitor\\%' AND r.f_group IS NOT NULL))) AND (((NOT ((r.f_permission = '2' AND r.f_permission IS NOT NULL))) OR (r.created_by = 1)) OR ((r.id = 1)))) AND r.id NOT IN (SELECT led.f_record_id FROM premium_listmanager_element_data_1 led WHERE f_list_name=15 AND f_record_type='company')")

[PHP core called function]
function called: Execute("INSERT INTO premium_listmanager_element_data_1 (active, created_by, created_on, f_active, f_list_name, f_record_type, f_record_id, f_votes) SELECT 1, ?, ?, 1, ?, ?, r.id, ? FROM company_data_1 AS r WHERE r.active=1 AND ((NOT ((r.f_group LIKE ? AND r.f_group IS NOT NULL))) AND (((NOT ((r.f_permission = ? AND r.f_permission IS NOT NULL))) OR (r.created_by = ?)) OR ((r.id = ?)))) AND r.id NOT IN (SELECT led.f_record_id FROM premium_listmanager_element_data_1 led WHERE f_list_name=? AND f_record_type=?)", Array (#11))

File: /epesi/include/database.php
line 360
function called: call_user_func_array(Array (Object (ADODB_mysqlt), "Execute"), Array ("INSERT INTO premium_listmanager_element_data_1 (active, created_by, created_on, f_active, f_list_name, f_record_type, f_record_id, f_votes) SELECT 1, ?, ?, 1, ?, ?, r.id, ? FROM company_data_1 AS r WHERE r.active=1 AND ((NOT ((r.f_group LIKE ? AND r.f_group IS NOT NULL))) AND (((NOT ((r.f_permission = ? AND r.f_permission IS NOT NULL))) OR (r.created_by = ?)) OR ((r.id = ?)))) AND r.id NOT IN (SELECT led.f_record_id FROM premium_listmanager_element_data_1 led WHERE f_list_name=? AND f_record_type=?)", Array (#11)))

File: /epesi/modules/Premium/ListManager/DynamicList.php
line 53
function called: Execute("INSERT INTO premium_listmanager_element_data_1 (active, created_by, created_on, f_active, f_list_name, f_record_type, f_record_id, f_votes) SELECT 1, %d, %T, 1, %d, %s, r.id, %s FROM company_data_1 AS r WHERE r.active=1 AND ((NOT ((r.f_group LIKE %s AND r.f_group IS NOT NULL))) AND (((NOT ((r.f_permission = %s AND r.f_permission IS NOT NULL))) OR (r.created_by = %d)) OR ((r.id = %d)))) AND r.id NOT IN (SELECT led.f_record_id FROM premium_listmanager_element_data_1 led WHERE f_list_name=%d AND f_record_type=%s)", Array (#11))

File: /epesi/modules/Premium/ListManager/DynamicListView.php
line 48
function called: update_list()

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

File: /epesi/include/module.php
line 887
function called: call_user_func_array(Array (Object (Premium_ListManager_DynamicListView), "update_list"), Array ())

File: /epesi/include/module.php
line 818
function called: get_html_of_module(Object (Premium_ListManager_DynamicListView), null, null)

File: /epesi/include/module.php
line 117
function called: display_module(Object (Premium_ListManager_DynamicListView), null, null)

File: /epesi/modules/Premium/ListManager/ListManager_0.php
line 87
function called: pack_module("#DynamicListView", null, null, 15)

[PHP core called function]
function called: premium_listmanager_list_crits(Array (#11), Object (Utils_RecordBrowser))

File: /epesi/include/module.php
line 898
function called: call_user_func_array(Array (Object (Premium_ListManager), "premium_listmanager_list_crits"), Array (Array (#11), Object (Utils_RecordBrowser)))

File: /epesi/include/module.php
line 818
function called: get_html_of_module(Object (Premium_ListManager), Array (Array (#11), Object (Utils_RecordBrowser)), "premium_listmanager_list_crits")

[PHP core called function]
function called: display_module(Object (Premium_ListManager), Array (Array (#11), Object (Utils_RecordBrowser)), "premium_listmanager_list_crits")

File: /epesi/modules/Utils/TabbedBrowser/TabbedBrowser_0.php
line 120
function called: call_user_func_array(Array (Object (Utils_RecordBrowser), "display_module"), Array ("Object (Premium_ListManager)", Array (#2), "premium_listmanager_list_crits"))

File: /epesi/modules/Utils/TabbedBrowser/TabbedBrowser_0.php
line 85
function called: display_contents(Array (4, Array (#2), Array (#3), false), 4, true)

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

File: /epesi/include/module.php
line 898
function called: call_user_func_array(Array (Object (Utils_TabbedBrowser), "body"), Array ())

File: /epesi/include/module.php
line 818
function called: get_html_of_module(Object (Utils_TabbedBrowser), null, null)

File: /epesi/modules/Utils/RecordBrowser/RecordBrowser_0.php
line 1544
function called: display_module(Object (Utils_TabbedBrowser))

File: /epesi/modules/Utils/RecordBrowser/RecordBrowser_0.php
line 1209
function called: view_entry("view", "15", Array (), true)

[PHP core called function]
function called: view_entry_with_REQUEST("view", "15", Array (), true, Array ())

File: /epesi/include/module.php
line 898
function called: call_user_func_array(Array (Object (Utils_RecordBrowser), "view_entry_with_REQUEST"), Array ("view", "15", Array (#0), true, Array (#0)))

File: /epesi/include/module.php
line 818
function called: get_html_of_module(Object (Utils_RecordBrowser), Array ("view", "15", Array (#0), true, Array (#0)), "view_entry_with_REQUEST")

File: /epesi/modules/Base/Box/Box_0.php
line 138
function called: display_module(Object (Utils_RecordBrowser), Array ("view", "15", Array (#0), true, Array (#0)), "view_entry_with_REQUEST")

File: /epesi/include/epesi.php
line 246
function called: body()

File: /epesi/include/epesi.php
line 291
function called: go(Object (Base_Box))

File: /epesi/process.php
line 41
function called: process("action_module=%2FBase_Box%7C0%2FUtils_RecordBrowser%7Cmain_29f367b39deb851911382f0b1a08485a%2FPremium_ListManager%7C2%2FPremium_ListManager%23DynamicListView%7C0&%2FBase_Box%7C0%2FUtils_RecordBrowser%7Cmain_29f367b39deb851911382f0b1a08485a%2FPremium_ListManager%7C2%2FPremium_ListManager%23DynamicListView%7C0_callback_17f0fe7a833362bbb7af9f9d35ab29f0=1", "")

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

Help Me! | Download from SourceForge