TYPO3 Core

Bug #79298

Updated by Mathias Schreiber over 7 years ago

Page module, clicking on a page results in with mssqL: 
 Oops, an error occurred! 
 An exception occurred while executing ' 

 <pre> 
 SELECT 
     '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 
 [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 
 </pre> 
 ' 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.

Back