Ticket #1984 (new バグ指摘) — at Version 1

Opened 11 years ago

Last modified 11 years ago

SQL文上の「00:00:00」がプリペアドステートメントの変数と見做されるケースが存在する

Reported by: Seasoft Owned by: somebody
Priority: Milestone: EC-CUBE2.12.3
Component: その他 Version: 2.12.2
Keywords: Cc:
修正済み: yes

Description (last modified by Seasoft) (diff)

LC_Page_Admin_Total#lfGetOrderTerm の下記コードで発生した。

$arrTotalResults = $objQuery->select($col, 'dtb_order', $where, $arrWhereVal);
EC-CUBE	 2.12.3-dev
サーバーOS	 Windows NT SEVEN 6.1 build 7600 (Windows 7 Home Premium Edition) i586
DBサーバー	 MySQL 5.5.16
WEBサーバー	 Apache/2.2.16 (Win32) mod_ssl/2.2.16 OpenSSL/0.9.8l PHP/5.4.7
PHP	 5.4.7 (Core, bcmath, calendar, ctype, date, ereg, filter, ftp, hash, iconv, json, mcrypt, SPL, odbc, pcre, Reflection, session, standard, mysqlnd, tokenizer, zip, zlib, libxml, dom, PDO, openssl, SimpleXML, wddx, xml, xmlreader, xmlwriter, apache2handler, gd, mbstring, mysql, Phar, pgsql, mhash)
GD	 有効 (GD Version => bundled (2.0.34 compatible), FreeType Support => 1, FreeType Linkage => with freetype, T1Lib Support => , GIF Read Support => 1, GIF Create Support => 1, JPEG Support => 1, PNG Support => 1, WBMP Support => 1, XPM Support => , XBM Support => 1, JIS-mapped Japanese Font Support => )
HTTPユーザーエージェント	 Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.95 Safari/537.11

r22136 (根本的な原因を把握でしていないため応急処置)

Change History

comment:1 Changed 11 years ago by Seasoft

  • Description modified (diff)
Note: See TracTickets for help on using tickets.