#79298"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.
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.