バージョン選択

フォーラム

メニュー

オンライン状況

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

サイト内検索

質問 > フロント機能 > プラグインインストール失敗後、トップページ以外エラー表示になります

フロント機能

新規スレッドを追加する

スレッド表示 | 新しいものから 前のトピック | 次のトピック | 下へ
投稿者 スレッド
SAZABI
投稿日時: 2021/3/2 9:48
対応状況: −−−
常連
登録日: 2019/1/16
居住地:
投稿: 40
プラグインインストール失敗後、トップページ以外エラー表示になります
[EC-CUBE] 4.0.2
[レンタルサーバ] X SERVER
[OS] Windows 10 Pro
[PHP] PHP 7.2.6
[データベース] MySQL 5.7.x
[WEBサーバ] Apache 2.4x
[ブラウザ] Chrome
[導入プラグインの有無] カートリダイレクトプラグイン、ソーシャルボタンを追加、商品タグ機能拡張、商品オプションプラグイン、クロネコヤマトクレジットカード決済モジュール、全体ランキング(販売個数ベース) for EC-CUBE4
[カスタマイズの有無] 無

(現象)
ECCUBEペイメント決済プラグインを導入しようとしたところ、インストールすることは出来たのですが、トップページ以外のページへログインする際にエラー(サイト管理者までご連絡ください)が表示されるようになってしまい大変困っています。
知識が不足している中ではございますが、2年ほど運営してきたサイトですので、非常に困っています。
どなたかお助けいただけないでしょうか。

【ログ】
[2021-03-02 09:41:43] app.DEBUG [N/A] [da1fa20] [anon.] [Eccube\Log\Logger:log:68] - Commit executed. [] [GET, /products/list?category_id=3, 14.13.7.33, https://gaming.sazabies.com/, Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.190 Safari/537.36]
[2021-03-02 09:41:43] app.INFO [N/A] [da1fa20] [anon.] [Eccube\Log\Logger:log:68] - PROCESS END ["product_list"] [GET, /products/list?category_id=3, 14.13.7.33, https://gaming.sazabies.com/, Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.190 Safari/537.36]
[2021-03-02 09:41:43] front.INFO [5b1baa389d636a598ed62df5d35d6ea2] [da1fa20] [anon.] [Eccube\Log\Logger:log:66] - LOGIC END ["product_list"] [GET, /products/list?category_id=3, 14.13.7.33, https://gaming.sazabies.com/, Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.190 Safari/537.36]
[2021-03-02 09:41:43] front.ERROR [5b1baa389d636a598ed62df5d35d6ea2] [da1fa20] [anon.] [Eccube\Log\Logger:log:66] - システムエラーが発生しました。 ["An exception occurred while executing 'SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.note AS note_2, d0_.description_list AS description_list_3, d0_.description_detail AS description_detail_4, d0_.search_word AS search_word_5, d0_.free_area AS free_area_6, d0_.create_date AS create_date_7, d0_.update_date AS update_date_8, d0_.shipping_name AS shipping_name_9, MIN(d1_.price02) AS sclr_10, d0_.discriminator_type AS discriminator_type_11, d0_.creator_id AS creator_id_12, d0_.product_status_id AS product_status_id_13 FROM dtb_product d0_ INNER JOIN dtb_product_category d2_ ON d0_.id = d2_.product_id AND d2_.discriminator_type IN ('productcategory') INNER JOIN dtb_category d3_ ON d2_.category_id = d3_.id AND d3_.discriminator_type IN ('category') INNER JOIN dtb_product_class d1_ ON d0_.id = d1_.product_id AND d1_.discriminator_type IN ('productclass') WHERE (d0_.product_status_id = 1 AND d2_.category_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d1_.visible = 1 AND d0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND d0_.discriminator_type IN ('product') GROUP BY d0_.id ORDER BY sclr_10 ASC, d0_.id DESC' with params [3, 12, 13, 16, 46, 18, 21, 22, 55, 56, 57, \"6\", \"4\", \"38\", \"37\", \"36\", \"35\", \"34\", \"33\", \"32\", \"31\", \"30\", \"29\", \"28\", \"26\", \"25\", \"23\", \"519\", \"383\", \"382\", \"381\"]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'd0_.shipping_name' in 'field list'","/home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php",80,"#0 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(184): Doctrine\\DBAL\\Driver\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\DBAL\\Driver\\PDOException))\n#1 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(158): Doctrine\\DBAL\\DBALException::wrapException(Object(Doctrine\\DBAL\\Driver\\PDOMySql\\Driver), Object(Doctrine\\DBAL\\Driver\\PDOException), 'An exception oc...')\n#2 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(943): Doctrine\\DBAL\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\DBAL\\Driver\\PDOMySql\\Driver), Object(Doctrine\\DBAL\\Driver\\PDOException), 'SELECT d0_.id A...', Array)\n#3 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(987): Doctrine\\DBAL\\Connection->executeQuery('SELECT d0_.id A...', Array, Array)\n#4 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(918): Doctrine\\DBAL\\Connection->executeCacheQuery('SELECT d0_.id A...', Array, Array, Object(Doctrine\\DBAL\\Cache\\QueryCacheProfile))\n#5 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(50): Doctrine\\DBAL\\Connection->executeQuery('SELECT d0_.id A...', Array, Array, Object(Doctrine\\DBAL\\Cache\\QueryCacheProfile))\n#6 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(334): Doctrine\\ORM\\Query\\Exec\\SingleSelectExecutor->execute(Object(Doctrine\\DBAL\\Connection), Array, Array)\n#7 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(957): Doctrine\\ORM\\Query->_doExecute()\n#8 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(912): Doctrine\\ORM\\AbstractQuery->executeIgnoreQueryCache(NULL, 1)\n#9 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(716): Doctrine\\ORM\\AbstractQuery->execute(NULL, 1)\n#10 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php(166): Doctrine\\ORM\\AbstractQuery->getResult(1)\n#11 [internal function]: Doctrine\\ORM\\Tools\\Pagination\\Paginator->getIterator()\n#12 /home/sazabies/sazabies.com/public_html/gaming/vendor/knplabs/knp-components/src/Knp/Component/Pager/Event/Subscriber/Paginate/Doctrine/ORM/QuerySubscriber/UsesPaginator.php(52): iterator_to_array(Object(Doctrine\\ORM\\Tools\\Pagination\\Paginator))\n#13 /home/sazabies/sazabies.com/public_html/gaming/vendor/symfony/event-dispatcher/EventDispatcher.php(212): Knp\\Component\\Pager\\Event\\Subscriber\\Paginate\\Doctrine\\ORM\\QuerySubscriber\\UsesPaginator->items(Object(Knp\\Component\\Pager\\Event\\ItemsEvent), 'knp_pager.items', Object(Symfony\\Component\\EventDispatcher\\ContainerAwareEventDispatcher))\n#14 /home/sazabies/sazabies.com/public_html/gaming/vendor/symfony/event-dispatcher/EventDispatcher.php(44): Symfony\\Component\\EventDispatcher\\EventDispatcher->doDispatch(Array, 'knp_pager.items', Object(Knp\\Component\\Pager\\Event\\ItemsEvent))\n#15 /home/sazabies/sazabies.com/public_html/gaming/vendor/knplabs/knp-components/src/Knp/Component/Pager/Paginator.php(114): Symfony\\Component\\EventDispatcher\\EventDispatcher->dispatch('knp_pager.items', Object(Knp\\Component\\Pager\\Event\\ItemsEvent))\n#16 /home/sazabies/sazabies.com/public_html/gaming/var/cache/prod/Container5lhnjqf/Paginator_f262b94.php(18): Knp\\Component\\Pager\\Paginator->paginate(Object(Doctrine\\ORM\\Query), 1, 20, Array)\n#17 /home/sazabies/sazabies.com/public_html/gaming/src/Eccube/Controller/ProductController.php(169): Paginator_f262b94->paginate(Object(Doctrine\\ORM\\Query), 1, 20)\n#18 /home/sazabies/sazabies.com/public_html/gaming/vendor/symfony/http-kernel/HttpKernel.php(151): Eccube\\Controller\\ProductController->index(Object(Symfony\\Component\\HttpFoundation\\Request), Object(Paginator_f262b94))\n#19 /home/sazabies/sazabies.com/public_html/gaming/vendor/symfony/http-kernel/HttpKernel.php(68): Symfony\\Component\\HttpKernel\\HttpKernel->handleRaw(Object(Symfony\\Component\\HttpFoundation\\Request), 1)\n#20 /home/sazabies/sazabies.com/public_html/gaming/vendor/symfony/http-kernel/Kernel.php(200): Symfony\\Component\\HttpKernel\\HttpKernel->handle(Object(Symfony\\Component\\HttpFoundation\\Request), 1, true)\n#21 /home/sazabies/sazabies.com/public_html/gaming/index.php(79): Symfony\\Component\\HttpKernel\\Kernel->handle(Object(Symfony\\Component\\HttpFoundation\\Request))\n#22 {main}"] [GET, /products/list?category_id=3, 14.13.7.33, https://gaming.sazabies.com/, Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.190 Safari/537.36]
[2021-03-02 09:41:43] front.INFO [5b1baa389d636a598ed62df5d35d6ea2] [da1fa20] [anon.] [Eccube\Log\Logger:log:66] - LOGIC START ["product_list"] [GET, /products/list?category_id=3, 14.13.7.33, https://gaming.sazabies.com/, Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.190 Safari/537.36]
[2021-03-02 09:41:43] front.DEBUG [5b1baa389d636a598ed62df5d35d6ea2] [da1fa20] [anon.] [Eccube\Log\Logger:log:66] - Begin Transaction. [] [GET, /products/list?category_id=3, 14.13.7.33, https://gaming.sazabies.com/, Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.190 Safari/537.36]
[2021-03-02 09:41:43] front.INFO [5b1baa389d636a598ed62df5d35d6ea2] [da1fa20] [anon.] [Eccube\Log\Logger:log:66] - PROCESS START ["product_list"] [GET, /products/list?category_id=3, 14.13.7.33, https://gaming.sazabies.com/, Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.190 Safari/537.36]
[2021-03-02 09:41:43] front.INFO [N/A] [da1fa20] [N/A] [Eccube\Log\Logger:log:66] - INIT [] [GET, /products/list?category_id=3, 14.13.7.33, https://gaming.sazabies.com/, Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.190 Safari/537.36]
[2021-03-02 09:41:41] app.DEBUG [N/A] [4e10eb8] [anon.] [Eccube\Log\Logger:log:68] - Commit executed. [] [GET, /, 14.13.7.33, https://gaming.sazabies.com/products/list?category_id=1, Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.190 Safari/537.36]
[2021-03-02 09:41:41] app.INFO [N/A] [4e10eb8] [anon.] [Eccube\Log\Logger:log:68] - PROCESS END ["homepage"] [GET, /, 14.13.7.33, https://gaming.sazabies.com/products/list?category_id=1, Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.190 Safari/537.36]
[2021-03-02 09:41:41] front.INFO [5b1baa389d636a598ed62df5d35d6ea2] [4e10eb8] [anon.] [Eccube\Log\Logger:log:66] - LOGIC END ["homepage"] [GET, /, 14.13.7.33, https://gaming.sazabies.com/products/list?category_id=1, Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.190 Safari/537.36]
[2021-03-02 09:41:41] front.ERROR [5b1baa389d636a598ed62df5d35d6ea2] [4e10eb8] [anon.] [Eccube\Log\Logger:log:66] - システムエラーが発生しました。 ["An exception occurred while executing 'SELECT t0.id AS id_1, t0.name AS name_2, t0.note AS note_3, t0.description_list AS description_list_4, t0.description_detail AS description_detail_5, t0.search_word AS search_word_6, t0.free_area AS free_area_7, t0.create_date AS create_date_8, t0.update_date AS update_date_9, t0.shipping_name AS shipping_name_10, t0.creator_id AS creator_id_11, t0.product_status_id AS product_status_id_12, t0.discriminator_type FROM dtb_product t0 WHERE t0.id = ? AND t0.discriminator_type IN ('product')' with params [435]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.shipping_name' in 'field list'","/home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php",80,"#0 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(184): Doctrine\\DBAL\\Driver\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\DBAL\\Driver\\PDOException))\n#1 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(158): Doctrine\\DBAL\\DBALException::wrapException(Object(Doctrine\\DBAL\\Driver\\PDOMySql\\Driver), Object(Doctrine\\DBAL\\Driver\\PDOException), 'An exception oc...')\n#2 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(943): Doctrine\\DBAL\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\DBAL\\Driver\\PDOMySql\\Driver), Object(Doctrine\\DBAL\\Driver\\PDOException), 'SELECT t0.id AS...', Array)\n#3 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(733): Doctrine\\DBAL\\Connection->executeQuery('SELECT t0.id AS...', Array, Array)\n#4 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(751): Doctrine\\ORM\\Persisters\\Entity\\BasicEntityPersister->load(Array, NULL)\n#5 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(460): Doctrine\\ORM\\Persisters\\Entity\\BasicEntityPersister->loadById(Array)\n#6 /home/sazabies/sazabies.com/public_html/gaming/var/cache/prod/Container5lhnjqf/EntityManager_9a5be93.php(88): Doctrine\\ORM\\EntityManager->find('Eccube\\\\Entity\\\\P...', Array, NULL, NULL)\n#7 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php(154): EntityManager_9a5be93->find('Eccube\\\\Entity\\\\P...', 435, NULL, NULL)\n#8 /home/sazabies/sazabies.com/public_html/gaming/app/Plugin/SalesRankingB4/Controller/SalesRankingController.php(62): Doctrine\\ORM\\EntityRepository->find(435)\n#9 /home/sazabies/sazabies.com/public_html/gaming/vendor/symfony/http-kernel/HttpKernel.php(151): Plugin\\SalesRankingB4\\Controller\\SalesRankingController->index(Object(Plugin\\SalesRankingB4\\Repository\\SalesRankingConfigRepository))\n#10 /home/sazabies/sazabies.com/public_html/gaming/vendor/symfony/http-kernel/HttpKernel.php(68): Symfony\\Component\\HttpKernel\\HttpKernel->handleRaw(Object(Symfony\\Component\\HttpFoundation\\Request), 2)\n#11 /home/sazabies/sazabies.com/public_html/gaming/vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(102): Symfony\\Component\\HttpKernel\\HttpKernel->handle(Object(Symfony\\Component\\HttpFoundation\\Request), 2, false)\n#12 /home/sazabies/sazabies.com/public_html/gaming/vendor/symfony/http-kernel/Fragment/InlineFragmentRenderer.php(80): Symfony\\Component\\HttpKernel\\HttpCache\\SubRequestHandler::handle(Object(Symfony\\Component\\HttpKernel\\HttpKernel), Object(Symfony\\Component\\HttpFoundation\\Request), 2, false)\n#13 /home/sazabies/sazabies.com/public_html/gaming/vendor/symfony/http-kernel/Fragment/FragmentHandler.php(87): Symfony\\Component\\HttpKernel\\Fragment\\InlineFragmentRenderer->render('/block/sales_ra...', Object(Symfony\\Component\\HttpFoundation\\Request), Array)\n#14 /home/sazabies/sazabies.com/public_html/gaming/vendor/symfony/http-kernel/DependencyInjection/LazyLoadingFragmentHandler.php(77): Symfony\\Component\\HttpKernel\\Fragment\\FragmentHandler->render('/block/sales_ra...', 'inline', Array)\n#15 /home/sazabies/sazabies.com/public_html/gaming/vendor/symfony/twig-bridge/Extension/HttpKernelRuntime.php(46): Symfony\\Component\\HttpKernel\\DependencyInjection\\LazyLoadingFragmentHandler->render('/block/sales_ra...', 'inline', Array)\n#16 /home/sazabies/sazabies.com/public_html/gaming/var/cache/prod/twig/2f/2f11a1f2cb6215feed567f928e0b9ca5b2c8587dbb22ab67114f5b9b119bf444.php(35): Symfony\\Bridge\\Twig\\Extension\\HttpKernelRuntime->renderFragment('/block/sales_ra...')\n#17 /home/sazabies/sazabies.com/public_html/gaming/vendor/twig/twig/lib/Twig/Template.php(390): __TwigTemplate_257dc3bc551b2008c23f9b0884dbd30c599f130114a38af6c2613741ca4e7230->doDisplay(Array, Array)\n#18 /home/sazabies/sazabies.com/public_html/gaming/vendor/twig/twig/lib/Twig/Template.php(367): Twig_Template->displayWithErrorHandling(Array, Array)\n#19 /home/sazabies/sazabies.com/public_html/gaming/vendor/twig/twig/lib/Twig/Template.php(375): Twig_Template->display(Array)\n#20 /home/sazabies/sazabies.com/public_html/gaming/vendor/twig/twig/lib/Twig/Extension/Core.php(1326): Twig_Template->render(Array)\n#21 /home/sazabies/sazabies.com/public_html/gaming/var/cache/prod/twig/47/47a398bbd8abd1ec731307da8db6c6c14323d6b30849fe59dcf72ef3e4be44a5.php(256): twig_include(Object(Twig_Environment), Array, 'block.twig', Array)\n#22 /home/sazabies/sazabies.com/public_html/gaming/vendor/twig/twig/lib/Twig/Template.php(390): __TwigTemplate_d61fac71ab345db5e7ed92b7e340557495fda30f76c4bb7f1ecdd659521eb7b1->doDisplay(Array, Array)\n#23 /home/sazabies/sazabies.com/public_html/gaming/vendor/twig/twig/lib/Twig/Template.php(367): Twig_Template->displayWithErrorHandling(Array, Array)\n#24 /home/sazabies/sazabies.com/public_html/gaming/var/cache/prod/twig/80/8098e2af90b3d637ec5b5a124bc3c29784e1d55279302168702d4797dbf1a723.php(33): Twig_Template->display(Array, Array)\n#25 /home/sazabies/sazabies.com/public_html/gaming/vendor/twig/twig/lib/Twig/Template.php(390): __TwigTemplate_55084e69b225edcd9607c5193eb4f593f1e1a2c445cffa5fdd9f109362a93ad1->doDisplay(Array, Array)\n#26 /home/sazabies/sazabies.com/public_html/gaming/vendor/twig/twig/lib/Twig/Template.php(367): Twig_Template->displayWithErrorHandling(Array, Array)\n#27 /home/sazabies/sazabies.com/public_html/gaming/vendor/twig/twig/lib/Twig/Template.php(375): Twig_Template->display(Array)\n#28 /home/sazabies/sazabies.com/public_html/gaming/src/Eccube/Twig/Environment.php(54): Twig_Template->render(Array)\n#29 /home/sazabies/sazabies.com/public_html/gaming/vendor/sensio/framework-extra-bundle/EventListener/TemplateListener.php(103): Eccube\\Twig\\Environment->render('index.twig', Array)\n#30 /home/sazabies/sazabies.com/public_html/gaming/vendor/symfony/event-dispatcher/EventDispatcher.php(212): Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\TemplateListener->onKernelView(Object(Symfony\\Component\\HttpKernel\\Event\\GetResponseForControllerResultEvent), 'kernel.view', Object(Symfony\\Component\\EventDispatcher\\ContainerAwareEventDispatcher))\n#31 /home/sazabies/sazabies.com/public_html/gaming/vendor/symfony/event-dispatcher/EventDispatcher.php(44): Symfony\\Component\\EventDispatcher\\EventDispatcher->doDispatch(Array, 'kernel.view', Object(Symfony\\Component\\HttpKernel\\Event\\GetResponseForControllerResultEvent))\n#32 /home/sazabies/sazabies.com/public_html/gaming/vendor/symfony/http-kernel/HttpKernel.php(156): Symfony\\Component\\EventDispatcher\\EventDispatcher->dispatch('kernel.view', Object(Symfony\\Component\\HttpKernel\\Event\\GetResponseForControllerResultEvent))\n#33 /home/sazabies/sazabies.com/public_html/gaming/vendor/symfony/http-kernel/HttpKernel.php(68): Symfony\\Component\\HttpKernel\\HttpKernel->handleRaw(Object(Symfony\\Component\\HttpFoundation\\Request), 1)\n#34 /home/sazabies/sazabies.com/public_html/gaming/vendor/symfony/http-kernel/Kernel.php(200): Symfony\\Component\\HttpKernel\\HttpKernel->handle(Object(Symfony\\Component\\HttpFoundation\\Request), 1, true)\n#35 /home/sazabies/sazabies.com/public_html/gaming/index.php(79): Symfony\\Component\\HttpKernel\\Kernel->handle(Object(Symfony\\Component\\HttpFoundation\\Request))\n#36 {main}"] [GET, /, 14.13.7.33, https://gaming.sazabies.com/products/list?category_id=1, Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.190 Safari/537.36]
[2021-03-02 09:41:41] php.INFO [5b1baa389d636a598ed62df5d35d6ea2] [4e10eb8] [anon.] [Symfony\Component\Debug\ErrorHandler:handleError:523] - User Deprecated: The "Eccube\Repository\ProductRepository" service is private, getting it from the container is deprecated since Symfony 3.2 and will fail in 4.0. You should either make the service public, or stop using the container directly and use dependency injection instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: The \"Eccube\\Repository\\ProductRepository\" service is private, getting it from the container is deprecated since Symfony 3.2 and will fail in 4.0. You should either make the service public, or stop using the container directly and use dependency injection instead. at /home/sazabies/sazabies.com/public_html/gaming/vendor/symfony/dependency-injection/Container.php:282)"} [GET, /, 14.13.7.33, https://gaming.sazabies.com/products/list?category_id=1, Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.190 Safari/537.36]
[2021-03-02 09:41:41] php.INFO [5b1baa389d636a598ed62df5d35d6ea2] [4e10eb8] [anon.] [Symfony\Component\Debug\ErrorHandler:handleError:523] - User Deprecated: The "Eccube\Repository\OrderItemRepository" service is private, getting it from the container is deprecated since Symfony 3.2 and will fail in 4.0. You should either make the service public, or stop using the container directly and use dependency injection instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: The \"Eccube\\Repository\\OrderItemRepository\" service is private, getting it from the container is deprecated since Symfony 3.2 and will fail in 4.0. You should either make the service public, or stop using the container directly and use dependency injection instead. at /home/sazabies/sazabies.com/public_html/gaming/vendor/symfony/dependency-injection/Container.php:282)"} [GET, /, 14.13.7.33, https://gaming.sazabies.com/products/list?category_id=1, Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.190 Safari/537.36]
[2021-03-02 09:41:41] front.INFO [5b1baa389d636a598ed62df5d35d6ea2] [4e10eb8] [anon.] [Eccube\Log\Logger:log:66] - LOGIC START ["homepage"] [GET, /, 14.13.7.33, https://gaming.sazabies.com/products/list?category_id=1, Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.190 Safari/537.36]
[2021-03-02 09:41:41] front.DEBUG [5b1baa389d636a598ed62df5d35d6ea2] [4e10eb8] [anon.] [Eccube\Log\Logger:log:66] - Begin Transaction. [] [GET, /, 14.13.7.33, https://gaming.sazabies.com/products/list?category_id=1, Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.190 Safari/537.36]
[2021-03-02 09:41:41] front.INFO [5b1baa389d636a598ed62df5d35d6ea2] [4e10eb8] [anon.] [Eccube\Log\Logger:log:66] - PROCESS START ["homepage"] [GET, /, 14.13.7.33, https://gaming.sazabies.com/products/list?category_id=1, Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.190 Safari/537.36]
[2021-03-02 09:41:41] front.INFO [N/A] [4e10eb8] [N/A] [Eccube\Log\Logger:log:66] - INIT [] [GET, /, 14.13.7.33, https://gaming.sazabies.com/products/list?category_id=1, Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.190 Safari/537.36]
[2021-03-02 09:41:33] app.INFO [N/A] [f1863a6] [1] [Eccube\Log\Logger:log:68] - PROCESS END ["admin_setting_system_log"] [POST, /kanri/setting/system/log, 14.13.7.33, https://gaming.sazabies.com/kanri/setting/system/log, Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.190 Safari/537.36]
[2021-03-02 09:41:31] app.DEBUG [N/A] [f8cdb4a] [anon.] [Eccube\Log\Logger:log:68] - Commit executed. [] [GET, /products/detail/374, 18.210.12.229, NULL, CCBot/2.0 (https://commoncrawl.org/faq/)]
[2021-03-02 09:41:31] app.INFO [N/A] [f8cdb4a] [anon.] [Eccube\Log\Logger:log:68] - PROCESS END ["product_detail"] [GET, /products/detail/374, 18.210.12.229, NULL, CCBot/2.0 (https://commoncrawl.org/faq/)]
[2021-03-02 09:41:31] front.INFO [N/A] [f8cdb4a] [anon.] [Eccube\Log\Logger:log:66] - LOGIC END ["product_detail"] [GET, /products/detail/374, 18.210.12.229, NULL, CCBot/2.0 (https://commoncrawl.org/faq/)]
[2021-03-02 09:41:31] front.ERROR [N/A] [f8cdb4a] [anon.] [Eccube\Log\Logger:log:66] - システムエラーが発生しました。 ["An exception occurred while executing 'SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.note AS note_2, d0_.description_list AS description_list_3, d0_.description_detail AS description_detail_4, d0_.search_word AS search_word_5, d0_.free_area AS free_area_6, d0_.create_date AS create_date_7, d0_.update_date AS update_date_8, d0_.shipping_name AS shipping_name_9, d1_.id AS id_10, d1_.product_code AS product_code_11, d1_.stock AS stock_12, d1_.stock_unlimited AS stock_unlimited_13, d1_.sale_limit AS sale_limit_14, d1_.price01 AS price01_15, d1_.price02 AS price02_16, d1_.delivery_fee AS delivery_fee_17, d1_.visible AS visible_18, d1_.create_date AS create_date_19, d1_.update_date AS update_date_20, d1_.currency_code AS currency_code_21, d1_.point_rate AS point_rate_22, d2_.id AS id_23, d2_.backend_name AS backend_name_24, d2_.name AS name_25, d2_.sort_no AS sort_no_26, d2_.visible AS visible_27, d2_.create_date AS create_date_28, d2_.update_date AS update_date_29, d3_.id AS id_30, d3_.backend_name AS backend_name_31, d3_.name AS name_32, d3_.sort_no AS sort_no_33, d3_.visible AS visible_34, d3_.create_date AS create_date_35, d3_.update_date AS update_date_36, d4_.id AS id_37, d4_.file_name AS file_name_38, d4_.sort_no AS sort_no_39, d4_.create_date AS create_date_40, d5_.id AS id_41, d5_.create_date AS create_date_42, d0_.discriminator_type AS discriminator_type_43, d0_.creator_id AS creator_id_44, d0_.product_status_id AS product_status_id_45, d1_.discriminator_type AS discriminator_type_46, d1_.product_id AS product_id_47, d1_.sale_type_id AS sale_type_id_48, d1_.class_category_id1 AS class_category_id1_49, d1_.class_category_id2 AS class_category_id2_50, d1_.delivery_duration_id AS delivery_duration_id_51, d1_.creator_id AS creator_id_52, d2_.discriminator_type AS discriminator_type_53, d2_.class_name_id AS class_name_id_54, d2_.creator_id AS creator_id_55, d3_.discriminator_type AS discriminator_type_56, d3_.class_name_id AS class_name_id_57, d3_.creator_id AS creator_id_58, d4_.discriminator_type AS discriminator_type_59, d4_.product_id AS product_id_60, d4_.creator_id AS creator_id_61, d5_.discriminator_type AS discriminator_type_62, d5_.product_id AS product_id_63, d5_.tag_id AS tag_id_64, d5_.creator_id AS creator_id_65 FROM dtb_product d0_ INNER JOIN dtb_product_class d1_ ON d0_.id = d1_.product_id AND d1_.discriminator_type IN ('productclass') LEFT JOIN dtb_class_category d2_ ON d1_.class_category_id1 = d2_.id AND d2_.discriminator_type IN ('classcategory') LEFT JOIN dtb_class_category d3_ ON d1_.class_category_id2 = d3_.id AND d3_.discriminator_type IN ('classcategory') LEFT JOIN dtb_product_image d4_ ON d0_.id = d4_.product_id AND d4_.discriminator_type IN ('productimage') LEFT JOIN dtb_product_tag d5_ ON d0_.id = d5_.product_id AND d5_.discriminator_type IN ('producttag') WHERE (d0_.id = ? AND d1_.visible = ?) AND d0_.discriminator_type IN ('product') ORDER BY d2_.sort_no DESC, d3_.sort_no DESC, d4_.sort_no ASC' with params [\"374\", 1]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'd0_.shipping_name' in 'field list'","/home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php",80,"#0 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(184): Doctrine\\DBAL\\Driver\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\DBAL\\Driver\\PDOException))\n#1 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(158): Doctrine\\DBAL\\DBALException::wrapException(Object(Doctrine\\DBAL\\Driver\\PDOMySql\\Driver), Object(Doctrine\\DBAL\\Driver\\PDOException), 'An exception oc...')\n#2 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(943): Doctrine\\DBAL\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\DBAL\\Driver\\PDOMySql\\Driver), Object(Doctrine\\DBAL\\Driver\\PDOException), 'SELECT d0_.id A...', Array)\n#3 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(50): Doctrine\\DBAL\\Connection->executeQuery('SELECT d0_.id A...', Array, Array, NULL)\n#4 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(334): Doctrine\\ORM\\Query\\Exec\\SingleSelectExecutor->execute(Object(Doctrine\\DBAL\\Connection), Array, Array)\n#5 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(957): Doctrine\\ORM\\Query->_doExecute()\n#6 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(912): Doctrine\\ORM\\AbstractQuery->executeIgnoreQueryCache(NULL, NULL)\n#7 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(793): Doctrine\\ORM\\AbstractQuery->execute(NULL, NULL)\n#8 /home/sazabies/sazabies.com/public_html/gaming/src/Eccube/Repository/ProductRepository.php(84): Doctrine\\ORM\\AbstractQuery->getSingleResult()\n#9 /home/sazabies/sazabies.com/public_html/gaming/vendor/sensio/framework-extra-bundle/Request/ParamConverter/DoctrineParamConverter.php(122): Eccube\\Repository\\ProductRepository->findWithSortedClassCategories('374')\n#10 /home/sazabies/sazabies.com/public_html/gaming/vendor/sensio/framework-extra-bundle/Request/ParamConverter/DoctrineParamConverter.php(71): Sensio\\Bundle\\FrameworkExtraBundle\\Request\\ParamConverter\\DoctrineParamConverter->find('Eccube\\\\Entity\\\\P...', Object(Symfony\\Component\\HttpFoundation\\Request), Array, 'Product')\n#11 /home/sazabies/sazabies.com/public_html/gaming/vendor/sensio/framework-extra-bundle/Request/ParamConverter/ParamConverterManager.php(92): Sensio\\Bundle\\FrameworkExtraBundle\\Request\\ParamConverter\\DoctrineParamConverter->apply(Object(Symfony\\Component\\HttpFoundation\\Request), Object(Sensio\\Bundle\\FrameworkExtraBundle\\Configuration\\ParamConverter))\n#12 /home/sazabies/sazabies.com/public_html/gaming/vendor/sensio/framework-extra-bundle/Request/ParamConverter/ParamConverterManager.php(48): Sensio\\Bundle\\FrameworkExtraBundle\\Request\\ParamConverter\\ParamConverterManager->applyConverter(Object(Symfony\\Component\\HttpFoundation\\Request), Object(Sensio\\Bundle\\FrameworkExtraBundle\\Configuration\\ParamConverter))\n#13 /home/sazabies/sazabies.com/public_html/gaming/vendor/sensio/framework-extra-bundle/EventListener/ParamConverterListener.php(78): Sensio\\Bundle\\FrameworkExtraBundle\\Request\\ParamConverter\\ParamConverterManager->apply(Object(Symfony\\Component\\HttpFoundation\\Request), Array)\n#14 /home/sazabies/sazabies.com/public_html/gaming/vendor/symfony/event-dispatcher/EventDispatcher.php(212): Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\ParamConverterListener->onKernelController(Object(Symfony\\Component\\HttpKernel\\Event\\FilterControllerEvent), 'kernel.controll...', Object(Symfony\\Component\\EventDispatcher\\ContainerAwareEventDispatcher))\n#15 /home/sazabies/sazabies.com/public_html/gaming/vendor/symfony/event-dispatcher/EventDispatcher.php(44): Symfony\\Component\\EventDispatcher\\EventDispatcher->doDispatch(Array, 'kernel.controll...', Object(Symfony\\Component\\HttpKernel\\Event\\FilterControllerEvent))\n#16 /home/sazabies/sazabies.com/public_html/gaming/vendor/symfony/http-kernel/HttpKernel.php(139): Symfony\\Component\\EventDispatcher\\EventDispatcher->dispatch('kernel.controll...', Object(Symfony\\Component\\HttpKernel\\Event\\FilterControllerEvent))\n#17 /home/sazabies/sazabies.com/public_html/gaming/vendor/symfony/http-kernel/HttpKernel.php(68): Symfony\\Component\\HttpKernel\\HttpKernel->handleRaw(Object(Symfony\\Component\\HttpFoundation\\Request), 1)\n#18 /home/sazabies/sazabies.com/public_html/gaming/vendor/symfony/http-kernel/Kernel.php(200): Symfony\\Component\\HttpKernel\\HttpKernel->handle(Object(Symfony\\Component\\HttpFoundation\\Request), 1, true)\n#19 /home/sazabies/sazabies.com/public_html/gaming/index.php(79): Symfony\\Component\\HttpKernel\\Kernel->handle(Object(Symfony\\Component\\HttpFoundation\\Request))\n#20 {main}"] [GET, /products/detail/374, 18.210.12.229, NULL, CCBot/2.0 (https://commoncrawl.org/faq/)]
[2021-03-02 09:41:31] php.INFO [N/A] [f8cdb4a] [anon.] [Symfony\Component\Debug\ErrorHandler:handleError:523] - User Deprecated: The repository_method option of @ParamConverter is deprecated and will be removed in 6.0. Use the expr option or @Entity. {"exception":"[object] (ErrorException(code: 0): User Deprecated: The repository_method option of @ParamConverter is deprecated and will be removed in 6.0. Use the expr option or @Entity. at /home/sazabies/sazabies.com/public_html/gaming/vendor/sensio/framework-extra-bundle/Request/ParamConverter/DoctrineParamConverter.php:296)"} [GET, /products/detail/374, 18.210.12.229, NULL, CCBot/2.0 (https://commoncrawl.org/faq/)]
[2021-03-02 09:41:31] php.INFO [N/A] [f8cdb4a] [anon.] [Symfony\Component\Debug\ErrorHandler:handleError:523] - User Deprecated: The repository_method option of @ParamConverter is deprecated and will be removed in 6.0. Use the expr option or @Entity. {"exception":"[object] (ErrorException(code: 0): User Deprecated: The repository_method option of @ParamConverter is deprecated and will be removed in 6.0. Use the expr option or @Entity. at /home/sazabies/sazabies.com/public_html/gaming/vendor/sensio/framework-extra-bundle/Request/ParamConverter/DoctrineParamConverter.php:296)"} [GET, /products/detail/374, 18.210.12.229, NULL, CCBot/2.0 (https://commoncrawl.org/faq/)]
[2021-03-02 09:41:31] front.INFO [N/A] [f8cdb4a] [anon.] [Eccube\Log\Logger:log:66] - LOGIC START ["product_detail"] [GET, /products/detail/374, 18.210.12.229, NULL, CCBot/2.0 (https://commoncrawl.org/faq/)]
[2021-03-02 09:41:31] front.DEBUG [N/A] [f8cdb4a] [anon.] [Eccube\Log\Logger:log:66] - Begin Transaction. [] [GET, /products/detail/374, 18.210.12.229, NULL, CCBot/2.0 (https://commoncrawl.org/faq/)]
[2021-03-02 09:41:31] front.INFO [N/A] [f8cdb4a] [anon.] [Eccube\Log\Logger:log:66] - PROCESS START ["product_detail"] [GET, /products/detail/374, 18.210.12.229, NULL, CCBot/2.0 (https://commoncrawl.org/faq/)]
[2021-03-02 09:41:31] front.INFO [N/A] [f8cdb4a] [N/A] [Eccube\Log\Logger:log:66] - INIT [] [GET, /products/detail/374, 18.210.12.229, NULL, CCBot/2.0 (https://commoncrawl.org/faq/)]
[2021-03-02 09:41:29] app.INFO [N/A] [00610b9] [1] [Eccube\Log\Logger:log:68] - PROCESS END ["admin_setting_system_log"] [POST, /kanri/setting/system/log, 14.13.7.33, https://gaming.sazabies.com/kanri/setting/system/log, Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.190 Safari/537.36]
[2021-03-02 09:41:27] app.INFO [N/A] [7dfd376] [1] [Eccube\Log\Logger:log:68] - PROCESS END ["admin_setting_system_log"] [GET, /kanri/setting/system/log, 14.13.7.33, https://gaming.sazabies.com/kanri/store/plugin, Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.190 Safari/537.36]
[2021-03-02 09:41:25] app.DEBUG [N/A] [0ec8b28] [anon.] [Eccube\Log\Logger:log:68] - Commit executed. [] [GET, /products/list?category_id=57, 157.55.39.128, NULL, Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)]
[2021-03-02 09:41:25] app.INFO [N/A] [0ec8b28] [anon.] [Eccube\Log\Logger:log:68] - PROCESS END ["product_list"] [GET, /products/list?category_id=57, 157.55.39.128, NULL, Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)]
[2021-03-02 09:41:25] front.INFO [N/A] [0ec8b28] [anon.] [Eccube\Log\Logger:log:66] - LOGIC END ["product_list"] [GET, /products/list?category_id=57, 157.55.39.128, NULL, Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)]
[2021-03-02 09:41:25] front.ERROR [N/A] [0ec8b28] [anon.] [Eccube\Log\Logger:log:66] - システムエラーが発生しました。 ["An exception occurred while executing 'SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.note AS note_2, d0_.description_list AS description_list_3, d0_.description_detail AS description_detail_4, d0_.search_word AS search_word_5, d0_.free_area AS free_area_6, d0_.create_date AS create_date_7, d0_.update_date AS update_date_8, d0_.shipping_name AS shipping_name_9, MIN(d1_.price02) AS sclr_10, d0_.discriminator_type AS discriminator_type_11, d0_.creator_id AS creator_id_12, d0_.product_status_id AS product_status_id_13 FROM dtb_product d0_ INNER JOIN dtb_product_category d2_ ON d0_.id = d2_.product_id AND d2_.discriminator_type IN ('productcategory') INNER JOIN dtb_category d3_ ON d2_.category_id = d3_.id AND d3_.discriminator_type IN ('category') INNER JOIN dtb_product_class d1_ ON d0_.id = d1_.product_id AND d1_.discriminator_type IN ('productclass') WHERE (d0_.product_status_id = 1 AND d2_.category_id IN (?) AND d1_.visible = 1 AND d0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND d0_.discriminator_type IN ('product') GROUP BY d0_.id ORDER BY sclr_10 ASC, d0_.id DESC' with params [57, \"591\", \"590\", \"589\", \"588\", \"587\", \"586\", \"585\", \"584\", \"583\", \"582\", \"581\", \"580\", \"579\", \"578\", \"577\", \"576\", \"575\", \"574\", \"573\", \"572\"]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'd0_.shipping_name' in 'field list'","/home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php",80,"#0 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(184): Doctrine\\DBAL\\Driver\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\DBAL\\Driver\\PDOException))\n#1 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(158): Doctrine\\DBAL\\DBALException::wrapException(Object(Doctrine\\DBAL\\Driver\\PDOMySql\\Driver), Object(Doctrine\\DBAL\\Driver\\PDOException), 'An exception oc...')\n#2 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(943): Doctrine\\DBAL\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\DBAL\\Driver\\PDOMySql\\Driver), Object(Doctrine\\DBAL\\Driver\\PDOException), 'SELECT d0_.id A...', Array)\n#3 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(987): Doctrine\\DBAL\\Connection->executeQuery('SELECT d0_.id A...', Array, Array)\n#4 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(918): Doctrine\\DBAL\\Connection->executeCacheQuery('SELECT d0_.id A...', Array, Array, Object(Doctrine\\DBAL\\Cache\\QueryCacheProfile))\n#5 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(50): Doctrine\\DBAL\\Connection->executeQuery('SELECT d0_.id A...', Array, Array, Object(Doctrine\\DBAL\\Cache\\QueryCacheProfile))\n#6 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(334): Doctrine\\ORM\\Query\\Exec\\SingleSelectExecutor->execute(Object(Doctrine\\DBAL\\Connection), Array, Array)\n#7 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(957): Doctrine\\ORM\\Query->_doExecute()\n#8 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(912): Doctrine\\ORM\\AbstractQuery->executeIgnoreQueryCache(NULL, 1)\n#9 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(716): Doctrine\\ORM\\AbstractQuery->execute(NULL, 1)\n#10 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php(166): Doctrine\\ORM\\AbstractQuery->getResult(1)\n#11 [internal function]: Doctrine\\ORM\\Tools\\Pagination\\Paginator->getIterator()\n#12 /home/sazabies/sazabies.com/public_html/gaming/vendor/knplabs/knp-components/src/Knp/Component/Pager/Event/Subscriber/Paginate/Doctrine/ORM/QuerySubscriber/UsesPaginator.php(52): iterator_to_array(Object(Doctrine\\ORM\\Tools\\Pagination\\Paginator))\n#13 /home/sazabies/sazabies.com/public_html/gaming/vendor/symfony/event-dispatcher/EventDispatcher.php(212): Knp\\Component\\Pager\\Event\\Subscriber\\Paginate\\Doctrine\\ORM\\QuerySubscriber\\UsesPaginator->items(Object(Knp\\Component\\Pager\\Event\\ItemsEvent), 'knp_pager.items', Object(Symfony\\Component\\EventDispatcher\\ContainerAwareEventDispatcher))\n#14 /home/sazabies/sazabies.com/public_html/gaming/vendor/symfony/event-dispatcher/EventDispatcher.php(44): Symfony\\Component\\EventDispatcher\\EventDispatcher->doDispatch(Array, 'knp_pager.items', Object(Knp\\Component\\Pager\\Event\\ItemsEvent))\n#15 /home/sazabies/sazabies.com/public_html/gaming/vendor/knplabs/knp-components/src/Knp/Component/Pager/Paginator.php(114): Symfony\\Component\\EventDispatcher\\EventDispatcher->dispatch('knp_pager.items', Object(Knp\\Component\\Pager\\Event\\ItemsEvent))\n#16 /home/sazabies/sazabies.com/public_html/gaming/var/cache/prod/Container5lhnjqf/Paginator_f262b94.php(18): Knp\\Component\\Pager\\Paginator->paginate(Object(Doctrine\\ORM\\Query), 1, 20, Array)\n#17 /home/sazabies/sazabies.com/public_html/gaming/src/Eccube/Controller/ProductController.php(169): Paginator_f262b94->paginate(Object(Doctrine\\ORM\\Query), 1, 20)\n#18 /home/sazabies/sazabies.com/public_html/gaming/vendor/symfony/http-kernel/HttpKernel.php(151): Eccube\\Controller\\ProductController->index(Object(Symfony\\Component\\HttpFoundation\\Request), Object(Paginator_f262b94))\n#19 /home/sazabies/sazabies.com/public_html/gaming/vendor/symfony/http-kernel/HttpKernel.php(68): Symfony\\Component\\HttpKernel\\HttpKernel->handleRaw(Object(Symfony\\Component\\HttpFoundation\\Request), 1)\n#20 /home/sazabies/sazabies.com/public_html/gaming/vendor/symfony/http-kernel/Kernel.php(200): Symfony\\Component\\HttpKernel\\HttpKernel->handle(Object(Symfony\\Component\\HttpFoundation\\Request), 1, true)\n#21 /home/sazabies/sazabies.com/public_html/gaming/index.php(79): Symfony\\Component\\HttpKernel\\Kernel->handle(Object(Symfony\\Component\\HttpFoundation\\Request))\n#22 {main}"] [GET, /products/list?category_id=57, 157.55.39.128, NULL, Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)]
[2021-03-02 09:41:25] front.INFO [N/A] [0ec8b28] [anon.] [Eccube\Log\Logger:log:66] - LOGIC START ["product_list"] [GET, /products/list?category_id=57, 157.55.39.128, NULL, Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)]
[2021-03-02 09:41:25] front.DEBUG [N/A] [0ec8b28] [anon.] [Eccube\Log\Logger:log:66] - Begin Transaction. [] [GET, /products/list?category_id=57, 157.55.39.128, NULL, Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)]
[2021-03-02 09:41:25] front.INFO [N/A] [0ec8b28] [anon.] [Eccube\Log\Logger:log:66] - PROCESS START ["product_list"] [GET, /products/list?category_id=57, 157.55.39.128, NULL, Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)]
[2021-03-02 09:41:25] front.INFO [N/A] [0ec8b28] [N/A] [Eccube\Log\Logger:log:66] - INIT [] [GET, /products/list?category_id=57, 157.55.39.128, NULL, Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)]
[2021-03-02 09:40:20] app.DEBUG [N/A] [985cb2e] [anon.] [Eccube\Log\Logger:log:68] - Commit executed. [] [GET, /products/list?category_id=8, 36.11.228.220, https://gaming.sazabies.com/, Mozilla/5.0 (Linux; Android 10; SCV43-u) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.181 Mobile Safari/537.36]
[2021-03-02 09:40:20] app.INFO [N/A] [985cb2e] [anon.] [Eccube\Log\Logger:log:68] - PROCESS END ["product_list"] [GET, /products/list?category_id=8, 36.11.228.220, https://gaming.sazabies.com/, Mozilla/5.0 (Linux; Android 10; SCV43-u) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.181 Mobile Safari/537.36]
[2021-03-02 09:40:20] front.INFO [f04b2e5398140d282a6743d2fab2fbea] [985cb2e] [anon.] [Eccube\Log\Logger:log:66] - LOGIC END ["product_list"] [GET, /products/list?category_id=8, 36.11.228.220, https://gaming.sazabies.com/, Mozilla/5.0 (Linux; Android 10; SCV43-u) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.181 Mobile Safari/537.36]
[2021-03-02 09:40:20] front.ERROR [f04b2e5398140d282a6743d2fab2fbea] [985cb2e] [anon.] [Eccube\Log\Logger:log:66] - システムエラーが発生しました。 ["An exception occurred while executing 'SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.note AS note_2, d0_.description_list AS description_list_3, d0_.description_detail AS description_detail_4, d0_.search_word AS search_word_5, d0_.free_area AS free_area_6, d0_.create_date AS create_date_7, d0_.update_date AS update_date_8, d0_.shipping_name AS shipping_name_9, MIN(d1_.price02) AS sclr_10, d0_.discriminator_type AS discriminator_type_11, d0_.creator_id AS creator_id_12, d0_.product_status_id AS product_status_id_13 FROM dtb_product d0_ INNER JOIN dtb_product_category d2_ ON d0_.id = d2_.product_id AND d2_.discriminator_type IN ('productcategory') INNER JOIN dtb_category d3_ ON d2_.category_id = d3_.id AND d3_.discriminator_type IN ('category') INNER JOIN dtb_product_class d1_ ON d0_.id = d1_.product_id AND d1_.discriminator_type IN ('productclass') WHERE (d0_.product_status_id = 1 AND d2_.category_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d1_.visible = 1 AND d0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND d0_.discriminator_type IN ('product') GROUP BY d0_.id ORDER BY sclr_10 ASC, d0_.id DESC' with params [8, 15, 14, 29, 47, 27, 24, 23, 52, 53, 54, \"7\", \"5\", \"88\", \"87\", \"206\", \"99\", \"98\", \"97\", \"95\", \"94\", \"93\", \"92\", \"91\", \"90\", \"610\", \"609\", \"608\", \"607\", \"494\", \"493\"]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'd0_.shipping_name' in 'field list'","/home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php",80,"#0 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(184): Doctrine\\DBAL\\Driver\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\DBAL\\Driver\\PDOException))\n#1 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(158): Doctrine\\DBAL\\DBALException::wrapException(Object(Doctrine\\DBAL\\Driver\\PDOMySql\\Driver), Object(Doctrine\\DBAL\\Driver\\PDOException), 'An exception oc...')\n#2 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(943): Doctrine\\DBAL\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\DBAL\\Driver\\PDOMySql\\Driver), Object(Doctrine\\DBAL\\Driver\\PDOException), 'SELECT d0_.id A...', Array)\n#3 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(987): Doctrine\\DBAL\\Connection->executeQuery('SELECT d0_.id A...', Array, Array)\n#4 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(918): Doctrine\\DBAL\\Connection->executeCacheQuery('SELECT d0_.id A...', Array, Array, Object(Doctrine\\DBAL\\Cache\\QueryCacheProfile))\n#5 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(50): Doctrine\\DBAL\\Connection->executeQuery('SELECT d0_.id A...', Array, Array, Object(Doctrine\\DBAL\\Cache\\QueryCacheProfile))\n#6 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(334): Doctrine\\ORM\\Query\\Exec\\SingleSelectExecutor->execute(Object(Doctrine\\DBAL\\Connection), Array, Array)\n#7 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(957): Doctrine\\ORM\\Query->_doExecute()\n#8 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(912): Doctrine\\ORM\\AbstractQuery->executeIgnoreQueryCache(NULL, 1)\n#9 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(716): Doctrine\\ORM\\AbstractQuery->execute(NULL, 1)\n#10 /home/sazabies/sazabies.com/public_html/gaming/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php(166): Doctrine\\ORM\\AbstractQuery->getResult(1)\n#11 [internal function]: Doctrine\\ORM\\Tools\\Pagination\\Paginator->getIterator()\n#12 /home/sazabies/sazabies.com/public_html/gaming/vendor/knplabs/knp-components/src/Knp/Component/Pager/Event/Subscriber/Paginate/Doctrine/ORM/QuerySubscriber/UsesPaginator.php(52): iterator_to_array(Object(Doctrine\\ORM\\Tools\\Pagination\\Paginator))\n#13 /home/sazabies/sazabies.com/public_html/gaming/vendor/symfony/event-dispatcher/EventDispatcher.php(212): Knp\\Component\\Pager\\Event\\Subscriber\\Paginate\\Doctrine\\ORM\\QuerySubscriber\\UsesPaginator->items(Object(Knp\\Component\\Pager\\Event\\ItemsEvent), 'knp_pager.items', Object(Symfony\\Component\\EventDispatcher\\ContainerAwareEventDispatcher))\n#14 /home/sazabies/sazabies.com/public_html/gaming/vendor/symfony/event-dispatcher/EventDispatcher.php(44): Symfony\\Component\\EventDispatcher\\EventDispatcher->doDispatch(Array, 'knp_pager.items', Object(Knp\\Component\\Pager\\Event\\ItemsEvent))\n#15 /home/sazabies/sazabies.com/public_html/gaming/vendor/knplabs/knp-components/src/Knp/Component/Pager/Paginator.php(114): Symfony\\Component\\EventDispatcher\\EventDispatcher->dispatch('knp_pager.items', Object(Knp\\Component\\Pager\\Event\\ItemsEvent))\n#16 /home/sazabies/sazabies.com/public_html/gaming/var/cache/prod/Container5lhnjqf/Paginator_f262b94.php(18): Knp\\Component\\Pager\\Paginator->paginate(Object(Doctrine\\ORM\\Query), 1, 20, Array)\n#17 /home/sazabies/sazabies.com/public_html/gaming/src/Eccube/Controller/ProductController.php(169): Paginator_f262b94->paginate(Object(Doctrine\\ORM\\Query), 1, 20)\n#18 /home/sazabies/sazabies.com/public_html/gaming/vendor/symfony/http-kernel/HttpKernel.php(151): Eccube\\Controller\\ProductController->index(Object(Symfony\\Component\\HttpFoundation\\Request), Object(Paginator_f262b94))\n#19 /home/sazabies/sazabies.com/public_html/gaming/vendor/symfony/http-kernel/HttpKernel.php(68): Symfony\\Component\\HttpKernel\\HttpKernel->handleRaw(Object(Symfony\\Component\\HttpFoundation\\Request), 1)\n#20 /home/sazabies/sazabies.com/public_html/gaming/vendor/symfony/http-kernel/Kernel.php(200): Symfony\\Component\\HttpKernel\\HttpKernel->handle(Object(Symfony\\Component\\HttpFoundation\\Request), 1, true)\n#21 /home/sazabies/sazabies.com/public_html/gaming/index.php(79): Symfony\\Component\\HttpKernel\\Kernel->handle(Object(Symfony\\Component\\HttpFoundation\\Request))\n#22 {main}"] [GET, /products/list?category_id=8, 36.11.228.220, https://gaming.sazabies.com/, Mozilla/5.0 (Linux; Android 10; SCV43-u) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.181 Mobile Safari/537.36]
[2021-03-02 09:40:20] front.INFO [f04b2e5398140d282a6743d2fab2fbea] [985cb2e] [anon.] [Eccube\Log\Logger:log:66] - LOGIC START ["product_list"] [GET, /products/list?category_id=8, 36.11.228.220, https://gaming.sazabies.com/, Mozilla/5.0 (Linux; Android 10; SCV43-u) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.181 Mobile Safari/537.36]
[2021-03-02 09:40:20] front.DEBUG [f04b2e5398140d282a6743d2fab2fbea] [985cb2e] [anon.] [Eccube\Log\Logger:log:66] - Begin Transaction. [] [GET, /products/list?category_id=8, 36.11.228.220, https://gaming.sazabies.com/, Mozilla/5.0 (Linux; Android 10; SCV43-u) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.181 Mobile Safari/537.36]
[2021-03-02 09:40:20] front.INFO [f04b2e5398140d282a6743d2fab2fbea] [985cb2e] [anon.] [Eccube\Log\Logger:log:66] - fallback to PC layout [] [GET, /products/list?category_id=8, 36.11.228.220, https://gaming.sazabies.com/, Mozilla/5.0 (Linux; Android 10; SCV43-u) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.181 Mobile Safari/537.36]
[2021-03-02 09:40:20] front.INFO [f04b2e5398140d282a6743d2fab2fbea] [985cb2e] [anon.] [Eccube\Log\Logger:log:66] - PROCESS START ["product_list"] [GET, /products/list?category_id=8, 36.11.228.220, https://gaming.sazabies.com/, Mozilla/5.0 (Linux; Android 10; SCV43-u) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.181 Mobile Safari/537.36]
[2021-03-02 09:40:20] front.INFO [N/A] [985cb2e] [N/A] [Eccube\Log\Logger:log:66] - INIT [] [GET, /products/list?category_id=8, 36.11.228.220, https://gaming.sazabies.com/, Mozilla/5.0 (Linux; Android 10; SCV43-u) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.181 Mobile Safari/537.36]
[2021-03-02 09:40:15] app.DEBUG [N/A] [25e871c] [anon.] [Eccube\Log\Logger:log:68] - Commit executed. [] [GET, /products/list?category_id=8, 36.11.228.220, https://gaming.sazabies.com/, Mozilla/5.0 (Linux; Android 10; SCV43-u) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.181 Mobile Safari/537.36]
[2021-03-02 09:40:15] app.INFO [N/A] [25e871c] [anon.] [Eccube\Log\Logger:log:68] - PROCESS END ["product_list"] [GET, /products/list?category_id=8, 36.11.228.220, https://gaming.sazabies.com/, Mozilla/5.0 (Linux; Android 10; SCV43-u) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.181 Mobile Safari/537.36]
umebius
投稿日時: 2021/3/2 10:09
対応状況: −−−
登録日: 2016/7/22
居住地: 東京日本橋
投稿: 2030
Re: プラグインインストール失敗後、トップページ以外エラー表示になります
dtb_productのshipping_nameというカラム、お心当たりありますか?

エックスサーバーのphpMyAdminを開いて
dtb_productテーブルにshipping_nameというカラムをtextタイプで追加すると応急処置的にエラーが出なくなるかもしれません。
(他にもエラーがあるかもしれませんが、、)


----------------
EC-CUBE4系 カスタマイズ ECのプロがシステム急ぎの案件承ります。
EC-CUBE開発 リモートで働くエンジニア募集中

SAZABI
投稿日時: 2021/3/2 19:27
対応状況: −−−
常連
登録日: 2019/1/16
居住地:
投稿: 40
Re: プラグインインストール失敗後、トップページ以外エラー表示になります
全く触っていない場所ですので、プラグインの影響により改変されたのでしょうか。。。

ご教授いただいた内容でエラー出なくなりました。
とてもたすかりました。ありがとうございます。

少し慎重に触ってみます。
スレッド表示 | 新しいものから 前のトピック | 次のトピック | トップ


 



ログイン


EC-CUBEペイメント

公式ストアEC-CUBE4系デザインテンプレート続々リリース中

統計情報

総メンバー数は73,079名です
総投稿数は102,130件です

投稿数ランキング

1
seasoft
7333
2
468
3078
3
AMUAMU
2712
4
nanasess
2180
5
umebius
2030
6
yuh
1612
7
red
1453
8
h_tanaka
1090
9
tsuji
936
10
fukap
907
11
shutta
835
12
tao_s
793
13 ramrun 789
14 karin 689
15 sumida 641
16
homan
633
17 DELIGHT 572
18
patapata
502
19
flealog
485
20 tonton 437


ネットショップの壺

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

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