質問 > 管理機能 > お客様情報入力後エラーが発生する。 |
管理機能
フラット表示 | 前のトピック | 次のトピック |
投稿者 | スレッド |
---|---|
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 |