2024-01-12 10:27:38 [::1][25051][uka3de0a265g013b2pivm1sp4j][error][yii\db\Exception] PDOException: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near ','. in C:\xampp\htdocs\NCHM\vendor\yiisoft\yii2\db\Command.php:1302 Stack trace: #0 C:\xampp\htdocs\NCHM\vendor\yiisoft\yii2\db\Command.php(1302): PDOStatement->execute() #1 C:\xampp\htdocs\NCHM\vendor\yiisoft\yii2\db\Command.php(1168): yii\db\Command->internalExecute('exec getCommonD...') #2 C:\xampp\htdocs\NCHM\vendor\yiisoft\yii2\db\Command.php(410): yii\db\Command->queryInternal('fetchAll', NULL) #3 C:\xampp\htdocs\NCHM\frontend\modules\application\controllers\QualificationController.php(103): yii\db\Command->queryAll() #4 [internal function]: app\modules\application\controllers\QualificationController->actionIndex() #5 C:\xampp\htdocs\NCHM\vendor\yiisoft\yii2\base\InlineAction.php(57): call_user_func_array(Array, Array) #6 C:\xampp\htdocs\NCHM\vendor\yiisoft\yii2\base\Controller.php(178): yii\base\InlineAction->runWithParams(Array) #7 C:\xampp\htdocs\NCHM\vendor\yiisoft\yii2\base\Module.php(552): yii\base\Controller->runAction('index', Array) #8 C:\xampp\htdocs\NCHM\vendor\yiisoft\yii2\web\Application.php(103): yii\base\Module->runAction('application/qua...', Array) #9 C:\xampp\htdocs\NCHM\vendor\yiisoft\yii2\base\Application.php(384): yii\web\Application->handleRequest(Object(yii\web\Request)) #10 C:\xampp\htdocs\NCHM\frontend\web\index.php(18): yii\base\Application->run() #11 {main} Next yii\db\Exception: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near ','. The SQL being executed was: exec getCommonDataSP 'ID,UPPER(UniversityBoardName) as UniversityBoardName', 'WHERE IsActive=1 and (BoardType=10,UniversityCode!=99)', 'UniversityBoardMst', 'order by UniversityBoardName asc' in C:\xampp\htdocs\NCHM\vendor\yiisoft\yii2\db\Schema.php:676 Stack trace: #0 C:\xampp\htdocs\NCHM\vendor\yiisoft\yii2\db\Command.php(1307): yii\db\Schema->convertException(Object(PDOException), 'exec getCommonD...') #1 C:\xampp\htdocs\NCHM\vendor\yiisoft\yii2\db\Command.php(1168): yii\db\Command->internalExecute('exec getCommonD...') #2 C:\xampp\htdocs\NCHM\vendor\yiisoft\yii2\db\Command.php(410): yii\db\Command->queryInternal('fetchAll', NULL) #3 C:\xampp\htdocs\NCHM\frontend\modules\application\controllers\QualificationController.php(103): yii\db\Command->queryAll() #4 [internal function]: app\modules\application\controllers\QualificationController->actionIndex() #5 C:\xampp\htdocs\NCHM\vendor\yiisoft\yii2\base\InlineAction.php(57): call_user_func_array(Array, Array) #6 C:\xampp\htdocs\NCHM\vendor\yiisoft\yii2\base\Controller.php(178): yii\base\InlineAction->runWithParams(Array) #7 C:\xampp\htdocs\NCHM\vendor\yiisoft\yii2\base\Module.php(552): yii\base\Controller->runAction('index', Array) #8 C:\xampp\htdocs\NCHM\vendor\yiisoft\yii2\web\Application.php(103): yii\base\Module->runAction('application/qua...', Array) #9 C:\xampp\htdocs\NCHM\vendor\yiisoft\yii2\base\Application.php(384): yii\web\Application->handleRequest(Object(yii\web\Request)) #10 C:\xampp\htdocs\NCHM\frontend\web\index.php(18): yii\base\Application->run() #11 {main} Additional Information: Array ( [0] => 42000 [1] => 102 [2] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near ','. )