Bug #91659

DBAL-DriverException in IndexedSearch backend module on PostgreSQL

Added by Stephan Großberndt about 1 year ago. Updated 10 months 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«
#1

Updated by Stephan Großberndt about 1 year ago

  • Description updated (diff)
#2

Updated by Stephan Großberndt about 1 year 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 about 1 year 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 about 1 year ago

  • Assignee set to Stephan Großberndt
#5

Updated by Gerrit Code Review about 1 year 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

#6

Updated by Gerrit Code Review about 1 year 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

#7

Updated by Stephan Großberndt about 1 year ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
#8

Updated by Benni Mack 10 months ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF