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
  • Great - Thanks for the info and link,

    I must confess to being slightly (read: 'very much') punching above my weight - new to the whole Dev environment and officially just admin!

    I already broke my local dev instance with an extra ;   haha...  so just want to make sure I get this right.

    So on the command line in my ubuntu sugar mysql login I would do:

    --sql-mode='ONLY_FULL_GROUP_BY'    

    I see some differences with - and _ being used in what I do now and the string above?

    Currently I do this at each time I start the box up - or I get 500 errors:

    • Log into MySQL: 
    mysql -u root -p
    -enter the sql password
    Then in mysql enter Andre's string:
    SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

    And from then until rebooting the virtual machine it works fine.

    Thank you in advance for any clarification, very much appreciated.

    Luke.

Children
No Data