Summary
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:
Array
(
[0] => 42000
[1] => 169
[2] => [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.
Observed behavior
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.
Expected behavior
I expect zero errors in the error log.
Environment
Windows Server 2016
IIS 10.0
MS SQL 2012 SP4
ModX Revolution 2.7.1-pl