[2024-05-21 12:05:43] PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'url' in 'where clause' in F:\xampp\htdocs\tfb_api\models\CourseCommissionDetailsModel.php:180 Stack trace: #0 F:\xampp\htdocs\tfb_api\models\CourseCommissionDetailsModel.php(180): PDOStatement->execute(Array) #1 F:\xampp\htdocs\tfb_api\controllers\CourseCommissionDetails.php(62): Model\CourseCommissionDetailsModel->where(Array) #2 F:\xampp\htdocs\tfb_api\v1\index.php(1030): Controller\CourseCommissionDetails->where(Array) #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(1039): Bramus\Router\Router->run() #8 {main} [2024-05-21 12:05:36] PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sort' in 'where clause' in F:\xampp\htdocs\tfb_api\models\CourseCommissionDetailsModel.php:183 Stack trace: #0 F:\xampp\htdocs\tfb_api\models\CourseCommissionDetailsModel.php(183): PDOStatement->execute(Array) #1 F:\xampp\htdocs\tfb_api\controllers\CourseCommissionDetails.php(62): Model\CourseCommissionDetailsModel->where(Array) #2 F:\xampp\htdocs\tfb_api\v1\index.php(1030): Controller\CourseCommissionDetails->where(Array) #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(1039): Bramus\Router\Router->run() #8 {main} [2024-05-21 12:05:57] 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 'GROUP BY ccd.id' at line 27 in F:\xampp\htdocs\tfb_api\models\CourseCommissionDetailsModel.php:181 Stack trace: #0 F:\xampp\htdocs\tfb_api\models\CourseCommissionDetailsModel.php(181): PDOStatement->execute(Array) #1 F:\xampp\htdocs\tfb_api\controllers\CourseCommissionDetails.php(62): Model\CourseCommissionDetailsModel->where(Array) #2 F:\xampp\htdocs\tfb_api\v1\index.php(1030): Controller\CourseCommissionDetails->where(Array) #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(1039): Bramus\Router\Router->run() #8 {main} [2024-05-21 12:05:30] 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 'GROUP BY ccd.id' at line 27 in F:\xampp\htdocs\tfb_api\models\CourseCommissionDetailsModel.php:181 Stack trace: #0 F:\xampp\htdocs\tfb_api\models\CourseCommissionDetailsModel.php(181): PDOStatement->execute(Array) #1 F:\xampp\htdocs\tfb_api\controllers\CourseCommissionDetails.php(62): Model\CourseCommissionDetailsModel->where(Array) #2 F:\xampp\htdocs\tfb_api\v1\index.php(1030): Controller\CourseCommissionDetails->where(Array) #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(1039): Bramus\Router\Router->run() #8 {main} [2024-05-21 12:05:40] 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 'GROUP BY ccd.id' at line 27 in F:\xampp\htdocs\tfb_api\models\CourseCommissionDetailsModel.php:181 Stack trace: #0 F:\xampp\htdocs\tfb_api\models\CourseCommissionDetailsModel.php(181): PDOStatement->execute(Array) #1 F:\xampp\htdocs\tfb_api\controllers\CourseCommissionDetails.php(62): Model\CourseCommissionDetailsModel->where(Array) #2 F:\xampp\htdocs\tfb_api\v1\index.php(1030): Controller\CourseCommissionDetails->where(Array) #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(1039): Bramus\Router\Router->run() #8 {main} [2024-05-21 12:05:58] 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 status = '0' ORDER BY start_date asc' at line 28 in F:\xampp\htdocs\tfb_api\models\CourseCommissionDetailsModel.php:182 Stack trace: #0 F:\xampp\htdocs\tfb_api\models\CourseCommissionDetailsModel.php(182): PDOStatement->execute(Array) #1 F:\xampp\htdocs\tfb_api\controllers\CourseCommissionDetails.php(62): Model\CourseCommissionDetailsModel->where(Array) #2 F:\xampp\htdocs\tfb_api\v1\index.php(1030): Controller\CourseCommissionDetails->where(Array) #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(1039): Bramus\Router\Router->run() #8 {main}