2024-01-05 10:21:02 [::1][24025][5jrqql1qhiqt2dhdk8o0hi1bik][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\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(424): yii\db\Command->queryInternal('fetch', NULL) #3 C:\xampp\htdocs\NCHM\frontend\modules\Payment\controllers\PaymentController.php(92): yii\db\Command->queryOne() #4 [internal function]: app\modules\Payment\controllers\PaymentController->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('Payment/payment...', 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 keyword 'and'. The SQL being executed was: exec getCommonDataSP 'CategoryCode', 'WHERE ID= and IsActive=1', 'CasteCategoryMst' 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(424): yii\db\Command->queryInternal('fetch', NULL) #3 C:\xampp\htdocs\NCHM\frontend\modules\Payment\controllers\PaymentController.php(92): yii\db\Command->queryOne() #4 [internal function]: app\modules\Payment\controllers\PaymentController->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('Payment/payment...', 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] => 156 [2] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'and'. ) 2024-01-05 10:29:11 [::1][24025][5jrqql1qhiqt2dhdk8o0hi1bik][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\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(424): yii\db\Command->queryInternal('fetch', NULL) #3 C:\xampp\htdocs\NCHM\frontend\modules\Payment\controllers\PaymentController.php(92): yii\db\Command->queryOne() #4 [internal function]: app\modules\Payment\controllers\PaymentController->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('Payment/payment...', 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 keyword 'and'. The SQL being executed was: exec getCommonDataSP 'CategoryCode', 'WHERE ID= and IsActive=1', 'CasteCategoryMst' 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(424): yii\db\Command->queryInternal('fetch', NULL) #3 C:\xampp\htdocs\NCHM\frontend\modules\Payment\controllers\PaymentController.php(92): yii\db\Command->queryOne() #4 [internal function]: app\modules\Payment\controllers\PaymentController->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('Payment/payment...', 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] => 156 [2] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'and'. )