AnsweredAssumed Answered

Reports module error for dropdown values in Sugar 8.0 version

Question asked by Madhu p on Feb 19, 2019
Latest reply on May 31, 2019 by Jon Sheppard

Hi,

 

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 ?

 

 

Outcomes