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

Fix attendee count on event income summary report again

          Details

          • Type: Bug
          • Status: Won't Do
          • Priority: Minor
          • Resolution: Won't Do
          • Affects Version/s: 4.7.29
          • Fix Version/s: None
          • Component/s: CiviEvent, CiviReport
          • Labels:
          • Versioning Impact:
            Patch (backwards-compatible bug fixes)
          • Documentation Required?:
            None
          • Funding Source:
            Needs Funding
          • Verified?:
            No

            Description

            -CRM-21121- (Fix crash with sql_mode is only_full_group_by) caused a regression of -CRM-20170-.

            Ideally we would be able to preserve the correct functionality, whilst also supporting 'only_full_group_by'

             From the original issue:

             

            The 'event summary' report doesn't display the correct number of attendees for free events.

            When someone registers through the front end, they appear on the report (because a contribution is recorded).

            When you then record someone through the back end they do not appear, because there is no contribution record for the free event.

            Steps to recreate:

            • Create a free event with online registration
            • Register through the front end
            • Create another registration through the back end
            • View the 'Event Income Summary' report
            • Notice that only 1 participant is counted

              Attachments

                Issue Links

                duplicates

                Bug - A problem which impairs or prevents the functions of the product. CRM-21417 Regression in participant count in summary report

                • Major - Major loss of function.
                • Reopened
                is supplemented by

                Bug - A problem which impairs or prevents the functions of the product. CRM-21121 Event Income (Summary) report backtrace with 'only_full_group_by'

                • Major - Major loss of function.
                • Done/Fixed

                Bug - A problem which impairs or prevents the functions of the product. CRM-20170 Fix attendee count on event summary report for free events

                • Minor - Minor loss of function, or other problem where easy workaround is present.
                • Done/Fixed

                  Activity

                    People

                    • Assignee:
                      Unassigned
                      Reporter:
                      john John K.
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      2 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved: