Bug #91659
closedDBAL-DriverException in IndexedSearch backend module on PostgreSQL
100%
Description
If you select a page with subpages in the indexed search backend module the statistics are not shown, instead a DBAL-DriverException occurs.
E.g. for page 221 with subpages 243-248 the failing query looks like this:
(1/3) Doctrine\DBAL\Exception\DriverException An exception occurred while executing ' SELECT "word", COUNT(*) AS "c" FROM "index_stat_word" WHERE "pageid" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY "word" ORDER BY "c" desc LIMIT 50 ' with params [243, [243], 244, [243,[243],244], 245, [243,[243],244,[243,[243],244],245], 246, [243,[243],244,[243,[243],244],245,[243,[243],244,[243,[243],244],245],246], 247, [243,[243],244,[243,[243],244],245,[243,[243],244,[243,[243],244],245],246,[243,[243],244,[243,[243],244],245,[243,[243],244,[243,[243],244],245],246],247], 248, [243,[243],244,[243,[243],244],245,[243,[243],244,[243,[243],244],245],246,[243,[243],244,[243,[243],244],245,[243,[243],244,[243,[243],244],245],246],247,[243,[243],244,[243,[243],244],245,[243,[243],244,[243,[243],244],245],246,[243,[243],244,[243,[243],244],245,[243,[243],244,[243,[243],244],245],246],247],248], 221]: SQLSTATE[22P02]: Invalid text representation: 7 FEHLER: ungültige Eingabesyntax für ganze Zahl: »Array«
Updated by Stephan Großberndt over 4 years ago
Apparently something is wrong with the array structure generated for the IN
query as it is multidimensional and contains the same page uids over and over again.
Updated by Gerrit Code Review over 4 years ago
- Status changed from New to Under Review
Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/64901
Updated by Stephan Großberndt over 4 years ago
- Assignee set to Stephan Großberndt
Updated by Gerrit Code Review over 4 years ago
Patch set 1 for branch 10.4 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/65095
Updated by Gerrit Code Review over 4 years ago
Patch set 1 for branch 9.5 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/65096
Updated by Stephan Großberndt over 4 years ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset ee7500a2fb58f616fbe4c36a23c360467652835f.