From 9fd7ef4f0c1b366618638f051eb2566e1dd7cb04 Mon Sep 17 00:00:00 2001 From: eileen Date: Sun, 28 Feb 2016 18:06:04 +1300 Subject: [PATCH] CRM-18109 fix to earlier commit on this issue --- CRM/Contact/BAO/GroupContactCache.php | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/CRM/Contact/BAO/GroupContactCache.php b/CRM/Contact/BAO/GroupContactCache.php index 7718854663..690a200e69 100644 --- a/CRM/Contact/BAO/GroupContactCache.php +++ b/CRM/Contact/BAO/GroupContactCache.php @@ -336,18 +336,18 @@ SET cache_date = null, DELETE gc FROM civicrm_group_contact_cache gc INNER JOIN civicrm_group g ON g.id = gc.group_id -WHERE g.cache_date >= %1 +WHERE g.cache_date <= %1 "; $update = " UPDATE civicrm_group g SET cache_date = null, refresh_date = null -WHERE g.cache_date >= %1 +WHERE g.cache_date <= %1 "; $refresh = " UPDATE civicrm_group g SET refresh_date = $refreshTime -WHERE g.cache_date < %1 +WHERE g.cache_date > %1 AND refresh_date IS NULL "; $cacheTime = date('Y-m-d H-i-s', strtotime("- $smartGroupCacheTimeout minutes")); -- 2.25.1