バージョン選択

フォーラム

メニュー

オンライン状況

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

サイト内検索

質問 > 管理機能 > Product/listで表示エラー

管理機能

新規スレッドを追加する

スレッド表示 | 新しいものから 前のトピック | 次のトピック | 下へ
投稿者 スレッド
codama
投稿日時: 2020/8/25 13:04
対応状況: −−−
一人前
登録日: 2020/8/3
居住地:
投稿: 72
Product/listで表示エラー
直近のfront.log ですがどう読み解けばいいのか?

[2020-08-25 12:43:40] front.ERROR [f3e63acb] [cc0f9ef] [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, MIN(d1_.price02) AS sclr_9, d0_.discriminator_type AS discriminator_type_10, d0_.creator_id AS creator_id_11, d0_.product_status_id AS product_status_id_12 FROM dtb_product d0_ 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 d1_.visible = true AND d0_.id IN (?)) AND d0_.discriminator_type IN ('product') GROUP BY d0_.id ORDER BY sclr_9 ASC, d0_.id DESC' with params [7]:\n\nSQLSTATE[42803]: Grouping error: 7 ERROR: column \"d0_.name\" must appear in the GROUP BY clause or be used in an aggregate function\nLINE 1: SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.note AS note_...\n ^","/var/www/vhosts/anmin-ne.com/httpdocs/store/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractPostgreSQLDriver.php",79,"#0 /var/www/vhosts/anmin-ne.com/httpdocs/store/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(169): Doctrine\\DBAL\\Driver\\AbstractPostgreSQLDriver->convertException('An exception oc...', Object(Doctrine\\DBAL\\Driver\\PDOException))\n#1 /var/www/vhosts/anmin-ne.com/httpdocs/store/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(145): Doctrine\\DBAL\\DBALException::wrapException(Object(Doctrine\\DBAL\\Driver\\PDOPgSql\\Driver), Object(Doctrine\\DBAL\\Driver\\PDOException), 'An exception oc...')\n#2 /var/www/vhosts/anmin-ne.com/httpdocs/store/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(913): Doctrine\\DBAL\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\DBAL\\Driver\\PDOPgSql\\Driver), Object(Doctrine\\DBAL\\Driver\\PDOException), 'SELECT d0_.id A...', Array)\n#3 /var/www/vhosts/anmin-ne.com/httpdocs/store/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(959): Doctrine\\DBAL\\Connection->executeQuery('SELECT d0_.id A...', Array, Array)\n#4 /var/www/vhosts/anmin-ne.com/httpdocs/store/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(888): Doctrine\\DBAL\\Connection->executeCacheQuery('SELECT d0_.id A...', Array, Array, Object(Doctrine\\DBAL\\Cache\\QueryCacheProfile))\n#5 /var/www/vhosts/anmin-ne.com/httpdocs/store/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 /var/www/vhosts/anmin-ne.com/httpdocs/store/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(337): Doctrine\\ORM\\Query\\Exec\\SingleSelectExecutor->execute(Object(Doctrine\\DBAL\\Connection), Array, Array)\n#7 /var/www/vhosts/anmin-ne.com/httpdocs/store/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(991): Doctrine\\ORM\\Query->_doExecute()\n#8 /var/www/vhosts/anmin-ne.com/httpdocs/store/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(946): Doctrine\\ORM\\AbstractQuery->executeIgnoreQueryCache(NULL, 1)\n#9 /var/www/vhosts/anmin-ne.com/httpdocs/store/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(749): Doctrine\\ORM\\AbstractQuery->execute(NULL, 1)\n#10 /var/www/vhosts/anmin-ne.com/httpdocs/store/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php(171): Doctrine\\ORM\\AbstractQuery->getResult(1)\n#11 [internal function]: Doctrine\\ORM\\Tools\\Pagination\\Paginator->getIterator()\n#12 /var/www/vhosts/anmin-ne.com/httpdocs/store/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 /var/www/vhosts/anmin-ne.com/httpdocs/store/vendor/symfony/event-dispatcher/EventDispatcher.php(214): 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 /var/www/vhosts/anmin-ne.com/httpdocs/store/vendor/symfony/event-dispatcher/EventDispatcher.php(44): Symfony\\Component\\EventDispatcher\\EventDispatcher->doDispatch(Array, 'knp_pager.items', Object(Knp\\Component\\Pager\\Event\\ItemsEvent))\n#15 /var/www/vhosts/anmin-ne.com/httpdocs/store/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 /var/www/vhosts/anmin-ne.com/httpdocs/store/var/cache/prod/Container2gacnbx/Paginator_f262b94.php(18): Knp\\Component\\Pager\\Paginator->paginate(Object(Doctrine\\ORM\\Query), 1, 20, Array)\n#17 /var/www/vhosts/anmin-ne.com/httpdocs/store/src/Eccube/Controller/ProductController.php(170): Paginator_f262b94->paginate(Object(Doctrine\\ORM\\Query), 1, 20)\n#18 /var/www/vhosts/anmin-ne.com/httpdocs/store/vendor/symfony/http-kernel/HttpKernel.php(151): Eccube\\Controller\\ProductController->index(Object(Symfony\\Component\\HttpFoundation\\Request), Object(Paginator_f262b94))\n#19 /var/www/vhosts/anmin-ne.com/httpdocs/store/vendor/symfony/http-kernel/HttpKernel.php(68): Symfony\\Component\\HttpKernel\\HttpKernel->handleRaw(Object(Symfony\\Component\\HttpFoundation\\Request), 1)\n#20 /var/www/vhosts/anmin-ne.com/httpdocs/store/vendor/symfony/http-kernel/Kernel.php(200): Symfony\\Component\\HttpKernel\\HttpKernel->handle(Object(Symfony\\Component\\HttpFoundation\\Request), 1, true)\n#21 /var/www/vhosts/anmin-ne.com/httpdocs/store/index.php(76): Symfony\\Component\\HttpKernel\\Kernel->handle(Object(Symfony\\Component\\HttpFoundation\\Request))\n#22 {main}"] [GET, /store/products/list?category_id=4, 118.108.82.64, https://IP/home/, Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:79.0) Gecko/20100101 Firefox/79.0]
[2020-08-25 12:43:40] front.INFO [f3e63acb] [cc0f9ef] [anon.] [Eccube\Log\Logger:log:66] - LOGIC END ["product_list"] [GET, /store/products/list?category_id=4, 118.108.82.64, https://IP/home/, Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:79.0) Gecko/20100101 Firefox/79.0]
[2020-08-25 12:43:40] app.INFO [N/A] [cc0f9ef] [anon.] [Eccube\Log\Logger:log:68] - PROCESS END ["product_list"] [GET, /store/products/list?category_id=4, 118.108.82.64, https://IP/home/, Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:79.0) Gecko/20100101 Firefox/79.0]
[2020-08-25 12:43:40] app.DEBUG [N/A] [cc0f9ef] [anon.] [Eccube\Log\Logger:log:68] - Commit executed. [] [GET, /store/products/list?category_id=4, 118.108.82.64, https://IP/home/, Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:79.0) Gecko/20100101 Firefox/79.0]

それと、サーバー上のエラーログは
2020-08-25 12:43:28 Error IPアドレス 500 GET /store/products/list?category_id=18 HTTP/1.0 https://153.122.14.183/store/ Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:79.0) Gecko/20100101 Firefox/79.0 1.81 K Apache アクセス

です。

問題点と対策をお教えいただけないでしょうか?

468
投稿日時: 2020/8/26 10:55
対応状況: −−−
登録日: 2008/10/26
居住地:
投稿: 3217
Re: Product/listで表示エラー
SQLでエラーが出ているようです
must appear in the GROUP BY clause or be used in an aggregate function

ECCUBEのログの1行目です。

プログラムに改修を加えられていますか?
もしくはPostgreSQLのバージョンが関係しているのではないでしょうか?


----------------
株式会社シロハチ
■ECCUBE2系、3系構築カスタマイズご相談ください。
EC-CUBE3マニュアル
blog

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


 



ログイン


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

統計情報

総メンバー数は89,012名です
総投稿数は110,020件です

投稿数ランキング

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