CRM-16554 Cannot Use or Delete Smart Groups Created by Contribution Aggregate Search

          Details

          • Type: Bug
          • Status: Done/Fixed
          • Priority: Major
          • Resolution: Fixed/Completed
          • Affects Version/s: 4.6.3
          • Fix Version/s: 4.6.4
          • Component/s: Core CiviCRM
          • Labels:
            None
          • Documentation Required?:
            None

            Description

            In 4.4 we had several smart groups created by the Contribution Aggregate Search. An error is now received in 4.6 when looking at the Contacts in the Smart Group or trying to Delete the Smart Group.

            Backtrace attached.

              Attachments

                Activity

                [CRM-16554] Cannot Use or Delete Smart Groups Created by Contribution Aggregate Search
                Stoob added a comment -

                Can you tell me please, in the meantime, what I can do to "manually" remove a group from the db via a SQL query?

                David Greenberg added a comment -

                Do this on a test copy first .... N is your group ID
                Delete * from civicrm_group_contact where group_id = N
                Delete * from civicrm_group_contact_cache where group_id = N
                Delete * from civicrm_group where id = N

                I think that should do it (but haven't tried it - caveat!)

                Stoob added a comment -

                thanks, will try

                Jitendra Purohit added a comment -

                Submitted a PR : https://github.com/civicrm/civicrm-core/pull/5911

                Sudha Bisht added a comment - - edited

                Tested above PR. Working fine.

                  People

                  • Assignee:
                    Sudha Bisht
                    Reporter:
                    Stoob

                    Dates

                    • Created:
                      Updated:
                      Resolved: