When using MS SQL with ModX Revolution 2.7.1-pl I get the following errors in the Error Log:
[2019-07-18 13:29:09] (ERROR @ C:\inetpub\wwwroot\core\xpdo\om\xpdoobject.class.php : 240) Error 42000 executing statement:
 => 42000
 => 169
 => [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]A column has been specified more than once in the order by list. Columns in the order by list must be unique.
Step to reproduce
Do a fresh install of ModX Revolution 2.7.1-pl using MS SQL.
I just noticed this error in the error log. As we are still setting up a test environment we want to know if this will impact the installation as we are bound by MS SQL.
I expect zero errors in the error log.
Windows Server 2016
MS SQL 2012 SP4
ModX Revolution 2.7.1-pl