Project

General

Profile

Actions

Bug #91659

closed

DBAL-DriverException in IndexedSearch backend module on PostgreSQL

Added by Stephan Großberndt over 4 years ago. Updated about 4 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 #1

Updated by Stephan Großberndt over 4 years ago

  • Description updated (diff)
Actions #2

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.

Actions #3

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

Actions #4

Updated by Stephan Großberndt over 4 years ago

  • Assignee set to Stephan Großberndt
Actions #5

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

Actions #6

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

Actions #7

Updated by Stephan Großberndt over 4 years ago

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

Updated by Benni Mack about 4 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF