質問 > その他 > 商品詳細ページのエラーについて。 |
その他
フラット表示 | 前のトピック | 次のトピック |
投稿者 | スレッド |
---|---|
aria |
投稿日時: 2012/6/9 17:45
対応状況: −−−
|
半人前 登録日: 2012/4/24 居住地: 投稿: 22 |
商品詳細ページのエラーについて。 ▼▼▼ デバッグ情報ここから ▼▼▼
http://ariacompany-since2010.com/shop/products/detail.php?product_id=60?product_id=60 SERVER_ADDR: 172.17.0.97 REMOTE_ADDR: 116.82.238.63 USER_AGENT: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_7_4) AppleWebKit/536.5 (KHTML, like Gecko) Chrome/19.0.1084.54 Safari/536.5 Fatal error(E_USER_ERROR): DB処理でエラーが発生しました。 SQL: [SELECT T1.product_id, T1.stock, T1.stock_unlimited, T1.sale_limit, T1.price01, T1.price02, T1.point_rate, T1.product_code, T1.product_class_id, T1.del_flg, T1.product_type_id, T1.down_filename, T1.down_realfilename, T3.name AS classcategory_name1, T3.rank AS rank1, T4.name AS class_name1, T4.class_id AS class_id1, T1.classcategory_id1, T1.classcategory_id2, dtb_classcategory2.name AS classcategory_name2, dtb_classcategory2.rank AS rank2, dtb_class2.name AS class_name2, dtb_class2.class_id AS class_id2 FROM dtb_products_class T1 LEFT JOIN dtb_classcategory T3 ON T1.classcategory_id1 = T3.classcategory_id LEFT JOIN dtb_class T4 ON T3.class_id = T4.class_id LEFT JOIN dtb_classcategory dtb_classcategory2 ON T1.classcategory_id2 = dtb_classcategory2.classcategory_id LEFT JOIN dtb_class dtb_class2 ON dtb_classcategory2.class_id = dtb_class2.class_id WHERE product_id IN (?) AND T1.del_flg = 0 ORDER BY T3.rank DESC ] MDB2 Error: no such field _doQuery: [Error message: Could not execute statement] [Last executed query: PREPARE mdb2_statement_mysql_9d5fe1161a31202d81e70580672c588796873c03f FROM 'SELECT T1.product_id, T1.stock, T1.stock_unlimited, T1.sale_limit, T1.price01, T1.price02, T1.point_rate, T1.product_code, T1.product_class_id, T1.del_flg, T1.product_type_id, T1.down_filename, T1.down_realfilename, T3.name AS classcategory_name1, T3.rank AS rank1, T4.name AS class_name1, T4.class_id AS class_id1, T1.classcategory_id1, T1.classcategory_id2, dtb_classcategory2.name AS classcategory_name2, dtb_classcategory2.rank AS rank2, dtb_class2.name AS class_name2, dtb_class2.class_id AS class_id2 FROM dtb_products_class T1 LEFT JOIN dtb_classcategory T3 ON T1.classcategory_id1 = T3.classcategory_id LEFT JOIN dtb_class T4 ON T3.class_id = T4.class_id LEFT JOIN dtb_classcategory dtb_classcategory2 ON T1.classcategory_id2 = dtb_classcategory2.classcategory_id LEFT JOIN dtb_class dtb_class2 ON dtb_classcategory2.class_id = dtb_class2.class_id WHERE product_id IN (?) AND T1.del_flg = 0 ORDER BY T3.rank DESC '] [Native code: 1054] [Native message: Unknown column 'T1.classcategory_id1' in 'field list'] on [/home/users/1/lolipop.jp-4144c1062bbbea16/web/data/class/SC_Query.php(1005)] /home/users/1/lolipop.jp-4144c1062bbbea16/web/shop/products/detail.php(34): LC_Page_Products_Detail_Ex->process /home/users/1/lolipop.jp-4144c1062bbbea16/web/data/class_extends/page_extends/products/LC_Page_Products_Detail_Ex.php(56): LC_Page_Products_Detail->process /home/users/1/lolipop.jp-4144c1062bbbea16/web/data/class/pages/products/LC_Page_Products_Detail.php(84): LC_Page_Products_Detail->action /home/users/1/lolipop.jp-4144c1062bbbea16/web/data/class/pages/products/LC_Page_Products_Detail.php(112): SC_Product->setProductsClassByProductIds /home/users/1/lolipop.jp-4144c1062bbbea16/web/data/class/SC_Product.php(250): SC_Product->getProductsClassFullByProductId /home/users/1/lolipop.jp-4144c1062bbbea16/web/data/class/SC_Product.php(437): SC_Product->getProductsClassByProductIds /home/users/1/lolipop.jp-4144c1062bbbea16/web/data/class/SC_Product.php(426): SC_Product->getProductsClassByQuery /home/users/1/lolipop.jp-4144c1062bbbea16/web/data/class/SC_Product.php(389): SC_Query->select /home/users/1/lolipop.jp-4144c1062bbbea16/web/data/class/SC_Query.php(164): SC_Query->getAll /home/users/1/lolipop.jp-4144c1062bbbea16/web/data/class/SC_Query.php(276): SC_Query->prepare /home/users/1/lolipop.jp-4144c1062bbbea16/web/data/class/SC_Query.php(946): SC_Query->error /home/users/1/lolipop.jp-4144c1062bbbea16/web/data/class/SC_Query.php(1005): trigger_error ▲▲▲ デバッグ情報ここまで ▲▲▲ 商品詳細ページにアクセスしようとすると上記のようなエラーが出てしまいます。 これはどのようにして解決出来るのでしょうか? ご教授お願い致します。 ------------------------------------------------------------------------------------------ [EC-CUBE] 2.11.5(2.11.4>2.11.5へアップデート) [レンタルサーバ] ロリポップ [OS] MAC OS X [PHP] PHP 5.2.17 [データベース] MySQL 5.1.59-community-log [WEBサーバ] Apache ------------------------------------------------------------------------------------------ |
フラット表示 | 前のトピック | 次のトピック |
題名 | 投稿者 | 日時 |
---|---|---|
» 商品詳細ページのエラーについて。 | aria | 2012/6/9 17:45 |
Re: 商品詳細ページのエラーについて。 | seasoft | 2012/6/9 18:11 |
Re: 商品詳細ページのエラーについて。 | aria | 2012/6/9 19:58 |
Re: 商品詳細ページのエラーについて。 | seasoft | 2012/6/9 20:26 |