質問 > その他 > 商品毎に規格を設定しようとするとエラー |
その他
スレッド表示 | 新しいものから | 前のトピック | 次のトピック | 下へ |
投稿者 | スレッド |
---|---|
kae |
投稿日時: 2015/10/2 22:03
対応状況: −−−
|
常連 登録日: 2013/5/10 居住地: 投稿: 35 |
商品毎に規格を設定しようとするとエラー 規格の登録は完了しているのに、商品毎に規格を登録しようとするとエラーが出ます。
何がいけないのでしょうか? ご指導お願いいたします。 EC-CUBEバージョン 2.13.3 PHPバージョン PHP 5.3.15 DBバージョン MySQL 5.6.23-log ▼▼▼ デバッグ情報ここから ▼▼▼ 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, T1.plg_remiseautocharge_total, T1.plg_remiseautocharge_first_interval, T1.plg_remiseautocharge_next_date, T1.plg_remiseautocharge_interval, T1.plg_remiseautocharge_refusal_not_allow, 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, dtb_classcategory2.rank DESC ] MDB2 Error: no such field _doQuery: [Error message: Could not execute statement] [Last executed query: PREPARE mdb2_statement_mysql_178c991125acc19c57ed6daa6352db7f39f45a50b4 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, T1.plg_remiseautocharge_total, T1.plg_remiseautocharge_first_interval, T1.plg_remiseautocharge_next_date, T1.plg_remiseautocharge_interval, T1.plg_remiseautocharge_refusal_not_allow, 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, dtb_classcategory2.rank DESC '] [Native code: 1054] [Native message: Unknown column 'T1.plg_remiseautocharge_total' in 'field list'] on [/home/users/2/sub.jp-inaminosato/web/shop/data/class/SC_Query.php(1095)] /home/users/2/sub.jp-inaminosato/web/shop/miyakoya/products/product_class.php(29): LC_Page_Admin_Products_ProductClass_Ex->process /home/users/2/sub.jp-inaminosato/web/shop/data/class_extends/page_extends/admin/products/LC_Page_Admin_Products_ProductClass_Ex.php(79): LC_Page_Admin_Products_ProductClass->process /home/users/2/sub.jp-inaminosato/web/shop/data/class/pages/admin/products/LC_Page_Admin_Products_ProductClass.php(61): LC_Page_Admin_Products_ProductClass_Ex->action /home/users/2/sub.jp-inaminosato/web/shop/data/class_extends/page_extends/admin/products/LC_Page_Admin_Products_ProductClass_Ex.php(140): LC_Page_Admin_Products_ProductClass_Ex->doPreEdit_AC /home/users/2/sub.jp-inaminosato/web/shop/data/class_extends/page_extends/admin/products/LC_Page_Admin_Products_ProductClass_Ex.php(220): LC_Page_Admin_Products_ProductClass_Ex->getProductsClassFullByProductId_AC /home/users/2/sub.jp-inaminosato/web/shop/data/class_extends/page_extends/admin/products/LC_Page_Admin_Products_ProductClass_Ex.php(526): LC_Page_Admin_Products_ProductClass_Ex->getProductsClassByProductIds_AC /home/users/2/sub.jp-inaminosato/web/shop/data/class_extends/page_extends/admin/products/LC_Page_Admin_Products_ProductClass_Ex.php(515): LC_Page_Admin_Products_ProductClass_Ex->getProductsClassByQuery_AC /home/users/2/sub.jp-inaminosato/web/shop/data/class_extends/page_extends/admin/products/LC_Page_Admin_Products_ProductClass_Ex.php(478): SC_Query->select /home/users/2/sub.jp-inaminosato/web/shop/data/class/SC_Query.php(176): SC_Query->getAll /home/users/2/sub.jp-inaminosato/web/shop/data/class/SC_Query.php(304): SC_Query->prepare /home/users/2/sub.jp-inaminosato/web/shop/data/class/SC_Query.php(1024): SC_Query->error /home/users/2/sub.jp-inaminosato/web/shop/data/class/SC_Query.php(1095): trigger_error ▲▲▲ デバッグ情報ここまで ▲▲▲ |
yuh |
投稿日時: 2015/10/2 22:21
対応状況: −−−
|
神 登録日: 2013/1/9 居住地: 大阪 投稿: 1818 |
Re: 商品毎に規格を設定しようとするとエラー なんかのプラグインがうまくインストールされてないですね。
|
スレッド表示 | 新しいものから | 前のトピック | 次のトピック | トップ |