I have a normal Field-Element called 'urlaubstag', only integer-values are allowed. In the List-View-Settings I have select 'Sum' for Calculations. In the same list I use the User-Element too (it shows the user-email). So far no problems. But when I want to group by this user-email I always get the error-message 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 ') AS label FROM `fab_urlaub` LEFT JOIN `jo3_users` AS `jo3_users` ON `jo3_users' at line 2 SQL=SELECT SUM(value) AS value, label FROM (SELECT DISTINCT `fab_urlaub`.`id`, fab_urlaub.urlaubstag AS value, CONCAT(jo3_users_0.) AS label FROM `fab_urlaub` LEFT JOIN `jo3_users` AS `jo3_users` ON `jo3_users`.`id` = `fab_urlaub`.`id_benutzer` LEFT JOIN `jo3_users` AS `jo3_users_0` ON `jo3_users_0`.`id` = `fab_urlaub`.`id_chef` WHERE ( `jo3_users`.`id` = 607 )) AS t GROUP BY label"
I think the CONCAT-Statement is incomplete, the correct statement should be " ... CONCAT(jo3_users_0.id) ...".
Has anybody an idea to solve this issue?
"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 ') AS label FROM `fab_urlaub` LEFT JOIN `jo3_users` AS `jo3_users` ON `jo3_users' at line 2 SQL=SELECT SUM(value) AS value, label FROM (SELECT DISTINCT `fab_urlaub`.`id`, fab_urlaub.urlaubstag AS value, CONCAT(jo3_users_0.) AS label FROM `fab_urlaub` LEFT JOIN `jo3_users` AS `jo3_users` ON `jo3_users`.`id` = `fab_urlaub`.`id_benutzer` LEFT JOIN `jo3_users` AS `jo3_users_0` ON `jo3_users_0`.`id` = `fab_urlaub`.`id_chef` WHERE ( `jo3_users`.`id` = 607 )) AS t GROUP BY label"
I think the CONCAT-Statement is incomplete, the correct statement should be " ... CONCAT(jo3_users_0.id) ...".
Has anybody an idea to solve this issue?