From e2422b8f35e025a4702e962da323bcd84b522b26 Mon Sep 17 00:00:00 2001 From: "Donald A. Lobo" Date: Fri, 10 May 2013 08:54:48 -0700 Subject: [PATCH] CRM-12466 ---------------------------------------- * CRM-12466: Group listings don't load http://issues.civicrm.org/jira/browse/CRM-12466 --- CRM/Contact/BAO/GroupContactCache.php | 2 ++ 1 file changed, 2 insertions(+) diff --git a/CRM/Contact/BAO/GroupContactCache.php b/CRM/Contact/BAO/GroupContactCache.php index c10898fc5d..33f59d79c0 100644 --- a/CRM/Contact/BAO/GroupContactCache.php +++ b/CRM/Contact/BAO/GroupContactCache.php @@ -93,11 +93,13 @@ class CRM_Contact_BAO_GroupContactCache extends CRM_Contact_DAO_GroupContactCach $limitClause = " LIMIT 0, $limit"; $orderClause = " ORDER BY g.cache_date, g.refresh_date"; } + // We ignore hidden groups and disabled groups $query = " SELECT g.id FROM civicrm_group g WHERE ( g.saved_search_id IS NOT NULL OR g.children IS NOT NULL ) AND ( g.is_hidden = 0 OR g.is_hidden IS NULL ) +AND g.is_active = 1 AND ( g.cache_date IS NULL OR ( TIMESTAMPDIFF(MINUTE, g.cache_date, $now) >= $smartGroupCacheTimeout ) OR ( $now >= g.refresh_date ) -- 2.25.1