I’ve just upgraded to the latest version of Grid4PHP and switched from a WAMP-based server to Ubuntu (Apache and PHP 7.3). I am still connecting to a Microsoft SQLServer, however.

I’m now using the Microsoft ODBC Driver 17 for SQL Server. Just about everything is working with minimal changes except for grouping with sub-totals.

I am getting an error (below) and the query seems to be applying a second field to the Order by (a 1).

Error Message:

Microsoft][ODBC Driver 17 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.

The end of the query has this:

WHERE 1=1 ORDER BY PROJECT_ID ASC,1 ASC

It appears as though the second order-by clause “1 ASC” is throwing the error and I’m not sure where it is coming-from or how to remove-it. I am also using this on a multiple grid layout, if that makes any difference.

Please let me know if you have any ideas.

Thanks

Mike