バージョン選択

フォーラム

メニュー

オンライン状況

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

サイト内検索

質問 > フロント機能 > 商品 並び替え機能の不具合

フロント機能

新規スレッドを追加する

スレッド表示 | 新しいものから 前のトピック | 次のトピック | 下へ
投稿者 スレッド
ryerye
投稿日時: 2024/1/10 15:55
対応状況: 開発中
新米
登録日: 2023/12/15
居住地:
投稿: 7
商品 並び替え機能の不具合
環境 ローカル
[EC-CUBE] バージョン 4.0.5
[PHP] 7.4.15
[データベース] mysql 5.7.33
[WEBサーバ] Apache/2.4.57 () OpenSSL/1.0.2k-fips PHP/7.4.15

ユーザー画面側に関する質問です。
商品の表示順を高い順、低い順、名前順に並び替えしたいのですが、いづれもうまくいかず、でたらめな並びになります。

An exception occurred while executing 'SELECT DISTINCT d0_.id AS id_0, MAX(d1_.price02) AS sclr_1, d0_.id AS id_2 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 d1_.sale_type_id IN (?, ?)) AND d0_.discriminator_type IN ('product') ORDER BY sclr_1 DESC, d0_.id DESC LIMIT 200' with params [20, "1", "3"]:

SQLSTATE[42000]: Syntax error or access violation: 1140 In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'root.d0_.id'; this is incompatible with sql_mode=only_full_group_by


こういったエラーがでています。

group byが原因っぽいのでしょうが、なにをどう修正すれば想定通り動くのかまったくわかりません。

なにか参考になりそうなことを教えていただけないでしょうか
mcontact
投稿日時: 2024/1/10 16:20
対応状況: −−−
登録日: 2022/1/22
居住地:
投稿: 1287
Re: 商品 並び替え機能の不具合
EC-CUBEログを確認できますか?
どのようなエラーが出ますでしょうか?
EC-CUBEのログであれば、var/log/prod/site-yyyy-mm-dd.log に「システムエラーが発生しました」や「ERROR」といった行がありましたらご提示ください。


----------------
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
EC-CUBEインテグレートパートナー【ゴールド】ランク
M&I Works
URL: https://miworks.biz/
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

ryerye
投稿日時: 2024/1/10 16:44
対応状況: −−−
新米
登録日: 2023/12/15
居住地:
投稿: 7
Re: 商品 並び替え機能の不具合
[2023-12-18 22:04:53] php.INFO [N/A] [a5a658f] [N/A] [Symfony\Component\Debug\ErrorHandler:setLoggers:249] - User Deprecated: Creating Doctrine\ORM\Mapping\UnderscoreNamingStrategy without making it number aware is deprecated and will be removed in Doctrine ORM 3.0. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Creating Doctrine\\ORM\\Mapping\\UnderscoreNamingStrategy without making it number aware is deprecated and will be removed in Doctrine ORM 3.0. at /Applications/MAMP/htdocs/instill/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/UnderscoreNamingStrategy.php:66)"} [, , , , ]
[2023-12-18 22:04:53] php.INFO [N/A] [a5a658f] [N/A] [Symfony\Component\Debug\ErrorHandler:setLoggers:249] - User Deprecated: The type "datetime" was implicitly marked as commented due to the configuration. This is deprecated and will be removed in DoctrineBundle 2.0. Either set the "commented" attribute in the configuration to "false" or mark the type as commented in "Eccube\Doctrine\DBAL\Types\UTCDateTimeType::requiresSQLCommentHint()." {"exception":"[object] (ErrorException(code: 0): User Deprecated: The type \"datetime\" was implicitly marked as commented due to the configuration. This is deprecated and will be removed in DoctrineBundle 2.0. Either set the \"commented\" attribute in the configuration to \"false\" or mark the type as commented in \"Eccube\\Doctrine\\DBAL\\Types\\UTCDateTimeType::requiresSQLCommentHint().\" at /Applications/MAMP/htdocs/instill/vendor/doctrine/doctrine-bundle/ConnectionFactory.php:122)"} [, , , , ]
[2023-12-18 22:04:53] php.INFO [N/A] [a5a658f] [N/A] [Symfony\Component\Debug\ErrorHandler:setLoggers:249] - User Deprecated: The type "datetimetz" was implicitly marked as commented due to the configuration. This is deprecated and will be removed in DoctrineBundle 2.0. Either set the "commented" attribute in the configuration to "false" or mark the type as commented in "Eccube\Doctrine\DBAL\Types\UTCDateTimeTzType::requiresSQLCommentHint()." {"exception":"[object] (ErrorException(code: 0): User Deprecated: The type \"datetimetz\" was implicitly marked as commented due to the configuration. This is deprecated and will be removed in DoctrineBundle 2.0. Either set the \"commented\" attribute in the configuration to \"false\" or mark the type as commented in \"Eccube\\Doctrine\\DBAL\\Types\\UTCDateTimeTzType::requiresSQLCommentHint().\" at /Applications/MAMP/htdocs/instill/vendor/doctrine/doctrine-bundle/ConnectionFactory.php:122)"} [, , , , ]
[2023-12-18 22:04:53] php.INFO [N/A] [a5a658f] [N/A] [Symfony\Component\Debug\ErrorHandler:setLoggers:249] - User Deprecated: The "base_template_class" option on Twig\Environment is deprecated since Twig 2.7.0. {"exception":"[object] (ErrorException(code: 0): User Deprecated: The \"base_template_class\" option on Twig\\Environment is deprecated since Twig 2.7.0. at /Applications/MAMP/htdocs/instill/vendor/twig/twig/src/Environment.php:121)"} [, , , , ]
[2023-12-18 22:04:53] front.INFO [N/A] [a5a658f] [N/A] [Eccube\Log\Logger:log:66] - INIT [] [GET, /, ::1, http://localhost/MAMP/?language=English, Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36]
[2023-12-18 22:04:53] php.INFO [N/A] [a5a658f] [N/A] [Symfony\Component\Debug\ErrorHandler:handleError:533] - User Deprecated: The "sensio_framework_extra.routing.loader.annot_class" service is deprecated since version 5.2 {"exception":"[object] (ErrorException(code: 0): User Deprecated: The \"sensio_framework_extra.routing.loader.annot_class\" service is deprecated since version 5.2 at /Applications/MAMP/htdocs/instill/var/cache/prod/ContainerLgkaqrb/getSensioFrameworkExtra_Routing_Loader_AnnotClassService.php:8)"} [GET, /, ::1, http://localhost/MAMP/?language=English, Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36]
[2023-12-18 22:04:53] php.INFO [N/A] [a5a658f] [N/A] [Symfony\Component\Debug\ErrorHandler:handleError:533] - User Deprecated: The "sensio_framework_extra.routing.loader.annot_dir" service is deprecated since version 5.2 {"exception":"[object] (ErrorException(code: 0): User Deprecated: The \"sensio_framework_extra.routing.loader.annot_dir\" service is deprecated since version 5.2 at /Applications/MAMP/htdocs/instill/var/cache/prod/ContainerLgkaqrb/getSensioFrameworkExtra_Routing_Loader_AnnotDirService.php:8)"} [GET, /, ::1, http://localhost/MAMP/?language=English, Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36]
[2023-12-18 22:04:53] php.INFO [N/A] [a5a658f] [N/A] [Symfony\Component\Debug\ErrorHandler:handleError:533] - User Deprecated: The "sensio_framework_extra.routing.loader.annot_file" service is deprecated since version 5.2 {"exception":"[object] (ErrorException(code: 0): User Deprecated: The \"sensio_framework_extra.routing.loader.annot_file\" service is deprecated since version 5.2 at /Applications/MAMP/htdocs/instill/var/cache/prod/ContainerLgkaqrb/getSensioFrameworkExtra_Routing_Loader_AnnotFileService.php:8)"} [GET, /, ::1, http://localhost/MAMP/?language=English, Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36]
[2023-12-18 22:04:53] request.INFO [N/A] [a5a658f] [N/A] [Symfony\Component\HttpKernel\EventListener\RouterListener:onKernelRequest:123] - Matched route "homepage". {"route":"homepage","route_parameters":{"_controller":"Eccube\\Controller\\TopController::index","_route":"homepage"},"request_uri":"http://localhost/","method":"GET"} [GET, /, ::1, http://localhost/MAMP/?language=English, Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36]
[2023-12-18 22:04:54] security.INFO [N/A] [a5a658f] [anon.] [Symfony\Component\Security\Http\Firewall\AnonymousAuthenticationListener:handle:60] - Populated the TokenStorage with an anonymous Token. [] [GET, /, ::1, http://localhost/MAMP/?language=English, Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36]
[2023-12-18 22:04:54] front.INFO [N/A] [a5a658f] [anon.] [Eccube\Log\Logger:log:66] - PROCESS START ["homepage"] [GET, /, ::1, http://localhost/MAMP/?language=English, Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36]
[2023-12-18 22:04:54] php.INFO [N/A] [a5a658f] [anon.] [Symfony\Component\Debug\ErrorHandler:handleError:533] - User Deprecated: Not quoting the scalar "%success%件のファイルをアップロードしました。(%success%/%count%)" starting with the "%" indicator character is deprecated since Symfony 3.1 and will throw a ParseException in 4.0 in "/Applications/MAMP/htdocs/instill/src/Eccube/Resource/locale/messages.ja.yaml" on line 1072. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Not quoting the scalar \"%success%件のファイルをアップロードしました。(%success%/%count%)\" starting with the \"%\" indicator character is deprecated since Symfony 3.1 and will throw a ParseException in 4.0 in \"/Applications/MAMP/htdocs/instill/src/Eccube/Resource/locale/messages.ja.yaml\" on line 1072. at /Applications/MAMP/htdocs/instill/vendor/symfony/yaml/Inline.php:359)"} [GET, /, ::1, http://localhost/MAMP/?language=English, Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36]
[2023-12-18 22:04:54] php.INFO [N/A] [a5a658f] [anon.] [Symfony\Component\Debug\ErrorHandler:handleError:533] - User Deprecated: Not quoting the scalar "%file_name% のアップロードに失敗しました。(%error%)" starting with the "%" indicator character is deprecated since Symfony 3.1 and will throw a ParseException in 4.0 in "/Applications/MAMP/htdocs/instill/src/Eccube/Resource/locale/messages.ja.yaml" on line 1073. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Not quoting the scalar \"%file_name% のアップロードに失敗しました。(%error%)\" starting with the \"%\" indicator character is deprecated since Symfony 3.1 and will throw a ParseException in 4.0 in \"/Applications/MAMP/htdocs/instill/src/Eccube/Resource/locale/messages.ja.yaml\" on line 1073. at /Applications/MAMP/htdocs/instill/vendor/symfony/yaml/Inline.php:359)"} [GET, /, ::1, http://localhost/MAMP/?language=English, Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36]
[2023-12-18 22:04:54] php.INFO [N/A] [a5a658f] [anon.] [Symfony\Component\Debug\ErrorHandler:handleError:533] - User Deprecated: Not quoting the scalar "%name% %plugin_version% は EC-CUBE %eccube_version% には対応していません。続行しますか?" starting with the "%" indicator character is deprecated since Symfony 3.1 and will throw a ParseException in 4.0 in "/Applications/MAMP/htdocs/instill/src/Eccube/Resource/locale/messages.ja.yaml" on line 1803. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Not quoting the scalar \"%name% %plugin_version% は EC-CUBE %eccube_version% には対応していません。続行しますか?\" starting with the \"%\" indicator character is deprecated since Symfony 3.1 and will throw a ParseException in 4.0 in \"/Applications/MAMP/htdocs/instill/src/Eccube/Resource/locale/messages.ja.yaml\" on line 1803. at /Applications/MAMP/htdocs/instill/vendor/symfony/yaml/Inline.php:359)"} [GET, /, ::1, http://localhost/MAMP/?language=English, Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36]
[2023-12-18 22:04:54] front.ERROR [N/A] [a5a658f] [anon.] [Eccube\Log\Logger:log:66] - システムエラーが発生しました。 ["An exception occurred in driver: SQLSTATE[HY000] [1045] Access denied for user 'instill'@'localhost' (using password: YES)","/Applications/MAMP/htdocs/instill/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php",112,"#0 /Applications/MAMP/htdocs/instill/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(182): Doctrine\\DBAL\\Driver\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\DBAL\\Driver\\PDO\\Exception))\n#1 /Applications/MAMP/htdocs/instill/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(169): Doctrine\\DBAL\\DBALException::wrapException(Object(Doctrine\\DBAL\\Driver\\PDO\\MySQL\\Driver), Object(Doctrine\\DBAL\\Driver\\PDO\\Exception), 'An exception oc...')\n#2 /Applications/MAMP/htdocs/instill/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOMySql/Driver.php(31): Doctrine\\DBAL\\DBALException::driverException(Object(Doctrine\\DBAL\\Driver\\PDO\\MySQL\\Driver), Object(Doctrine\\DBAL\\Driver\\PDO\\Exception))\n#3 /Applications/MAMP/htdocs/instill/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(412): Doctrine\\DBAL\\Driver\\PDOMySql\\Driver->connect(Array, 'instill', 'Instill@2021020...';, Array)\n#4 /Applications/MAMP/htdocs/instill/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1952): Doctrine\\DBAL\\Connection->connect()\n#5 /Applications/MAMP/htdocs/instill/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(980): Doctrine\\DBAL\\Connection->getWrappedConnection()\n#6 /Applications/MAMP/htdocs/instill/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/SingleTablePersister.php(165): Doctrine\\DBAL\\Connection->quote('baseinfo')\n#7 /Applications/MAMP/htdocs/instill/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/SingleTablePersister.php(140): Doctrine\\ORM\\Persisters\\Entity\\SingleTablePersister->getSelectConditionDiscriminatorValueSQL()\n#8 /Applications/MAMP/htdocs/instill/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(1071): Doctrine\\ORM\\Persisters\\Entity\\SingleTablePersister->getSelectConditionSQL(Array, NULL)\n#9 /Applications/MAMP/htdocs/instill/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(724): Doctrine\\ORM\\Persisters\\Entity\\BasicEntityPersister->getSelectSQL(Array, NULL, NULL, NULL, NULL, NULL)\n#10 /Applications/MAMP/htdocs/instill/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(744): Doctrine\\ORM\\Persisters\\Entity\\BasicEntityPersister->load(Array, NULL)\n#11 /Applications/MAMP/htdocs/instill/vendor/doctrine/orm/lib/Doctrine/ORM/Cache/Persister/Entity/AbstractEntityPersister.php(466): Doctrine\\ORM\\Persisters\\Entity\\BasicEntityPersister->loadById(Array, NULL)\n#12 /Applications/MAMP/htdocs/instill/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(472): Doctrine\\ORM\\Cache\\Persister\\Entity\\AbstractEntityPersister->loadById(Array)\n#13 /Applications/MAMP/htdocs/instill/var/cache/prod/ContainerLgkaqrb/EntityManager_9a5be93.php(131): Doctrine\\ORM\\EntityManager->find('Eccube\\\\Entity\\\\B...', Array, NULL, NULL)\n#14 /Applications/MAMP/htdocs/instill/vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php(151): EntityManager_9a5be93->find('Eccube\\\\Entity\\\\B...', 1, NULL, NULL)\n#15 /Applications/MAMP/htdocs/instill/src/Eccube/Repository/BaseInfoRepository.php(44): Doctrine\\ORM\\EntityRepository->find(1)\n#16 /Applications/MAMP/htdocs/instill/src/Eccube/EventListener/TwigInitializeListener.php(162): Eccube\\Repository\\BaseInfoRepository->get()\n#17 /Applications/MAMP/htdocs/instill/vendor/symfony/event-dispatcher/Debug/WrappedListener.php(115): Eccube\\EventListener\\TwigInitializeListener->onKernelRequest(Object(Symfony\\Component\\HttpKernel\\Event\\GetResponseEvent), 'kernel.request', Object(Symfony\\Component\\HttpKernel\\Debug\\TraceableEventDispatcher))\n#18 /Applications/MAMP/htdocs/instill/vendor/symfony/event-dispatcher/EventDispatcher.php(214): Symfony\\Component\\EventDispatcher\\Debug\\WrappedListener->__invoke(Object(Symfony\\Component\\HttpKernel\\Event\\GetResponseEvent), 'kernel.request', Object(Symfony\\Component\\HttpKernel\\Debug\\TraceableEventDispatcher))\n#19 /Applications/MAMP/htdocs/instill/vendor/symfony/event-dispatcher/EventDispatcher.php(44): Symfony\\Component\\EventDispatcher\\EventDispatcher->doDispatch(Array, 'kernel.request', Object(Symfony\\Component\\HttpKernel\\Event\\GetResponseEvent))\n#20 /Applications/MAMP/htdocs/instill/vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php(143): Symfony\\Component\\EventDispatcher\\EventDispatcher->dispatch('kernel.request', Object(Symfony\\Component\\HttpKernel\\Event\\GetResponseEvent))\n#21 /Applications/MAMP/htdocs/instill/vendor/symfony/http-kernel/HttpKernel.php(127): Symfony\\Component\\EventDispatcher\\Debug\\TraceableEventDispatcher->dispatch('kernel.request', Object(Symfony\\Component\\HttpKernel\\Event\\GetResponseEvent))\n#22 /Applications/MAMP/htdocs/instill/vendor/symfony/http-kernel/HttpKernel.php(68): Symfony\\Component\\HttpKernel\\HttpKernel->handleRaw(Object(Symfony\\Component\\HttpFoundation\\Request), 1)\n#23 /Applications/MAMP/htdocs/instill/vendor/symfony/http-kernel/Kernel.php(200): Symfony\\Component\\HttpKernel\\HttpKernel->handle(Object(Symfony\\Component\\HttpFoundation\\Request), 1, true)\n#24 /Applications/MAMP/htdocs/instill/index.php(76): Symfony\\Component\\HttpKernel\\Kernel->handle(Object(Symfony\\Component\\HttpFoundation\\Request))\n#25 {main}"] [GET, /, ::1, http://localhost/MAMP/?language=English, Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36]
[2023-12-18 22:04:54] translation.WARNING [N/A] [a5a658f] [anon.] [Symfony\Component\Translation\LoggingTranslator:log:132] - Translation not found. {"id":"トップページへ","domain":"messages","locale":"ja"} [GET, /, ::1, http://localhost/MAMP/?language=English, Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36]
[2023-12-18 22:04:54] front.INFO [N/A] [a5a658f] [anon.] [Eccube\Log\Logger:log:66] - LOGIC END ["homepage"] [GET, /, ::1, http://localhost/MAMP/?language=English, Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36]
[2023-12-18 22:04:54] app.INFO [N/A] [a5a658f] [anon.] [Eccube\Log\Logger:log:68] - PROCESS END ["homepage"] [GET, /, ::1, http://localhost/MAMP/?language=English, Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36]
[2023-12-18 22:05:00] php.INFO [N/A] [6988fd5] [N/A] [Symfony\Component\Debug\ErrorHandler:setLoggers:249] - User Deprecated: The "base_template_class" option on Twig\Environment is deprecated since Twig 2.7.0. {"exception":"[object] (ErrorException(code: 0): User Deprecated: The \"base_template_class\" option on Twig\\Environment is deprecated since Twig 2.7.0. at /Applications/MAMP/htdocs/instill/vendor/twig/twig/src/Environment.php:121)"} [, , , , ]
[2023-12-18 22:05:00] php.INFO [N/A] [6988fd5] [N/A] [Symfony\Component\Debug\ErrorHandler:setLoggers:249] - User Deprecated: Creating Doctrine\ORM\Mapping\UnderscoreNamingStrategy without making it number aware is deprecated and will be removed in Doctrine ORM 3.0. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Creating Doctrine\\ORM\\Mapping\\UnderscoreNamingStrategy without making it number aware is deprecated and will be removed in Doctrine ORM 3.0. at /Applications/MAMP/htdocs/instill/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/UnderscoreNamingStrategy.php:66)"} [, , , , ]
[2023-12-18 22:05:00] php.INFO [N/A] [6988fd5] [N/A] [Symfony\Component\Debug\ErrorHandler:setLoggers:249] - User Deprecated: The type "datetime" was implicitly marked as commented due to the configuration. This is deprecated and will be removed in DoctrineBundle 2.0. Either set the "commented" attribute in the configuration to "false" or mark the type as commented in "Eccube\Doctrine\DBAL\Types\UTCDateTimeType::requiresSQLCommentHint()." {"exception":"[object] (ErrorException(code: 0): User Deprecated: The type \"datetime\" was implicitly marked as commented due to the configuration. This is deprecated and will be removed in DoctrineBundle 2.0. Either set the \"commented\" attribute in the configuration to \"false\" or mark the type as commented in \"Eccube\\Doctrine\\DBAL\\Types\\UTCDateTimeType::requiresSQLCommentHint().\" at /Applications/MAMP/htdocs/instill/vendor/doctrine/doctrine-bundle/ConnectionFactory.php:122)"} [, , , , ]
[2023-12-18 22:05:00] php.INFO [N/A] [6988fd5] [N/A] [Symfony\Component\Debug\ErrorHandler:setLoggers:249] - User Deprecated: The type "datetimetz" was implicitly marked as commented due to the configuration. This is deprecated and will be removed in DoctrineBundle 2.0. Either set the "commented" attribute in the configuration to "false" or mark the type as commented in "Eccube\Doctrine\DBAL\Types\UTCDateTimeTzType::requiresSQLCommentHint()." {"exception":"[object] (ErrorException(code: 0): User Deprecated: The type \"datetimetz\" was implicitly marked as commented due to the configuration. This is deprecated and will be removed in DoctrineBundle 2.0. Either set the \"commented\" attribute in the configuration to \"false\" or mark the type as commented in \"Eccube\\Doctrine\\DBAL\\Types\\UTCDateTimeTzType::requiresSQLCommentHint().\" at /Applications/MAMP/htdocs/instill/vendor/doctrine/doctrine-bundle/ConnectionFactory.php:122)"} [, , , , ]
[2023-12-18 22:05:00] front.INFO [N/A] [6988fd5] [N/A] [Eccube\Log\Logger:log:66] - INIT [] [GET, /, ::1, http://localhost/, Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36]
[2023-12-18 22:05:00] request.INFO [N/A] [6988fd5] [N/A] [Symfony\Component\HttpKernel\EventListener\RouterListener:onKernelRequest:123] - Matched route "homepage". {"route":"homepage","route_parameters":{"_controller":"Eccube\\Controller\\TopController::index","_route":"homepage"},"request_uri":"http://localhost/","method":"GET"} [GET, /, ::1, http://localhost/, Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36]
[2023-12-18 22:05:00] security.INFO [N/A] [6988fd5] [anon.] [Symfony\Component\Security\Http\Firewall\AnonymousAuthenticationListener:handle:60] - Populated the TokenStorage with an anonymous Token. [] [GET, /, ::1, http://localhost/, Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36]
[2023-12-18 22:05:00] front.INFO [N/A] [6988fd5] [anon.] [Eccube\Log\Logger:log:66] - PROCESS START ["homepage"] [GET, /, ::1, http://localhost/, Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36]
[2023-12-18 22:05:00] front.ERROR [N/A] [6988fd5] [anon.] [Eccube\Log\Logger:log:66] - システムエラーが発生しました。 ["An exception occurred in driver: SQLSTATE[HY000] [1045] Access denied for user 'instill'@'localhost' (using password: YES)","/Applications/MAMP/htdocs/instill/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php",112,"#0 /Applications/MAMP/htdocs/instill/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(182): Doctrine\\DBAL\\Driver\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\DBAL\\Driver\\PDO\\Exception))\n#1 /Applications/MAMP/htdocs/instill/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(169): Doctrine\\DBAL\\DBALException::wrapException(Object(Doctrine\\DBAL\\Driver\\PDO\\MySQL\\Driver), Object(Doctrine\\DBAL\\Driver\\PDO\\Exception), 'An exception oc...')\n#2 /Applications/MAMP/htdocs/instill/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOMySql/Driver.php(31): Doctrine\\DBAL\\DBALException::driverException(Object(Doctrine\\DBAL\\Driver\\PDO\\MySQL\\Driver), Object(Doctrine\\DBAL\\Driver\\PDO\\Exception))\n#3 /Applications/MAMP/htdocs/instill/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(412): Doctrine\\DBAL\\Driver\\PDOMySql\\Driver->connect(Array, 'instill', 'Instill@2021020...';, Array)\n#4 /Applications/MAMP/htdocs/instill/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1952): Doctrine\\DBAL\\Connection->connect()\n#5 /Applications/MAMP/htdocs/instill/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(980): Doctrine\\DBAL\\Connection->getWrappedConnection()\n#6 /Applications/MAMP/htdocs/instill/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/SingleTablePersister.php(165): Doctrine\\DBAL\\Connection->quote('baseinfo')\n#7 /Applications/MAMP/htdocs/instill/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/SingleTablePersister.php(140): Doctrine\\ORM\\Persisters\\Entity\\SingleTablePersister->getSelectConditionDiscriminatorValueSQL()\n#8 /Applications/MAMP/htdocs/instill/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(1071): Doctrine\\ORM\\Persisters\\Entity\\SingleTablePersister->getSelectConditionSQL(Array, NULL)\n#9 /Applications/MAMP/htdocs/instill/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(724): Doctrine\\ORM\\Persisters\\Entity\\BasicEntityPersister->getSelectSQL(Array, NULL, NULL, NULL, NULL, NULL)\n#10 /Applications/MAMP/htdocs/instill/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(744): Doctrine\\ORM\\Persisters\\Entity\\BasicEntityPersister->load(Array, NULL)\n#11 /Applications/MAMP/htdocs/instill/vendor/doctrine/orm/lib/Doctrine/ORM/Cache/Persister/Entity/AbstractEntityPersister.php(466): Doctrine\\ORM\\Persisters\\Entity\\BasicEntityPersister->loadById(Array, NULL)\n#12 /Applications/MAMP/htdocs/instill/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(472): Doctrine\\ORM\\Cache\\Persister\\Entity\\AbstractEntityPersister->loadById(Array)\n#13 /Applications/MAMP/htdocs/instill/var/cache/prod/ContainerLgkaqrb/EntityManager_9a5be93.php(131): Doctrine\\ORM\\EntityManager->find('Eccube\\\\Entity\\\\B...', Array, NULL, NULL)\n#14 /Applications/MAMP/htdocs/instill/vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php(151): EntityManager_9a5be93->find('Eccube\\\\Entity\\\\B...', 1, NULL, NULL)\n#15 /Applications/MAMP/htdocs/instill/src/Eccube/Repository/BaseInfoRepository.php(44): Doctrine\\ORM\\EntityRepository->find(1)\n#16 /Applications/MAMP/htdocs/instill/src/Eccube/EventListener/TwigInitializeListener.php(162): Eccube\\Repository\\BaseInfoRepository->get()\n#17 /Applications/MAMP/htdocs/instill/vendor/symfony/event-dispatcher/Debug/WrappedListener.php(115): Eccube\\EventListener\\TwigInitializeListener->onKernelRequest(Object(Symfony\\Component\\HttpKernel\\Event\\GetResponseEvent), 'kernel.request', Object(Symfony\\Component\\HttpKernel\\Debug\\TraceableEventDispatcher))\n#18 /Applications/MAMP/htdocs/instill/vendor/symfony/event-dispatcher/EventDispatcher.php(214): Symfony\\Component\\EventDispatcher\\Debug\\WrappedListener->__invoke(Object(Symfony\\Component\\HttpKernel\\Event\\GetResponseEvent), 'kernel.request', Object(Symfony\\Component\\HttpKernel\\Debug\\TraceableEventDispatcher))\n#19 /Applications/MAMP/htdocs/instill/vendor/symfony/event-dispatcher/EventDispatcher.php(44): Symfony\\Component\\EventDispatcher\\EventDispatcher->doDispatch(Array, 'kernel.request', Object(Symfony\\Component\\HttpKernel\\Event\\GetResponseEvent))\n#20 /Applications/MAMP/htdocs/instill/vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php(143): Symfony\\Component\\EventDispatcher\\EventDispatcher->dispatch('kernel.request', Object(Symfony\\Component\\HttpKernel\\Event\\GetResponseEvent))\n#21 /Applications/MAMP/htdocs/instill/vendor/symfony/http-kernel/HttpKernel.php(127): Symfony\\Component\\EventDispatcher\\Debug\\TraceableEventDispatcher->dispatch('kernel.request', Object(Symfony\\Component\\HttpKernel\\Event\\GetResponseEvent))\n#22 /Applications/MAMP/htdocs/instill/vendor/symfony/http-kernel/HttpKernel.php(68): Symfony\\Component\\HttpKernel\\HttpKernel->handleRaw(Object(Symfony\\Component\\HttpFoundation\\Request), 1)\n#23 /Applications/MAMP/htdocs/instill/vendor/symfony/http-kernel/Kernel.php(200): Symfony\\Component\\HttpKernel\\HttpKernel->handle(Object(Symfony\\Component\\HttpFoundation\\Request), 1, true)\n#24 /Applications/MAMP/htdocs/instill/index.php(76): Symfony\\Component\\HttpKernel\\Kernel->handle(Object(Symfony\\Component\\HttpFoundation\\Request))\n#25 {main}"] [GET, /, ::1, http://localhost/, Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36]
[2023-12-18 22:05:00] translation.WARNING [N/A] [6988fd5] [anon.] [Symfony\Component\Translation\LoggingTranslator:log:132] - Translation not found. {"id":"トップページへ","domain":"messages","locale":"ja"} [GET, /, ::1, http://localhost/, Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36]
[2023-12-18 22:05:00] front.INFO [N/A] [6988fd5] [anon.] [Eccube\Log\Logger:log:66] - LOGIC END ["homepage"] [GET, /, ::1, http://localhost/, Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36]
[2023-12-18 22:05:00] app.INFO [N/A] [6988fd5] [anon.] [Eccube\Log\Logger:log:68] - PROCESS END ["homepage"] [GET, /, ::1, http://localhost/, Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36]
[2023-12-18 22:05:18] php.INFO [N/A] [6a80ae2] [N/A] [Symfony\Component\Debug\ErrorHandler:setLoggers:249] - User Deprecated: The "base_template_class" option on Twig\Environment is deprecated since Twig 2.7.0. {"exception":"[object] (ErrorException(code: 0): User Deprecated: The \"base_template_class\" option on Twig\\Environment is deprecated since Twig 2.7.0. at /Applications/MAMP/htdocs/instill/vendor/twig/twig/src/Environment.php:121)"} [, , , , ]
[2023-12-18 22:05:18] php.INFO [N/A] [6a80ae2] [N/A] [Symfony\Component\Debug\ErrorHandler:setLoggers:249] - User Deprecated: Creating Doctrine\ORM\Mapping\UnderscoreNamingStrategy without making it number aware is deprecated and will be removed in Doctrine ORM 3.0. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Creating Doctrine\\ORM\\Mapping\\UnderscoreNamingStrategy without making it number aware is deprecated and will be removed in Doctrine ORM 3.0. at /Applications/MAMP/htdocs/instill/vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/UnderscoreNamingStrategy.php:66)"} [, , , , ]
[2023-12-18 22:05:18] php.INFO [N/A] [6a80ae2] [N/A] [Symfony\Component\Debug\ErrorHandler:setLoggers:249] - User Deprecated: The type "datetime" was implicitly marked as commented due to the configuration. This is deprecated and will be removed in DoctrineBundle 2.0. Either set the "commented" attribute in the configuration to "false" or mark the type as commented in "Eccube\Doctrine\DBAL\Types\UTCDateTimeType::requiresSQLCommentHint()." {"exception":"[object] (ErrorException(code: 0): User Deprecated: The type \"datetime\" was implicitly marked as commented due to the configuration. This is deprecated and will be removed in DoctrineBundle 2.0. Either set the \"commented\" attribute in the configuration to \"false\" or mark the type as commented in \"Eccube\\Doctrine\\DBAL\\Types\\UTCDateTimeType::requiresSQLCommentHint().\" at /Applications/MAMP/htdocs/instill/vendor/doctrine/doctrine-bundle/ConnectionFactory.php:122)"} [, , , , ]
[2023-12-18 22:05:18] php.INFO [N/A] [6a80ae2] [N/A] [Symfony\Component\Debug\ErrorHandler:setLoggers:249] - User Deprecated: The type "datetimetz" was implicitly marked as commented due to the configuration. This is deprecated and will be removed in DoctrineBundle 2.0. Either set the "commented" attribute in the configuration to "false" or mark the type as commented in "Eccube\Doctrine\DBAL\Types\UTCDateTimeTzType::requiresSQLCommentHint()." {"exception":"[object] (ErrorException(code: 0): User Deprecated: The type \"datetimetz\" was implicitly marked as commented due to the configuration. This is deprecated and will be removed in DoctrineBundle 2.0. Either set the \"commented\" attribute in the configuration to \"false\" or mark the type as commented in \"Eccube\\Doctrine\\DBAL\\Types\\UTCDateTimeTzType::requiresSQLCommentHint().\" at /Applications/MAMP/htdocs/instill/vendor/doctrine/doctrine-bundle/ConnectionFactory.php:122)"} [, , , , ]
[2023-12-18 22:05:18] front.INFO [N/A] [6a80ae2] [N/A] [Eccube\Log\Logger:log:66] - INIT [] [GET, /, ::1, http://localhost/, Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36]
[2023-12-18 22:05:18] request.INFO [N/A] [6a80ae2] [N/A] [Symfony\Component\HttpKernel\EventListener\RouterListener:onKernelRequest:123] - Matched route "homepage". {"route":"homepage","route_parameters":{"_controller":"Eccube\\Controller\\TopController::index","_route":"homepage"},"request_uri":"http://localhost/","method":"GET"} [GET, /, ::1, http://localhost/, Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36]
[2023-12-18 22:05:18] security.INFO [N/A] [6a80ae2] [anon.] [Symfony\Component\Security\Http\Firewall\AnonymousAuthenticationListener:handle:60] - Populated the TokenStorage with an anonymous Token. [] [GET, /, ::1, http://localhost/, Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36]
[2023-12-18 22:05:18] front.INFO [N/A] [6a80ae2] [anon.] [Eccube\Log\Logger:log:66] - PROCESS START ["homepage"] [GET, /, ::1, http://localhost/, Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36]
[2023-12-18 22:05:18] front.ERROR [N/A] [6a80ae2] [anon.] [Eccube\Log\Logger:log:66] - システムエラーが発生しました。 ["An exception occurred in driver: SQLSTATE[HY000] [1045] Access denied for user 'instill'@'localhost' (using password: YES)","/Applications/MAMP/htdocs/instill/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php",112,"#0 /Applications/MAMP/htdocs/instill/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(182): Doctrine\\DBAL\\Driver\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\DBAL\\Driver\\PDO\\Exception))\n#1 /Applications/MAMP/htdocs/instill/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(169): Doctrine\\DBAL\\DBALException::wrapException(Object(Doctrine\\DBAL\\Driver\\PDO\\MySQL\\Driver), Object(Doctrine\\DBAL\\Driver\\PDO\\Exception), 'An exception oc...')\n#2 /Applications/MAMP/htdocs/instill/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOMySql/Driver.php(31): Doctrine\\DBAL\\DBALException::driverException(Object(Doctrine\\DBAL\\Driver\\PDO\\MySQL\\Driver), Object(Doctrine\\DBAL\\Driver\\PDO\\Exception))\n#3 /Applications/MAMP/htdocs/instill/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(412): Doctrine\\DBAL\\Driver\\PDOMySql\\Driver->connect(Array, 'instill', 'Instill@2021020...';, Array)\n#4 /Applications/MAMP/htdocs/instill/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1952): Doctrine\\DBAL\\Connection->connect()\n#5 /Applications/MAMP/htdocs/instill/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(980): Doctrine\\DBAL\\Connection->getWrappedConnection()\n#6 /Applications/MAMP/htdocs/instill/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/SingleTablePersister.php(165): Doctrine\\DBAL\\Connection->quote('baseinfo')\n#7 /Applications/MAMP/htdocs/instill/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/SingleTablePersister.php(140): Doctrine\\ORM\\Persisters\\Entity\\SingleTablePersister->getSelectConditionDiscriminatorValueSQL()\n#8 /Applications/MAMP/htdocs/instill/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(1071): Doctrine\\ORM\\Persisters\\Entity\\SingleTablePersister->getSelectConditionSQL(Array, NULL)\n#9 /Applications/MAMP/htdocs/instill/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(724): Doctrine\\ORM\\Persisters\\Entity\\BasicEntityPersister->getSelectSQL(Array, NULL, NULL, NULL, NULL, NULL)\n#10 /Applications/MAMP/htdocs/instill/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(744): Doctrine\\ORM\\Persisters\\Entity\\BasicEntityPersister->load(Array, NULL)\n#11 /Applications/MAMP/htdocs/instill/vendor/doctrine/orm/lib/Doctrine/ORM/Cache/Persister/Entity/AbstractEntityPersister.php(466): Doctrine\\ORM\\Persisters\\Entity\\BasicEntityPersister->loadById(Array, NULL)\n#12 /Applications/MAMP/htdocs/instill/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(472): Doctrine\\ORM\\Cache\\Persister\\Entity\\AbstractEntityPersister->loadById(Array)\n#13 /Applications/MAMP/htdocs/instill/var/cache/prod/ContainerLgkaqrb/EntityManager_9a5be93.php(131): Doctrine\\ORM\\EntityManager->find('Eccube\\\\Entity\\\\B...', Array, NULL, NULL)\n#14 /Applications/MAMP/htdocs/instill/vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php(151): EntityManager_9a5be93->find('Eccube\\\\Entity\\\\B...', 1, NULL, NULL)\n#15 /Applications/MAMP/htdocs/instill/src/Eccube/Repository/BaseInfoRepository.php(44): Doctrine\\ORM\\EntityRepository->find(1)\n#16 /Applications/MAMP/htdocs/instill/src/Eccube/EventListener/TwigInitializeListener.php(162): Eccube\\Repository\\BaseInfoRepository->get()\n#17 /Applications/MAMP/htdocs/instill/vendor/symfony/event-dispatcher/Debug/WrappedListener.php(115): Eccube\\EventListener\\TwigInitializeListener->onKernelRequest(Object(Symfony\\Component\\HttpKernel\\Event\\GetResponseEvent), 'kernel.request', Object(Symfony\\Component\\HttpKernel\\Debug\\TraceableEventDispatcher))\n#18 /Applications/MAMP/htdocs/instill/vendor/symfony/event-dispatcher/EventDispatcher.php(214): Symfony\\Component\\EventDispatcher\\Debug\\WrappedListener->__invoke(Object(Symfony\\Component\\HttpKernel\\Event\\GetResponseEvent), 'kernel.request', Object(Symfony\\Component\\HttpKernel\\Debug\\TraceableEventDispatcher))\n#19 /Applications/MAMP/htdocs/instill/vendor/symfony/event-dispatcher/EventDispatcher.php(44): Symfony\\Component\\EventDispatcher\\EventDispatcher->doDispatch(Array, 'kernel.request', Object(Symfony\\Component\\HttpKernel\\Event\\GetResponseEvent))\n#20 /Applications/MAMP/htdocs/instill/vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php(143): Symfony\\Component\\EventDispatcher\\EventDispatcher->dispatch('kernel.request', Object(Symfony\\Component\\HttpKernel\\Event\\GetResponseEvent))\n#21 /Applications/MAMP/htdocs/instill/vendor/symfony/http-kernel/HttpKernel.php(127): Symfony\\Component\\EventDispatcher\\Debug\\TraceableEventDispatcher->dispatch('kernel.request', Object(Symfony\\Component\\HttpKernel\\Event\\GetResponseEvent))\n#22 /Applications/MAMP/htdocs/instill/vendor/symfony/http-kernel/HttpKernel.php(68): Symfony\\Component\\HttpKernel\\HttpKernel->handleRaw(Object(Symfony\\Component\\HttpFoundation\\Request), 1)\n#23 /Applications/MAMP/htdocs/instill/vendor/symfony/http-kernel/Kernel.php(200): Symfony\\Component\\HttpKernel\\HttpKernel->handle(Object(Symfony\\Component\\HttpFoundation\\Request), 1, true)\n#24 /Applications/MAMP/htdocs/instill/index.php(76): Symfony\\Component\\HttpKernel\\Kernel->handle(Object(Symfony\\Component\\HttpFoundation\\Request))\n#25 {main}"] [GET, /, ::1, http://localhost/, Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36]
[2023-12-18 22:05:18] translation.WARNING [N/A] [6a80ae2] [anon.] [Symfony\Component\Translation\LoggingTranslator:log:132] - Translation not found. {"id":"トップページへ","domain":"messages","locale":"ja"} [GET, /, ::1, http://localhost/, Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36]
[2023-12-18 22:05:18] front.INFO [N/A] [6a80ae2] [anon.] [Eccube\Log\Logger:log:66] - LOGIC END ["homepage"] [GET, /, ::1, http://localhost/, Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36]
[2023-12-18 22:05:18] app.INFO [N/A] [6a80ae2] [anon.] [Eccube\Log\Logger:log:68] - PROCESS END ["homepage"] [GET, /, ::1, http://localhost/, Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36]



あるにはあるんですが、去年のものなんですよね。
mcontact
投稿日時: 2024/1/10 16:58
対応状況: −−−
登録日: 2022/1/22
居住地:
投稿: 1287
Re: 商品 並び替え機能の不具合
> あるにはあるんですが、去年のものなんですよね。

昨年のものを出されても、何もアドバイスしようがないです。
システムを組む上で、エラーが発生しているのであればログを確認するは基本中の基本です。
エラー内容が解らないでアドバイスを受けるのであればエラー内容と適切なログを記載しましょう。


----------------
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
EC-CUBEインテグレートパートナー【ゴールド】ランク
M&I Works
URL: https://miworks.biz/
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

tattsu
投稿日時: 2024/1/10 17:00
対応状況: −−−
長老
登録日: 2023/12/23
居住地:
投稿: 207
Re: 商品 並び替え機能の不具合
SELECTする項目を変えるか、
あるいはローカル環境とのことですので、sql_modeを変更すれば解消すると思います。

sql_modeにONLY_FULL_GROUP_BYが指定されている場合に、SQLによっては発生するエラーです。
https://qiita.com/masayuki14/items/3aa199035eb4fdcfa446

ただ、「商品の表示順を高い順、低い順、名前順に並び替えしたいのですが、いづれもうまくいかず、でたらめな並びになります。」というのとこのエラーが関連あるのかは記載いただいた内容からはわからないですね。


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

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


 



ログイン


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

統計情報

総メンバー数は88,736名です
総投稿数は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.