質問 > 管理機能 > 商品ID及び規格IDの重複について |
管理機能
フラット表示 | 前のトピック | 次のトピック |
投稿者 | スレッド |
---|---|
ishibo |
投稿日時: 2009/5/27 22:50
対応状況: −−−
|
常連 ![]() ![]() 登録日: 2008/5/24 居住地: 北海道 投稿: 33 |
商品ID及び規格IDの重複について Var2.3.4を使用しており、商品登録後に規格登録を行うと規格IDが商品IDと重複してしまい管理画面から修正が行えなくなる事についてお伺いします。
通常でしたら商品を登録し、自動的にproductIDとclassIDが割り振られ、CSVで表現すると以下のようになると思いますが、 例) "商品ID","規格ID","規格名1","規格名2","商品名"・・・ "1","1","","","アイスクリーム"・・・ "2","2","","","プリン"・・・ これらに規格を設定すると通常?でしたら以下の様になると思います。 "商品ID","規格ID","規格名1","規格名2","商品名"・・・ "1","3","バニラ","","アイスクリーム"・・・ "1","4","抹茶","","アイスクリーム"・・・ "2","5","カスタード","","プリン"・・・ "2","6","マンゴー","","プリン"・・・ ところが、追加で商品を登録した際にCSVで登録を行い管理画面にて規格を登録すると 流れ的にはうまく登録が出来るのですが、一覧CSVをDLして見ると中身が以下の様になります。 実際に行った場合に以下のようになってしまいます。 "1","2","バニラ","","アイスクリーム"・・・ "1","3","抹茶","","アイスクリーム"・・・ "2","4","カスタード","","プリン"・・・ "2","5","マンゴー","","プリン"・・・ "3","6","","","ケーキ"・・・ "4","7","","","ヨーグルト"・・・ "8","8","","","アップルパイ"・・・ "9","9","","","ティラミス"・・・ そして管理画面より商品ID「1」のアイスクリームの規格内容を変更しようとするとエラーが発生し、 「システムエラーが発生しました〜」と表示されログインページへと進みます。 ちなみにエラーログでは、 2009/05/27 22:14:19 [/admin/products/product_class.php] http://www.*****.com/admin/products/product_class.php 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 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, T1.maker, T1.space_info, T1.eco_2005 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, T1.maker, T1.space_info, T1.eco_2005 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 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, T1.maker, T1.space_info, T1.eco_2005 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 = '433' 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, T1.maker, T1.space_info, T1.eco_2005 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 = '433' GROUP BY class_id1, class_id2)) AS T1 LEFT JOIN (SELECT * FROM dtb_products_class WHERE product_id = '433') 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 'T1.maker' in 'field list'] /home/hoge.com/public_html/admin/products/product_class.php 34:LC_Page_Admin_Products_ProductClass_Ex->process /home/hoge.com/data/class_extends/page_extends/admin/products/LC_Page_Admin_Products_ProductClass_Ex.php 56:LC_Page_Admin_Products_ProductClass->process /home/hoge.com/data/class/pages/admin/products/LC_Page_Admin_Products_ProductClass.php 127:LC_Page_Admin_Products_ProductClass->lfGetClassCatListEdit /home/hoge.com/data/class/pages/admin/products/LC_Page_Admin_Products_ProductClass.php 299:SC_Query->getall /home/hoge.com/data/class/SC_Query.php 156:SC_DbConn->getAll /home/hoge.com/data/class/SC_DbConn.php 160:DB_common->getAll /home/hoge.com/data/module/DB/common.php 1610:DB_common->execute /home/hoge.com/data/module/DB/common.php 959:DB_mysql->simpleQuery /home/hoge.com/data/module/DB/mysql.php 324:DB_mysql->mysqlRaiseError /home/hoge.com/data/module/DB/mysql.php 894:DB_common->raiseError /home/hoge.com/data/module/DB/common.php 1853:PEAR->raiseError /home/hoge.com/data/module/PEAR.php 557:DB_Error->DB_Error /home/hoge.com/data/module/DB.php 893:PEAR_Error->PEAR_Error 上記のようなエラーが出ております。(長文で読みづらく申し訳ありません。) インストール後にLC_Page_Admin_Products_ProductClass.phpやLC_Page_Admin_Products_Class.phpなどのファイルに関して、特に変更は行っておりませんが、何か打開策?修正案はありますでしょうか? アドバイス頂ければ幸いですので宜しくお願いいたします。 ----------------------------------- EC-CUBE:var.2.3.4 DB:MySQL 5.0.45 PHP:5.1.6 ----------------------------------- |
フラット表示 | 前のトピック | 次のトピック |
題名 | 投稿者 | 日時 |
---|---|---|
» ![]() |
ishibo | 2009/5/27 22:50 |
![]() |
seasoft | 2009/5/28 0:17 |
![]() |
ishibo | 2009/5/28 0:52 |
![]() |
seasoft | 2009/5/28 1:06 |
![]() |
ishibo | 2009/5/28 3:00 |
![]() |
seasoft | 2009/5/28 3:41 |
![]() |
ishibo | 2009/5/28 5:29 |
![]() |
seasoft | 2009/5/28 11:09 |
![](images/pixel.gif)