Ticket #1048 (closed バグ指摘: 修正済)
[フロント]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
Note: See
TracTickets for help on using
tickets.