バグ報告 > フロント機能 > 検索結果後に価格順に並べ替えようとしたらエラーが発生しました。 |
フロント機能
フラット表示 | 前のトピック | 次のトピック |
投稿者 | スレッド |
---|---|
ゲスト |
投稿日時: 2008/1/7 18:14
対応状況: −−−
|
検索結果後に価格順に並べ替えようとしたらエラーが発生しました。 トップページから商品検索を行い、結果を価格順に並べかえようと
クリックしたところ、下記エラーが表示されました。 どなたか解決法をご存じであれば教えていただきたく、投稿しました。 宜しくお願いします。 http://xxxxx.xxx/products/list.php?mode=search&category_id=&name=&search.x=37&search.y=9 SERVER_ADDR:xxx.xxx.x.xxx REMOTE_ADDR:xx.xx.xxx.xx USER_AGENT:Mozilla/5.0 (Windows; U; Windows NT 5.1; ja; rv:1.8.1.11) Gecko/20071127 Firefox/2.0.0.11 SELECT DISTINCT price02_min, product_id, product_code_min, product_code_max, name, comment1, comment2, comment3, main_list_comment, main_image, main_list_image, price01_min, price01_max, price02_max, stock_min, stock_max, stock_unlimited_min, stock_unlimited_max, point_rate, sale_limit, sale_unlimited, deliv_date_id, deliv_fee, status, product_flag, create_date, del_flg 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 ) AS T1 WHERE del_flg = 0 AND status = 1 ORDER BY price02_min, product_id LIMIT 15 OFFSET 0 DB Error: unknown error SELECT DISTINCT price02_min, product_id, product_code_min, product_code_max, name, comment1, comment2, comment3, main_list_comment, main_image, main_list_image, price01_min, price01_max, price02_max, stock_min, stock_max, stock_unlimited_min, stock_unlimited_max, point_rate, sale_limit, sale_unlimited, deliv_date_id, deliv_fee, status, product_flag, create_date, del_flg 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 ) AS T1 WHERE del_flg = 0 AND status = 1 ORDER BY price02_min, product_id LIMIT 15 OFFSET 0 [nativecode=1037 ** Out of memory; restart server and try again (needed 65528 bytes)] /contents/www/xxxx.xxx/htdocs/products/list.php 34:LC_Page_Products_List_Ex->process /contents/www/xxxx.xxx/htdocs/data/class_extends/page_extends/products/LC_Page_Products_List_Ex.php 56:LC_Page_Products_List->process /contents/www/xxxx.xxx/htdocs/data/class/pages/products/LC_Page_Products_List.php 127:LC_Page_Products_List->lfDispProductsList /contents/www/xxxx.xxx/htdocs/data/class/pages/products/LC_Page_Products_List.php 475:SC_Query->select /contents/www/xxxx.xxx/htdocs/data/class/SC_Query.php 67:SC_DbConn->getAll /contents/www/xxxx.xxx/htdocs/data/class/SC_DbConn.php 158:DB_common->getAll /contents/www/xxxx.xxx/htdocs/data/module/DB/common.php 1613:DB_common->query /contents/www/xxxx.xxx/htdocs/data/module/DB/common.php 1167:DB_mysql->simpleQuery /contents/www/xxxx.xxx/htdocs/data/module/DB/mysql.php 324:DB_mysql->mysqlRaiseError /contents/www/xxxx.xxx/htdocs/data/module/DB/mysql.php 894:DB_common->raiseError /contents/www/xxxx.xxx/htdocs/data/module/DB/common.php 1853:PEAR->raiseError /contents/www/xxxx.xxx/htdocs/data/module/PEAR.php 557:DB_Error->DB_Error /contents/www/xxxx.xxx/htdocs/data/module/DB.php 893:PEAR_Error->PEAR_Error 環境は EC-CUBEバージョン 2.0.1 PHPバージョン PHP 5.2.3 DBバージョン MySQL 5.0.45 |
|
フラット表示 | 前のトピック | 次のトピック |
題名 | 投稿者 | 日時 |
---|---|---|
» 検索結果後に価格順に並べ替えようとしたらエラーが発生しました。 | ゲスト | 2008/1/7 18:14 |
Re: 検索結果後に価格順に並べ替えようとしたらエラーが発生しました。 | apogee | 2008/1/7 18:55 |
Re: 検索結果後に価格順に並べ替えようとしたらエラーが発生しました。 | ゲスト | 2008/1/7 21:42 |