Project

General

Profile

Actions

Bug #91659

closed

DBAL-DriverException in IndexedSearch backend module on PostgreSQL

Added by Stephan Großberndt almost 4 years ago. Updated over 3 years ago.

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

100%

Estimated time:
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«
Actions

Also available in: Atom PDF