特定の検索条件で受注CSVダウンロードをするとシステムエラー

[nanasess]

http://xoops.ec-cube.net/modules/newbb/viewtopic.php?topic_id=16852&forum=12&post_id=74175#forumpost74175

3.0.8 で確認。
対応状況、性別は、文字列が SQL に渡ってしまっている可能性がある。
購入商品名は再現しなかった

[2016-01-12 09:58:23] eccube.CRITICAL: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'SELECT d0_.order_id AS order_id0, d0_.pre_order_id AS pre_order_id1, d0_.message AS message2, d0_.order_name01 AS order_name013, d0_.order_name02 AS order_name024, d0_.order_kana01 AS order_kana015, d0_.order_kana02 AS order_kana026, d0_.order_company_name AS order_company_name7, d0_.order_email AS order_email8, d0_.order_tel01 AS order_tel019, d0_.order_tel02 AS order_tel0210, d0_.order_tel03 AS order_tel0311, d0_.order_fax01 AS order_fax0112, d0_.order_fax02 AS order_fax0213, d0_.order_fax03 AS order_fax0314, d0_.order_zip01 AS order_zip0115, d0_.order_zip02 AS order_zip0216, d0_.order_zipcode AS order_zipcode17, d0_.order_addr01 AS order_addr0118, d0_.order_addr02 AS order_addr0219, d0_.order_birth AS order_birth20, d0_.subtotal AS subtotal21, d0_.discount AS discount22, d0_.delivery_fee_total AS delivery_fee_total23, d0_.charge AS charge24, d0_.tax AS tax25, d0_.total AS total26, d0_.payment_total AS payment_total27, d0_.payment_method AS payment_method28, d0_.note AS note29, d0_.create_date AS create_date30, d0_.update_date AS update_date31, d0_.order_date AS order_date32, d0_.commit_date AS commit_date33, d0_.payment_date AS payment_date34, d0_.del_flg AS del_flg35, d0_.customer_id AS customer_id36, d0_.order_country_id AS order_country_id37, d0_.order_pref AS order_pref38, d0_.order_sex AS order_sex39, d0_.order_job AS order_job40, d0_.payment_id AS payment_id41, d0_.device_type_id AS device_type_id42, d0_.status AS status43, d0_.status AS status44, d0_.status AS status45 FROM dtb_order d0_ LEFT JOIN dtb_order_detail d1_ ON d0_.order_id = d1_.order_id WHERE (d0_.status = ? AND d1_.product_name LIKE ?) AND (d0_.del_flg = 0) ORDER BY d0_.update_date DESC' with params [{}, "%\u30c7\u30a3\u30ca\u30fc\u30d5\u30a9\u30fc\u30af%"]:

SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for integer: "新規受付" (uncaught exception) at C:\Users\username\git-repos\ec-cube\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\AbstractPostgreSQLDriver.php line 91 {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 0): An exception occurred while executing 'SELECT d0_.order_id AS order_id0, d0_.pre_order_id AS pre_order_id1, d0_.message AS message2, d0_.order_name01 AS order_name013, d0_.order_name02 AS order_name024, d0_.order_kana01 AS order_kana015, d0_.order_kana02 AS order_kana026, d0_.order_company_name AS order_company_name7, d0_.order_email AS order_email8, d0_.order_tel01 AS order_tel019, d0_.order_tel02 AS order_tel0210, d0_.order_tel03 AS order_tel0311, d0_.order_fax01 AS order_fax0112, d0_.order_fax02 AS order_fax0213, d0_.order_fax03 AS order_fax0314, d0_.order_zip01 AS order_zip0115, d0_.order_zip02 AS order_zip0216, d0_.order_zipcode AS order_zipcode17, d0_.order_addr01 AS order_addr0118, d0_.order_addr02 AS order_addr0219, d0_.order_birth AS order_birth20, d0_.subtotal AS subtotal21, d0_.discount AS discount22, d0_.delivery_fee_total AS delivery_fee_total23, d0_.charge AS charge24, d0_.tax AS tax25, d0_.total AS total26, d0_.payment_total AS payment_total27, d0_.payment_method AS payment_method28, d0_.note AS note29, d0_.create_date AS create_date30, d0_.update_date AS update_date31, d0_.order_date AS order_date32, d0_.commit_date AS commit_date33, d0_.payment_date AS payment_date34, d0_.del_flg AS del_flg35, d0_.customer_id AS customer_id36, d0_.order_country_id AS order_country_id37, d0_.order_pref AS order_pref38, d0_.order_sex AS order_sex39, d0_.order_job AS order_job40, d0_.payment_id AS payment_id41, d0_.device_type_id AS device_type_id42, d0_.status AS status43, d0_.status AS status44, d0_.status AS status45 FROM dtb_order d0_ LEFT JOIN dtb_order_detail d1_ ON d0_.order_id = d1_.order_id WHERE (d0_.status = ? AND d1_.product_name LIKE ?) AND (d0_.del_flg = 0) ORDER BY d0_.update_date DESC' with params [{}, \"%\\u30c7\\u30a3\\u30ca\\u30fc\\u30d5\\u30a9\\u30fc\\u30af%\"]:\n\nSQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for integer: \"新規受付\" at C:\\Users\\kentaro_ohkouchi\\git-repos\\ec-cube\\vendor\\doctrine\\dbal\\lib\\Doctrine\\DBAL\\Driver\\AbstractPostgreSQLDriver.php:91, Doctrine\\DBAL\\Driver\\PDOException(code: 22P02): SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for integer: \"新規受付\" at C:\\Users\\kentaro_ohkouchi\\git-repos\\ec-cube\\vendor\\doctrine\\dbal\\lib\\Doctrine\\DBAL\\Driver\\PDOStatement.php:93, PDOException(code: 22P02): SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for integer: \"新規受付\" at C:\\Users\\kentaro_ohkouchi\\git-repos\\ec-cube\\vendor\\doctrine\\dbal\\lib\\Doctrine\\DBAL\\Driver\\PDOStatement.php:91)"} []

[chihiro-adachi]

fixed #1429