Bug #98534
Updated by Gerald Z about 2 years ago
Today I ran into a new Problem with PostgreSQL: <pre> Core: Exception handler (WEB): Uncaught TYPO3 Exception: An exception occurred while executing 'SELECT COUNT(*) FROM "sys_redirect" WHERE "sys_redirect"."deleted" = 0 ORDER BY "source_host" asc, "source_host" ASC': SQLSTATE[42803]: Grouping error: 7 ERROR: column "sys_redirect.source_host" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: ...rect" WHERE "sys_redirect"."deleted" = 0 ORDER BY "source_ho... ^ | Doctrine\DBAL\Exception\DriverException thrown in file /var/www/typo3/typo3_src-11.5.16/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractPostgreSQLDriver.php in line 102. Requested URL: https://--Anonymized--/typo3/module/site/redirects?token=--AnonymizedToken-- </pre> This occours when opening the Redirects Page on the Backend. psql (PostgreSQL) 13.8 (Debian 13.8-0+deb11u1)