バージョン選択

フォーラム

メニュー

オンライン状況

31 人のユーザが現在オンラインです。 (20 人のユーザが フォーラム を参照しています。)
登録ユーザ: 3
ゲスト: 28
piyush23 tattsu lyly もっと...

サイト内検索

質問 > 管理機能 > 商品規格再登録エラー

管理機能

新規スレッドを追加する

スレッド表示 | 新しいものから 前のトピック | 次のトピック | 下へ
投稿者 スレッド
hunterman
投稿日時: 2010/5/26 7:15
対応状況: −−−
一人前
登録日: 2010/3/14
居住地:
投稿: 78
商品規格再登録エラー
[EC-CUBE] V 2.4.3
[レンタルサーバ] infitoPLUS
[OS] Windows XP
[PHP] Version 5.2.9-2
[データベース] Mysql v 5.0.83
[ブラウザ] Firfox バージョン3.6.2

商品マスタで規格を再登録しようとするとシステムエラーが発生して、再登録する事が出来ません。
対策を調べていて、 $sqlval['product_class_id'] = “”;
を追加というものがあったので、
data/class/pages/admin/products/LC_Page_Admin_Products_ProductClass.php

// 既存規格の削除
$where = "product_id = ?";
$objQuery->delete("dtb_products_class", $where, array($product_id));

$cnt = 1;
// すべての規格を登録する。
while($arrList["classcategory_id1:".$cnt] != "") {

$sqlval['product_class_id'] = “”;  ←追加

if($arrList["check:".$cnt] == 1) {
$sqlval = array();
$sqlval['product_id'] = $product_id;
$sqlval['classcategory_id1'] = $arrList["classcategory_id1:".$cnt];
$sqlval['classcategory_id2'] = $arrList["classcategory_id2:".$cnt];
if( strlen($arrList["product_class_id:".$cnt]) > 0 ){
$sqlval['product_class_id'] = $arrList["product_class_id:".$cnt];
}
へ追加したのですが、一向に症状が治らずシステムエラーが発生します。
いったい原因は何でしょうか?どなたか、教えて下さい。
お願いします。
nanasess
投稿日時: 2010/5/27 18:15
対応状況: −−−
登録日: 2006/9/9
居住地:
投稿: 2311
Re: 商品規格再登録エラー
具体的にどんなエラーが発生してシステムエラーになったのでしょうか?
それによっては, 修正方法が異なります.

data/logs/site.log へ出力されていると思います.
hunterman
投稿日時: 2010/5/28 7:28
対応状況: −−−
一人前
登録日: 2010/3/14
居住地:
投稿: 78
Re: 商品規格再登録エラー
nanasessさん、ご返信ありがとうございます。
下記この様にエラーが表示されます。

>data/logs/site.log へ出力されていると思います.

すみません、知識が浅いため上記の内容が見方などよく分かりません、site.log 〜site.log5まで有りましたが、何を示しているのか分かりません。コレは、エラーが出力される場所なのですか?

http://〇〇.com/eccube/html/admin/products/product_class.php

SERVER_ADDR:
REMOTE_ADDR:64.134.243.10
USER_AGENT:Mozilla/5.0 (Windows; U; Windows NT 5.1; ja; rv:1.9.2.3) Gecko/20100401 Firefox/3.6.3 (.NET CLR 3.5.30729)

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
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, T1.size2, ) 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, T1.size2, ) 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: syntax error

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
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, T1.size2, ) AS crs_prd WHERE product_id = '199' 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, T1.size2, ) AS crs_prd WHERE product_id = '199' GROUP BY class_id1, class_id2)) AS T1 LEFT JOIN (SELECT * FROM dtb_products_class WHERE product_id = '199') AS T3 ON T1_classcategory_id = T3.classcategory_id1 AND T2_classcategory_id = T3.classcategory_id2 ORDER BY rank1 DESC, rank2 DESC [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AS crs_prd WHERE product_id = '199' GROUP BY class_id1, class_id2) AND T2.cla' at line 6]

D:\CustomerData\webspaces\webspace_00120487\wwwroot\eccube\html\admin\products\product_class.php 34:LC_Page_Admin_Products_ProductClass_Ex->process
D:\CustomerData\webspaces\webspace_00120487\wwwroot\eccube\data\class_extends\page_extends\admin\products\LC_Page_Admin_Products_ProductClass_Ex.php 56:LC_Page_Admin_Products_ProductClass->process
D:\CustomerData\webspaces\webspace_00120487\wwwroot\eccube\data\class\pages\admin\products\LC_Page_Admin_Products_ProductClass.php 127:LC_Page_Admin_Products_ProductClass->lfGetClassCatListEdit
D:\CustomerData\webspaces\webspace_00120487\wwwroot\eccube\data\class\pages\admin\products\LC_Page_Admin_Products_ProductClass.php 299:SC_Query->getall
D:\CustomerData\webspaces\webspace_00120487\wwwroot\eccube\data\class\SC_Query.php 156:SC_DbConn->getAll
D:\CustomerData\webspaces\webspace_00120487\wwwroot\eccube\data\class\SC_DbConn.php 164:DB_common->getAll
D:\CustomerData\webspaces\webspace_00120487\wwwroot\eccube\data\module\DB\common.php 1610:DB_common->execute
D:\CustomerData\webspaces\webspace_00120487\wwwroot\eccube\data\module\DB\common.php 959:DB_mysql->simpleQuery
D:\CustomerData\webspaces\webspace_00120487\wwwroot\eccube\data\module\DB\mysql.php 324:DB_mysql->mysqlRaiseError
D:\CustomerData\webspaces\webspace_00120487\wwwroot\eccube\data\module\DB\mysql.php 894:DB_common->raiseError
D:\CustomerData\webspaces\webspace_00120487\wwwroot\eccube\data\module\DB\common.php 1853:PEAR->raiseError
D:\CustomerData\webspaces\webspace_00120487\wwwroot\eccube\data\module\PEAR.php 557:DB_Error->DB_Error
D:\CustomerData\webspaces\webspace_00120487\wwwroot\eccube\data\module\DB.php 893:PEAR_Error->PEAR_Error

上のようなエラーがシステムエラー画面に表示されます。
お手数ですが、どのような原因でしょうか?また、解決法など、お教え下されば幸いです。お願いします。
スレッド表示 | 新しいものから 前のトピック | 次のトピック | トップ


 



ログイン


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

統計情報

総メンバー数は88,627名です
総投稿数は109,866件です

投稿数ランキング

1
seasoft
7367
2
468
3217
3
AMUAMU
2712
4
nanasess
2311
5
umebius
2085
6
yuh
1819
7
h_tanaka
1632
8
red
1569
9
mcontact
1259
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.