Project

General

Profile

Actions

Bug #98534

closed

PostgreSQL Grouping error on Backend/Redirects

Added by Gerald Z about 2 years ago. Updated almost 2 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Category:
-
Target version:
-
Start date:
2022-10-05
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
11
PHP Version:
7.4
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

Today I ran into a new Problem with PostgreSQL:

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--

This occours when opening the Redirects Page on the Backend.

psql (PostgreSQL) 13.8 (Debian 13.8-0+deb11u1)

Actions #1

Updated by Gerald Z about 2 years ago

  • Description updated (diff)
Actions #2

Updated by Stefan Bürk about 2 years ago

  • Assignee set to Stefan Bürk
Actions #3

Updated by Gerrit Code Review about 2 years ago

  • Status changed from New to Under Review

Patch set 1 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/76037

Actions #4

Updated by Gerrit Code Review about 2 years ago

Patch set 1 for branch 11.5 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/76052

Actions #5

Updated by Stefan Bürk about 2 years ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
Actions #6

Updated by Benni Mack almost 2 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF