Issue Bug Closed

#91659DBAL-DriverException in IndexedSearch backend module on PostgreSQL

Stephan Großberndt 06/16/20, 17:52 updated 09/29/20, 15:07

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«

Reviews 3