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	修正済