id	summary	reporter	owner	description	type	status	priority	milestone	component	version	resolution	keywords	cc	modified_flg
1048	[フロント]MYページ：ダウンロード商品をダウンロードでDBエラー	kotani	shutta	"ダウンロード商品を購入し、受注ステータスが「入金済み」の状態で、[[BR]]
MYページ＞購入履歴詳細＞「ダウンロード」リンクをクリック[[BR]]

MySQL

{{{
USER_AGENT: Mozilla/5.0 (Windows; U; Windows NT 6.1; ja; rv:1.9.2.13) Gecko/20101203 Firefox/3.6.13 GTB7.1

SQL: SELECT pc.product_id AS product_id, pc.product_class_id AS product_class_id, pc.down_realfilename AS down_realfilename, pc.down_filename AS down_filename, o.order_id AS order_id, o.customer_id AS customer_id, o.payment_date AS payment_date, o.status AS status FROM dtb_products_class pc, dtb_order_detail od, dtb_order o WHERE o.customer_id = ? AND o.order_id = ? AND pc.product_id = ? AND pc.product_class_id = ? AND (SELECT IF((SELECT d1.downloadable_days_unlimited FROM dtb_baseinfo d1)=1, 1, DATE(NOW()) <= DATE(DATE_ADD(dtb_order.payment_date, INTERVAL (SELECT downloadable_days FROM dtb_baseinfo) DAY)))) = 1

MDB2 Error: no such field

_doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_6f00b60c53d268ffbbe7fff1cf152a69345a7b4ea FROM 'SELECT pc.product_id AS product_id, pc.product_class_id AS product_class_id, pc.down_realfilename AS down_realfilename, pc.down_filename AS down_filename, o.order_id AS order_id, o.customer_id AS customer_id, o.payment_date AS payment_date, o.status AS status FROM dtb_products_class pc, dtb_order_detail od, dtb_order o WHERE o.customer_id = ? AND o.order_id = ? AND pc.product_id = ? AND pc.product_class_id = ? AND (SELECT IF((SELECT d1.downloadable_days_unlimited FROM dtb_baseinfo d1)=1, 1, DATE(NOW()) <= DATE(DATE_ADD(dtb_order.payment_date, INTERVAL (SELECT downloadable_days FROM dtb_baseinfo) DAY)))) = 1 ']
[Native code: 1054]
[Native message: Unknown column 'dtb_order.payment_date' in 'field list']


}}}

PostgreSQL

{{{
USER_AGENT: Mozilla/5.0 (Windows; U; Windows NT 6.1; ja; rv:1.9.2.13) Gecko/20101203 Firefox/3.6.13

SQL: SELECT             pc.product_id AS product_id,
            pc.product_class_id AS product_class_id,
            pc.down_realfilename AS down_realfilename,
            pc.down_filename AS down_filename,
            o.order_id AS order_id,
            o.customer_id AS customer_id,
            o.payment_date AS payment_date,
            o.status AS status FROM             dtb_products_class pc,
            dtb_order_detail od,
            dtb_order o WHERE o.customer_id = ? AND o.order_id = ? AND pc.product_id = ? AND pc.product_class_id = ? AND (SELECT CASE WHEN (SELECT d1.downloadable_days_unlimited FROM dtb_baseinfo d1) = 1 AND dtb_order.payment_date IS NOT NULL THEN 1 WHEN DATE(NOW()) <= DATE(dtb_order.payment_date + '30 days') THEN 1 ELSE 0 END) = 1   

MDB2 Error: unknown error

prepare: [Error message: Unable to create prepared statement handle]
[Last executed query: EXECUTE mdb2_statement_pgsql_6382b2bbeaacaae1dc1e88431c26ed51bca5680d4]
[Native message: ERROR:  invalid reference to FROM-clause entry for table ""dtb_order""
HINT:  Perhaps you meant to reference the table alias ""o"".]
}}}
"	バグ指摘	closed	高	EC-CUBE2.11.0 リファクタリングProject	フロント	2.11.0 β	修正済