----------------------------------
[EC-CUBE] 2.4.2正式版
[レンタルサーバ] 自社サーバ
[OS] LedHat5
[PHP] PHP 5.1.6
[データベース] MySQL 5.0.22
[WEBサーバ] apache2.2.3
[ブラウザ] IE8
----------------------------------

お世話になっております。
現在下記の現象が発生して、困っております。

商品管理の商品の編集時、ひとつの商品に対して、複数の関連商品を登録しました。
その状態でCSVダウンロードを行うと上手く出力されるのですが、
複数の商品に対して、複数の関連商品を登録し、CSVダウンロードを実行すると
システムエラーとなってしまいます。

調査を行ったところ、data\class\helper\SC_Helper_CSV.php内のSQL文で構文エラー
となっているようなのですが、原因がつかめません。
なお、カスタマイズは一切行っておりません。

下記にエラーログを記載します。
どなたか教えて下さい。よろしくお願いいたします。

SELECT product_id, product_class_id, classcategory_id1, classcategory_id2, name, status, product_flag, product_code, price01, price02, stock, deliv_fee, point_rate, sale_limit, comment1, comment3, note, main_list_comment, main_list_image, main_comment, main_image, main_large_image, file1, file2, sub_title1, sub_comment1, sub_image1, sub_large_image1, sub_title2, sub_comment2, sub_image2, sub_large_image2, sub_title3, sub_comment3, sub_image3, sub_large_image3, sub_title4, sub_comment4, sub_image4, sub_large_image4, sub_title5, sub_comment5, sub_image5, sub_large_image5, deliv_date_id, (SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1) AS recommend_product_id1, (SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1) AS recommend_comment1, (SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 1) AS recommend_product_id2, (SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 1) AS recommend_comment2, (SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 2) AS recommend_product_id3, (SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 2) AS recommend_comment3, (SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 3) AS recommend_product_id4, (SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 3) AS recommend_comment4, (SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 4) AS recommend_product_id5, (SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 4) AS recommend_comment5, (SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 5) AS recommend_product_id6, (SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 5) AS recommend_comment6 FROM (SELECT * FROM (SELECT T3.product_class_id, T3.product_id AS product_id_sub, classcategory_id1, classcategory_id2, T3.rank AS rank1, T4.rank AS rank2, T3.class_id AS class_id1, T4.class_id AS class_id2, stock, price01, price02, stock_unlimited, product_code FROM ( SELECT T1.product_class_id, T1.product_id, classcategory_id1, classcategory_id2, T2.rank, T2.class_id, stock, price01, price02, stock_unlimited, product_code FROM (dtb_products_class AS T1 LEFT JOIN dtb_classcategory AS T2 ON T1.classcategory_id1 = T2.classcategory_id)) AS T3 LEFT JOIN dtb_classcategory AS T4 ON T3.classcategory_id2 = T4.classcategory_id) AS T5 LEFT JOIN dtb_products AS T6 ON product_id_sub = T6.product_id) AS prdcls WHERE del_flg = 0 ORDER BY update_date DESC, product_id DESC
DB Error: unknown error

SELECT product_id, product_class_id, classcategory_id1, classcategory_id2, name, status, product_flag, product_code, price01, price02, stock, deliv_fee, point_rate, sale_limit, comment1, comment3, note, main_list_comment, main_list_image, main_comment, main_image, main_large_image, file1, file2, sub_title1, sub_comment1, sub_image1, sub_large_image1, sub_title2, sub_comment2, sub_image2, sub_large_image2, sub_title3, sub_comment3, sub_image3, sub_large_image3, sub_title4, sub_comment4, sub_image4, sub_large_image4, sub_title5, sub_comment5, sub_image5, sub_large_image5, deliv_date_id, (SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1) AS recommend_product_id1, (SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1) AS recommend_comment1, (SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 1) AS recommend_product_id2, (SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 1) AS recommend_comment2, (SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 2) AS recommend_product_id3, (SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 2) AS recommend_comment3, (SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 3) AS recommend_product_id4, (SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 3) AS recommend_comment4, (SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 4) AS recommend_product_id5, (SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 4) AS recommend_comment5, (SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 5) AS recommend_product_id6, (SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 5) AS recommend_comment6 FROM (SELECT * FROM (SELECT T3.product_class_id, T3.product_id AS product_id_sub, classcategory_id1, classcategory_id2, T3.rank AS rank1, T4.rank AS rank2, T3.class_id AS class_id1, T4.class_id AS class_id2, stock, price01, price02, stock_unlimited, product_code FROM ( SELECT T1.product_class_id, T1.product_id, classcategory_id1, classcategory_id2, T2.rank, T2.class_id, stock, price01, price02, stock_unlimited, product_code FROM (dtb_products_class AS T1 LEFT JOIN dtb_classcategory AS T2 ON T1.classcategory_id1 = T2.classcategory_id)) AS T3 LEFT JOIN dtb_classcategory AS T4 ON T3.classcategory_id2 = T4.classcategory_id) AS T5 LEFT JOIN dtb_products AS T6 ON product_id_sub = T6.product_id) AS prdcls WHERE del_flg = 0 ORDER BY update_date DESC, product_id DESC [nativecode=1242 ** Subquery returns more than 1 row]

/html/admin/products/index.php 34:LC_Page_Admin_Products_Ex->process
/data/class_extends/page_extends/admin/products/LC_Page_Admin_Products_Ex.php 56:LC_Page_Admin_Products->process
/data/class/pages/admin/products/LC_Page_Admin_Products.php 263:SC_Helper_CSV->lfGetProductsCSV
/data/class/helper/SC_Helper_CSV.php 112:SC_Query->select
/data/class/SC_Query.php 95:SC_DbConn->getAll
/data/class/SC_DbConn.php 166:DB_common->getAll
/data/module/DB/common.php 1613:DB_common->query
/data/module/DB/common.php 1167: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

同じような現象が起こっているようですが、こちらのスレッドではPostgreSQLへの移行が一番の解決策と書かれてありますね。
http://xoops.ec-cube.net/modules/newbb/viewtopic.php?topic_id=3799&forum=11

----------------
株式会社サンクユーは東京都品川区のWEB制作会社です。
サンクユーのEC-CUBE構築、カスタマイズ・サービス
お問合せ先：info@thank-u.net
（有償対応のみ

ご返信どうもありがとうございました。

DBはMySQLを利用して行きたいと思っているのですが、
DBを変更することなく、解決する方法はございませんでしょうか。

何卒よろしくお願いいたします。

ＳＱＬ文に問題があるので、ＳＱＬ文内の問題点をまずは特定し、問題のクエリを正しいクエリに置き換える処理を乗せるという感じになるかと思います。
根源的な問題解決はすぐにされそうにない気がします・・・。

----------------
EC-CUBE公式エヴァンジェリスト
EC-CUBEインテグレートパートナー (株)スピリット・オブ
移転・拡張・高速化・問題解決
各種カスタマイズ・支援依頼承ります。
[url=h