Bug #91659

DBAL-DriverException in IndexedSearch backend module on PostgreSQL

Added by Stephan Großberndt 16 days ago. Updated 16 days ago.

Status:
Under Review
Priority:
Must have
Category:
Indexed Search
Target version:
-
Start date:
2020-06-16
Due date:
% Done:

0%

TYPO3 Version:
9
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:

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«

History

#1 Updated by Stephan Großberndt 16 days ago

  • Description updated (diff)

#2 Updated by Stephan Großberndt 16 days 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.

#3 Updated by Gerrit Code Review 16 days 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

#4 Updated by Stephan Großberndt 16 days ago

  • Assignee set to Stephan Großberndt

Also available in: Atom PDF