I have Sugar 8.0.2 Enterprise Edition.
I have created report for opportunities module , and I used sales stage in group by statement, when I try to run the report it is showing database failure error check in sugar log.
I have checked in sugar log and it is showing
sales stage which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by.
Then I tried creating report with any of the dropdown fields iin group by statement, and it is throwing the same error which I have mentioned in the above.
for dropdown values if use group by statement in reports it is throwing data base failure error.
Is anyone facing this issue?? ,is it a bug in sugar 8.0 or mysql 5.7 change ?