Project

General

Profile

Bug #91649

Updated by Stephan Großberndt almost 4 years ago

If a @$GLOBALS['TYPO3_CONF_VARS']['BE']['warning_email_addr']@ is set a DBAL-DriverException will occur in the backend log if there have been failed login attempts on a TYPO3 running with PostgreSQL: 

 <pre> 
 Core: Exception handler (WEB): 
 Uncaught TYPO3 Exception: 
 An exception occurred while executing  
 'SELECT COUNT("uid") FROM "sys_log" WHERE ("type" = ?) AND ("action" = ?) AND ("error" <> ?) AND ("tstamp" > ?) ORDER BY "tstamp" ASC' 
 with params 
 [255, 3, 0, 1592228590]: 
 SQLSTATE[42803]: Grouping error: 7 FEHLER: Spalte »sys_log.tstamp« muss in der GROUP-BY-Klausel erscheinen oder in einer Aggregatfunktion verwendet werden 
 LINE 1: ... AND ("error" <> $3) AND ("tstamp" > $4) ORDER BY "tstamp" A... ^ 
 | Doctrine\DBAL\Exception\DriverException thrown in file /vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractPostgreSQLDriver.php in line 79. 
 Requested URL: https://example.org/typo3/index.php?loginProvider=1433416747 
 </pre> 

 This leads to the warning email not being sent.

Back