Bug #82084

List module broken on mssql

Added by Susanne Moog 2 months ago. Updated 2 months ago.

Status:
Resolved
Priority:
Should have
Assignee:
Category:
-
Start date:
2017-08-11
Due date:
% Done:

100%

TYPO3 Version:
8
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

The list module tries to sort a query that's just doing a COUNT - which fails on MSSQL.

Associated revisions

Revision 3c91f544 (diff)
Added by Susanne Moog 2 months ago

[BUGFIX] Drop sorting in COUNT query in list module

The list module throws an exception on mssql as there
is a COUNT query done with an ORDER BY sorting.

Sorting the count is pretty useless and has been
removed.

Change-Id: I8d94da2dc3dfecb7c20308180e9916b16b152b01
Resolves: #82084
Releases: master, 8.7
Reviewed-on: https://review.typo3.org/53677
Reviewed-by: Wouter Wolters <>
Reviewed-by: Christian Kuhn <>
Tested-by: TYPO3com <>
Reviewed-by: Jan Helke <>
Tested-by: Jan Helke <>
Tested-by: Christian Kuhn <>
Reviewed-by: Susanne Moog <>
Tested-by: Susanne Moog <>

Revision 086add63 (diff)
Added by Susanne Moog 2 months ago

[BUGFIX] Drop sorting in COUNT query in list module

The list module throws an exception on mssql as there
is a COUNT query done with an ORDER BY sorting.

Sorting the count is pretty useless and has been
removed.

Change-Id: I8d94da2dc3dfecb7c20308180e9916b16b152b01
Resolves: #82084
Releases: master, 8.7
Reviewed-on: https://review.typo3.org/53680
Tested-by: TYPO3com <>
Reviewed-by: Susanne Moog <>
Tested-by: Susanne Moog <>

History

#1 Updated by Gerrit Code Review 2 months ago

  • Status changed from New to Under Review

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

#2 Updated by Anonymous 2 months ago

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

#3 Updated by Gerrit Code Review 2 months ago

  • Status changed from Resolved to Under Review

Patch set 1 for branch TYPO3_8-7 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/53680

#4 Updated by Anonymous 2 months ago

  • Status changed from Under Review to Resolved

Also available in: Atom PDF