error by indexing pages

[p-view]

become in typo3 11.5 ke_search 4.5.1:
Core: Exception handler (WEB): Uncaught TYPO3 Exception: An exception occurred while executing 'SELECT pages.*, GROUP_CONCAT(CONCAT("#", tx_kesearch_filteroptions.tag, "#")) as tags FROM pages, tx_kesearch_filteroptions WHERE (pages.uid IN (565,1000195,1000196,1000197,1000198,1000199,1000201,1000202,1000203,1000204,1000205,1000206,1000207,1000208,1000209,1000210,1000211,1000212,1000229) AND pages.tx_kesearch_tags <> "" AND FIND_IN_SET(tx_kesearch_filteroptions.uid, pages.tx_kesearch_tags)) AND (((pages.deleted = 0) AND (tx_kesearch_filteroptions.deleted = 0)) AND ((pages.hidden = 0) AND (tx_kesearch_filteroptions.hidden = 0))) GROUP BY pages.uid': 'typo3_2022.pages.pid' isn't in GROUP BY

[christianbltr]

What database are you using and in which version?
Could you explain a bit more how to reproduce this issue?

[p-view]

i use MariaDB 10.1.48
the problem comes from indexerBase.php #250
$tagQuery = $queryBuilder
->add('select', $fields)
->from('pages')
->from('tx_kesearch_filteroptions')
->add('where', $where)
->groupBy('pages.uid')
->execute();

solutions by google keeps me this: "In mysql array, set strict => false to disable MySQL's strict mode"
But for me is not possible to configurate this.

[christianbltr]

This error only occurs when sql_mode ONLY_FULL_GROUP_BY is set.
This is now fixed in version 4.6.2.
Thanks for reporting.

Please use https://github.com/tpwd/ke_search/issues for reporting further issues because that's the official issue tracker.