Actions
Bug #79298
closed"sys_language.sorting" is invalid in the ORDER BY clause because it is not contained in either an aggregate function or the GROUP BY clause.
Status:
Closed
Priority:
Should have
Assignee:
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2017-01-12
Due date:
% Done:
100%
Estimated time:
TYPO3 Version:
8
PHP Version:
Tags:
Complexity:
Is Regression:
No
Sprint Focus:
Description
Page module, clicking on a page results in with mssqL:
Oops, an error occurred!
An exception occurred while executing '
SELECT [sys_language].[uid] AS [uid], [sys_language].[title] AS [title] FROM [sys_language] INNER JOIN [pages_language_overlay] [pages_language_overlay] ON [sys_language].[uid] = [pages_language_overlay].[sys_language_uid WHERE ([pages_language_overlay].[deleted] = ?) AND ([pages_language_overlay].[pid] = ?) AND (([pages_language_overlay].[t3ver_state] >= ?) OR ([pages_language_overlay].[t3ver_wsid] = ?)) GROUP BY [pages_language_overlay].[sys_language_uid], [sys_language].[uid], [sys_language].[pid], [sys_language].[tstamp], [sys_language].[hidden], [sys_language].[title], [sys_language].[language_isocode], [sys_language].[static_lang_isocode], [sys_language].[flag] ORDER BY [sys_language].[sorting] ASC
' with params [0, 1, "0", 0]:
SQLSTATE [42000, 8127]: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Column "sys_language.sorting" is invalid in the ORDER BY clause because it is not contained in either an aggregate function or the GROUP BY clause.
Updated by Morton Jonuschat over 7 years ago
- Status changed from New to Accepted
Updated by Gerrit Code Review over 7 years ago
- Status changed from Accepted 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/53674
Updated by Gerrit Code Review over 7 years ago
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/53676
Updated by Anonymous over 7 years ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset 4ae10c81e81ce3a3d95f8a36c25109fef226ff0d.
Actions