バージョン選択

フォーラム

メニュー

オンライン状況

88 人のユーザが現在オンラインです。 (71 人のユーザが フォーラム を参照しています。)
登録ユーザ: 0
ゲスト: 88
もっと...

サイト内検索

質問 > 管理機能 > 商品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
-----------------------------------

フラット表示 前のトピック | 次のトピック


題名 投稿者 日時
 » 商品ID及び規格IDの重複について ishibo 2009/5/27 22:50
     Re: 商品ID及び規格IDの重複について seasoft 2009/5/28 0:17
       Re: 商品ID及び規格IDの重複について ishibo 2009/5/28 0:52
         Re: 商品ID及び規格IDの重複について seasoft 2009/5/28 1:06
           Re: 商品ID及び規格IDの重複について ishibo 2009/5/28 3:00
             Re: 商品ID及び規格IDの重複について seasoft 2009/5/28 3:41
               Re: 商品ID及び規格IDの重複について ishibo 2009/5/28 5:29
                 Re: 商品ID及び規格IDの重複について seasoft 2009/5/28 11:09

 



ログイン


EC-CUBE公式 Amazon Payプラグイン

統計情報

総メンバー数は90,294名です
総投稿数は110,364件です

投稿数ランキング

1
seasoft
7369
2
468
3217
3
AMUAMU
2712
4
nanasess
2314
5
umebius
2085
6
yuh
1819
7
h_tanaka
1693
8
red
1571
9
mcontact
1357
10
tsuji
958
11
fukap
907
12
shutta
835
13
tao_s
799
14 ramrun 789
15 karin 689
16 sumida 641
17
homan
633
18 DELIGHT 572
19
patapata
502
20
flealog
485


ネットショップの壺

EC-CUBEインテグレートパートナー

Copyright© EC-CUBE CO.,LTD. All Rights Reserved.