Having an issue with SQL reports in Configurable reports. We have 4 Moodle servers recently upgraded to Moodle 3.3. SQL reports work fine on all but one of those servers. We have deleted and installed Configurable Reports plugin, updated the SQL database for that server as well. Compared all settings to those functioning in the remaining 3 Moodle 3.3 servers where configurable reports work fine. Here is the error messagereceived:
Error Code: 156
Message: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Incorrect syntax near the keyword 'ORDER'.
Error Code: 153
Message: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Invalid usage of the option NEXT in the FETCH statement.
Does anyone have any suggested solutions or approaches we might try?