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.
How useful was this discussion?
Click on a star to rate it!
Average rating / 5. Vote count:
We are sorry that this post was not useful for you!
Let us improve this post!
Thanks for your feedback!