[2024-08-17 10:08:29] PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'where id = '72'' at line 1 in F:\xampp\htdocs\tfb_api\core\Model.php:248 Stack trace: #0 F:\xampp\htdocs\tfb_api\core\Model.php(248): PDOStatement->execute(Array) #1 F:\xampp\htdocs\tfb_api\controllers\TransactionController.php(128): Model\TransactionModel->update('72', Array) #2 F:\xampp\htdocs\tfb_api\v1\index.php(1279): Controller\TransactionController->patch('72') #3 [internal function]: {closure}('72') #4 F:\xampp\htdocs\tfb_api\vendor\bramus\router\src\Bramus\Router\Router.php(458): call_user_func_array(Object(Closure), Array) #5 F:\xampp\htdocs\tfb_api\vendor\bramus\router\src\Bramus\Router\Router.php(440): Bramus\Router\Router->invoke(Object(Closure), Array) #6 F:\xampp\htdocs\tfb_api\vendor\bramus\router\src\Bramus\Router\Router.php(287): Bramus\Router\Router->handle(Array, true) #7 F:\xampp\htdocs\tfb_api\v1\index.php(1451): Bramus\Router\Router->run() #8 {main}, UPDATE transaction SET where id = :id [2024-08-17 13:08:23] PDOException: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens in F:\xampp\htdocs\tfb_api\core\Model.php:197 Stack trace: #0 F:\xampp\htdocs\tfb_api\core\Model.php(197): PDOStatement->execute(Array) #1 F:\xampp\htdocs\tfb_api\models\TransactionModel.php(214): Model\TransactionModel->query('SELECT * FROM t...', Array) #2 F:\xampp\htdocs\tfb_api\controllers\TransactionController.php(251): Model\TransactionModel->getTransactionsToInvoice('2', '136') #3 F:\xampp\htdocs\tfb_api\v1\index.php(1295): Controller\TransactionController->getTransactionsToInvoiceByB2BClient('2', '136') #4 [internal function]: {closure}('2', '136') #5 F:\xampp\htdocs\tfb_api\vendor\bramus\router\src\Bramus\Router\Router.php(458): call_user_func_array(Object(Closure), Array) #6 F:\xampp\htdocs\tfb_api\vendor\bramus\router\src\Bramus\Router\Router.php(440): Bramus\Router\Router->invoke(Object(Closure), Array) #7 F:\xampp\htdocs\tfb_api\vendor\bramus\router\src\Bramus\Router\Router.php(287): Bramus\Router\Router->handle(Array, true) #8 F:\xampp\htdocs\tfb_api\v1\index.php(1459): Bramus\Router\Router->run() #9 {main}