Issue Bug Closed

#81802SQL Exception when searching in recycler using PostgreSQL

Stephan Großberndt 07/05/17, 14:37 updated 04/21/20, 10:42

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.

Reviews 2