id summary reporter owner description type status priority milestone component version resolution keywords cc modified_flg 1131 [管理画面]メルマガ管理(テンプレート設定):「編集」リンクをクリックするとDBエラー(MySQLのみ) kotani kimoto "管理画面>メルマガ管理>テンプレート設定[[BR]] ※MySQLのみ(MySQL 5.0.91-communityで再現確認)[[BR]] {{{ ▼▼▼ デバッグ情報ここから ▼▼▼ http://eccube.local/admin/mail/template_input.php?mode=edit&template_id=1?mode=edit&template_id=1 SERVER_ADDR: 127.0.0.1 REMOTE_ADDR: 127.0.0.1 USER_AGENT: Mozilla/5.0 (Windows; U; Windows NT 6.1; ja; rv:1.9.2.15) Gecko/20110303 Firefox/3.6.15 GTB7.1 C:\workspace\eccube\html\admin\mail\template_input.php 34:LC_Page_Admin_Mail_TemplateInput_Ex->process C:\workspace\eccube\data\class_extends\page_extends\admin\mail\LC_Page_Admin_Mail_TemplateInput_Ex.php 56:LC_Page_Admin_Mail_TemplateInput->process C:\workspace\eccube\data\class\pages\admin\mail\LC_Page_Admin_Mail_TemplateInput.php 62:LC_Page_Admin_Mail_TemplateInput->action C:\workspace\eccube\data\class\pages\admin\mail\LC_Page_Admin_Mail_TemplateInput.php 78:SC_Helper_Mail->sfGetMailmagaTemplate C:\workspace\eccube\data\class\helper\SC_Helper_Mail.php 351:SC_Query->select C:\workspace\eccube\data\class\SC_Query.php 153:SC_Query->getAll C:\workspace\eccube\data\class\SC_Query.php 265:SC_Query->prepare C:\workspace\eccube\data\class\SC_Query.php 870:trigger_error ▼▼▼ エラーメッセージ ▼▼▼ https://eccube.local/admin/mail/template_input.php?mode=edit&template_id=1 SERVER_ADDR: 127.0.0.1 REMOTE_ADDR: 127.0.0.1 USER_AGENT: Mozilla/5.0 (Windows; U; Windows NT 6.1; ja; rv:1.9.2.15) Gecko/20110303 Firefox/3.6.15 GTB7.1 SQL: SELECT * FROM dtb_mailmaga_template WHERE del_flg = ?AND template_id = ? ORDER BY create_date DESC MDB2 Error: syntax error _doQuery: [Error message: Could not execute statement] [Last executed query: PREPARE mdb2_statement_mysql_2f42a38e4631931fc11b1428e40d3c548204117cd FROM 'SELECT * FROM dtb_mailmaga_template WHERE del_flg = ?AND template_id = ? ORDER BY create_date DESC '] [Native code: 1064] [Native message: 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 template_id = ? ORDER BY create_date DESC' at line 1] C:\workspace\eccube\html\admin\mail\template_input.php 34:LC_Page_Admin_Mail_TemplateInput_Ex->process C:\workspace\eccube\data\class_extends\page_extends\admin\mail\LC_Page_Admin_Mail_TemplateInput_Ex.php 56:LC_Page_Admin_Mail_TemplateInput->process C:\workspace\eccube\data\class\pages\admin\mail\LC_Page_Admin_Mail_TemplateInput.php 62:LC_Page_Admin_Mail_TemplateInput->action C:\workspace\eccube\data\class\pages\admin\mail\LC_Page_Admin_Mail_TemplateInput.php 78:SC_Helper_Mail->sfGetMailmagaTemplate C:\workspace\eccube\data\class\helper\SC_Helper_Mail.php 351:SC_Query->select C:\workspace\eccube\data\class\SC_Query.php 153:SC_Query->getAll C:\workspace\eccube\data\class\SC_Query.php 265:SC_Query->prepare C:\workspace\eccube\data\class\SC_Query.php 867:MDB2_Driver_mysql->prepare C:\workspace\eccube\data\module\MDB2\Driver\mysql.php 1123:MDB2_Driver_mysql->_doQuery C:\workspace\eccube\data\module\MDB2\Driver\mysql.php 798:MDB2_Driver_Common->raiseError C:\workspace\eccube\data\module\MDB2.php 1497:PEAR->raiseError C:\workspace\eccube\data\module\PEAR.php 557:MDB2_Error->MDB2_Error C:\workspace\eccube\data\module\MDB2.php 1009:PEAR_Error->PEAR_Error ▲▲▲ エラーメッセージ ▲▲▲ }}} " バグ指摘 closed 高 EC-CUBE2.11.0 管理画面 2.11.0 β2 修正済