[2024-07-30 17:07:05] PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'category_name' in 'order clause' in F:\xampp\htdocs\tfb_api\core\Model.php:136 Stack trace: #0 F:\xampp\htdocs\tfb_api\core\Model.php(136): PDOStatement->execute() #1 F:\xampp\htdocs\tfb_api\controllers\ProductController.php(38): Model\ProductModel->findAll() #2 F:\xampp\htdocs\tfb_api\v1\index.php(136): Controller\ProductController->read() #3 [internal function]: {closure}() #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(1339): Bramus\Router\Router->run() #8 {main} [2024-07-30 17:07:05] PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'category_name' in 'order clause' in F:\xampp\htdocs\tfb_api\core\Model.php:136 Stack trace: #0 F:\xampp\htdocs\tfb_api\core\Model.php(136): PDOStatement->execute() #1 F:\xampp\htdocs\tfb_api\controllers\ProductController.php(38): Model\ProductModel->findAll() #2 F:\xampp\htdocs\tfb_api\v1\index.php(136): Controller\ProductController->read() #3 [internal function]: {closure}() #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(1339): Bramus\Router\Router->run() #8 {main} [2024-07-30 17:07:12] PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'category_name' in 'order clause' in F:\xampp\htdocs\tfb_api\core\Model.php:136 Stack trace: #0 F:\xampp\htdocs\tfb_api\core\Model.php(136): PDOStatement->execute() #1 F:\xampp\htdocs\tfb_api\controllers\ProductController.php(38): Model\ProductModel->findAll() #2 F:\xampp\htdocs\tfb_api\v1\index.php(136): Controller\ProductController->read() #3 [internal function]: {closure}() #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(1339): Bramus\Router\Router->run() #8 {main} [2024-07-30 19:07:31] 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:191 Stack trace: #0 F:\xampp\htdocs\tfb_api\core\Model.php(191): PDOStatement->execute(Array) #1 F:\xampp\htdocs\tfb_api\models\FranchiseeProductPriceConnectionModel.php(98): Model\FranchiseeProductPriceConnectionModel->query('SELECT \r\n ...', Array) #2 F:\xampp\htdocs\tfb_api\controllers\ProductController.php(344): Model\FranchiseeProductPriceConnectionModel->getByIdShop('2', Array) #3 F:\xampp\htdocs\tfb_api\v1\index.php(370): Controller\ProductController->getPossibleToSale('2', Array) #4 [internal function]: {closure}('2') #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(1339): Bramus\Router\Router->run() #9 {main} [2024-07-30 19:07:41] 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:191 Stack trace: #0 F:\xampp\htdocs\tfb_api\core\Model.php(191): PDOStatement->execute(Array) #1 F:\xampp\htdocs\tfb_api\models\FranchiseeProductPriceConnectionModel.php(98): Model\FranchiseeProductPriceConnectionModel->query('SELECT \r\n ...', Array) #2 F:\xampp\htdocs\tfb_api\controllers\ProductController.php(344): Model\FranchiseeProductPriceConnectionModel->getByIdShop('2', Array) #3 F:\xampp\htdocs\tfb_api\v1\index.php(370): Controller\ProductController->getPossibleToSale('2', Array) #4 [internal function]: {closure}('2') #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(1339): Bramus\Router\Router->run() #9 {main} [2024-07-30 19:07:46] 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:191 Stack trace: #0 F:\xampp\htdocs\tfb_api\core\Model.php(191): PDOStatement->execute(Array) #1 F:\xampp\htdocs\tfb_api\models\FranchiseeProductPriceConnectionModel.php(101): Model\FranchiseeProductPriceConnectionModel->query('SELECT \r\n ...', Array) #2 F:\xampp\htdocs\tfb_api\controllers\ProductController.php(344): Model\FranchiseeProductPriceConnectionModel->getByIdShop('2', Array) #3 F:\xampp\htdocs\tfb_api\v1\index.php(370): Controller\ProductController->getPossibleToSale('2', Array) #4 [internal function]: {closure}('2') #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(1339): Bramus\Router\Router->run() #9 {main} [2024-07-30 19:07:04] 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:191 Stack trace: #0 F:\xampp\htdocs\tfb_api\core\Model.php(191): PDOStatement->execute(Array) #1 F:\xampp\htdocs\tfb_api\models\FranchiseeProductPriceConnectionModel.php(101): Model\FranchiseeProductPriceConnectionModel->query('SELECT \r\n ...', Array) #2 F:\xampp\htdocs\tfb_api\controllers\ProductController.php(344): Model\FranchiseeProductPriceConnectionModel->getByIdShop('2', Array) #3 F:\xampp\htdocs\tfb_api\v1\index.php(370): Controller\ProductController->getPossibleToSale('2', Array) #4 [internal function]: {closure}('2') #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(1339): Bramus\Router\Router->run() #9 {main} [2024-07-30 19:07:12] PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'is_possible_to_sale' in 'where clause' in F:\xampp\htdocs\tfb_api\core\Model.php:191 Stack trace: #0 F:\xampp\htdocs\tfb_api\core\Model.php(191): PDOStatement->execute(Array) #1 F:\xampp\htdocs\tfb_api\models\FranchiseeProductPriceConnectionModel.php(99): Model\FranchiseeProductPriceConnectionModel->query('SELECT \r\n ...', Array) #2 F:\xampp\htdocs\tfb_api\controllers\ProductController.php(344): Model\FranchiseeProductPriceConnectionModel->getByIdShop('2', Array) #3 F:\xampp\htdocs\tfb_api\v1\index.php(370): Controller\ProductController->getPossibleToSale('2', Array) #4 [internal function]: {closure}('2') #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(1339): Bramus\Router\Router->run() #9 {main} [2024-07-30 19:07:16] 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 is_possible_to_sale = '1'' at line 23 in F:\xampp\htdocs\tfb_api\core\Model.php:191 Stack trace: #0 F:\xampp\htdocs\tfb_api\core\Model.php(191): PDOStatement->execute(Array) #1 F:\xampp\htdocs\tfb_api\models\FranchiseeProductPriceConnectionModel.php(102): Model\FranchiseeProductPriceConnectionModel->query('\r\n ...', Array) #2 F:\xampp\htdocs\tfb_api\controllers\ProductController.php(344): Model\FranchiseeProductPriceConnectionModel->getByIdShop('2', Array) #3 F:\xampp\htdocs\tfb_api\v1\index.php(370): Controller\ProductController->getPossibleToSale('2', Array) #4 [internal function]: {closure}('2') #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(1339): Bramus\Router\Router->run() #9 {main} [2024-07-30 19:07:03] 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 is_possible_to_sale = '1'' at line 23 in F:\xampp\htdocs\tfb_api\core\Model.php:191 Stack trace: #0 F:\xampp\htdocs\tfb_api\core\Model.php(191): PDOStatement->execute(Array) #1 F:\xampp\htdocs\tfb_api\models\FranchiseeProductPriceConnectionModel.php(102): Model\FranchiseeProductPriceConnectionModel->query('\r\n ...', Array) #2 F:\xampp\htdocs\tfb_api\controllers\ProductController.php(344): Model\FranchiseeProductPriceConnectionModel->getByIdShop('2', Array) #3 F:\xampp\htdocs\tfb_api\v1\index.php(370): Controller\ProductController->getPossibleToSale('2', Array) #4 [internal function]: {closure}('2') #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(1339): Bramus\Router\Router->run() #9 {main} [2024-07-30 19:07:23] 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 is_possible_to_sale = '1'' at line 23 in F:\xampp\htdocs\tfb_api\core\Model.php:191 Stack trace: #0 F:\xampp\htdocs\tfb_api\core\Model.php(191): PDOStatement->execute(Array) #1 F:\xampp\htdocs\tfb_api\models\FranchiseeProductPriceConnectionModel.php(103): Model\FranchiseeProductPriceConnectionModel->query('\r\n ...', Array) #2 F:\xampp\htdocs\tfb_api\controllers\ProductController.php(344): Model\FranchiseeProductPriceConnectionModel->getByIdShop('2', Array) #3 F:\xampp\htdocs\tfb_api\v1\index.php(370): Controller\ProductController->getPossibleToSale('2', Array) #4 [internal function]: {closure}('2') #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(1339): Bramus\Router\Router->run() #9 {main} [2024-07-30 19:07:26] 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 is_possible_to_sale = '1'' at line 23 in F:\xampp\htdocs\tfb_api\core\Model.php:191 Stack trace: #0 F:\xampp\htdocs\tfb_api\core\Model.php(191): PDOStatement->execute(Array) #1 F:\xampp\htdocs\tfb_api\models\FranchiseeProductPriceConnectionModel.php(103): Model\FranchiseeProductPriceConnectionModel->query('\r\n ...', Array) #2 F:\xampp\htdocs\tfb_api\controllers\ProductController.php(344): Model\FranchiseeProductPriceConnectionModel->getByIdShop('2', Array) #3 F:\xampp\htdocs\tfb_api\v1\index.php(370): Controller\ProductController->getPossibleToSale('2', Array) #4 [internal function]: {closure}('2') #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(1339): Bramus\Router\Router->run() #9 {main} [2024-07-30 21:07:21] 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 is_possible_to_sale = '1'' at line 23 in F:\xampp\htdocs\tfb_api\core\Model.php:191 Stack trace: #0 F:\xampp\htdocs\tfb_api\core\Model.php(191): PDOStatement->execute(Array) #1 F:\xampp\htdocs\tfb_api\models\FranchiseeProductPriceConnectionModel.php(103): Model\FranchiseeProductPriceConnectionModel->query('\r\n ...', Array) #2 F:\xampp\htdocs\tfb_api\controllers\ProductController.php(344): Model\FranchiseeProductPriceConnectionModel->getByIdShop('2', Array) #3 F:\xampp\htdocs\tfb_api\v1\index.php(370): Controller\ProductController->getPossibleToSale('2', Array) #4 [internal function]: {closure}('2') #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(1339): Bramus\Router\Router->run() #9 {main} [2024-07-30 21:07:52] 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 is_possible_to_sale = '1'' at line 23 in F:\xampp\htdocs\tfb_api\core\Model.php:191 Stack trace: #0 F:\xampp\htdocs\tfb_api\core\Model.php(191): PDOStatement->execute(Array) #1 F:\xampp\htdocs\tfb_api\models\FranchiseeProductPriceConnectionModel.php(103): Model\FranchiseeProductPriceConnectionModel->query('\r\n ...', Array) #2 F:\xampp\htdocs\tfb_api\controllers\ProductController.php(344): Model\FranchiseeProductPriceConnectionModel->getByIdShop('2', Array) #3 F:\xampp\htdocs\tfb_api\v1\index.php(370): Controller\ProductController->getPossibleToSale('2', Array) #4 [internal function]: {closure}('2') #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(1339): Bramus\Router\Router->run() #9 {main} [2024-07-30 22:07:56] 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 ':id_shop, id_product = :id_product, portion_price = :portion_price where id_s...' at line 1 in F:\xampp\htdocs\tfb_api\core\Model.php:191 Stack trace: #0 F:\xampp\htdocs\tfb_api\core\Model.php(191): PDOStatement->execute(Array) #1 F:\xampp\htdocs\tfb_api\models\ShopProductModel.php(67): Model\ShopProductModel->query('UPDATE shop_pro...') #2 F:\xampp\htdocs\tfb_api\controllers\ProductController.php(377): Model\ShopProductModel->update(Array) #3 F:\xampp\htdocs\tfb_api\v1\index.php(374): Controller\ProductController->updatePrice('2', '1150033') #4 [internal function]: {closure}('2', '1150033') #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(1339): Bramus\Router\Router->run() #9 {main} [2024-07-30 22:07:55] 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 ':id_shop, id_product = :id_product, portion_price = :portion_price where id_s...' at line 1 in F:\xampp\htdocs\tfb_api\core\Model.php:191 Stack trace: #0 F:\xampp\htdocs\tfb_api\core\Model.php(191): PDOStatement->execute(Array) #1 F:\xampp\htdocs\tfb_api\models\ShopProductModel.php(68): Model\ShopProductModel->query('UPDATE shop_pro...') #2 F:\xampp\htdocs\tfb_api\controllers\ProductController.php(374): Model\ShopProductModel->update(Array) #3 F:\xampp\htdocs\tfb_api\v1\index.php(374): Controller\ProductController->updatePrice('2', '1150033') #4 [internal function]: {closure}('2', '1150033') #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(1339): Bramus\Router\Router->run() #9 {main}