バージョン選択

フォーラム

メニュー

オンライン状況

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

サイト内検索

バグ報告 > フロント機能 > ECCUBE-2.0.0-BETAでエラー

フロント機能

新規スレッドを追加する

スレッド表示 | 新しいものから 前のトピック | 次のトピック | 下へ
投稿者 スレッド
ゲスト
投稿日時: 2007/11/15 8:50
対応状況: −−−
ECCUBE-2.0.0-BETAでエラー
2.0.0−betaでエラーがでています。
商品一覧ページの価格順・新着順に並べるリンクを押すとエラーになります。
アドバイスお願いします。

ECCUBE-2.0.0-BETA
PHP 4.4.4
MYSQL 4.1.11
ラピッドサイトVPSを使用しています。
ゲスト
投稿日時: 2007/11/15 8:59
対応状況: −−−
Re: ECCUBE-2.0.0-BETAでエラー
すみません補足です。
以下のようなページになっています。

http://xxxxx.com/html/products/list.php?category_id=1

SELECT DISTINCT ON (price02_min, product_id) * FROM (SELECT T1.product_id, product_code_min, product_code_max, price01_min, price01_max, price02_min, price02_max, stock_min, stock_max, stock_unlimited_min, stock_unlimited_max, del_flg, status, name, comment1, comment2, comment3, main_list_comment, main_image, main_list_image, product_flag, deliv_date_id, sale_limit, point_rate, sale_unlimited, create_date, deliv_fee, rank ,(SELECT rank AS category_rank FROM dtb_category AS T4 WHERE T1.category_id = T4.category_id) as category_rank ,(SELECT category_id AS sub_category_id FROM dtb_category T4 WHERE T1.category_id = T4.category_id) as category_id FROM (SELECT T0.product_id, T0.del_flg, T0.status, T0.name, T0.comment1, T0.comment2, T0.comment3, T0.main_list_comment, T0.main_image, T0.main_list_image, T0.product_flag, T0.deliv_date_id, T0.sale_limit, T0.point_rate, T0.sale_unlimited, T0.create_date, T0.deliv_fee, T00.category_id, T00.rank FROM dtb_products AS T0 LEFT JOIN dtb_product_categories AS T00 USING (product_id)) AS T1 RIGHT JOIN (SELECT product_id as product_id_sub, MIN(product_code) AS product_code_min, MAX(product_code) AS product_code_max, MIN(price01) AS price01_min, MAX(price01) AS price01_max, MIN(price02) AS price02_min, MAX(price02) AS price02_max, MIN(stock) AS stock_min, MAX(stock) AS stock_max, MIN(stock_unlimited) AS stock_unlimited_min, MAX(stock_unlimited) AS stock_unlimited_max FROM dtb_products_class GROUP BY product_id) AS T2 ON T1.product_id = T2.product_id_sub ) WHERE del_flg = 0 AND status = 1 AND category_id IN ( ?,? ,? ,? ) ORDER BY price02_min ASC, product_id ASC LIMIT 15 OFFSET 0
DB Error: syntax error

SELECT DISTINCT ON (price02_min, product_id) * FROM (SELECT T1.product_id, product_code_min, product_code_max, price01_min, price01_max, price02_min, price02_max, stock_min, stock_max, stock_unlimited_min, stock_unlimited_max, del_flg, status, name, comment1, comment2, comment3, main_list_comment, main_image, main_list_image, product_flag, deliv_date_id, sale_limit, point_rate, sale_unlimited, create_date, deliv_fee, rank ,(SELECT rank AS category_rank FROM dtb_category AS T4 WHERE T1.category_id = T4.category_id) as category_rank ,(SELECT category_id AS sub_category_id FROM dtb_category T4 WHERE T1.category_id = T4.category_id) as category_id FROM (SELECT T0.product_id, T0.del_flg, T0.status, T0.name, T0.comment1, T0.comment2, T0.comment3, T0.main_list_comment, T0.main_image, T0.main_list_image, T0.product_flag, T0.deliv_date_id, T0.sale_limit, T0.point_rate, T0.sale_unlimited, T0.create_date, T0.deliv_fee, T00.category_id, T00.rank FROM dtb_products AS T0 LEFT JOIN dtb_product_categories AS T00 USING (product_id)) AS T1 RIGHT JOIN (SELECT product_id as product_id_sub, MIN(product_code) AS product_code_min, MAX(product_code) AS product_code_max, MIN(price01) AS price01_min, MAX(price01) AS price01_max, MIN(price02) AS price02_min, MAX(price02) AS price02_max, MIN(stock) AS stock_min, MAX(stock) AS stock_max, MIN(stock_unlimited) AS stock_unlimited_min, MAX(stock_unlimited) AS stock_unlimited_max FROM dtb_products_class GROUP BY product_id) AS T2 ON T1.product_id = T2.product_id_sub ) WHERE del_flg = 0 AND status = 1 AND category_id IN ( 1,'3' ,'4' ,'5' ) ORDER BY price02_min ASC, product_id ASC LIMIT 15 OFFSET 0 [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 'ON (price02_min, product_id) * FROM (SELECT T1.product_id, produc' at line 1]

/www/xxx.com/html/products/list.php 34:lc_page_products_list_ex->process
/www/xxx.com/data/class_extends/page_extends/products/LC_Page_Products_List_Ex.php 56:lc_page_products_list->process
/www/xxx.com/data/class/pages/products/LC_Page_Products_List.php 127:lc_page_products_list_ex->lfdispproductslist
/www/xxx.com/data/class/pages/products/LC_Page_Products_List.php 465:sc_query->select
/www/xxx.com/data/class/SC_Query.php 67:sc_dbconn->getall
/www/xxx.com/data/class/SC_DbConn.php 156:db_mysql->getall
/www/xxx.com/data/module/DB/common.php 1610:db_mysql->execute
/www/xxx.com/data/module/DB/common.php 959:db_mysql->simplequery
/www/xxx.com/data/module/DB/mysql.php 324:db_mysql->mysqlraiseerror
/www/xxx.com/data/module/DB/mysql.php 894:db_mysql->raiseerror
/www/xxx.com/data/module/DB/common.php 1853:pear->raiseerror
/www/xxx.com/data/module/PEAR.php 557:db_error->db_error
/www/xxx.com/data/module/DB.php 893:db_error->pear_error

ゲスト
投稿日時: 2007/11/15 9:01
対応状況: −−−
Re: ECCUBE-2.0.0-BETAでエラー
すみません。削除してください・・・
変なリンクになってしまいました。
スレッド表示 | 新しいものから 前のトピック | 次のトピック | トップ


 



ログイン



統計情報

総メンバー数は75,086名です
総投稿数は104,359件です

投稿数ランキング

1
seasoft
7333
2
468
3217
3
AMUAMU
2712
4
nanasess
2202
5
umebius
2085
6
yuh
1664
7
red
1535
8
h_tanaka
1189
9
tsuji
942
10
fukap
907
11
shutta
835
12
tao_s
794
13 ramrun 789
14 karin 689
15 sumida 641
16
homan
633
17 DELIGHT 572
18
patapata
502
19
flealog
485
20 tonton 437
Copyright© EC-CUBE CO.,LTD. All Rights Reserved.