▼テンプレート
[EC-CUBE] 4.2 新規インストール
[VirtualBox] 7.0
[OS] Rocky Linux9
[PHP] 8.2
[データベース] mysql Ver 15.1 Distrib 10.5.16-MariaDB,
[WEBサーバ] 開発中の為symfony-cliのビルトインサーバ
[ブラウザ] Google Chrome バージョン: 116.0.5845.188（Official Build）（64 ビット）
[導入プラグインの有無] WebAPI(コード:Api42)
[カスタマイズの有無] 無し
[現象] WebAPIを有効化すると管理画面から利用できる「GraphiQL」でクエリのテストをしたところ以下の結果となります。
limitとorderを同時に処理できないようですがこれは仕様なのでしょうか。
もし仕様の場合は、この修正プラグインなどありましたら教えてください。
よろしくお願いいたします。


***クエリ***

query {
products(limit:1,page:1,sorttype:"d",sortkey:"product_code"){
nodes{
id
name
}
}
************

***レスポンス***
{
"errors": [
{
"debugMessage": "Cannot select distinct identifiers from query with LIMIT and ORDER BY on a column from a fetch joined to-many association. Use output walkers.",
"message": "Internal server error",
"extensions": {
"category": "internal"
},
"locations": [
{
"line": 2,
"column": 3
}
],
"path": [
"products"
],
"trace": [
{
"file": "/home/webmaster/public_html/ec-cube/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/LimitSubqueryWalker.php",
"line": 46,
"call": "Doctrine\\ORM\\Tools\\Pagination\\LimitSubqueryWalker::validate()"
},
{
"file": "/home/webmaster/public_html/ec-cube/vendor/doctrine/orm/lib/Doctrine/ORM/Query/TreeWalkerChain.php",
"line": 97,
"call": "Doctrine\\ORM\\Tools\\Pagination\\LimitSubqueryWalker::walkSelectStatement()"
},
{
"file": "/home/webmaster/public_html/ec-cube/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php",
"line": 387,
"call": "Doctrine\\ORM\\Query\\TreeWalkerChain::walkSelectStatement()"
},
{
"file": "/home/webmaster/public_html/ec-cube/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php",
"line": 254,
"call": "Doctrine\\ORM\\Query\\Parser::parse()"
},
{
"file": "/home/webmaster/public_html/ec-cube/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php",
"line": 145,
"call": "Doctrine\\ORM\\Tools\\Pagination\\Paginator::unbindUnusedQueryParams()"
},
{
"call": "Doctrine\\ORM\\Tools\\Pagination\\Paginator::getIterator()"
},
{
"file": "/home/webmaster/public_html/ec-cube/vendor/knplabs/knp-components/src/Knp/Component/Pager/Event/Subscriber/Paginate/Doctrine/ORM/QuerySubscriber.php",
"line": 48,
"function": "iterator_to_array()"
},
{
"file": "/home/webmaster/public_html/ec-cube/vendor/symfony/event-dispatcher/Debug/WrappedListener.php",
"line": 117,
"call": "Knp\\Component\\Pager\\Event\\Subscriber\\Paginate\\Doctrine\\ORM\\QuerySubscriber::items()"
},
{
"file": "/home/webmaster/public_html/ec-cube/vendor/symfony/event-dispatcher/EventDispatcher.php",
"line": 230,
"call": "Symfony\\Component\\EventDispatcher\\Debug\\WrappedListener::__invoke()"
},
{
"file": "/home/webmaster/public_html/ec-cube/vendor/symfony/event-dispatcher/EventDispatcher.php",
"line": 59,
"call": "Symfony\\Component\\EventDispatcher\\EventDispatcher::callListeners()"
},
{
"file": "/home/webmaster/public_html/ec-cube/vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php",
"line": 154,
"call": "Symfony\\Component\\EventDispatcher\\EventDispatcher::dispatch()"
},
{
"file": "/home/webmaster/public_html/ec-cube/vendor/knplabs/knp-components/src/Knp/Component/Pager/Paginator.php",
"line": 93,
"call": "Symfony\\Component\\EventDispatcher\\Debug\\TraceableEventDispatcher::dispatch()"
},
{
"file": "/home/webmaster/public_html/ec-cube/var/cache/dev/Container3AvcL5m/PaginatorInterface_82dac15.php",
"line": 30,
"call": "Knp\\Component\\Pager\\Paginator::paginate()"
},
{
"file": "/home/webmaster/public_html/ec-cube/app/Plugin/Api42/GraphQL/Query/SearchFormQuery.php",
"line": 151,
"call": "Container3AvcL5m\\PaginatorInterface_82dac15::paginate()"
},
{
"file": "/home/webmaster/public_html/ec-cube/vendor/webonyx/graphql-php/src/Executor/ReferenceExecutor.php",
"line": 623,
"call": "Plugin\\Api42\\GraphQL\\Query\\SearchFormQuery::Plugin\\Api42\\GraphQL\\Query\\{closure}()"
},
{
"file": "/home/webmaster/public_html/ec-cube/vendor/webonyx/graphql-php/src/Executor/ReferenceExecutor.php",
"line": 550,
"call": "GraphQL\\Executor\\ReferenceExecutor::resolveFieldValueOrError()"
},
{
"file": "/home/webmaster/public_html/ec-cube/vendor/webonyx/graphql-php/src/Executor/ReferenceExecutor.php",
"line": 1195,
"call": "GraphQL\\Executor\\ReferenceExecutor::resolveField()"
},
{
"file": "/home/webmaster/public_html/ec-cube/vendor/webonyx/graphql-php/src/Executor/ReferenceExecutor.php",
"line": 264,
"call": "GraphQL\\Executor\\ReferenceExecutor::executeFields()"
},
{
"file": "/home/webmaster/public_html/ec-cube/vendor/webonyx/graphql-php/src/Executor/ReferenceExecutor.php",
"line": 215,
"call": "GraphQL\\Executor\\ReferenceExecutor::executeOperation()"
},
{
"file": "/home/webmaster/public_html/ec-cube/vendor/webonyx/graphql-php/src/Executor/Executor.php",
"line": 156,
"call": "GraphQL\\Executor\\ReferenceExecutor::doExecute()"
},
{
"file": "/home/webmaster/public_html/ec-cube/vendor/webonyx/graphql-php/src/GraphQL.php",
"line": 162,
"call": "GraphQL\\Executor\\Executor::promiseToExecute()"
},
{
"file": "/home/webmaster/public_html/ec-cube/vendor/webonyx/graphql-php/src/GraphQL.php",
"line": 94,
"call": "GraphQL\\GraphQL::promiseToExecute()"
},
{
"file": "/home/webmaster/public_html/ec-cube/app/Plugin/Api42/Controller/Admin/GraphiQLController.php",
"line": 85,
"call": "GraphQL\\GraphQL::executeQuery()"
},
{
"file": "/home/webmaster/public_html/ec-cube/vendor/symfony/http-kernel/HttpKernel.php",
"line": 163,
"call": "Plugin\\Api42\\Controller\\Admin\\GraphiQLController::index()"
},
{
"file": "/home/webmaster/public_html/ec-cube/vendor/symfony/http-kernel/HttpKernel.php",
"line": 75,
"call": "Symfony\\Component\\HttpKernel\\HttpKernel::handleRaw()"
},
{
"file": "/home/webmaster/public_html/ec-cube/vendor/symfony/http-kernel/Kernel.php",
"line": 202,
"call": "Symfony\\Component\\HttpKernel\\HttpKernel::handle()"
},
{
"file": "/home/webmaster/public_html/ec-cube/index.php",
"line": 83,
"call": "Symfony\\Component\\HttpKernel\\Kernel::handle()"
}
]
}
],
"data": {
"products": null
}
}
************