Project

General

Profile

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.

Added by Johannes Goslar over 7 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Should have
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.

Actions #1

Updated by Mathias Schreiber over 7 years ago

  • Description updated (diff)
Actions #2

Updated by Morton Jonuschat almost 7 years ago

  • Status changed from New to Accepted
Actions #3

Updated by Gerrit Code Review over 6 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

Actions #4

Updated by Gerrit Code Review over 6 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

Actions #5

Updated by Anonymous over 6 years ago

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

Updated by Benni Mack over 5 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF