Ticket #1131 (closed バグ指摘: 修正済)

Opened 10 years ago

Last modified 10 years ago

[管理画面]メルマガ管理(テンプレート設定):「編集」リンクをクリックするとDBエラー(MySQLのみ)

Reported by: kotani Owned by: kimoto
Priority: Milestone: EC-CUBE2.11.0
Component: 管理画面 Version: 2.11.0 β2
Keywords: Cc:
修正済み:

Description (last modified by kotani) (diff)

管理画面>メルマガ管理>テンプレート設定

※MySQLのみ(MySQL 5.0.91-communityで再現確認)

▼▼▼ デバッグ情報ここから ▼▼▼

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
▲▲▲ エラーメッセージ ▲▲▲


Change History

comment:1 Changed 10 years ago by kotani

  • Description modified (diff)

comment:2 Changed 10 years ago by kotani

  • Priority changed from to

comment:3 Changed 10 years ago by kimoto

  • Owner changed from somebody to kimoto

comment:4 Changed 10 years ago by kimoto

  • Status changed from new to closed
  • Resolution set to 修正済

[20642]にて修正
postgresだとスペースなくても動くんですね~

Note: See TracTickets for help on using tickets.