Bug #85743

An exception occurred if I click on List

Added by Alexander Averbuch over 1 year ago. Updated 10 months ago.

Status:
Closed
Priority:
Must have
Assignee:
-
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2016-10-03
Due date:
2016-10-03
% Done:

0%

TYPO3 Version:
9
PHP Version:
7.2
Tags:
postgres
Complexity:
Is Regression:
Yes
Sprint Focus:

Description

I have fresh installed TYPO3 9.3.3
If I click on List, I get an error message. See the screenshot.
I'm using PostgreSQL 9.5 as database

typo3nine-bug.jpg View (93.8 KB) Alexander Averbuch, 2018-08-03 16:17


Related issues

Duplicates TYPO3 Core - Bug #85359: BE-Pagebrowser broken Closed 2018-06-23
Follows TYPO3 Core - Bug #78129: Statement::rowCount not reliable for SELECT queries Closed 2016-10-02

History

#1 Updated by Alexander Averbuch over 1 year ago

You should consider how to use ORDER BY and GROUP BY in PostgreSQL. There is a huge difference in comparison to MySQL

#2 Updated by Stephan Großberndt over 1 year ago

  • Description updated (diff)

#3 Updated by Stephan Großberndt over 1 year ago

  • Tags set to postgres
  • Is Regression set to Yes

Problem here is that the COUNT() statement must not use the ORDER BY and LIMIT.

#5 Updated by Stephan Großberndt over 1 year ago

  • Due date set to 2016-10-03
  • Start date changed from 2018-08-03 to 2016-10-03
  • Follows Bug #78129: Statement::rowCount not reliable for SELECT queries added

#6 Updated by Alexander Averbuch over 1 year ago

yes, it makes no sense to use ORDER with COUNT. Also if using MySQL

#7 Updated by Riccardo De Contardi over 1 year ago

  • Category set to Database API (Doctrine DBAL)

#8 Updated by Susanne Moog over 1 year ago

  • Duplicates Bug #85359: BE-Pagebrowser broken added

#9 Updated by Susanne Moog over 1 year ago

  • Status changed from New to Resolved

This has been fixed with https://review.typo3.org/#/c/57347/ (for TYPO3 9.4.0 and later).

#10 Updated by Benni Mack 10 months ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF