バージョン選択

フォーラム

メニュー

オンライン状況

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

サイト内検索

質問 > 管理機能 > お客様情報入力後エラーが発生する。

管理機能

新規スレッドを追加する

フラット表示 前のトピック | 次のトピック
投稿者 スレッド
takamichi
投稿日時: 2023/12/27 16:58
対応状況: −−−
新米
登録日: 2020/12/21
居住地:
投稿: 8
お客様情報入力後エラーが発生する。
▼テンプレート
[EC-CUBE] 3.0.18
[レンタルサーバ] Xserver
[PHP]7.3.33
[データベース] MySQL5.7
[現象]
商品をカートに追加→レジに進む→ゲスト購入→お客様情報を入力後、次へボタンをを押すと「システムエラーが発生しました。大変お手数ですが、サイト管理者までご連絡ください。」と表示され商品の購入ができないエラーが発生ています。
/index_dev.phpにアクセスし検証モードにすると下記のエラーが表記されていました。

エラー内容

ERROR - Doctrine\DBAL\Exception\ConnectionException: An exception occurred while executing 'SELECT t0.customer_address_id AS customer_address_id1, t0.name01 AS name012, t0.name02 AS name023, t0.kana01 AS kana014, t0.kana02 AS kana025, t0.company_name AS company_name6, t0.zip01 AS zip017, t0.zip02 AS zip028, t0.zipcode AS zipcode9, t0.addr01 AS addr0110, t0.addr02 AS addr0211, t0.addr03 AS addr0312, t0.tel01 AS tel0113, t0.tel02 AS tel0214, t0.tel03 AS tel0315, t0.fax01 AS fax0116, t0.fax02 AS fax0217, t0.fax03 AS fax0318, t0.create_date AS create_date19, t0.update_date AS update_date20, t0.del_flg AS del_flg21, t0.customer_id AS customer_id22, t0.country_id AS country_id23, t0.pref AS pref24 FROM *******.dtb_customer_address t0 WHERE t0.customer_id = ? AND ((t0.del_flg = 0)) ORDER BY t0.customer_address_id ASC LIMIT 1' with params [3579]: SQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user '*******'@'*******' for table 'dtb_customer_address' (uncaught exception) at /home/*******/*******/public_html/*******/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 103
Context: {"exception":"Exception(Doctrine\\DBAL\\Exception\\ConnectionException): An exception occurred while executing 'SELECT t0.customer_address_id AS customer_address_id1, t0.name01 AS name012, t0.name02 AS name023, t0.kana01 AS kana014, t0.kana02 AS kana025, t0.company_name AS company_name6, t0.zip01 AS zip017, t0.zip02 AS zip028, t0.zipcode AS zipcode9, t0.addr01 AS addr0110, t0.addr02 AS addr0211, t0.addr03 AS addr0312, t0.tel01 AS tel0113, t0.tel02 AS tel0214, t0.tel03 AS tel0315, t0.fax01 AS fax0116, t0.fax02 AS fax0217, t0.fax03 AS fax0318, t0.create_date AS create_date19, t0.update_date AS update_date20, t0.del_flg AS del_flg21, t0.customer_id AS customer_id22, t0.country_id AS country_id23, t0.pref AS pref24 FROM *******.dtb_customer_address t0 WHERE t0.customer_id = ? AND ((t0.del_flg = 0)) ORDER BY t0.customer_address_id ASC LIMIT 1' with params [3579]:\n\nSQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user '*******'@'*******' for table 'dtb_customer_address'"}
CRITICAL - Doctrine\DBAL\Exception\ConnectionException: An exception occurred while executing 'SELECT t0.customer_address_id AS customer_address_id1, t0.name01 AS name012, t0.name02 AS name023, t0.kana01 AS kana014, t0.kana02 AS kana025, t0.company_name AS company_name6, t0.zip01 AS zip017, t0.zip02 AS zip028, t0.zipcode AS zipcode9, t0.addr01 AS addr0110, t0.addr02 AS addr0211, t0.addr03 AS addr0312, t0.tel01 AS tel0113, t0.tel02 AS tel0214, t0.tel03 AS tel0315, t0.fax01 AS fax0116, t0.fax02 AS fax0217, t0.fax03 AS fax0318, t0.create_date AS create_date19, t0.update_date AS update_date20, t0.del_flg AS del_flg21, t0.customer_id AS customer_id22, t0.country_id AS country_id23, t0.pref AS pref24 FROM *******.dtb_customer_address t0 WHERE t0.customer_id = ? AND ((t0.del_flg = 0)) ORDER BY t0.customer_address_id ASC LIMIT 1' with params [3579]: SQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user '*******'@'*******' for table 'dtb_customer_address' (uncaught exception) at /home/*******/*******/public_html/*******/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 103
Context: {"exception":"Exception(Doctrine\\DBAL\\Exception\\ConnectionException): An exception occurred while executing 'SELECT t0.customer_address_id AS customer_address_id1, t0.name01 AS name012, t0.name02 AS name023, t0.kana01 AS kana014, t0.kana02 AS kana025, t0.company_name AS company_name6, t0.zip01 AS zip017, t0.zip02 AS zip028, t0.zipcode AS zipcode9, t0.addr01 AS addr0110, t0.addr02 AS addr0211, t0.addr03 AS addr0312, t0.tel01 AS tel0113, t0.tel02 AS tel0214, t0.tel03 AS tel0315, t0.fax01 AS fax0116, t0.fax02 AS fax0217, t0.fax03 AS fax0318, t0.create_date AS create_date19, t0.update_date AS update_date20, t0.del_flg AS del_flg21, t0.customer_id AS customer_id22, t0.country_id AS country_id23, t0.pref AS pref24 FROM *******.dtb_customer_address t0 WHERE t0.customer_id = ? AND ((t0.del_flg = 0)) ORDER BY t0.customer_address_id ASC LIMIT 1' with params [3579]:\n\nSQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user '*******'@'*******' for table 'dtb_customer_address'"}

eccube管理画面やFTPからキャッシュを削除したのですが解決しません。
解決方法をご存じの方がいらっしゃればご教示をお願いいたします。
フラット表示 前のトピック | 次のトピック


題名 投稿者 日時
 » お客様情報入力後エラーが発生する。 takamichi 2023/12/27 16:58
     Re: お客様情報入力後エラーが発生する。 tattsu 2023/12/27 17:10
       Re: お客様情報入力後エラーが発生する。 takamichi 2023/12/27 17:32
         Re: お客様情報入力後エラーが発生する。 tattsu 2023/12/28 17:13

 



ログイン


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

統計情報

総メンバー数は89,169名です
総投稿数は110,047件です

投稿数ランキング

1
seasoft
7367
2
468
3217
3
AMUAMU
2712
4
nanasess
2314
5
umebius
2085
6
yuh
1819
7
h_tanaka
1650
8
red
1570
9
mcontact
1299
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.