バージョン選択

フォーラム

メニュー

オンライン状況

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

サイト内検索

 > 管理機能 > メール一括通知機能でシステムエラーが発生します。

管理機能

新規スレッドを追加する

スレッド表示 | 新しいものから 前のトピック | 次のトピック | 下へ
投稿者 スレッド
uribow
投稿日時: 2016/8/22 16:47
対応状況: −−−
半人前
登録日: 2016/8/22
居住地:
投稿: 17
メール一括通知機能でシステムエラーが発生します。
お世話になっております。ECサイトを今までは2系で運用しておりましたが3系も視野に入れテストを行っております。

メール一括通知機能を試したところ、システムエラーが発生します。
ただし、メールの送信自体は行えているらしく、テストに使用したオーダーのメールアドレスには指定したメールが着信しております。

Invalid text representation: 7 ERROR: 型integerの入力構文が無効です
が原因かと思いますが、既知の不具合で対応方法がありましたらご教授いただけますでしょうか。



環境は下記の通りです。

----------------
EC-CUBE
3.0.10
DBサーバー
PostgreSQL 9.2.15 on x86_64-redhat-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit
WEBサーバー
nginx/1.6.3
PHP
5.4.16 (Core, date, ereg, libxml, openssl, pcre, zlib, bz2, calendar, ctype, hash, filter, ftp, gettext, gmp, SPL, iconv, Reflection, session, standard, shmop, SimpleXML, sockets, mbstring, tokenizer, xml, cgi-fcgi, apcu, curl, dom, fileinfo, json, exif, mcrypt, mysql, mysqli, PDO, pdo_mysql, pdo_pgsql, pdo_sqlite, pgsql, Phar, posix, sqlite3, sysvmsg, sysvsem, sysvshm, wddx, xmlreader, xmlwriter, xsl, zip, mhash, apc)

----------------

発生時のログは下記となります。

[2016-08-22 16:27:54] eccube.INFO: > POST /__admin__/order/mail/mail_all [] []
[2016-08-22 16:27:54] eccube.CRITICAL: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'SELECT t0.order_id AS order_id1, t0.pre_order_id AS pre_order_id2, t0.message AS message3, t0.order_name01 AS order_name014, t0.order_name02 AS order_name025, t0.order_kana01 AS order_kana016, t0.order_kana02 AS order_kana027, t0.order_company_name AS order_company_name8, t0.order_email AS order_email9, t0.order_tel01 AS order_tel0110, t0.order_tel02 AS order_tel0211, t0.order_tel03 AS order_tel0312, t0.order_fax01 AS order_fax0113, t0.order_fax02 AS order_fax0214, t0.order_fax03 AS order_fax0315, t0.order_zip01 AS order_zip0116, t0.order_zip02 AS order_zip0217, t0.order_zipcode AS order_zipcode18, t0.order_addr01 AS order_addr0119, t0.order_addr02 AS order_addr0220, t0.order_birth AS order_birth21, t0.subtotal AS subtotal22, t0.discount AS discount23, t0.delivery_fee_total AS delivery_fee_total24, t0.charge AS charge25, t0.tax AS tax26, t0.total AS total27, t0.payment_total AS payment_total28, t0.payment_method AS payment_method29, t0.note AS note30, t0.create_date AS create_date31, t0.update_date AS update_date32, t0.order_date AS order_date33, t0.commit_date AS commit_date34, t0.payment_date AS payment_date35, t0.del_flg AS del_flg36, t0.customer_id AS customer_id37, t0.order_country_id AS order_country_id38, t0.order_pref AS order_pref39, t0.order_sex AS order_sex40, t0.order_job AS order_job41, t0.payment_id AS payment_id42, t0.device_type_id AS device_type_id43, t0.status AS status44, t0.status AS status45, t0.status AS status46 FROM dtb_order t0 WHERE t0.order_id = ? AND ((t0.del_flg = 0))' with params ["q"]:

SQLSTATE[22P02]: Invalid text representation: 7 ERROR: 型integerの入力構文が無効です: "q" (uncaught exception) at /var/lib/eccube-3.0.10/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 t0.order_id AS order_id1, t0.pre_order_id AS pre_order_id2, t0.message AS message3, t0.order_name01 AS order_name014, t0.order_name02 AS order_name025, t0.order_kana01 AS order_kana016, t0.order_kana02 AS order_kana027, t0.order_company_name AS order_company_name8, t0.order_email AS order_email9, t0.order_tel01 AS order_tel0110, t0.order_tel02 AS order_tel0211, t0.order_tel03 AS order_tel0312, t0.order_fax01 AS order_fax0113, t0.order_fax02 AS order_fax0214, t0.order_fax03 AS order_fax0315, t0.order_zip01 AS order_zip0116, t0.order_zip02 AS order_zip0217, t0.order_zipcode AS order_zipcode18, t0.order_addr01 AS order_addr0119, t0.order_addr02 AS order_addr0220, t0.order_birth AS order_birth21, t0.subtotal AS subtotal22, t0.discount AS discount23, t0.delivery_fee_total AS delivery_fee_total24, t0.charge AS charge25, t0.tax AS tax26, t0.total AS total27, t0.payment_total AS payment_total28, t0.payment_method AS payment_method29, t0.note AS note30, t0.create_date AS create_date31, t0.update_date AS update_date32, t0.order_date AS order_date33, t0.commit_date AS commit_date34, t0.payment_date AS payment_date35, t0.del_flg AS del_flg36, t0.customer_id AS customer_id37, t0.order_country_id AS order_country_id38, t0.order_pref AS order_pref39, t0.order_sex AS order_sex40, t0.order_job AS order_job41, t0.payment_id AS payment_id42, t0.device_type_id AS device_type_id43, t0.status AS status44, t0.status AS status45, t0.status AS status46 FROM dtb_order t0 WHERE t0.order_id = ? AND ((t0.del_flg = 0))' with params [\"q\"]:\n\nSQLSTATE[22P02]: Invalid text representation: 7 ERROR: 型integerの入力構文が無効です: \"q\" at /var/lib/eccube-3.0.10/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractPostgreSQLDriver.php:91, Doctrine\\DBAL\\Driver\\PDOException(code: 22P02): SQLSTATE[22P02]: Invalid text representation: 7 ERROR: 型integerの入力構文が無効です: \"q\" at /var/lib/eccube-3.0.10/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:93, PDOException(code: 22P02): SQLSTATE[22P02]: Invalid text representation: 7 ERROR: 型integerの入力構文が無効です: \"q\" at /var/lib/eccube-3.0.10/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91)"} []
[2016-08-22 16:27:54] eccube.INFO: < 500 [] []



tao_s
投稿日時: 2016/8/23 18:48
対応状況: −−−
仙人
登録日: 2008/8/20
居住地: 東京
投稿: 799
Re: メール一括通知機能でシステムエラーが発生します。
どうやらorder_idが入るべき部分に文字列のqが入ってるみたいですね。
ちょっと調べてみます


----------------
EC-CUBEカスタマイズ相談してください。
緊急のEC-CUBEの障害対応
EC-CUBEカスタマイズブログ

スレッド表示 | 新しいものから 前のトピック | 次のトピック | トップ


 



ログイン


EC-CUBE公式 Amazon Payプラグイン

統計情報

総メンバー数は88,865名です
総投稿数は109,999件です

投稿数ランキング

1
seasoft
7367
2
468
3217
3
AMUAMU
2712
4
nanasess
2313
5
umebius
2085
6
yuh
1819
7
h_tanaka
1646
8
red
1570
9
mcontact
1295
10
tsuji
958
11
fukap
907
12
shutta
835
13
tao_s
799
14 ramrun 789
15 karin 689
16 sumida 641
17
homan
633
18 DELIGHT 572
19
patapata
502
20
flealog
485


ネットショップの壺

EC-CUBEインテグレートパートナー

Copyright© EC-CUBE CO.,LTD. All Rights Reserved.