[2024-03-11 11:03:42] 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 'FROM product prod INNER JOIN product_category cat ON pr...' at line 7 in F:\xampp\htdocs\tfb_api\core\Model.php:118 Stack trace: #0 F:\xampp\htdocs\tfb_api\core\Model.php(118): PDOStatement->execute(Array) #1 F:\xampp\htdocs\tfb_api\models\ProductModel.php(122): Model\ProductModel->query('SELECT \r\n ...', Array) #2 F:\xampp\htdocs\tfb_api\models\ProductModel.php(140): Model\ProductModel->single(Array) #3 F:\xampp\htdocs\tfb_api\controllers\ProductController.php(321): Model\ProductModel->getProductCard('17') #4 F:\xampp\htdocs\tfb_api\v1\index.php(145): Controller\ProductController->getProductCard('17') #5 [internal function]: {closure}('17') #6 F:\xampp\htdocs\tfb_api\vendor\bramus\router\src\Bramus\Router\Router.php(458): call_user_func_array(Object(Closure), Array) #7 F:\xampp\htdocs\tfb_api\vendor\bramus\router\src\Bramus\Router\Router.php(440): Bramus\Router\Router->invoke(Object(Closure), Array) #8 F:\xampp\htdocs\tfb_api\vendor\bramus\router\src\Bramus\Router\Router.php(287): Bramus\Router\Router->handle(Array, true) #9 F:\xampp\htdocs\tfb_api\v1\index.php(573): Bramus\Router\Router->run() #10 {main} [2024-03-11 16:03:56] PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'id_brand' cannot be null in F:\xampp\htdocs\tfb_api\core\Model.php:99 Stack trace: #0 F:\xampp\htdocs\tfb_api\core\Model.php(99): PDOStatement->execute(Array) #1 F:\xampp\htdocs\tfb_api\models\SubrecipeModel.php(36): Model\RecipeModel->insert(Array) #2 F:\xampp\htdocs\tfb_api\controllers\SubrecipeController.php(69): Model\SubrecipeModel->insert(Array) #3 F:\xampp\htdocs\tfb_api\v1\index.php(399): Controller\SubrecipeController->insert() #4 [internal function]: {closure}() #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(596): Bramus\Router\Router->run() #9 {main}