注文履歴詳細にて下記エラーが発生するようです。
FATAL Error(256) /home/eccube/ec25d/data/class/SC_Query.php:762 https://****/ec25d/mypage/history.php?order_id=1
SERVER_ADDR: *****
REMOTE_ADDR: ****
USER_AGENT: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/534.7 (KHTML, like Gecko) Chrome/7.0.517.44 Safari/534.7
SQL: SELECT od.product_id AS product_id, od.product_code AS product_code, od.product_name AS product_name, od.classcategory_name1 AS classcategory_name1,od.classcategory_name2 AS classcategory_name2, od.price AS price, od.quantity AS quantity, od.point_rate AS point_rate,CASE WHEN EXISTS(SELECT * FROM dtb_products WHERE product_id = od.product_id AND del_flg = 0 AND status = 1) THEN '1' ELSE '0' END AS enable,o.status AS status, pc.down AS down, o.payment_date AS payment_date, od.product_class_id as product_class_id, (SELECT CASE WHEN (SELECT d1.downloadable_days_unlimited FROM dtb_baseinfo d1) = 1 AND o.payment_date IS NOT NULL THEN 1 WHEN DATE(NOW()) <= DATE(o.payment_date + '30 days') THEN 1 ELSE 0 END) AS effective FROM dtb_products p, dtb_products_class pc, dtb_order_detail od, dtb_order o WHERE p.product_id = od.product_id AND pc.product_id = od.product_id AND pc.product_class_id = od.product_class_id AND od.order_id = o.order_id AND od.order_id = ?
MDB2 Error: no such field
prepare: [Error message: Unable to create prepared statement handle]
[Last executed query: EXECUTE mdb2_statement_pgsql_130748140673193995de03b388953b42f9771eb858 ('1')]
[Native message: ERROR: column pc.down does not exist
LINE 1: ...EN '1' ELSE '0' END AS enable,o.status AS status, pc.down AS...
^]
/home/eccube/ec25d/html/mypage/history.php 34:LC_Page_Mypage_History_Ex->process
/home/eccube/ec25d/data/class_extends/page_extends/mypage/LC_Page_Mypage_History_Ex.php 56:LC_Page_Mypage_History->process
/home/eccube/ec25d/data/class/pages/mypage/LC_Page_Mypage_History.php 106:LC_Page_Mypage_History->lfGetOrderDetail
/home/eccube/ec25d/data/class/pages/mypage/LC_Page_Mypage_History.php 233:SC_Query->select
/home/eccube/ec25d/data/class/SC_Query.php 143:SC_Query->getAll
/home/eccube/ec25d/data/class/SC_Query.php 222:SC_Query->prepare
/home/eccube/ec25d/data/class/SC_Query.php 759:MDB2_Driver_pgsql->prepare
/home/eccube/ec25d/data/module/MDB2/Driver/pgsql.php 965:MDB2_Driver_Common->raiseError
/home/eccube/ec25d/data/module/MDB2.php 1497:PEAR->raiseError
/home/eccube/ec25d/data/module/PEAR.php 557:MDB2_Error->MDB2_Error
/home/eccube/ec25d/data/module/MDB2.php 1009:PEAR_Error->PEAR_Error
カラム名からの推測で、こちらのスレッドへ投稿させていただきました。
----------------
Seasoft
こちらでの投稿は、アイディア程度に留めさせていただいております。
個別案件の作業は有償で承っております。お気軽にご相談ください。
どうか教えて下さい！
