Reports module error for dropdown values in Sugar 8.0 version

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 ?

 

 

Parents Reply
  • Hi @André,

    We have used this mysql string in my new local dev instance of Enterprise v10.1.0 and it works brilliantly.

    However, if i switch off my VirtualBox (Ubuntu server) and back on again I need to redo this command each time?

     - Do you know of a way to make it stick?

    I know this is an older post for v8 so maybe there are some differences now we are using our downloaded backup of v10.1 Ent?

    Either way, it works and thank you for posting initially.  Just be nice to to have to log in to sql each time I start up the box.

    Thank you again,

    Luke.

Children