バージョン選択

フォーラム

メニュー

オンライン状況

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

サイト内検索

バグ報告 > 管理機能 > 規格登録ボタンでシステムエラー

管理機能

新規スレッドを追加する

スレッド表示 | 新しいものから 前のトピック | 次のトピック | 下へ
投稿者 スレッド
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: 規格登録ボタンでシステムエラー
すみません、自己解決しました・・・。
スレッド表示 | 新しいものから 前のトピック | 次のトピック | トップ


 



ログイン


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

統計情報

総メンバー数は89,089名です
総投稿数は110,033件です

投稿数ランキング

1
seasoft
7367
2
468
3217
3
AMUAMU
2712
4
nanasess
2314
5
umebius
2085
6
yuh
1819
7
h_tanaka
1649
8
red
1570
9
mcontact
1297
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.