Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-21121

Event Income (Summary) report backtrace with 'only_full_group_by'

          Details

          • Type: Bug
          • Status: Done/Fixed
          • Priority: Major
          • Resolution: Fixed/Completed
          • Affects Version/s: 4.7.23
          • Fix Version/s: 4.7.25
          • Component/s: CiviReport
          • Labels:
          • Versioning Impact:
            Patch (backwards-compatible bug fixes)
          • Documentation Required?:
            None
          • Funding Source:
            Contributed Code
          • Verified?:
            No

            Description

            We're on 4.7.23 with MySQL 5.7.19 on Linux.

            The Event Income (Summary) report fails with "1055 ** Expression #5 of SELECT list is not in GROUP BY clause and contains n..."

            Disabling 'only_full_group_by' mode avoids the problem. Will attach complete backtrace.

              Attachments

                Activity

                  People

                  • Assignee:
                    palantejon Jon K Goldberg
                    Reporter:
                    thoni56 Thomas Nilefalk
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    3 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: