環境　ローカル
[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が原因っぽいのでしょうが、なにをどう修正すれば想定通り動くのかまったくわかりません。

なにか参考になりそうなことを教えていただけないでしょうか

EC-CUBEログを確認できますか？
どのようなエラーが出ますでしょうか？
EC-CUBEのログであれば、var/log/prod/site-yyyy-mm-dd.log に「システムエラーが発生しました」や「ERROR」といった行がありましたらご提示ください。

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

[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]



あるにはあるんですが、去年のものなんですよね。

> あるにはあるんですが、去年のものなんですよね。

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

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

SELECTする項目を変えるか、
あるいはローカル環境とのことですので、sql_modeを変更すれば解消すると思います。

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

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

----------------
-------------------

EC-CUBEカスタマイズ・バージョンアップ・不具合修正(状況調査は無料)
ゴールドパートナー。