Witam,
Podczas pracy objawił mi się taki błąd:
Type: E_USER_ERROR (256)
Message: mysqlt error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND ual.local LIKE '%' LIMIT 50' at line 1] in EXECUTE("SELECT ual.local,ual.id,ual.func,ual.args FROM utils_attachment_link ual WHERE ual.deleted=0 AND (0!=(SELECT count(uan.id) FROM utils_attachment_note AS uan WHERE uan.attach_id=ual.id AND uan.text LIKE CONCAT('%','Polfa Tarchomin S.A.','%') AND uan.revision=(SELECT MAX(xxx.revision) FROM utils_attachment_note xxx WHERE xxx.attach_id=ual.id)) OR 0!=(SELECT count(uaf.id) FROM utils_attachment_file AS uaf WHERE uaf.attach_id=ual.id AND uaf.original LIKE CONCAT('%','Polfa Tarchomin S.A.','%') AND uaf.deleted=0)) AND (ual.permission<2 OR ual.permission_by=) AND ual.local LIKE '%' LIMIT 50")
File: /usr/local/apache/www/htdocs/crm.system.pl/epesi/libs/adodb/adodb-errorhandler.inc.php
Line=77
error backtrace:
[PHP core called function]
function called: handle_epesi_error(256, "mysqlt error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND ual.local LIKE '%' LIMIT 50' at line 1] in EXECUTE(\"SELECT ual.local,ual.id,ual.func,ual.args FROM utils_attachment_link ual WHERE ual.deleted=0 AND (0!=(SELECT count(uan.id) FROM utils_attachment_note AS uan WHERE uan.attach_id=ual.id AND uan.text LIKE CONCAT('%','Polfa Tarchomin S.A.','%') AND uan.revision=(SELECT MAX(xxx.revision) FROM utils_attachment_note xxx WHERE xxx.attach_id=ual.id)) OR 0!=(SELECT count(uaf.id) FROM utils_attachment_file AS uaf WHERE uaf.attach_id=ual.id AND uaf.original LIKE CONCAT('%','Polfa Tarchomin S.A.','%') AND uaf.deleted=0)) AND (ual.permission<2 OR ual.permission_by=) AND ual.local LIKE '%' LIMIT 50\") ", "/usr/local/apache/www/htdocs/crm.system.pl/epesi/libs/adodb/adodb-errorhandler.inc.php", 77, Array ("mysqlt", "EXECUTE", 1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND ual.local LIKE '%' LIMIT 50' at line 1", "SELECT ual.local,ual.id,ual.func,ual.args FROM utils_attachment_link ual WHERE ual.deleted=0 AND (0!=(SELECT count(uan.id) FROM utils_attachment_note AS uan WHERE uan.attach_id=ual.id AND uan.text LIKE CONCAT('%','Polfa Tarchomin S.A.','%') AND uan.revision=(SELECT MAX(xxx.revision) FROM utils_attachment_note xxx WHERE xxx.attach_id=ual.id)) OR 0!=(SELECT count(uaf.id) FROM utils_attachment_file AS uaf WHERE uaf.attach_id=ual.id AND uaf.original LIKE CONCAT('%','Polfa Tarchomin S.A.','%') AND uaf.deleted=0)) AND (ual.permission<2 OR ual.permission_by=) AND ual.local LIKE '%' LIMIT 50", false, Object (ADODB_mysqlt), "SELECT ual.local,ual.id,ual.func,ual.args FROM utils_attachment_link ual WHERE ual.deleted=0 AND (0!=(SELECT count(uan.id) FROM utils_attachment_note AS uan WHERE uan.attach_id=ual.id AND uan.text LIKE CONCAT('%','Polfa Tarchomin S.A.','%') AND uan.revision=(SELECT MAX(xxx.revision) FROM utils_attachment_note xxx WHERE xxx.attach_id=ual.id)) OR 0!=(SELECT count(uaf.id) FROM utils_attachment_file AS uaf WHERE uaf.attach_id=ual.id AND uaf.original LIKE CONCAT('%','Polfa Tarchomin S.A.','%') AND uaf.deleted=0)) AND (ual.permission<2 OR ual.permission_by=) AND ual.local LIKE '%' LIMIT 50", false, "mysqlt error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND ual.local LIKE '%' LIMIT 50' at line 1] in EXECUTE(\"SELECT ual.local,ual.id,ual.func,ual.args FROM utils_attachment_link ual WHERE ual.deleted=0 AND (0!=(SELECT count(uan.id) FROM utils_attachment_note AS uan WHERE uan.attach_id=ual.id AND uan.text LIKE CONCAT('%','Polfa Tarchomin S.A.','%') AND uan.revision=(SELECT MAX(xxx.revision) FROM utils_attachment_note xxx WHERE xxx.attach_id=ual.id)) OR 0!=(SELECT count(uaf.id) FROM utils_attachment_file AS uaf WHERE uaf.attach_id=ual.id AND uaf.original LIKE CONCAT('%','Polfa Tarchomin S.A.','%') AND uaf.deleted=0)) AND (ual.permission<2 OR ual.permission_by=) AND ual.local LIKE '%' LIMIT 50\") "))
File: /usr/local/apache/www/htdocs/crm.system.pl/epesi/libs/adodb/adodb-errorhandler.inc.php
line 77
function called: trigger_error("mysqlt error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND ual.local LIKE '%' LIMIT 50' at line 1] in EXECUTE(\"SELECT ual.local,ual.id,ual.func,ual.args FROM utils_attachment_link ual WHERE ual.deleted=0 AND (0!=(SELECT count(uan.id) FROM utils_attachment_note AS uan WHERE uan.attach_id=ual.id AND uan.text LIKE CONCAT('%','Polfa Tarchomin S.A.','%') AND uan.revision=(SELECT MAX(xxx.revision) FROM utils_attachment_note xxx WHERE xxx.attach_id=ual.id)) OR 0!=(SELECT count(uaf.id) FROM utils_attachment_file AS uaf WHERE uaf.attach_id=ual.id AND uaf.original LIKE CONCAT('%','Polfa Tarchomin S.A.','%') AND uaf.deleted=0)) AND (ual.permission<2 OR ual.permission_by=) AND ual.local LIKE '%' LIMIT 50\") ", 256)
File: /usr/local/apache/www/htdocs/crm.system.pl/epesi/libs/adodb/adodb.inc.php
line 1043
function called: ADODB_Error_Handler("mysqlt", "EXECUTE", 1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND ual.local LIKE '%' LIMIT 50' at line 1", "SELECT ual.local,ual.id,ual.func,ual.args FROM utils_attachment_link ual WHERE ual.deleted=0 AND (0!=(SELECT count(uan.id) FROM utils_attachment_note AS uan WHERE uan.attach_id=ual.id AND uan.text LIKE CONCAT('%','Polfa Tarchomin S.A.','%') AND uan.revision=(SELECT MAX(xxx.revision) FROM utils_attachment_note xxx WHERE xxx.attach_id=ual.id)) OR 0!=(SELECT count(uaf.id) FROM utils_attachment_file AS uaf WHERE uaf.attach_id=ual.id AND uaf.original LIKE CONCAT('%','Polfa Tarchomin S.A.','%') AND uaf.deleted=0)) AND (ual.permission<2 OR ual.permission_by=) AND ual.local LIKE '%' LIMIT 50", false, "Object (ADODB_mysqlt)")
File: /usr/local/apache/www/htdocs/crm.system.pl/epesi/libs/adodb/adodb.inc.php
line 999
function called: _Execute("SELECT ual.local,ual.id,ual.func,ual.args FROM utils_attachment_link ual WHERE ual.deleted=0 AND (0!=(SELECT count(uan.id) FROM utils_attachment_note AS uan WHERE uan.attach_id=ual.id AND uan.text LIKE CONCAT('%','Polfa Tarchomin S.A.','%') AND uan.revision=(SELECT MAX(xxx.revision) FROM utils_attachment_note xxx WHERE xxx.attach_id=ual.id)) OR 0!=(SELECT count(uaf.id) FROM utils_attachment_file AS uaf WHERE uaf.attach_id=ual.id AND uaf.original LIKE CONCAT('%','Polfa Tarchomin S.A.','%') AND uaf.deleted=0)) AND (ual.permission<2 OR ual.permission_by=) AND ual.local LIKE '%' LIMIT 50")
File: /usr/local/apache/www/htdocs/crm.system.pl/epesi/libs/adodb/drivers/adodb-mysql.inc.php
line 497
function called: Execute("SELECT ual.local,ual.id,ual.func,ual.args FROM utils_attachment_link ual WHERE ual.deleted=0 AND (0!=(SELECT count(uan.id) FROM utils_attachment_note AS uan WHERE uan.attach_id=ual.id AND uan.text LIKE CONCAT('%',?,'%') AND uan.revision=(SELECT MAX(xxx.revision) FROM utils_attachment_note xxx WHERE xxx.attach_id=ual.id)) OR 0!=(SELECT count(uaf.id) FROM utils_attachment_file AS uaf WHERE uaf.attach_id=ual.id AND uaf.original LIKE CONCAT('%',?,'%') AND uaf.deleted=0)) AND (ual.permission<2 OR ual.permission_by=) AND ual.local LIKE '%' LIMIT 50", Array ("Polfa Tarchomin S.A.", "Polfa Tarchomin S.A."))
[PHP core called function]
function called: SelectLimit("SELECT ual.local,ual.id,ual.func,ual.args FROM utils_attachment_link ual WHERE ual.deleted=0 AND (0!=(SELECT count(uan.id) FROM utils_attachment_note AS uan WHERE uan.attach_id=ual.id AND uan.text LIKE CONCAT('%',?,'%') AND uan.revision=(SELECT MAX(xxx.revision) FROM utils_attachment_note xxx WHERE xxx.attach_id=ual.id)) OR 0!=(SELECT count(uaf.id) FROM utils_attachment_file AS uaf WHERE uaf.attach_id=ual.id AND uaf.original LIKE CONCAT('%',?,'%') AND uaf.deleted=0)) AND (ual.permission<2 OR ual.permission_by=) AND ual.local LIKE '%'", 50, -1, Array ("Polfa Tarchomin S.A.", "Polfa Tarchomin S.A."))
File: /usr/local/apache/www/htdocs/crm.system.pl/epesi/include/database.php
line 433
function called: call_user_func_array(Array (Object (ADODB_mysqlt), "SelectLimit"), Array ("SELECT ual.local,ual.id,ual.func,ual.args FROM utils_attachment_link ual WHERE ual.deleted=0 AND (0!=(SELECT count(uan.id) FROM utils_attachment_note AS uan WHERE uan.attach_id=ual.id AND uan.text LIKE CONCAT('%',?,'%') AND uan.revision=(SELECT MAX(xxx.revision) FROM utils_attachment_note xxx WHERE xxx.attach_id=ual.id)) OR 0!=(SELECT count(uaf.id) FROM utils_attachment_file AS uaf WHERE uaf.attach_id=ual.id AND uaf.original LIKE CONCAT('%',?,'%') AND uaf.deleted=0)) AND (ual.permission<2 OR ual.permission_by=) AND ual.local LIKE '%'", 50, -1, Array (#2)))
File: /usr/local/apache/www/htdocs/crm.system.pl/epesi/modules/Utils/Attachment/AttachmentCommon_0.php
line 135
function called: SelectLimit("SELECT ual.local,ual.id,ual.func,ual.args FROM utils_attachment_link ual WHERE ual.deleted=0 AND (0!=(SELECT count(uan.id) FROM utils_attachment_note AS uan WHERE uan.attach_id=ual.id AND uan.text LIKE CONCAT('%',%s,'%') AND uan.revision=(SELECT MAX(xxx.revision) FROM utils_attachment_note xxx WHERE xxx.attach_id=ual.id)) OR 0!=(SELECT count(uaf.id) FROM utils_attachment_file AS uaf WHERE uaf.attach_id=ual.id AND uaf.original LIKE CONCAT('%',%s,'%') AND uaf.deleted=0)) AND (ual.permission<2 OR ual.permission_by=) AND ual.local LIKE '%'", 50, -1, Array ("Polfa Tarchomin S.A.", "Polfa Tarchomin S.A."))
File: /usr/local/apache/www/htdocs/crm.system.pl/epesi/modules/Utils/Attachment/AttachmentCommon_0.php
line 154
function called: search_group("", "Polfa Tarchomin S.A.", true, 50)
[PHP core called function]
function called: search("Polfa Tarchomin S.A.")
File: /usr/local/apache/www/htdocs/crm.system.pl/epesi/modules/Base/Search/Search_0.php
line 53
function called: call_user_func(Array ("Utils_AttachmentCommon", "search"), "Polfa Tarchomin S.A.")
[PHP core called function]
function called: body()
File: /usr/local/apache/www/htdocs/crm.system.pl/epesi/include/module.php
line 793
function called: call_user_func_array(Array (Object (Base_Search), "body"), Array ())
File: /usr/local/apache/www/htdocs/crm.system.pl/epesi/include/module.php
line 713
function called: get_html_of_module(Object (Base_Search), null, null)
File: /usr/local/apache/www/htdocs/crm.system.pl/epesi/modules/Base/Box/Box_0.php
line 146
function called: display_module("Object (Base_Search)")
File: /usr/local/apache/www/htdocs/crm.system.pl/epesi/include/epesi.php
line 213
function called: body()
File: /usr/local/apache/www/htdocs/crm.system.pl/epesi/include/epesi.php
line 258
function called: go(Object (Base_Box))
File: /usr/local/apache/www/htdocs/crm.system.pl/epesi/process.php
line 32
function called: process("__jump_to_RB_table=company&__jump_to_RB_record=1276&__jump_to_RB_action=view", false)
Co to za błąd.
Pozdrawiam,
Daniel
