Request






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 'Exception' with message '[Microsoft][ODBC Driver 11 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('SELECT distinct...') #1 F:\inetpub\nouveau.multipsi.com\xone\ns\core\db\v1\db.php(38): ns\core\db\drivermssql->execute('SELECT distinct...', Array) #2 F:\inetpub\nouveau.multipsi.com\web\pages\Category.php(183): ns\core\db->execute('SELECT distinct...', Array) #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('Category.php') #5 F:\inetpub\nouveau.multipsi.com\xone\ns\web\layout\v1\layout.php(17): ns\web\layout\page->myrun() #6 F:\inetpub\nouveau.multip in F:\inetpub\nouveau.multipsi.com\xone\ns\core\db\drivermssql\v1\drivermssql.php on line 193