バージョン選択

フォーラム

メニュー

オンライン状況

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

サイト内検索

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

管理機能

新規スレッドを追加する

スレッド表示 | 新しいものから 前のトピック | 次のトピック | 下へ
投稿者 スレッド
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からキャッシュを削除したのですが解決しません。
解決方法をご存じの方がいらっしゃればご教示をお願いいたします。
tattsu
投稿日時: 2023/12/27 17:10
対応状況: −−−
長老
登録日: 2023/12/23
居住地:
投稿: 207
Re: お客様情報入力後エラーが発生する。
dtb_customer_addressテーブルにアクセスする権限がないようです。

マイページのお届け先の追加変更画面などもエラーになりますか?

phpMyAdminでテーブルのアクセス権限などを変更されていないか確認できますでしょうか。


----------------
-------------------
EC-CUBEカスタマイズ・バージョンアップ・不具合修正 
気軽にご相談ください。ゴールドランクパートナー。

takamichi
投稿日時: 2023/12/27 17:32
対応状況: −−−
新米
登録日: 2020/12/21
居住地:
投稿: 8
Re: お客様情報入力後エラーが発生する。
ご回答ありがとうございます。
phpMyAdminでテーブルのアクセス権限などの変更は特にしておりません。
また、アクセス権限を付与しようとphpMyAdminにてSQLを書いてみたのですが入力が拒否されてしまいます。これはおそらく使用しているXserverの仕様のようです。ルート権限がないみたいでして、、、

マイページにログインしお届け先編集画面をクリックした際もシステムエラーが発生いたしました。
エラー内容は下記になります。

エラー内容
Twig_Error_Runtime in Template.php line 230:
An exception has been thrown during the rendering of a template ("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 drvanah.dtb_customer_address t0 WHERE t0.customer_id = ? AND ((t0.del_flg = 0)) ORDER BY t0.customer_address_id ASC' with params [3579]:

SQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user '******'@'********' for table 'dtb_customer_address'") in "__string_template__64504c88177b51a01f70607fd4fc4f8729642af14dce671afc232839b9d5b745" at line 36.
in Template.php line 230
at Twig_Template->displayBlock('main', array('Customer' => object(Customer), 'app' => object(Application), 'BaseInfo' => object(BaseInfo), 'PageLayout' => object(PageLayout), 'title' => 'MYページ/お届け先一覧', 'mypageno' => 'delivery', 'body_class' => 'mypage'), array('meta_tags' => array(object(__TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35), 'block_meta_tags'), 'stylesheet' => array(object(__TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35), 'block_stylesheet'), 'main' => array(object(__TwigTemplate_e1f02986fb24b3de3d4e919ead9fb53b6747cb85470576ca141886e090d070cc), 'block_main'), 'javascript' => array(object(__TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35), 'block_javascript'))) in eaf8e7088b55fa438a680d56c36c5084e6a803a1ef8457eef417f4a8e552188f.php line 255
at __TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35->doDisplay(array('Customer' => object(Customer), 'app' => object(Application), 'BaseInfo' => object(BaseInfo), 'PageLayout' => object(PageLayout), 'title' => 'MYページ/お届け先一覧', 'mypageno' => 'delivery', 'body_class' => 'mypage'), array('meta_tags' => array(object(__TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35), 'block_meta_tags'), 'stylesheet' => array(object(__TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35), 'block_stylesheet'), 'main' => array(object(__TwigTemplate_e1f02986fb24b3de3d4e919ead9fb53b6747cb85470576ca141886e090d070cc), 'block_main'), 'javascript' => array(object(__TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35), 'block_javascript'))) in Template.php line 432
at Twig_Template->displayWithErrorHandling(array('Customer' => object(Customer), 'app' => object(Application), 'BaseInfo' => object(BaseInfo), 'PageLayout' => object(PageLayout), 'title' => 'MYページ/お届け先一覧', 'mypageno' => 'delivery', 'body_class' => 'mypage'), array('meta_tags' => array(object(__TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35), 'block_meta_tags'), 'stylesheet' => array(object(__TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35), 'block_stylesheet'), 'main' => array(object(__TwigTemplate_e1f02986fb24b3de3d4e919ead9fb53b6747cb85470576ca141886e090d070cc), 'block_main'), 'javascript' => array(object(__TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35), 'block_javascript'))) in Template.php line 403
at Twig_Template->display(array('Customer' => object(Customer), 'app' => object(Application), 'BaseInfo' => object(BaseInfo), 'PageLayout' => object(PageLayout), 'title' => 'MYページ/お届け先一覧', 'mypageno' => 'delivery', 'body_class' => 'mypage'), array('main' => array(object(__TwigTemplate_e1f02986fb24b3de3d4e919ead9fb53b6747cb85470576ca141886e090d070cc), 'block_main'))) in 264400ef320cd3c376df5371f3b14d7e28e53df15164806af294aa6e5a1ee269.php line 32
at __TwigTemplate_e1f02986fb24b3de3d4e919ead9fb53b6747cb85470576ca141886e090d070cc->doDisplay(array('Customer' => object(Customer), 'app' => object(Application), 'BaseInfo' => object(BaseInfo), 'PageLayout' => object(PageLayout), 'title' => 'MYページ/お届け先一覧', 'mypageno' => 'delivery', 'body_class' => 'mypage'), array('main' => array(object(__TwigTemplate_e1f02986fb24b3de3d4e919ead9fb53b6747cb85470576ca141886e090d070cc), 'block_main'))) in Template.php line 432
at Twig_Template->displayWithErrorHandling(array('Customer' => object(Customer), 'app' => object(Application), 'BaseInfo' => object(BaseInfo), 'PageLayout' => object(PageLayout), 'title' => 'MYページ/お届け先一覧'), array('main' => array(object(__TwigTemplate_e1f02986fb24b3de3d4e919ead9fb53b6747cb85470576ca141886e090d070cc), 'block_main'))) in Template.php line 403
at Twig_Template->display(array('Customer' => object(Customer))) in Template.php line 411
at Twig_Template->render(array('Customer' => object(Customer))) in ApplicationTrait.php line 256
at ApplicationTrait->render('Mypage/delivery.twig', array('Customer' => object(Customer))) in DeliveryController.php line 48
at DeliveryController->index(object(Application), object(Request))
at call_user_func_array(array(object(DeliveryController), 'index'), array(object(Application), object(Request))) in HttpKernel.php line 144
at HttpKernel->handleRaw(object(Request), '1') in HttpKernel.php line 64
at HttpKernel->handle(object(Request), '1', true) in Application.php line 586
at Application->handle(object(Request)) in Application.php line 563
at Application->run() in index_dev.php line 107
3/4
ConnectionException in AbstractMySQLDriver.php line 103:
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 drvanah.dtb_customer_address t0 WHERE t0.customer_id = ? AND ((t0.del_flg = 0)) ORDER BY t0.customer_address_id ASC' with params [3579]:

SQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user '******'@'********' for table 'dtb_customer_address'
in AbstractMySQLDriver.php line 103
at AbstractMySQLDriver->convertException('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 drvanah.dtb_customer_address t0 WHERE t0.customer_id = ? AND ((t0.del_flg = 0)) ORDER BY t0.customer_address_id ASC' with params [3579]: SQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user '******'@'********' for table 'dtb_customer_address'', object(PDOException)) in DBALException.php line 128
at DBALException::driverExceptionDuringQuery(object(Driver), object(PDOException), '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 drvanah.dtb_customer_address t0 WHERE t0.customer_id = ? AND ((t0.del_flg = 0)) ORDER BY t0.customer_address_id ASC', array('3579')) in Connection.php line 855
at Connection->executeQuery('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 drvanah.dtb_customer_address t0 WHERE t0.customer_id = ? AND ((t0.del_flg = 0)) ORDER BY t0.customer_address_id ASC', array('3579'), array(null)) in BasicEntityPersister.php line 1784
at BasicEntityPersister->getOneToManyStatement(array('fieldName' => 'CustomerAddresses', 'targetEntity' => 'Eccube\Entity\CustomerAddress', 'mappedBy' => 'Customer', 'orderBy' => array('id' => 'ASC'), 'type' => '4', 'inversedBy' => null, 'isOwningSide' => false, 'sourceEntity' => 'Eccube\Entity\Customer', 'fetch' => '2', 'cascade' => array(), 'isCascadeRemove' => false, 'isCascadePersist' => false, 'isCascadeRefresh' => false, 'isCascadeMerge' => false, 'isCascadeDetach' => false, 'orphanRemoval' => false), object(Customer)) in BasicEntityPersister.php line 1740
at BasicEntityPersister->loadOneToManyCollection(array('fieldName' => 'CustomerAddresses', 'targetEntity' => 'Eccube\Entity\CustomerAddress', 'mappedBy' => 'Customer', 'orderBy' => array('id' => 'ASC'), 'type' => '4', 'inversedBy' => null, 'isOwningSide' => false, 'sourceEntity' => 'Eccube\Entity\Customer', 'fetch' => '2', 'cascade' => array(), 'isCascadeRemove' => false, 'isCascadePersist' => false, 'isCascadeRefresh' => false, 'isCascadeMerge' => false, 'isCascadeDetach' => false, 'orphanRemoval' => false), object(Customer), object(PersistentCollection)) in UnitOfWork.php line 2797
at UnitOfWork->loadCollection(object(PersistentCollection)) in PersistentCollection.php line 236
at PersistentCollection->initialize() in PersistentCollection.php line 568
at PersistentCollection->count() in Core.php line 1275
at twig_length_filter(object(Twig_Environment), object(PersistentCollection)) in 264400ef320cd3c376df5371f3b14d7e28e53df15164806af294aa6e5a1ee269.php line 57
at __TwigTemplate_e1f02986fb24b3de3d4e919ead9fb53b6747cb85470576ca141886e090d070cc->block_main(array('Customer' => object(Customer), 'app' => object(Application), 'BaseInfo' => object(BaseInfo), 'PageLayout' => object(PageLayout), 'title' => 'MYページ/お届け先一覧', 'mypageno' => 'delivery', 'body_class' => 'mypage'), array('meta_tags' => array(object(__TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35), 'block_meta_tags'), 'stylesheet' => array(object(__TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35), 'block_stylesheet'), 'main' => array(object(__TwigTemplate_e1f02986fb24b3de3d4e919ead9fb53b6747cb85470576ca141886e090d070cc), 'block_main'), 'javascript' => array(object(__TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35), 'block_javascript'))) in Template.php line 215
at Twig_Template->displayBlock('main', array('Customer' => object(Customer), 'app' => object(Application), 'BaseInfo' => object(BaseInfo), 'PageLayout' => object(PageLayout), 'title' => 'MYページ/お届け先一覧', 'mypageno' => 'delivery', 'body_class' => 'mypage'), array('meta_tags' => array(object(__TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35), 'block_meta_tags'), 'stylesheet' => array(object(__TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35), 'block_stylesheet'), 'main' => array(object(__TwigTemplate_e1f02986fb24b3de3d4e919ead9fb53b6747cb85470576ca141886e090d070cc), 'block_main'), 'javascript' => array(object(__TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35), 'block_javascript'))) in eaf8e7088b55fa438a680d56c36c5084e6a803a1ef8457eef417f4a8e552188f.php line 255
at __TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35->doDisplay(array('Customer' => object(Customer), 'app' => object(Application), 'BaseInfo' => object(BaseInfo), 'PageLayout' => object(PageLayout), 'title' => 'MYページ/お届け先一覧', 'mypageno' => 'delivery', 'body_class' => 'mypage'), array('meta_tags' => array(object(__TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35), 'block_meta_tags'), 'stylesheet' => array(object(__TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35), 'block_stylesheet'), 'main' => array(object(__TwigTemplate_e1f02986fb24b3de3d4e919ead9fb53b6747cb85470576ca141886e090d070cc), 'block_main'), 'javascript' => array(object(__TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35), 'block_javascript'))) in Template.php line 432
at Twig_Template->displayWithErrorHandling(array('Customer' => object(Customer), 'app' => object(Application), 'BaseInfo' => object(BaseInfo), 'PageLayout' => object(PageLayout), 'title' => 'MYページ/お届け先一覧', 'mypageno' => 'delivery', 'body_class' => 'mypage'), array('meta_tags' => array(object(__TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35), 'block_meta_tags'), 'stylesheet' => array(object(__TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35), 'block_stylesheet'), 'main' => array(object(__TwigTemplate_e1f02986fb24b3de3d4e919ead9fb53b6747cb85470576ca141886e090d070cc), 'block_main'), 'javascript' => array(object(__TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35), 'block_javascript'))) in Template.php line 403
at Twig_Template->display(array('Customer' => object(Customer), 'app' => object(Application), 'BaseInfo' => object(BaseInfo), 'PageLayout' => object(PageLayout), 'title' => 'MYページ/お届け先一覧', 'mypageno' => 'delivery', 'body_class' => 'mypage'), array('main' => array(object(__TwigTemplate_e1f02986fb24b3de3d4e919ead9fb53b6747cb85470576ca141886e090d070cc), 'block_main'))) in 264400ef320cd3c376df5371f3b14d7e28e53df15164806af294aa6e5a1ee269.php line 32
at __TwigTemplate_e1f02986fb24b3de3d4e919ead9fb53b6747cb85470576ca141886e090d070cc->doDisplay(array('Customer' => object(Customer), 'app' => object(Application), 'BaseInfo' => object(BaseInfo), 'PageLayout' => object(PageLayout), 'title' => 'MYページ/お届け先一覧', 'mypageno' => 'delivery', 'body_class' => 'mypage'), array('main' => array(object(__TwigTemplate_e1f02986fb24b3de3d4e919ead9fb53b6747cb85470576ca141886e090d070cc), 'block_main'))) in Template.php line 432
at Twig_Template->displayWithErrorHandling(array('Customer' => object(Customer), 'app' => object(Application), 'BaseInfo' => object(BaseInfo), 'PageLayout' => object(PageLayout), 'title' => 'MYページ/お届け先一覧'), array('main' => array(object(__TwigTemplate_e1f02986fb24b3de3d4e919ead9fb53b6747cb85470576ca141886e090d070cc), 'block_main'))) in Template.php line 403
at Twig_Template->display(array('Customer' => object(Customer))) in Template.php line 411
at Twig_Template->render(array('Customer' => object(Customer))) in ApplicationTrait.php line 256
at ApplicationTrait->render('Mypage/delivery.twig', array('Customer' => object(Customer))) in DeliveryController.php line 48
at DeliveryController->index(object(Application), object(Request))
at call_user_func_array(array(object(DeliveryController), 'index'), array(object(Application), object(Request))) in HttpKernel.php line 144
at HttpKernel->handleRaw(object(Request), '1') in HttpKernel.php line 64
at HttpKernel->handle(object(Request), '1', true) in Application.php line 586
at Application->handle(object(Request)) in Application.php line 563
at Application->run() in index_dev.php line 107
2/4
PDOException in PDOStatement.php line 93:
SQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user '******'@'********' for table 'dtb_customer_address'
in PDOStatement.php line 93
at PDOStatement->execute() in Connection.php line 847
at Connection->executeQuery('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 drvanah.dtb_customer_address t0 WHERE t0.customer_id = ? AND ((t0.del_flg = 0)) ORDER BY t0.customer_address_id ASC', array('3579'), array(null)) in BasicEntityPersister.php line 1784
at BasicEntityPersister->getOneToManyStatement(array('fieldName' => 'CustomerAddresses', 'targetEntity' => 'Eccube\Entity\CustomerAddress', 'mappedBy' => 'Customer', 'orderBy' => array('id' => 'ASC'), 'type' => '4', 'inversedBy' => null, 'isOwningSide' => false, 'sourceEntity' => 'Eccube\Entity\Customer', 'fetch' => '2', 'cascade' => array(), 'isCascadeRemove' => false, 'isCascadePersist' => false, 'isCascadeRefresh' => false, 'isCascadeMerge' => false, 'isCascadeDetach' => false, 'orphanRemoval' => false), object(Customer)) in BasicEntityPersister.php line 1740
at BasicEntityPersister->loadOneToManyCollection(array('fieldName' => 'CustomerAddresses', 'targetEntity' => 'Eccube\Entity\CustomerAddress', 'mappedBy' => 'Customer', 'orderBy' => array('id' => 'ASC'), 'type' => '4', 'inversedBy' => null, 'isOwningSide' => false, 'sourceEntity' => 'Eccube\Entity\Customer', 'fetch' => '2', 'cascade' => array(), 'isCascadeRemove' => false, 'isCascadePersist' => false, 'isCascadeRefresh' => false, 'isCascadeMerge' => false, 'isCascadeDetach' => false, 'orphanRemoval' => false), object(Customer), object(PersistentCollection)) in UnitOfWork.php line 2797
at UnitOfWork->loadCollection(object(PersistentCollection)) in PersistentCollection.php line 236
at PersistentCollection->initialize() in PersistentCollection.php line 568
at PersistentCollection->count() in Core.php line 1275
at twig_length_filter(object(Twig_Environment), object(PersistentCollection)) in 264400ef320cd3c376df5371f3b14d7e28e53df15164806af294aa6e5a1ee269.php line 57
at __TwigTemplate_e1f02986fb24b3de3d4e919ead9fb53b6747cb85470576ca141886e090d070cc->block_main(array('Customer' => object(Customer), 'app' => object(Application), 'BaseInfo' => object(BaseInfo), 'PageLayout' => object(PageLayout), 'title' => 'MYページ/お届け先一覧', 'mypageno' => 'delivery', 'body_class' => 'mypage'), array('meta_tags' => array(object(__TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35), 'block_meta_tags'), 'stylesheet' => array(object(__TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35), 'block_stylesheet'), 'main' => array(object(__TwigTemplate_e1f02986fb24b3de3d4e919ead9fb53b6747cb85470576ca141886e090d070cc), 'block_main'), 'javascript' => array(object(__TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35), 'block_javascript'))) in Template.php line 215
at Twig_Template->displayBlock('main', array('Customer' => object(Customer), 'app' => object(Application), 'BaseInfo' => object(BaseInfo), 'PageLayout' => object(PageLayout), 'title' => 'MYページ/お届け先一覧', 'mypageno' => 'delivery', 'body_class' => 'mypage'), array('meta_tags' => array(object(__TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35), 'block_meta_tags'), 'stylesheet' => array(object(__TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35), 'block_stylesheet'), 'main' => array(object(__TwigTemplate_e1f02986fb24b3de3d4e919ead9fb53b6747cb85470576ca141886e090d070cc), 'block_main'), 'javascript' => array(object(__TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35), 'block_javascript'))) in eaf8e7088b55fa438a680d56c36c5084e6a803a1ef8457eef417f4a8e552188f.php line 255
at __TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35->doDisplay(array('Customer' => object(Customer), 'app' => object(Application), 'BaseInfo' => object(BaseInfo), 'PageLayout' => object(PageLayout), 'title' => 'MYページ/お届け先一覧', 'mypageno' => 'delivery', 'body_class' => 'mypage'), array('meta_tags' => array(object(__TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35), 'block_meta_tags'), 'stylesheet' => array(object(__TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35), 'block_stylesheet'), 'main' => array(object(__TwigTemplate_e1f02986fb24b3de3d4e919ead9fb53b6747cb85470576ca141886e090d070cc), 'block_main'), 'javascript' => array(object(__TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35), 'block_javascript'))) in Template.php line 432
at Twig_Template->displayWithErrorHandling(array('Customer' => object(Customer), 'app' => object(Application), 'BaseInfo' => object(BaseInfo), 'PageLayout' => object(PageLayout), 'title' => 'MYページ/お届け先一覧', 'mypageno' => 'delivery', 'body_class' => 'mypage'), array('meta_tags' => array(object(__TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35), 'block_meta_tags'), 'stylesheet' => array(object(__TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35), 'block_stylesheet'), 'main' => array(object(__TwigTemplate_e1f02986fb24b3de3d4e919ead9fb53b6747cb85470576ca141886e090d070cc), 'block_main'), 'javascript' => array(object(__TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35), 'block_javascript'))) in Template.php line 403
at Twig_Template->display(array('Customer' => object(Customer), 'app' => object(Application), 'BaseInfo' => object(BaseInfo), 'PageLayout' => object(PageLayout), 'title' => 'MYページ/お届け先一覧', 'mypageno' => 'delivery', 'body_class' => 'mypage'), array('main' => array(object(__TwigTemplate_e1f02986fb24b3de3d4e919ead9fb53b6747cb85470576ca141886e090d070cc), 'block_main'))) in 264400ef320cd3c376df5371f3b14d7e28e53df15164806af294aa6e5a1ee269.php line 32
at __TwigTemplate_e1f02986fb24b3de3d4e919ead9fb53b6747cb85470576ca141886e090d070cc->doDisplay(array('Customer' => object(Customer), 'app' => object(Application), 'BaseInfo' => object(BaseInfo), 'PageLayout' => object(PageLayout), 'title' => 'MYページ/お届け先一覧', 'mypageno' => 'delivery', 'body_class' => 'mypage'), array('main' => array(object(__TwigTemplate_e1f02986fb24b3de3d4e919ead9fb53b6747cb85470576ca141886e090d070cc), 'block_main'))) in Template.php line 432
at Twig_Template->displayWithErrorHandling(array('Customer' => object(Customer), 'app' => object(Application), 'BaseInfo' => object(BaseInfo), 'PageLayout' => object(PageLayout), 'title' => 'MYページ/お届け先一覧'), array('main' => array(object(__TwigTemplate_e1f02986fb24b3de3d4e919ead9fb53b6747cb85470576ca141886e090d070cc), 'block_main'))) in Template.php line 403
at Twig_Template->display(array('Customer' => object(Customer))) in Template.php line 411
at Twig_Template->render(array('Customer' => object(Customer))) in ApplicationTrait.php line 256
at ApplicationTrait->render('Mypage/delivery.twig', array('Customer' => object(Customer))) in DeliveryController.php line 48
at DeliveryController->index(object(Application), object(Request))
at call_user_func_array(array(object(DeliveryController), 'index'), array(object(Application), object(Request))) in HttpKernel.php line 144
at HttpKernel->handleRaw(object(Request), '1') in HttpKernel.php line 64
at HttpKernel->handle(object(Request), '1', true) in Application.php line 586
at Application->handle(object(Request)) in Application.php line 563
at Application->run() in index_dev.php line 107
1/4
PDOException in PDOStatement.php line 91:
SQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user '******'@'********' for table 'dtb_customer_address'
in PDOStatement.php line 91
at PDOStatement->execute(null) in PDOStatement.php line 91
at PDOStatement->execute() in Connection.php line 847
at Connection->executeQuery('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 drvanah.dtb_customer_address t0 WHERE t0.customer_id = ? AND ((t0.del_flg = 0)) ORDER BY t0.customer_address_id ASC', array('3579'), array(null)) in BasicEntityPersister.php line 1784
at BasicEntityPersister->getOneToManyStatement(array('fieldName' => 'CustomerAddresses', 'targetEntity' => 'Eccube\Entity\CustomerAddress', 'mappedBy' => 'Customer', 'orderBy' => array('id' => 'ASC'), 'type' => '4', 'inversedBy' => null, 'isOwningSide' => false, 'sourceEntity' => 'Eccube\Entity\Customer', 'fetch' => '2', 'cascade' => array(), 'isCascadeRemove' => false, 'isCascadePersist' => false, 'isCascadeRefresh' => false, 'isCascadeMerge' => false, 'isCascadeDetach' => false, 'orphanRemoval' => false), object(Customer)) in BasicEntityPersister.php line 1740
at BasicEntityPersister->loadOneToManyCollection(array('fieldName' => 'CustomerAddresses', 'targetEntity' => 'Eccube\Entity\CustomerAddress', 'mappedBy' => 'Customer', 'orderBy' => array('id' => 'ASC'), 'type' => '4', 'inversedBy' => null, 'isOwningSide' => false, 'sourceEntity' => 'Eccube\Entity\Customer', 'fetch' => '2', 'cascade' => array(), 'isCascadeRemove' => false, 'isCascadePersist' => false, 'isCascadeRefresh' => false, 'isCascadeMerge' => false, 'isCascadeDetach' => false, 'orphanRemoval' => false), object(Customer), object(PersistentCollection)) in UnitOfWork.php line 2797
at UnitOfWork->loadCollection(object(PersistentCollection)) in PersistentCollection.php line 236
at PersistentCollection->initialize() in PersistentCollection.php line 568
at PersistentCollection->count() in Core.php line 1275
at twig_length_filter(object(Twig_Environment), object(PersistentCollection)) in 264400ef320cd3c376df5371f3b14d7e28e53df15164806af294aa6e5a1ee269.php line 57
at __TwigTemplate_e1f02986fb24b3de3d4e919ead9fb53b6747cb85470576ca141886e090d070cc->block_main(array('Customer' => object(Customer), 'app' => object(Application), 'BaseInfo' => object(BaseInfo), 'PageLayout' => object(PageLayout), 'title' => 'MYページ/お届け先一覧', 'mypageno' => 'delivery', 'body_class' => 'mypage'), array('meta_tags' => array(object(__TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35), 'block_meta_tags'), 'stylesheet' => array(object(__TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35), 'block_stylesheet'), 'main' => array(object(__TwigTemplate_e1f02986fb24b3de3d4e919ead9fb53b6747cb85470576ca141886e090d070cc), 'block_main'), 'javascript' => array(object(__TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35), 'block_javascript'))) in Template.php line 215
at Twig_Template->displayBlock('main', array('Customer' => object(Customer), 'app' => object(Application), 'BaseInfo' => object(BaseInfo), 'PageLayout' => object(PageLayout), 'title' => 'MYページ/お届け先一覧', 'mypageno' => 'delivery', 'body_class' => 'mypage'), array('meta_tags' => array(object(__TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35), 'block_meta_tags'), 'stylesheet' => array(object(__TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35), 'block_stylesheet'), 'main' => array(object(__TwigTemplate_e1f02986fb24b3de3d4e919ead9fb53b6747cb85470576ca141886e090d070cc), 'block_main'), 'javascript' => array(object(__TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35), 'block_javascript'))) in eaf8e7088b55fa438a680d56c36c5084e6a803a1ef8457eef417f4a8e552188f.php line 255
at __TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35->doDisplay(array('Customer' => object(Customer), 'app' => object(Application), 'BaseInfo' => object(BaseInfo), 'PageLayout' => object(PageLayout), 'title' => 'MYページ/お届け先一覧', 'mypageno' => 'delivery', 'body_class' => 'mypage'), array('meta_tags' => array(object(__TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35), 'block_meta_tags'), 'stylesheet' => array(object(__TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35), 'block_stylesheet'), 'main' => array(object(__TwigTemplate_e1f02986fb24b3de3d4e919ead9fb53b6747cb85470576ca141886e090d070cc), 'block_main'), 'javascript' => array(object(__TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35), 'block_javascript'))) in Template.php line 432
at Twig_Template->displayWithErrorHandling(array('Customer' => object(Customer), 'app' => object(Application), 'BaseInfo' => object(BaseInfo), 'PageLayout' => object(PageLayout), 'title' => 'MYページ/お届け先一覧', 'mypageno' => 'delivery', 'body_class' => 'mypage'), array('meta_tags' => array(object(__TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35), 'block_meta_tags'), 'stylesheet' => array(object(__TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35), 'block_stylesheet'), 'main' => array(object(__TwigTemplate_e1f02986fb24b3de3d4e919ead9fb53b6747cb85470576ca141886e090d070cc), 'block_main'), 'javascript' => array(object(__TwigTemplate_4ef2c789e27153c39747ab804614a7fbedbda26c44463ebe53d6faccfa1aca35), 'block_javascript'))) in Template.php line 403
at Twig_Template->display(array('Customer' => object(Customer), 'app' => object(Application), 'BaseInfo' => object(BaseInfo), 'PageLayout' => object(PageLayout), 'title' => 'MYページ/お届け先一覧', 'mypageno' => 'delivery', 'body_class' => 'mypage'), array('main' => array(object(__TwigTemplate_e1f02986fb24b3de3d4e919ead9fb53b6747cb85470576ca141886e090d070cc), 'block_main'))) in 264400ef320cd3c376df5371f3b14d7e28e53df15164806af294aa6e5a1ee269.php line 32
at __TwigTemplate_e1f02986fb24b3de3d4e919ead9fb53b6747cb85470576ca141886e090d070cc->doDisplay(array('Customer' => object(Customer), 'app' => object(Application), 'BaseInfo' => object(BaseInfo), 'PageLayout' => object(PageLayout), 'title' => 'MYページ/お届け先一覧', 'mypageno' => 'delivery', 'body_class' => 'mypage'), array('main' => array(object(__TwigTemplate_e1f02986fb24b3de3d4e919ead9fb53b6747cb85470576ca141886e090d070cc), 'block_main'))) in Template.php line 432
at Twig_Template->displayWithErrorHandling(array('Customer' => object(Customer), 'app' => object(Application), 'BaseInfo' => object(BaseInfo), 'PageLayout' => object(PageLayout), 'title' => 'MYページ/お届け先一覧'), array('main' => array(object(__TwigTemplate_e1f02986fb24b3de3d4e919ead9fb53b6747cb85470576ca141886e090d070cc), 'block_main'))) in Template.php line 403
at Twig_Template->display(array('Customer' => object(Customer))) in Template.php line 411
at Twig_Template->render(array('Customer' => object(Customer))) in ApplicationTrait.php line 256
at ApplicationTrait->render('Mypage/delivery.twig', array('Customer' => object(Customer))) in DeliveryController.php line 48
at DeliveryController->index(object(Application), object(Request))
at call_user_func_array(array(object(DeliveryController), 'index'), array(object(Application), object(Request))) in HttpKernel.php line 144
at HttpKernel->handleRaw(object(Request), '1') in HttpKernel.php line 64
at HttpKernel->handle(object(Request), '1', true) in Application.php line 586
at Application->handle(object(Request)) in Application.php line 563
at Application->run() in index_dev.php line 107
tattsu
投稿日時: 2023/12/28 17:13
対応状況: −−−
長老
登録日: 2023/12/23
居住地:
投稿: 207
Re: お客様情報入力後エラーが発生する。
takamichi様

user '******'@'********' の部分は、EC-CUBEに設定されているものと同じですよね・・?

また、特定のエンティティだけ別のユーザーでアクセスするようなカスタマイズや、別のデータベースを参照するようなをカスタマイズはされていないですよね?

エックスサーバーで特定テーブルの権限変更は現状そもそもできないと思うので不思議です。

エックスサーバーに問い合わせた方がいいかもしれないと思いました。


----------------
-------------------
EC-CUBEカスタマイズ・バージョンアップ・不具合修正 
気軽にご相談ください。ゴールドランクパートナー。

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


 



ログイン


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

統計情報

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

投稿数ランキング

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