Project

General

Profile

Actions

Bug #81802

closed

SQL Exception when searching in recycler using PostgreSQL

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

Status:
Closed
Priority:
Must have
Assignee:
-
Category:
Recycler
Target version:
-
Start date:
2017-07-05
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
8
PHP Version:
Tags:
postgresql
Complexity:
Is Regression:
Sprint Focus:

Description

Searching for any string in the recycler causes an SQL Exception, e.g. searching for 98770 leads to

Core: Exception handler (WEB): Uncaught TYPO3 Exception: An exception occurred while executing 

'SELECT COUNT(*) FROM "tx_extension_table" WHERE ("pid" = ?) AND (("uid" = ?) OR ("pid" = ?) OR ("uid" LIKE ?)) AND ("deleted" <> ?)' 

with params [18, "98770", "98770", "'%98770%'", 0]: 

SQLSTATE[42883]: Undefined function: 7 

FEHLER: Operator existiert nicht: integer ~~ unknown LINE 1: ...= $1) AND (("uid" = $2) OR ("pid" = $3) OR ("uid" LIKE $4)) ... ^ 

HINT: Kein Operator stimmt mit dem angegebenen Namen und den Argumenttypen überein. Sie müssen möglicherweise ausdrückliche Typumwandlungen hinzufügen.

Doctrine\DBAL\Exception\DriverException thrown in file vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractPostgreSQLDriver.php in line 91. Requested URL: http://example.org/typo3/index.php?ajaxID=%2Fajax%2Frecycler&ajaxToken=XXX&action=getDeletedRecords&depth=999&startUid=18&table=tx_extension_table&filterTxt=98770&start=0&limit=50

I guess this happens because column uid is of type int and a LIKE search is performed on the column.


Related issues 2 (1 open1 closed)

Related to TYPO3 Core - Bug #82837: Exception in backend searching in columns of type integer/bigint on PostgreSQLClosed2017-10-20

Actions
Related to TYPO3 Core - Epic #90719: PostgreSQL related issuesAccepted2020-03-10

Actions
Actions

Also available in: Atom PDF