[2024-08-20 13:08:06] 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 DATE(trans.insert_timestamp)' at line 15 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(350): Model\TransactionModel->query('SELECT \r\n      ...', Array)
#2 F:\xampp\htdocs\tfb_api\models\ZDocModel.php(159): Model\TransactionModel->getDataForMonthYearZDoc('2', '08', '2024')
#3 F:\xampp\htdocs\tfb_api\models\ZDocModel.php(190): Model\ZDocModel->getZDocMonthYearData('2', '08', '2024')
#4 F:\xampp\htdocs\tfb_api\controllers\SalesReportController.php(62): Model\ZDocModel->getPDFMonthYear('2', '08', '2024')
#5 F:\xampp\htdocs\tfb_api\v1\index.php(1387): Controller\SalesReportController->getPDFMonthYear('2', '08', '2024')
#6 [internal function]: {closure}('2', '2024', '08')
#7 F:\xampp\htdocs\tfb_api\vendor\bramus\router\src\Bramus\Router\Router.php(458): call_user_func_array(Object(Closure), Array)
#8 F:\xampp\htdocs\tfb_api\vendor\bramus\router\src\Bramus\Router\Router.php(440): Bramus\Router\Router->invoke(Object(Closure), Array)
#9 F:\xampp\htdocs\tfb_api\vendor\bramus\router\src\Bramus\Router\Router.php(287): Bramus\Router\Router->handle(Array, true)
#10 F:\xampp\htdocs\tfb_api\v1\index.php(1547): Bramus\Router\Router->run()
#11 {main}