バグ報告 > フロント機能 > ECCUBE-2.0.0-BETAでエラー |
フロント機能
スレッド表示 | 古いものから | 前のトピック | 次のトピック | 下へ |
投稿者 | スレッド |
---|---|
ゲスト |
投稿日時: 2007/11/15 9:01
対応状況: −−−
|
Re: ECCUBE-2.0.0-BETAでエラー すみません。削除してください・・・
変なリンクになってしまいました。 |
|
ゲスト |
投稿日時: 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 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を使用しています。 |
|
スレッド表示 | 古いものから | 前のトピック | 次のトピック | トップ |