[フロント]MYページ：ダウンロード商品をダウンロードでDBエラー

[kotani]

ダウンロード商品を購入し、受注ステータスが「入金済み」の状態で、
MYページ＞購入履歴詳細＞「ダウンロード」リンクをクリック

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".]

[shutta]

r20358 で修正しました。