質問 > 管理機能 > 商品詳細画面でシステムエラーと表示されます。 |
管理機能
スレッド表示 | 新しいものから | 前のトピック | 次のトピック | 下へ |
投稿者 | スレッド |
---|---|
yamagata78 |
投稿日時: 2021/6/1 16:53
対応状況: 確認中
|
半人前 登録日: 2019/11/25 居住地: 投稿: 29 |
商品詳細画面でシステムエラーと表示されます。 [EC-CUBE]ECCUBE3 新規インストール
[OS]CENTOS [PHP]7系 [データベース]MSQL [WEBサーバ]アパッチ [ブラウザ]クローム [導入プラグインの有無] 無し [カスタマイズの有無] 無し [現象] 新規インストールにてセットアップが無事に完了。 管理画面へアクセス→OK ショップページにて商品一覧(初期登録商品2点)ページを表示→OK 商品詳細ページへアクセスすると、システムエラーが表示されます。 index_dev.phpで確認すると以下のエラーが表示されます。 そもそもWEBインストーラーでテーブルが作成されていないのか、よくわかりません。 他の質問も見ましたがアップグレードの方でした。 DBを新規に作り変えてもう一度最初からインストールした方がいいでしょうか? 新規インストールする際は、public_htmlフォルダ以下を全て削除してから新規インストールしております。 どなたかご教授お願いします。。。 SQLSTATE[42S02]: Base table or view not found: 1146 Table 'DB名.plg_checkeditem_dtb_config' doesn't exist at /home/XXX/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:53, Doctrine\\DBAL\\Driver\\PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'DB名.plg_checkeditem_dtb_config' doesn't exist at /home/XXX/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107, PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'DB名.plg_checkeditem_dtb_config' doesn't exist at /home/XXX/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105)"} SQLSTATE[42S02]: Base table or view not found: 1146 Table 'DB名.plg_checkeditem_dtb_config' doesn't exist (uncaught exception) at /home/XXX/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 53 {"exception":"[object] (Doctrine\\DBAL\\Exception\\TableNotFoundException(code: 0): An exception occurred while executing 'SELECT t0.name AS name1, t0.value AS value2 FROM plg_checkeditem_dtb_config t0 WHERE t0.name = ? LIMIT 1' with params [\"term\"]: TableNotFoundException in AbstractMySQLDriver.php line 53: An exception occurred while executing 'SELECT t0.name AS name1, t0.value AS value2 FROM plg_checkeditem_dtb_config t0 WHERE t0.name = ? LIMIT 1' with params ["term"]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'DB名.plg_checkeditem_dtb_config' doesn't exist in AbstractMySQLDriver.php line 53 at AbstractMySQLDriver->convertException('An exception occurred while executing 'SELECT t0.name AS name1, t0.value AS value2 FROM plg_checkeditem_dtb_config t0 WHERE t0.name = ? LIMIT 1' with params ["term"]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'DB名plg_checkeditem_dtb_config' doesn't exist', object(PDOException)) in DBALException.php line 128 at DBALException::driverExceptionDuringQuery(object(Driver), object(PDOException), 'SELECT t0.name AS name1, t0.value AS value2 FROM plg_checkeditem_dtb_config t0 WHERE t0.name = ? LIMIT 1', array('term')) in Connection.php line 855 at Connection->executeQuery('SELECT t0.name AS name1, t0.value AS value2 FROM plg_checkeditem_dtb_config t0 WHERE t0.name = ? LIMIT 1', array('term'), array('text')) in BasicEntityPersister.php line 748 at BasicEntityPersister->load(array('name' => 'term'), null, null, array(), '0', '1', null) in EntityRepository.php line 196 at EntityRepository->findOneBy(array('name' => 'term')) in UtilService.php line 32 at UtilService->getConfig('term') in UtilService.php line 66 at UtilService->setCheckedItem('12', object(Response)) in CheckedItemEvent.php line 41 at CheckedItemEvent->onRenderProductDetail(object(FilterResponseEvent), 'eccube.event.render.product_detail.before', object(EventDispatcher)) at call_user_func(array(object(CheckedItemEvent), 'onRenderProductDetail'), object(FilterResponseEvent), 'eccube.event.render.product_detail.before', object(EventDispatcher)) in EventDispatcher.php line 161 at EventDispatcher->doDispatch(array(array(object(CheckedItemEvent), 'onRenderProductDetail')), 'eccube.event.render.product_detail.before', object(FilterResponseEvent)) in EventDispatcher.php line 46 at EventDispatcher->dispatch('eccube.event.render.product_detail.before', object(FilterResponseEvent)) in Application.php line 744 at Application->Eccube\{closure}(object(FilterResponseEvent), 'kernel.response', object(TraceableEventDispatcher)) at call_user_func(object(Closure), object(FilterResponseEvent), 'kernel.response', object(TraceableEventDispatcher)) in WrappedListener.php line 61 at WrappedListener->__invoke(object(FilterResponseEvent), 'kernel.response', object(EventDispatcher)) at call_user_func(object(WrappedListener), object(FilterResponseEvent), 'kernel.response', object(EventDispatcher)) in EventDispatcher.php line 161 at EventDispatcher->doDispatch(array(object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener)), 'kernel.response', object(FilterResponseEvent)) in EventDispatcher.php line 46 at EventDispatcher->dispatch('kernel.response', object(FilterResponseEvent)) in TraceableEventDispatcher.php line 121 at TraceableEventDispatcher->dispatch('kernel.response', object(FilterResponseEvent)) in HttpKernel.php line 175 at HttpKernel->filterResponse(object(Response), object(Request), '1') in HttpKernel.php line 157 at HttpKernel->handleRaw(object(Request), '1') in HttpKernel.php line 57 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 108 2/3 PDOException in PDOStatement.php line 107: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'DB名.plg_checkeditem_dtb_config' doesn't exist in PDOStatement.php line 107 at PDOStatement->execute() in Connection.php line 847 at Connection->executeQuery('SELECT t0.name AS name1, t0.value AS value2 FROM plg_checkeditem_dtb_config t0 WHERE t0.name = ? LIMIT 1', array('term'), array('text')) in BasicEntityPersister.php line 748 at BasicEntityPersister->load(array('name' => 'term'), null, null, array(), '0', '1', null) in EntityRepository.php line 196 at EntityRepository->findOneBy(array('name' => 'term')) in UtilService.php line 32 at UtilService->getConfig('term') in UtilService.php line 66 at UtilService->setCheckedItem('12', object(Response)) in CheckedItemEvent.php line 41 at CheckedItemEvent->onRenderProductDetail(object(FilterResponseEvent), 'eccube.event.render.product_detail.before', object(EventDispatcher)) at call_user_func(array(object(CheckedItemEvent), 'onRenderProductDetail'), object(FilterResponseEvent), 'eccube.event.render.product_detail.before', object(EventDispatcher)) in EventDispatcher.php line 161 at EventDispatcher->doDispatch(array(array(object(CheckedItemEvent), 'onRenderProductDetail')), 'eccube.event.render.product_detail.before', object(FilterResponseEvent)) in EventDispatcher.php line 46 at EventDispatcher->dispatch('eccube.event.render.product_detail.before', object(FilterResponseEvent)) in Application.php line 744 at Application->Eccube\{closure}(object(FilterResponseEvent), 'kernel.response', object(TraceableEventDispatcher)) at call_user_func(object(Closure), object(FilterResponseEvent), 'kernel.response', object(TraceableEventDispatcher)) in WrappedListener.php line 61 at WrappedListener->__invoke(object(FilterResponseEvent), 'kernel.response', object(EventDispatcher)) at call_user_func(object(WrappedListener), object(FilterResponseEvent), 'kernel.response', object(EventDispatcher)) in EventDispatcher.php line 161 at EventDispatcher->doDispatch(array(object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener)), 'kernel.response', object(FilterResponseEvent)) in EventDispatcher.php line 46 at EventDispatcher->dispatch('kernel.response', object(FilterResponseEvent)) in TraceableEventDispatcher.php line 121 at TraceableEventDispatcher->dispatch('kernel.response', object(FilterResponseEvent)) in HttpKernel.php line 175 at HttpKernel->filterResponse(object(Response), object(Request), '1') in HttpKernel.php line 157 at HttpKernel->handleRaw(object(Request), '1') in HttpKernel.php line 57 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 108 1/3 PDOException in PDOStatement.php line 105: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'DB名.plg_checkeditem_dtb_config' doesn't exist in PDOStatement.php line 105 at PDOStatement->execute(null) in PDOStatement.php line 105 at PDOStatement->execute() in Connection.php line 847 at Connection->executeQuery('SELECT t0.name AS name1, t0.value AS value2 FROM plg_checkeditem_dtb_config t0 WHERE t0.name = ? LIMIT 1', array('term'), array('text')) in BasicEntityPersister.php line 748 at BasicEntityPersister->load(array('name' => 'term'), null, null, array(), '0', '1', null) in EntityRepository.php line 196 at EntityRepository->findOneBy(array('name' => 'term')) in UtilService.php line 32 at UtilService->getConfig('term') in UtilService.php line 66 at UtilService->setCheckedItem('12', object(Response)) in CheckedItemEvent.php line 41 at CheckedItemEvent->onRenderProductDetail(object(FilterResponseEvent), 'eccube.event.render.product_detail.before', object(EventDispatcher)) at call_user_func(array(object(CheckedItemEvent), 'onRenderProductDetail'), object(FilterResponseEvent), 'eccube.event.render.product_detail.before', object(EventDispatcher)) in EventDispatcher.php line 161 at EventDispatcher->doDispatch(array(array(object(CheckedItemEvent), 'onRenderProductDetail')), 'eccube.event.render.product_detail.before', object(FilterResponseEvent)) in EventDispatcher.php line 46 at EventDispatcher->dispatch('eccube.event.render.product_detail.before', object(FilterResponseEvent)) in Application.php line 744 at Application->Eccube\{closure}(object(FilterResponseEvent), 'kernel.response', object(TraceableEventDispatcher)) at call_user_func(object(Closure), object(FilterResponseEvent), 'kernel.response', object(TraceableEventDispatcher)) in WrappedListener.php line 61 at WrappedListener->__invoke(object(FilterResponseEvent), 'kernel.response', object(EventDispatcher)) at call_user_func(object(WrappedListener), object(FilterResponseEvent), 'kernel.response', object(EventDispatcher)) in EventDispatcher.php line 161 at EventDispatcher->doDispatch(array(object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener)), 'kernel.response', object(FilterResponseEvent)) in EventDispatcher.php line 46 at EventDispatcher->dispatch('kernel.response', object(FilterResponseEvent)) in TraceableEventDispatcher.php line 121 at TraceableEventDispatcher->dispatch('kernel.response', object(FilterResponseEvent)) in HttpKernel.php line 175 at HttpKernel->filterResponse(object(Response), object(Request), '1') in HttpKernel.php line 157 at HttpKernel->handleRaw(object(Request), '1') in HttpKernel.php line 57 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 108 |
umebius |
投稿日時: 2021/6/1 18:01
対応状況: −−−
|
神 登録日: 2016/7/22 居住地: 投稿: 2085 |
Re: 商品詳細画面でシステムエラーと表示されます。 最近見た商品プラグインが設置してあるがインストールしていない状態でしょうか?
インストールするか、プラグインのファイルを取り除くとどうでしょうか?
|
yamagata78 |
投稿日時: 2021/6/1 18:45
対応状況: −−−
|
半人前 登録日: 2019/11/25 居住地: 投稿: 29 |
Re: 商品詳細画面でシステムエラーと表示されます。 ありがとうございます。
プラグインが何故か消えてなかった様子です。 消すと無事に表示され、カートに入れる事ができ、お買い物が完了しました。 ただ何故か自動送信メールが送信されない?別のトラブルに見舞わられております。。。。。 |
balisys |
投稿日時: 2023/12/4 17:26
対応状況: −−−
|
仙人 登録日: 2020/7/5 居住地: 投稿: 398 |
Re: 商品詳細画面でシステムエラーと表示されます。 購入のメール送信メソッド内にlogを仕込んでみてはいかがでしょうか。
logを仕込めば、そもそもメール送信処理を通過しているか、どのようなデータを持ってメール送信処理を通過しているかわかるかと思います。 |
スレッド表示 | 新しいものから | 前のトピック | 次のトピック | トップ |