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

Membership Smart groups created in older version breaks Manage Groups Page

    Details

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

      Description

      We had an older smart group created in ~3 version. It was never being visited and this issue was unknown to us. Suddenly, it stopped Manage Group Page from loading after upgrading to the latest release 4.7.21.

      Saved Search entry for this group looks like -

      where clause -

       (  ( LOWER(civicrm_membership_status.name) != 'new' AND LOWER(civicrm_membership_status.name) != 'current' )  ) 
      

      form_values -

      a:8:{s:5:"qfKey";s:37:"131e75db705acc7d12fc336c0ec1d478_2349";s:6:"mapper";a:2:{i:1;a:2:{i:0;a:2:{i:0;s:10:"Membership";i:1;s:17:"membership_status";}i:1;a:2:{i:0;s:10:"Membership";i:1;s:17:"membership_status";}}i:2;a:1:{i:0;a:1:{i:0;s:0:"";}}}s:8:"operator";a:2:{i:1;a:2:{i:0;s:2:"!=";i:1;s:2:"!=";}i:2;a:1:{i:0;s:0:"";}}s:5:"value";a:2:{i:1;a:2:{i:0;s:3:"New";i:1;s:7:"Current";}i:2;a:1:{i:0;s:0:"";}}s:4:"task";s:2:"13";s:8:"radio_ts";s:6:"ts_all";s:11:"uf_group_id";s:0:"";s:14:"component_mode";i:1;}
      

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              jitendra.purohit Jitendra Purohit
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: