From 40e150f772f50c5e44775f0d72198e7a1ffcb6a0 Mon Sep 17 00:00:00 2001 From: Jagadedes Date: Tue, 25 Nov 2014 14:12:22 +0530 Subject: [PATCH] 31603 progress bar update not clearing widget cache --- CRM/Wci/BAO/WidgetCache.php | 6 +----- 1 file changed, 1 insertion(+), 5 deletions(-) diff --git a/CRM/Wci/BAO/WidgetCache.php b/CRM/Wci/BAO/WidgetCache.php index a06dd7d..2889ae6 100644 --- a/CRM/Wci/BAO/WidgetCache.php +++ b/CRM/Wci/BAO/WidgetCache.php @@ -71,11 +71,7 @@ class CRM_Wci_BAO_WidgetCache extends CRM_Wci_DAO_WidgetCache { } public static function deleteWidgetCacheByProgressbar($pbId) { - $query = "SELECT wc.widget_id FROM civicrm_wci_widget_cache as wc INNER JOIN civicrm_wci_widget w on w.id = wc.widget_id WHERE w.progress_bar_id =%1"; + $query = "DELETE wc FROM civicrm_wci_widget_cache as wc INNER JOIN civicrm_wci_widget w on w.id = wc.widget_id WHERE w.progress_bar_id =%1"; $dao = CRM_Core_DAO::executeQuery($query, array(1 => array($pbId, 'Integer')), TRUE, 'CRM_Wci_DAO_WidgetCache'); - while ($dao->fetch()) { - $widget_id = $dao->widget_id; - CRM_Wci_BAO_WidgetCache::deleteWidgetCache($widget_id); - } } } -- 2.25.1