2024-12-13 17:41:02 [192.168.10.1][-][2a61d5d60802339ef6a612da0f11d4d2][error][yii\db\Exception] PDOException: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Ambiguous column name 'ID'. in /var/www/html/vendor/yiisoft/yii2/db/Command.php:1320
Stack trace:
#0 /var/www/html/vendor/yiisoft/yii2/db/Command.php(1320): PDOStatement->execute()
#1 /var/www/html/vendor/yiisoft/yii2/db/Command.php(1186): yii\db\Command->internalExecute('exec getCommonD...')
#2 /var/www/html/vendor/yiisoft/yii2/db/Command.php(417): yii\db\Command->queryInternal('fetchAll', NULL)
#3 /var/www/html/frontend/controllers/ChargeBackController.php(140): yii\db\Command->queryAll()
#4 [internal function]: frontend\controllers\ChargeBackController->actionDownloadApplication('250210000002')
#5 /var/www/html/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array(Array, Array)
#6 /var/www/html/vendor/yiisoft/yii2/base/Controller.php(178): yii\base\InlineAction->runWithParams(Array)
#7 /var/www/html/vendor/yiisoft/yii2/base/Module.php(552): yii\base\Controller->runAction('download-applic...', Array)
#8 /var/www/html/vendor/yiisoft/yii2/web/Application.php(103): yii\base\Module->runAction('charge-back/dow...', Array)
#9 /var/www/html/vendor/yiisoft/yii2/base/Application.php(384): yii\web\Application->handleRequest(Object(yii\web\Request))
#10 /var/www/html/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]Ambiguous column name 'ID'.
The SQL being executed was: exec getCommonDataSP 'CandidateID,InvoiceCode,TranscationID,ActualExamFee,PaidAmount,PaymentGatewayID,PaymentSubmitDate,PaymentSucessDate,PaymentSubmitDate,TranscationDate,PaymentStatus,PaymentGatewayMst.GatewayName,PaymentModeMst.ModeType', 'Inner join PaymentGatewayMst ON PaymentGatewayMst.ID=PaymentTranscationTbl.PaymentGatewayID INNER JOIN PaymentModeMst ON PaymentModeMst.ID=PaymentTranscationTbl.PaymentModeID WHERE CandidateID=''2''', 'PaymentTranscationTbl','order by ID desc' in /var/www/html/vendor/yiisoft/yii2/db/Schema.php:676
Stack trace:
#0 /var/www/html/vendor/yiisoft/yii2/db/Command.php(1325): yii\db\Schema->convertException(Object(PDOException), 'exec getCommonD...')
#1 /var/www/html/vendor/yiisoft/yii2/db/Command.php(1186): yii\db\Command->internalExecute('exec getCommonD...')
#2 /var/www/html/vendor/yiisoft/yii2/db/Command.php(417): yii\db\Command->queryInternal('fetchAll', NULL)
#3 /var/www/html/frontend/controllers/ChargeBackController.php(140): yii\db\Command->queryAll()
#4 [internal function]: frontend\controllers\ChargeBackController->actionDownloadApplication('250210000002')
#5 /var/www/html/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array(Array, Array)
#6 /var/www/html/vendor/yiisoft/yii2/base/Controller.php(178): yii\base\InlineAction->runWithParams(Array)
#7 /var/www/html/vendor/yiisoft/yii2/base/Module.php(552): yii\base\Controller->runAction('download-applic...', Array)
#8 /var/www/html/vendor/yiisoft/yii2/web/Application.php(103): yii\base\Module->runAction('charge-back/dow...', Array)
#9 /var/www/html/vendor/yiisoft/yii2/base/Application.php(384): yii\web\Application->handleRequest(Object(yii\web\Request))
#10 /var/www/html/frontend/web/index.php(18): yii\base\Application->run()
#11 {main}
Additional Information:
Array
(
    [0] => 42000
    [1] => 209
    [2] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Ambiguous column name 'ID'.
)