From 89b183fa4cf4e9cbe3da99e7e15008e9a2ece35f Mon Sep 17 00:00:00 2001 From: Sunil Pawar Date: Wed, 28 Oct 2020 14:01:12 +0530 Subject: [PATCH] correct query to log_date for log_conn_id --- CRM/Logging/Differ.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/CRM/Logging/Differ.php b/CRM/Logging/Differ.php index 863322bb2a..f92cfcfc05 100644 --- a/CRM/Logging/Differ.php +++ b/CRM/Logging/Differ.php @@ -420,7 +420,8 @@ ORDER BY log_date $dao = CRM_Core_DAO::executeQuery($sql, $params); while ($dao->fetch()) { if (empty($this->log_date)) { - $this->log_date = CRM_Core_DAO::singleValueQuery("SELECT log_date FROM {$this->db}.log_{$table} WHERE log_conn_id = %1 LIMIT 1", $params); + // look for available table in above query instead of looking for last table. this will avoid multiple loops + $this->log_date = CRM_Core_DAO::singleValueQuery("SELECT log_date FROM {$this->db}.log_{$dao->table_name} WHERE log_conn_id = %1 LIMIT 1", $params); } $diffs = array_merge($diffs, $this->diffsInTableForId($dao->table_name, $dao->id)); } -- 2.25.1