バグ報告 > 管理機能 > 規格登録ボタンでシステムエラー |
管理機能
スレッド表示 | 新しいものから | 前のトピック | 次のトピック | 下へ |
投稿者 | スレッド |
---|---|
tmn |
投稿日時: 2009/11/2 19:45
対応状況: −−−
|
半人前 登録日: 2009/9/8 居住地: 投稿: 11 |
規格登録ボタンでシステムエラー ------------------------------------------------------------------------------------------
[EC-CUBE] 2.4.1 [レンタルサーバ] WADAX [PHP] 5.2.11 [データベース] MySQL 4.1.22 [現象] 管理画面の商品マスタにおいて検索後【規格】ボタンを押すとシステムエラーが発生 ------------------------------------------------------------------------------------------ 上記現象が発生しました。 商品登録に関しては複数のカスタマイズを行っているため、原因の切り分けに苦慮しております。 以下のエラーメッセージが出ているのですが、以前カスタマイズの際に作成した「deliv」カラムは現在DB上から削除しています(使用しなかったため)。 商品の登録は正常に行えております。 何かお気づきの点がありましたらご教授ください。 SELECT class_id1, class_id2, name1, name2, rank1, rank2, product_class_id, product_id, T1_classcategory_id AS classcategory_id1, T2_classcategory_id AS classcategory_id2, product_code, stock, stock_unlimited, sale_limit, price01, price02, status, deliv FROM ( SELECT T1.class_id AS class_id1, T2.class_id AS class_id2, T1.classcategory_id AS T1_classcategory_id, T2.classcategory_id AS T2_classcategory_id, T1.name AS name1, T2.name AS name2, T1.rank AS rank1, T2.rank AS rank2 FROM dtb_classcategory AS T1, dtb_classcategory AS T2 WHERE T1.class_id IN (SELECT class_id1 FROM (SELECT T1.class_id1, T1.class_id2, T1.classcategory_id1, T1.classcategory_id2, T2.product_id, T1.name1, T1.name2, T2.product_code, T2.stock, T2.price01, T2.price02, T1.rank1, T1.rank2 FROM (SELECT T1.class_id AS class_id1, T2.class_id AS class_id2, T1.classcategory_id AS classcategory_id1, T2.classcategory_id AS classcategory_id2, T1.name AS name1, T2.name AS name2, T1.rank AS rank1, T2.rank AS rank2 FROM dtb_classcategory AS T1, dtb_classcategory AS T2 ) AS T1 LEFT JOIN dtb_products_class AS T2 ON T1.classcategory_id1 = T2.classcategory_id1 AND T1.classcategory_id2 = T2.classcategory_id2) AS crs_prd WHERE product_id = ? GROUP BY class_id1, class_id2) AND T2.class_id IN (SELECT class_id2 FROM (SELECT T1.class_id1, T1.class_id2, T1.classcategory_id1, T1.classcategory_id2, T2.product_id, T1.name1, T1.name2, T2.product_code, T2.stock, T2.price01, T2.price02, T1.rank1, T1.rank2 FROM (SELECT T1.class_id AS class_id1, T2.class_id AS class_id2, T1.classcategory_id AS classcategory_id1, T2.classcategory_id AS classcategory_id2, T1.name AS name1, T2.name AS name2, T1.rank AS rank1, T2.rank AS rank2 FROM dtb_classcategory AS T1, dtb_classcategory AS T2 ) AS T1 LEFT JOIN dtb_products_class AS T2 ON T1.classcategory_id1 = T2.classcategory_id1 AND T1.classcategory_id2 = T2.classcategory_id2) AS crs_prd WHERE product_id = ? GROUP BY class_id1, class_id2)) AS T1 LEFT JOIN (SELECT * FROM dtb_products_class WHERE product_id = ?) AS T3 ON T1_classcategory_id = T3.classcategory_id1 AND T2_classcategory_id = T3.classcategory_id2 ORDER BY rank1 DESC, rank2 DESC DB Error: no such field SELECT class_id1, class_id2, name1, name2, rank1, rank2, product_class_id, product_id, T1_classcategory_id AS classcategory_id1, T2_classcategory_id AS classcategory_id2, product_code, stock, stock_unlimited, sale_limit, price01, price02, status, deliv FROM ( SELECT T1.class_id AS class_id1, T2.class_id AS class_id2, T1.classcategory_id AS T1_classcategory_id, T2.classcategory_id AS T2_classcategory_id, T1.name AS name1, T2.name AS name2, T1.rank AS rank1, T2.rank AS rank2 FROM dtb_classcategory AS T1, dtb_classcategory AS T2 WHERE T1.class_id IN (SELECT class_id1 FROM (SELECT T1.class_id1, T1.class_id2, T1.classcategory_id1, T1.classcategory_id2, T2.product_id, T1.name1, T1.name2, T2.product_code, T2.stock, T2.price01, T2.price02, T1.rank1, T1.rank2 FROM (SELECT T1.class_id AS class_id1, T2.class_id AS class_id2, T1.classcategory_id AS classcategory_id1, T2.classcategory_id AS classcategory_id2, T1.name AS name1, T2.name AS name2, T1.rank AS rank1, T2.rank AS rank2 FROM dtb_classcategory AS T1, dtb_classcategory AS T2 ) AS T1 LEFT JOIN dtb_products_class AS T2 ON T1.classcategory_id1 = T2.classcategory_id1 AND T1.classcategory_id2 = T2.classcategory_id2) AS crs_prd WHERE product_id = '21' GROUP BY class_id1, class_id2) AND T2.class_id IN (SELECT class_id2 FROM (SELECT T1.class_id1, T1.class_id2, T1.classcategory_id1, T1.classcategory_id2, T2.product_id, T1.name1, T1.name2, T2.product_code, T2.stock, T2.price01, T2.price02, T1.rank1, T1.rank2 FROM (SELECT T1.class_id AS class_id1, T2.class_id AS class_id2, T1.classcategory_id AS classcategory_id1, T2.classcategory_id AS classcategory_id2, T1.name AS name1, T2.name AS name2, T1.rank AS rank1, T2.rank AS rank2 FROM dtb_classcategory AS T1, dtb_classcategory AS T2 ) AS T1 LEFT JOIN dtb_products_class AS T2 ON T1.classcategory_id1 = T2.classcategory_id1 AND T1.classcategory_id2 = T2.classcategory_id2) AS crs_prd WHERE product_id = '21' GROUP BY class_id1, class_id2)) AS T1 LEFT JOIN (SELECT * FROM dtb_products_class WHERE product_id = '21') AS T3 ON T1_classcategory_id = T3.classcategory_id1 AND T2_classcategory_id = T3.classcategory_id2 ORDER BY rank1 DESC, rank2 DESC [nativecode=1054 ** Unknown column 'deliv' in 'field list'] public_html/admin/products/product_class.php 34:LC_Page_Admin_Products_ProductClass_Ex->process data/class_extends/page_extends/admin/products/LC_Page_Admin_Products_ProductClass_Ex.php 56:LC_Page_Admin_Products_ProductClass->process data/class/pages/admin/products/LC_Page_Admin_Products_ProductClass.php 128:LC_Page_Admin_Products_ProductClass->lfGetClassCatListEdit data/class/pages/admin/products/LC_Page_Admin_Products_ProductClass.php 300:SC_Query->getall data/class/SC_Query.php 156:SC_DbConn->getAll data/class/SC_DbConn.php 161:DB_common->getAll data/module/DB/common.php 1610:DB_common->execute data/module/DB/common.php 959:DB_mysql->simpleQuery data/module/DB/mysql.php 324:DB_mysql->mysqlRaiseError data/module/DB/mysql.php 894:DB_common->raiseError data/module/DB/common.php 1853:PEAR->raiseError data/module/PEAR.php 557:DB_Error->DB_Error data/module/DB.php 893:PEAR_Error->PEAR_Error |
tmn |
投稿日時: 2009/11/2 20:02
対応状況: 解決済
|
半人前 登録日: 2009/9/8 居住地: 投稿: 11 |
Re: 規格登録ボタンでシステムエラー すみません、自己解決しました・・・。
|
スレッド表示 | 新しいものから | 前のトピック | 次のトピック | トップ |