BootstrapCategoryTree.setup_qs error when using SQL Server

Issue #492 resolved
Ryan Bottema created an issue

Using MS SQL v15 and getting the following error with the BootstrapCategoryTree queryset

django.db.utils.ProgrammingError: ('42000', '[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]ORDER BY items must appear in the select list if SELECT DISTINCT is specified. (145) (SQLExecDirectW); [42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Statement(s) could not be prepared. (8180)')

Comments (1)

  1. Log in to comment