2024-03-19 11:36:08 [125.63.102.166][35461][4l5qe1n16dj0r7khlcbhld8ql8][error][yii\web\HttpException:400] yii\web\BadRequestHttpException: Missing required parameters: id, StateId in C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\web\Controller.php:199 Stack trace: #0 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\InlineAction.php(51): yii\web\Controller->bindActionParams(Object(yii\base\InlineAction), Array) #1 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Controller.php(178): yii\base\InlineAction->runWithParams(Array) #2 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Module.php(552): yii\base\Controller->runAction('resultmode-coll...', Array) #3 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\web\Application.php(103): yii\base\Module->runAction('application/app...', Array) #4 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Application.php(384): yii\web\Application->handleRequest(Object(yii\web\Request)) #5 C:\xampp\htdocs\NTA_Exams\swayam12\frontend\web\index.php(18): yii\base\Application->run() #6 {main} 2024-03-19 11:36:47 [125.63.102.166][35461][4l5qe1n16dj0r7khlcbhld8ql8][error][yii\db\Exception] PDOException: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'and'. in C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php:1320 Stack trace: #0 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(1320): PDOStatement->execute() #1 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(1186): yii\db\Command->internalExecute('exec getCommonD...') #2 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(417): yii\db\Command->queryInternal('fetchAll', NULL) #3 C:\xampp\htdocs\NTA_Exams\swayam12\common\components\MasterDataComponent.php(830): yii\db\Command->queryAll() #4 C:\xampp\htdocs\NTA_Exams\swayam12\common\components\MasterDataComponent.php(837): common\components\MasterDataComponent->collegeList('164784', '27') #5 C:\xampp\htdocs\NTA_Exams\swayam12\frontend\modules\application\controllers\ApplicationController.php(172): common\components\MasterDataComponent->getCollegeData('164784', '27') #6 [internal function]: app\modules\application\controllers\ApplicationController->actionResultmodeCollege('164784', '27') #7 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\InlineAction.php(57): call_user_func_array(Array, Array) #8 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Controller.php(178): yii\base\InlineAction->runWithParams(Array) #9 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Module.php(552): yii\base\Controller->runAction('resultmode-coll...', Array) #10 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\web\Application.php(103): yii\base\Module->runAction('application/app...', Array) #11 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Application.php(384): yii\web\Application->handleRequest(Object(yii\web\Request)) #12 C:\xampp\htdocs\NTA_Exams\swayam12\frontend\web\index.php(18): yii\base\Application->run() #13 {main} Next yii\db\Exception: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'and'. The SQL being executed was: exec getCommonDataSP 'ID,CollegeName', 'WHERE and StateID=164784 OR IsOtherCollege=1 ', 'CollegeMst' in C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Schema.php:676 Stack trace: #0 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(1325): yii\db\Schema->convertException(Object(PDOException), 'exec getCommonD...') #1 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(1186): yii\db\Command->internalExecute('exec getCommonD...') #2 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(417): yii\db\Command->queryInternal('fetchAll', NULL) #3 C:\xampp\htdocs\NTA_Exams\swayam12\common\components\MasterDataComponent.php(830): yii\db\Command->queryAll() #4 C:\xampp\htdocs\NTA_Exams\swayam12\common\components\MasterDataComponent.php(837): common\components\MasterDataComponent->collegeList('164784', '27') #5 C:\xampp\htdocs\NTA_Exams\swayam12\frontend\modules\application\controllers\ApplicationController.php(172): common\components\MasterDataComponent->getCollegeData('164784', '27') #6 [internal function]: app\modules\application\controllers\ApplicationController->actionResultmodeCollege('164784', '27') #7 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\InlineAction.php(57): call_user_func_array(Array, Array) #8 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Controller.php(178): yii\base\InlineAction->runWithParams(Array) #9 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Module.php(552): yii\base\Controller->runAction('resultmode-coll...', Array) #10 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\web\Application.php(103): yii\base\Module->runAction('application/app...', Array) #11 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Application.php(384): yii\web\Application->handleRequest(Object(yii\web\Request)) #12 C:\xampp\htdocs\NTA_Exams\swayam12\frontend\web\index.php(18): yii\base\Application->run() #13 {main} Additional Information: Array ( [0] => 42000 [1] => 156 [2] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'and'. ) 2024-03-19 11:38:44 [125.63.102.166][35461][4l5qe1n16dj0r7khlcbhld8ql8][error][yii\db\Exception] PDOException: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'and'. in C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php:1320 Stack trace: #0 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(1320): PDOStatement->execute() #1 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(1186): yii\db\Command->internalExecute('exec getCommonD...') #2 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(417): yii\db\Command->queryInternal('fetchAll', NULL) #3 C:\xampp\htdocs\NTA_Exams\swayam12\common\components\MasterDataComponent.php(830): yii\db\Command->queryAll() #4 C:\xampp\htdocs\NTA_Exams\swayam12\common\components\MasterDataComponent.php(837): common\components\MasterDataComponent->collegeList('164784', '27') #5 C:\xampp\htdocs\NTA_Exams\swayam12\frontend\modules\application\controllers\ApplicationController.php(175): common\components\MasterDataComponent->getCollegeData('164784', '27') #6 [internal function]: app\modules\application\controllers\ApplicationController->actionResultmodeCollege() #7 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\InlineAction.php(57): call_user_func_array(Array, Array) #8 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Controller.php(178): yii\base\InlineAction->runWithParams(Array) #9 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Module.php(552): yii\base\Controller->runAction('resultmode-coll...', Array) #10 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\web\Application.php(103): yii\base\Module->runAction('application/app...', Array) #11 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Application.php(384): yii\web\Application->handleRequest(Object(yii\web\Request)) #12 C:\xampp\htdocs\NTA_Exams\swayam12\frontend\web\index.php(18): yii\base\Application->run() #13 {main} Next yii\db\Exception: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'and'. The SQL being executed was: exec getCommonDataSP 'ID,CollegeName', 'WHERE and StateID=164784 OR IsOtherCollege=1 ', 'CollegeMst' in C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Schema.php:676 Stack trace: #0 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(1325): yii\db\Schema->convertException(Object(PDOException), 'exec getCommonD...') #1 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(1186): yii\db\Command->internalExecute('exec getCommonD...') #2 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(417): yii\db\Command->queryInternal('fetchAll', NULL) #3 C:\xampp\htdocs\NTA_Exams\swayam12\common\components\MasterDataComponent.php(830): yii\db\Command->queryAll() #4 C:\xampp\htdocs\NTA_Exams\swayam12\common\components\MasterDataComponent.php(837): common\components\MasterDataComponent->collegeList('164784', '27') #5 C:\xampp\htdocs\NTA_Exams\swayam12\frontend\modules\application\controllers\ApplicationController.php(175): common\components\MasterDataComponent->getCollegeData('164784', '27') #6 [internal function]: app\modules\application\controllers\ApplicationController->actionResultmodeCollege() #7 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\InlineAction.php(57): call_user_func_array(Array, Array) #8 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Controller.php(178): yii\base\InlineAction->runWithParams(Array) #9 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Module.php(552): yii\base\Controller->runAction('resultmode-coll...', Array) #10 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\web\Application.php(103): yii\base\Module->runAction('application/app...', Array) #11 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Application.php(384): yii\web\Application->handleRequest(Object(yii\web\Request)) #12 C:\xampp\htdocs\NTA_Exams\swayam12\frontend\web\index.php(18): yii\base\Application->run() #13 {main} Additional Information: Array ( [0] => 42000 [1] => 156 [2] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'and'. ) 2024-03-19 11:41:20 [125.63.102.166][35461][4l5qe1n16dj0r7khlcbhld8ql8][error][yii\db\Exception] PDOException: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'and'. in C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php:1320 Stack trace: #0 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(1320): PDOStatement->execute() #1 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(1186): yii\db\Command->internalExecute('exec getCommonD...') #2 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(417): yii\db\Command->queryInternal('fetchAll', NULL) #3 C:\xampp\htdocs\NTA_Exams\swayam12\common\components\MasterDataComponent.php(830): yii\db\Command->queryAll() #4 C:\xampp\htdocs\NTA_Exams\swayam12\common\components\MasterDataComponent.php(837): common\components\MasterDataComponent->collegeList('164784', '27') #5 C:\xampp\htdocs\NTA_Exams\swayam12\frontend\modules\application\controllers\ApplicationController.php(175): common\components\MasterDataComponent->getCollegeData('164784', '27') #6 [internal function]: app\modules\application\controllers\ApplicationController->actionResultmodeCollege() #7 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\InlineAction.php(57): call_user_func_array(Array, Array) #8 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Controller.php(178): yii\base\InlineAction->runWithParams(Array) #9 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Module.php(552): yii\base\Controller->runAction('resultmode-coll...', Array) #10 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\web\Application.php(103): yii\base\Module->runAction('application/app...', Array) #11 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Application.php(384): yii\web\Application->handleRequest(Object(yii\web\Request)) #12 C:\xampp\htdocs\NTA_Exams\swayam12\frontend\web\index.php(18): yii\base\Application->run() #13 {main} Next yii\db\Exception: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'and'. The SQL being executed was: exec getCommonDataSP 'ID,CollegeName', 'WHERE and StateID=27 OR IsOtherCollege=1 ', 'CollegeMst' in C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Schema.php:676 Stack trace: #0 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(1325): yii\db\Schema->convertException(Object(PDOException), 'exec getCommonD...') #1 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(1186): yii\db\Command->internalExecute('exec getCommonD...') #2 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(417): yii\db\Command->queryInternal('fetchAll', NULL) #3 C:\xampp\htdocs\NTA_Exams\swayam12\common\components\MasterDataComponent.php(830): yii\db\Command->queryAll() #4 C:\xampp\htdocs\NTA_Exams\swayam12\common\components\MasterDataComponent.php(837): common\components\MasterDataComponent->collegeList('164784', '27') #5 C:\xampp\htdocs\NTA_Exams\swayam12\frontend\modules\application\controllers\ApplicationController.php(175): common\components\MasterDataComponent->getCollegeData('164784', '27') #6 [internal function]: app\modules\application\controllers\ApplicationController->actionResultmodeCollege() #7 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\InlineAction.php(57): call_user_func_array(Array, Array) #8 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Controller.php(178): yii\base\InlineAction->runWithParams(Array) #9 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Module.php(552): yii\base\Controller->runAction('resultmode-coll...', Array) #10 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\web\Application.php(103): yii\base\Module->runAction('application/app...', Array) #11 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Application.php(384): yii\web\Application->handleRequest(Object(yii\web\Request)) #12 C:\xampp\htdocs\NTA_Exams\swayam12\frontend\web\index.php(18): yii\base\Application->run() #13 {main} Additional Information: Array ( [0] => 42000 [1] => 156 [2] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'and'. ) 2024-03-19 11:43:42 [125.63.102.166][35461][4l5qe1n16dj0r7khlcbhld8ql8][error][yii\db\Exception] PDOException: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'and'. in C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php:1320 Stack trace: #0 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(1320): PDOStatement->execute() #1 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(1186): yii\db\Command->internalExecute('exec getCommonD...') #2 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(417): yii\db\Command->queryInternal('fetchAll', NULL) #3 C:\xampp\htdocs\NTA_Exams\swayam12\common\components\MasterDataComponent.php(830): yii\db\Command->queryAll() #4 C:\xampp\htdocs\NTA_Exams\swayam12\common\components\MasterDataComponent.php(838): common\components\MasterDataComponent->collegeList('164749', '8') #5 C:\xampp\htdocs\NTA_Exams\swayam12\frontend\modules\application\controllers\ApplicationController.php(175): common\components\MasterDataComponent->getCollegeData('164749', '8') #6 [internal function]: app\modules\application\controllers\ApplicationController->actionResultmodeCollege() #7 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\InlineAction.php(57): call_user_func_array(Array, Array) #8 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Controller.php(178): yii\base\InlineAction->runWithParams(Array) #9 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Module.php(552): yii\base\Controller->runAction('resultmode-coll...', Array) #10 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\web\Application.php(103): yii\base\Module->runAction('application/app...', Array) #11 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Application.php(384): yii\web\Application->handleRequest(Object(yii\web\Request)) #12 C:\xampp\htdocs\NTA_Exams\swayam12\frontend\web\index.php(18): yii\base\Application->run() #13 {main} Next yii\db\Exception: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'and'. The SQL being executed was: exec getCommonDataSP 'ID,CollegeName', 'WHERE and StateID=8 OR IsOtherCollege=1 ', 'CollegeMst' in C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Schema.php:676 Stack trace: #0 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(1325): yii\db\Schema->convertException(Object(PDOException), 'exec getCommonD...') #1 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(1186): yii\db\Command->internalExecute('exec getCommonD...') #2 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(417): yii\db\Command->queryInternal('fetchAll', NULL) #3 C:\xampp\htdocs\NTA_Exams\swayam12\common\components\MasterDataComponent.php(830): yii\db\Command->queryAll() #4 C:\xampp\htdocs\NTA_Exams\swayam12\common\components\MasterDataComponent.php(838): common\components\MasterDataComponent->collegeList('164749', '8') #5 C:\xampp\htdocs\NTA_Exams\swayam12\frontend\modules\application\controllers\ApplicationController.php(175): common\components\MasterDataComponent->getCollegeData('164749', '8') #6 [internal function]: app\modules\application\controllers\ApplicationController->actionResultmodeCollege() #7 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\InlineAction.php(57): call_user_func_array(Array, Array) #8 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Controller.php(178): yii\base\InlineAction->runWithParams(Array) #9 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Module.php(552): yii\base\Controller->runAction('resultmode-coll...', Array) #10 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\web\Application.php(103): yii\base\Module->runAction('application/app...', Array) #11 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Application.php(384): yii\web\Application->handleRequest(Object(yii\web\Request)) #12 C:\xampp\htdocs\NTA_Exams\swayam12\frontend\web\index.php(18): yii\base\Application->run() #13 {main} Additional Information: Array ( [0] => 42000 [1] => 156 [2] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'and'. ) 2024-03-19 11:44:21 [125.63.102.166][35461][4l5qe1n16dj0r7khlcbhld8ql8][error][yii\db\Exception] PDOException: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'and'. in C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php:1320 Stack trace: #0 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(1320): PDOStatement->execute() #1 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(1186): yii\db\Command->internalExecute('exec getCommonD...') #2 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(417): yii\db\Command->queryInternal('fetchAll', NULL) #3 C:\xampp\htdocs\NTA_Exams\swayam12\common\components\MasterDataComponent.php(831): yii\db\Command->queryAll() #4 C:\xampp\htdocs\NTA_Exams\swayam12\common\components\MasterDataComponent.php(839): common\components\MasterDataComponent->collegeList('164749', '8') #5 C:\xampp\htdocs\NTA_Exams\swayam12\frontend\modules\application\controllers\ApplicationController.php(175): common\components\MasterDataComponent->getCollegeData('164749', '8') #6 [internal function]: app\modules\application\controllers\ApplicationController->actionResultmodeCollege() #7 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\InlineAction.php(57): call_user_func_array(Array, Array) #8 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Controller.php(178): yii\base\InlineAction->runWithParams(Array) #9 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Module.php(552): yii\base\Controller->runAction('resultmode-coll...', Array) #10 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\web\Application.php(103): yii\base\Module->runAction('application/app...', Array) #11 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Application.php(384): yii\web\Application->handleRequest(Object(yii\web\Request)) #12 C:\xampp\htdocs\NTA_Exams\swayam12\frontend\web\index.php(18): yii\base\Application->run() #13 {main} Next yii\db\Exception: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'and'. The SQL being executed was: exec getCommonDataSP 'ID,CollegeName', 'WHERE and StateID=8 OR IsOtherCollege=1 ', 'CollegeMst' in C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Schema.php:676 Stack trace: #0 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(1325): yii\db\Schema->convertException(Object(PDOException), 'exec getCommonD...') #1 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(1186): yii\db\Command->internalExecute('exec getCommonD...') #2 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(417): yii\db\Command->queryInternal('fetchAll', NULL) #3 C:\xampp\htdocs\NTA_Exams\swayam12\common\components\MasterDataComponent.php(831): yii\db\Command->queryAll() #4 C:\xampp\htdocs\NTA_Exams\swayam12\common\components\MasterDataComponent.php(839): common\components\MasterDataComponent->collegeList('164749', '8') #5 C:\xampp\htdocs\NTA_Exams\swayam12\frontend\modules\application\controllers\ApplicationController.php(175): common\components\MasterDataComponent->getCollegeData('164749', '8') #6 [internal function]: app\modules\application\controllers\ApplicationController->actionResultmodeCollege() #7 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\InlineAction.php(57): call_user_func_array(Array, Array) #8 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Controller.php(178): yii\base\InlineAction->runWithParams(Array) #9 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Module.php(552): yii\base\Controller->runAction('resultmode-coll...', Array) #10 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\web\Application.php(103): yii\base\Module->runAction('application/app...', Array) #11 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Application.php(384): yii\web\Application->handleRequest(Object(yii\web\Request)) #12 C:\xampp\htdocs\NTA_Exams\swayam12\frontend\web\index.php(18): yii\base\Application->run() #13 {main} Additional Information: Array ( [0] => 42000 [1] => 156 [2] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'and'. ) 2024-03-19 11:48:08 [125.63.102.166][35461][4l5qe1n16dj0r7khlcbhld8ql8][error][yii\db\Exception] PDOException: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'OR'. in C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php:1320 Stack trace: #0 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(1320): PDOStatement->execute() #1 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(1186): yii\db\Command->internalExecute('exec getCommonD...') #2 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(417): yii\db\Command->queryInternal('fetchAll', NULL) #3 C:\xampp\htdocs\NTA_Exams\swayam12\common\components\MasterDataComponent.php(828): yii\db\Command->queryAll() #4 C:\xampp\htdocs\NTA_Exams\swayam12\frontend\modules\application\controllers\CollegeController.php(190): common\components\MasterDataComponent->collegeList('164862') #5 [internal function]: app\modules\application\controllers\CollegeController->actionIndex() #6 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\InlineAction.php(57): call_user_func_array(Array, Array) #7 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Controller.php(178): yii\base\InlineAction->runWithParams(Array) #8 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Module.php(552): yii\base\Controller->runAction('index', Array) #9 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\web\Application.php(103): yii\base\Module->runAction('application/col...', Array) #10 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Application.php(384): yii\web\Application->handleRequest(Object(yii\web\Request)) #11 C:\xampp\htdocs\NTA_Exams\swayam12\frontend\web\index.php(18): yii\base\Application->run() #12 {main} Next yii\db\Exception: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'OR'. The SQL being executed was: exec getCommonDataSP 'ID,CollegeName', 'WHERE OR IsOtherCollege=1 ', 'CollegeMst' in C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Schema.php:676 Stack trace: #0 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(1325): yii\db\Schema->convertException(Object(PDOException), 'exec getCommonD...') #1 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(1186): yii\db\Command->internalExecute('exec getCommonD...') #2 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(417): yii\db\Command->queryInternal('fetchAll', NULL) #3 C:\xampp\htdocs\NTA_Exams\swayam12\common\components\MasterDataComponent.php(828): yii\db\Command->queryAll() #4 C:\xampp\htdocs\NTA_Exams\swayam12\frontend\modules\application\controllers\CollegeController.php(190): common\components\MasterDataComponent->collegeList('164862') #5 [internal function]: app\modules\application\controllers\CollegeController->actionIndex() #6 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\InlineAction.php(57): call_user_func_array(Array, Array) #7 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Controller.php(178): yii\base\InlineAction->runWithParams(Array) #8 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Module.php(552): yii\base\Controller->runAction('index', Array) #9 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\web\Application.php(103): yii\base\Module->runAction('application/col...', Array) #10 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Application.php(384): yii\web\Application->handleRequest(Object(yii\web\Request)) #11 C:\xampp\htdocs\NTA_Exams\swayam12\frontend\web\index.php(18): yii\base\Application->run() #12 {main} Additional Information: Array ( [0] => 42000 [1] => 156 [2] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'OR'. ) 2024-03-19 11:48:13 [125.63.102.166][35461][4l5qe1n16dj0r7khlcbhld8ql8][error][yii\db\Exception] PDOException: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'OR'. in C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php:1320 Stack trace: #0 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(1320): PDOStatement->execute() #1 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(1186): yii\db\Command->internalExecute('exec getCommonD...') #2 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(417): yii\db\Command->queryInternal('fetchAll', NULL) #3 C:\xampp\htdocs\NTA_Exams\swayam12\common\components\MasterDataComponent.php(828): yii\db\Command->queryAll() #4 C:\xampp\htdocs\NTA_Exams\swayam12\frontend\modules\application\controllers\CollegeController.php(190): common\components\MasterDataComponent->collegeList('164862') #5 [internal function]: app\modules\application\controllers\CollegeController->actionIndex() #6 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\InlineAction.php(57): call_user_func_array(Array, Array) #7 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Controller.php(178): yii\base\InlineAction->runWithParams(Array) #8 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Module.php(552): yii\base\Controller->runAction('index', Array) #9 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\web\Application.php(103): yii\base\Module->runAction('application/col...', Array) #10 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Application.php(384): yii\web\Application->handleRequest(Object(yii\web\Request)) #11 C:\xampp\htdocs\NTA_Exams\swayam12\frontend\web\index.php(18): yii\base\Application->run() #12 {main} Next yii\db\Exception: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'OR'. The SQL being executed was: exec getCommonDataSP 'ID,CollegeName', 'WHERE OR IsOtherCollege=1 ', 'CollegeMst' in C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Schema.php:676 Stack trace: #0 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(1325): yii\db\Schema->convertException(Object(PDOException), 'exec getCommonD...') #1 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(1186): yii\db\Command->internalExecute('exec getCommonD...') #2 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(417): yii\db\Command->queryInternal('fetchAll', NULL) #3 C:\xampp\htdocs\NTA_Exams\swayam12\common\components\MasterDataComponent.php(828): yii\db\Command->queryAll() #4 C:\xampp\htdocs\NTA_Exams\swayam12\frontend\modules\application\controllers\CollegeController.php(190): common\components\MasterDataComponent->collegeList('164862') #5 [internal function]: app\modules\application\controllers\CollegeController->actionIndex() #6 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\InlineAction.php(57): call_user_func_array(Array, Array) #7 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Controller.php(178): yii\base\InlineAction->runWithParams(Array) #8 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Module.php(552): yii\base\Controller->runAction('index', Array) #9 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\web\Application.php(103): yii\base\Module->runAction('application/col...', Array) #10 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Application.php(384): yii\web\Application->handleRequest(Object(yii\web\Request)) #11 C:\xampp\htdocs\NTA_Exams\swayam12\frontend\web\index.php(18): yii\base\Application->run() #12 {main} Additional Information: Array ( [0] => 42000 [1] => 156 [2] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'OR'. ) 2024-03-19 11:48:20 [125.63.102.166][35461][4l5qe1n16dj0r7khlcbhld8ql8][error][yii\db\Exception] PDOException: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'OR'. in C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php:1320 Stack trace: #0 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(1320): PDOStatement->execute() #1 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(1186): yii\db\Command->internalExecute('exec getCommonD...') #2 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(417): yii\db\Command->queryInternal('fetchAll', NULL) #3 C:\xampp\htdocs\NTA_Exams\swayam12\common\components\MasterDataComponent.php(828): yii\db\Command->queryAll() #4 C:\xampp\htdocs\NTA_Exams\swayam12\frontend\modules\application\controllers\CollegeController.php(190): common\components\MasterDataComponent->collegeList('164862') #5 [internal function]: app\modules\application\controllers\CollegeController->actionIndex() #6 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\InlineAction.php(57): call_user_func_array(Array, Array) #7 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Controller.php(178): yii\base\InlineAction->runWithParams(Array) #8 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Module.php(552): yii\base\Controller->runAction('index', Array) #9 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\web\Application.php(103): yii\base\Module->runAction('application/col...', Array) #10 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Application.php(384): yii\web\Application->handleRequest(Object(yii\web\Request)) #11 C:\xampp\htdocs\NTA_Exams\swayam12\frontend\web\index.php(18): yii\base\Application->run() #12 {main} Next yii\db\Exception: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'OR'. The SQL being executed was: exec getCommonDataSP 'ID,CollegeName', 'WHERE OR IsOtherCollege=1 ', 'CollegeMst' in C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Schema.php:676 Stack trace: #0 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(1325): yii\db\Schema->convertException(Object(PDOException), 'exec getCommonD...') #1 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(1186): yii\db\Command->internalExecute('exec getCommonD...') #2 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(417): yii\db\Command->queryInternal('fetchAll', NULL) #3 C:\xampp\htdocs\NTA_Exams\swayam12\common\components\MasterDataComponent.php(828): yii\db\Command->queryAll() #4 C:\xampp\htdocs\NTA_Exams\swayam12\frontend\modules\application\controllers\CollegeController.php(190): common\components\MasterDataComponent->collegeList('164862') #5 [internal function]: app\modules\application\controllers\CollegeController->actionIndex() #6 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\InlineAction.php(57): call_user_func_array(Array, Array) #7 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Controller.php(178): yii\base\InlineAction->runWithParams(Array) #8 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Module.php(552): yii\base\Controller->runAction('index', Array) #9 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\web\Application.php(103): yii\base\Module->runAction('application/col...', Array) #10 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Application.php(384): yii\web\Application->handleRequest(Object(yii\web\Request)) #11 C:\xampp\htdocs\NTA_Exams\swayam12\frontend\web\index.php(18): yii\base\Application->run() #12 {main} Additional Information: Array ( [0] => 42000 [1] => 156 [2] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'OR'. ) 2024-03-19 11:52:19 [125.63.102.166][35461][4l5qe1n16dj0r7khlcbhld8ql8][error][yii\db\Exception] PDOException: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'OR'. in C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php:1320 Stack trace: #0 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(1320): PDOStatement->execute() #1 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(1186): yii\db\Command->internalExecute('exec getCommonD...') #2 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(417): yii\db\Command->queryInternal('fetchAll', NULL) #3 C:\xampp\htdocs\NTA_Exams\swayam12\common\components\MasterDataComponent.php(828): yii\db\Command->queryAll() #4 C:\xampp\htdocs\NTA_Exams\swayam12\common\components\StateDistrictComponent.php(181): common\components\MasterDataComponent->collegeList('164784') #5 C:\xampp\htdocs\NTA_Exams\swayam12\frontend\modules\application\controllers\FinalReviewsController.php(124): common\components\StateDistrictComponent->StateDistrictMatchCheck(35461) #6 [internal function]: app\modules\application\controllers\FinalReviewsController->actionIndex() #7 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\InlineAction.php(57): call_user_func_array(Array, Array) #8 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Controller.php(178): yii\base\InlineAction->runWithParams(Array) #9 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Module.php(552): yii\base\Controller->runAction('index', Array) #10 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\web\Application.php(103): yii\base\Module->runAction('application/fin...', Array) #11 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Application.php(384): yii\web\Application->handleRequest(Object(yii\web\Request)) #12 C:\xampp\htdocs\NTA_Exams\swayam12\frontend\web\index.php(18): yii\base\Application->run() #13 {main} Next yii\db\Exception: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'OR'. The SQL being executed was: exec getCommonDataSP 'ID,CollegeName', 'WHERE OR IsOtherCollege=1 ', 'CollegeMst' in C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Schema.php:676 Stack trace: #0 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(1325): yii\db\Schema->convertException(Object(PDOException), 'exec getCommonD...') #1 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(1186): yii\db\Command->internalExecute('exec getCommonD...') #2 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(417): yii\db\Command->queryInternal('fetchAll', NULL) #3 C:\xampp\htdocs\NTA_Exams\swayam12\common\components\MasterDataComponent.php(828): yii\db\Command->queryAll() #4 C:\xampp\htdocs\NTA_Exams\swayam12\common\components\StateDistrictComponent.php(181): common\components\MasterDataComponent->collegeList('164784') #5 C:\xampp\htdocs\NTA_Exams\swayam12\frontend\modules\application\controllers\FinalReviewsController.php(124): common\components\StateDistrictComponent->StateDistrictMatchCheck(35461) #6 [internal function]: app\modules\application\controllers\FinalReviewsController->actionIndex() #7 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\InlineAction.php(57): call_user_func_array(Array, Array) #8 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Controller.php(178): yii\base\InlineAction->runWithParams(Array) #9 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Module.php(552): yii\base\Controller->runAction('index', Array) #10 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\web\Application.php(103): yii\base\Module->runAction('application/fin...', Array) #11 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Application.php(384): yii\web\Application->handleRequest(Object(yii\web\Request)) #12 C:\xampp\htdocs\NTA_Exams\swayam12\frontend\web\index.php(18): yii\base\Application->run() #13 {main} Additional Information: Array ( [0] => 42000 [1] => 156 [2] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'OR'. ) 2024-03-19 11:56:14 [125.63.102.166][35461][4l5qe1n16dj0r7khlcbhld8ql8][error][yii\db\Exception] PDOException: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'OR'. in C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php:1320 Stack trace: #0 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(1320): PDOStatement->execute() #1 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(1186): yii\db\Command->internalExecute('exec getCommonD...') #2 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(417): yii\db\Command->queryInternal('fetchAll', NULL) #3 C:\xampp\htdocs\NTA_Exams\swayam12\common\components\MasterDataComponent.php(828): yii\db\Command->queryAll() #4 C:\xampp\htdocs\NTA_Exams\swayam12\common\components\StateDistrictComponent.php(181): common\components\MasterDataComponent->collegeList('164863') #5 C:\xampp\htdocs\NTA_Exams\swayam12\frontend\modules\application\controllers\FinalReviewsController.php(124): common\components\StateDistrictComponent->StateDistrictMatchCheck(35461) #6 [internal function]: app\modules\application\controllers\FinalReviewsController->actionIndex() #7 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\InlineAction.php(57): call_user_func_array(Array, Array) #8 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Controller.php(178): yii\base\InlineAction->runWithParams(Array) #9 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Module.php(552): yii\base\Controller->runAction('index', Array) #10 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\web\Application.php(103): yii\base\Module->runAction('application/fin...', Array) #11 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Application.php(384): yii\web\Application->handleRequest(Object(yii\web\Request)) #12 C:\xampp\htdocs\NTA_Exams\swayam12\frontend\web\index.php(18): yii\base\Application->run() #13 {main} Next yii\db\Exception: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'OR'. The SQL being executed was: exec getCommonDataSP 'ID,CollegeName', 'WHERE OR IsOtherCollege=1 ', 'CollegeMst' in C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Schema.php:676 Stack trace: #0 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(1325): yii\db\Schema->convertException(Object(PDOException), 'exec getCommonD...') #1 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(1186): yii\db\Command->internalExecute('exec getCommonD...') #2 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\db\Command.php(417): yii\db\Command->queryInternal('fetchAll', NULL) #3 C:\xampp\htdocs\NTA_Exams\swayam12\common\components\MasterDataComponent.php(828): yii\db\Command->queryAll() #4 C:\xampp\htdocs\NTA_Exams\swayam12\common\components\StateDistrictComponent.php(181): common\components\MasterDataComponent->collegeList('164863') #5 C:\xampp\htdocs\NTA_Exams\swayam12\frontend\modules\application\controllers\FinalReviewsController.php(124): common\components\StateDistrictComponent->StateDistrictMatchCheck(35461) #6 [internal function]: app\modules\application\controllers\FinalReviewsController->actionIndex() #7 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\InlineAction.php(57): call_user_func_array(Array, Array) #8 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Controller.php(178): yii\base\InlineAction->runWithParams(Array) #9 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Module.php(552): yii\base\Controller->runAction('index', Array) #10 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\web\Application.php(103): yii\base\Module->runAction('application/fin...', Array) #11 C:\xampp\htdocs\NTA_Exams\swayam12\vendor\yiisoft\yii2\base\Application.php(384): yii\web\Application->handleRequest(Object(yii\web\Request)) #12 C:\xampp\htdocs\NTA_Exams\swayam12\frontend\web\index.php(18): yii\base\Application->run() #13 {main} Additional Information: Array ( [0] => 42000 [1] => 156 [2] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'OR'. )