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

Opened 11 years ago

Last modified 11 years ago

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

Reported by: kotani Owned by: shutta
Priority: Milestone: EC-CUBE2.11.0 リファクタリングProject
Component: フロント Version: 2.11.0 β
Keywords: Cc:
修正済み:

Description

ダウンロード商品を購入し、受注ステータスが「入金済み」の状態で、
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".]

Change History

comment:1 Changed 11 years ago by shutta

  • Owner changed from somebody to shutta
  • Status changed from new to assigned

comment:2 Changed 11 years ago by shutta

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

r20358 で修正しました。

Note: See TracTickets for help on using tickets.