Project

General

Profile

Actions

Bug #91649

closed

Login Failure Warning not sent when using PostgreSQL or MySQL strict mode

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

Status:
Closed
Priority:
Must have
Category:
Authentication
Target version:
-
Start date:
2020-06-15
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
9
PHP Version:
Tags:
Complexity:
no-brainer
Is Regression:
Sprint Focus:

Description

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:

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

This leads to the warning email not being sent.

Actions

Also available in: Atom PDF