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).
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.
We are sorry that this post was not useful for you!
Let us improve this post!
Tell us how we can improve this post?