2025-02-03 14:18:03 [::1][25132][doiotuhm3dv2c049rghg6r9kh1][error][yii\db\Exception] PDOException: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'FROM'. in D:\xampp\htdocs\GETB_2025\vendor\yiisoft\yii2\db\Command.php:1320
Stack trace:
#0 D:\xampp\htdocs\GETB_2025\vendor\yiisoft\yii2\db\Command.php(1320): PDOStatement->execute()
#1 D:\xampp\htdocs\GETB_2025\vendor\yiisoft\yii2\db\Command.php(1186): yii\db\Command->internalExecute('exec getCommonD...')
#2 D:\xampp\htdocs\GETB_2025\vendor\yiisoft\yii2\db\Command.php(431): yii\db\Command->queryInternal('fetch', NULL)
#3 D:\xampp\htdocs\GETB_2025\frontend\modules\application\controllers\FinalReviewsController.php(976): yii\db\Command->queryOne()
#4 [internal function]: app\modules\application\controllers\FinalReviewsController->actionDownloadForm()
#5 D:\xampp\htdocs\GETB_2025\vendor\yiisoft\yii2\base\InlineAction.php(57): call_user_func_array(Array, Array)
#6 D:\xampp\htdocs\GETB_2025\vendor\yiisoft\yii2\base\Controller.php(178): yii\base\InlineAction->runWithParams(Array)
#7 D:\xampp\htdocs\GETB_2025\vendor\yiisoft\yii2\base\Module.php(552): yii\base\Controller->runAction('download-form', Array)
#8 D:\xampp\htdocs\GETB_2025\vendor\yiisoft\yii2\web\Application.php(103): yii\base\Module->runAction('application/fin...', Array)
#9 D:\xampp\htdocs\GETB_2025\vendor\yiisoft\yii2\base\Application.php(384): yii\web\Application->handleRequest(Object(yii\web\Request))
#10 D:\xampp\htdocs\GETB_2025\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 keyword 'FROM'.
The SQL being executed was: exec getCommonDataSP 'Cand_Tbl.ExamFee,
						Cand_Tbl.TranscationID,
						Cand_Tbl.PaymentConfirmedDate,
						Cand_Tbl.PaymentStatus,
						Cand_Tbl.ActivityID,
						Cand_Tbl.PaymentGatewayID,
						PGMST.GatewayName,
						PTT.PaymentSubmitDate,
                        PTT.InvoiceCode,
                        PTT.PaymentStatus,', '
						INNER JOIN PaymentGatewayMst As PGMST ON PGMST.ID=Cand_Tbl.PaymentGatewayID and PGMST.IsActive=1 
						INNER JOIN PaymentTranscationTbl As PTT ON Cand_Tbl.ID = PTT.CandidateID and PTT.PaymentStatus=''Success'' and Cand_Tbl.TranscationID=PTT.TranscationID
						WHERE Cand_Tbl.ApplicationNumber=''252910000117'' and Cand_Tbl.PaymentStatus=1', 'CandidateTbl As Cand_Tbl' in D:\xampp\htdocs\GETB_2025\vendor\yiisoft\yii2\db\Schema.php:676
Stack trace:
#0 D:\xampp\htdocs\GETB_2025\vendor\yiisoft\yii2\db\Command.php(1325): yii\db\Schema->convertException(Object(PDOException), 'exec getCommonD...')
#1 D:\xampp\htdocs\GETB_2025\vendor\yiisoft\yii2\db\Command.php(1186): yii\db\Command->internalExecute('exec getCommonD...')
#2 D:\xampp\htdocs\GETB_2025\vendor\yiisoft\yii2\db\Command.php(431): yii\db\Command->queryInternal('fetch', NULL)
#3 D:\xampp\htdocs\GETB_2025\frontend\modules\application\controllers\FinalReviewsController.php(976): yii\db\Command->queryOne()
#4 [internal function]: app\modules\application\controllers\FinalReviewsController->actionDownloadForm()
#5 D:\xampp\htdocs\GETB_2025\vendor\yiisoft\yii2\base\InlineAction.php(57): call_user_func_array(Array, Array)
#6 D:\xampp\htdocs\GETB_2025\vendor\yiisoft\yii2\base\Controller.php(178): yii\base\InlineAction->runWithParams(Array)
#7 D:\xampp\htdocs\GETB_2025\vendor\yiisoft\yii2\base\Module.php(552): yii\base\Controller->runAction('download-form', Array)
#8 D:\xampp\htdocs\GETB_2025\vendor\yiisoft\yii2\web\Application.php(103): yii\base\Module->runAction('application/fin...', Array)
#9 D:\xampp\htdocs\GETB_2025\vendor\yiisoft\yii2\base\Application.php(384): yii\web\Application->handleRequest(Object(yii\web\Request))
#10 D:\xampp\htdocs\GETB_2025\frontend\web\index.php(18): yii\base\Application->run()
#11 {main}
Additional Information:
Array
(
    [0] => 42000
    [1] => 156
    [2] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'FROM'.
)