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
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