QUERY: SELECT distinct tblSubGroup1.fdesc_en as fdesc_fr, tblSubGroup1.fSubGroup1ID, tblSubGroup1.fOrder from tblSubGroup1 where tblSubGroup1.fCompanyID='244' and tblSubGroup1.fDesc_fr<>'' and isnull(tblSubGroup1.fGroupParentID, 500) like '2914' and tblSubGroup1.fActive=1 order by tblSubGroup1.fOrder, tblSubGroup1.fDesc_fr
Fatal error: Uncaught Exception: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]ORDER BY items must appear in the select list if SELECT DISTINCT is specified. in F:\inetpub\nouveau.multipsi.com\xone\ns\core\db\drivermssql\v1\drivermssql.php:193 Stack trace: #0 F:\inetpub\nouveau.multipsi.com\xone\ns\core\db\drivermssql\v1\drivermssql.php(47): ns\core\db\drivermssql->checkError() #1 F:\inetpub\nouveau.multipsi.com\xone\ns\core\db\v1\db.php(38): ns\core\db\drivermssql->execute() #2 F:\inetpub\nouveau.multipsi.com\web\pages\Category.php(183): ns\core\db->execute() #3 F:\inetpub\nouveau.multipsi.com\xone\ns\core\base\v1\base.php(323): require_once('F:\\inetpub\\nouv...') #4 F:\inetpub\nouveau.multipsi.com\xone\ns\web\layout\page\v1\page.php(18): ns\core\base->includeWorkingFile() #5 F:\inetpub\nouveau.multipsi.com\xone\ns\web\layout\v1\layout.php(17): ns\web\layout\page->myrun() #6 F:\inetpub\nouveau.multipsi.com\xone\ns\core\v1\core.php(85): ns\web\layout->__run() #7 F:\inetpub\nouveau.multipsi.com\xone\ns\core\v1\cor in F:\inetpub\nouveau.multipsi.com\xone\ns\core\db\drivermssql\v1\drivermssql.php on line 193