Error Generating a Report

andres

New member
Using
DaDaBIK version 10.0-Manarola enterprise
PHP Version: 7.2.31
mysql version: 5.1.73
Web server: Apache

I get the following error when trying to run a report similar to the one in the sample Sales/CRM application...

Your SQL query (for debugging purpose): select `Tasks`.`Project` AS dadabik_group_by_field, `Projects____1`.`Name` AS `Projects____Name____1`, count(*) AS dadabik_aggregate_function_value FROM `Tasks` LEFT JOIN `Projects` AS `Projects____1` ON `Tasks`.`Project` = `Projects____1`.`id` GROUP BY `Tasks`.`Project`, `Projects____1`.`Name` ORDER BY `Tasks`.`Project`, `Projects____1`.`Name`

[08] Error: during query execution. select `Tasks`.`Project` AS dadabik_group_by_field, `Projects____1`.`Name` AS `Projects____Name____1`, count(*) AS dadabik_aggregate_function_value FROM `Tasks` LEFT JOIN `Projects` AS `Projects____1` ON `Tasks`.`Project` = `Projects____1`.`id` GROUP BY `Tasks`.`Project`, `Projects____1`.`Name` ORDER BY `Tasks`.`Project`, `Projects____1`.`Name` LIMIT 0,
The DBMS server said: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
 

eugenio

Administrator
Staff member
Hello,
are you creating an advanced report providing your own SQL query or you are using the simple report feature?
Please provide the exact steps to get the error.

Best,
 
Top