Actions
Bug #91649
closedLogin Failure Warning not sent when using PostgreSQL or MySQL strict mode
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