From b10fb37686594ac93979bc44fb4b4b88305784d1 Mon Sep 17 00:00:00 2001 From: Deepak Srivastava Date: Fri, 28 Jun 2013 16:39:51 +0530 Subject: [PATCH] CRM-12951 --- CRM/Logging/Differ.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/CRM/Logging/Differ.php b/CRM/Logging/Differ.php index e93c4133d5..ce9fef2dc1 100644 --- a/CRM/Logging/Differ.php +++ b/CRM/Logging/Differ.php @@ -73,7 +73,7 @@ class CRM_Logging_Differ { $contactIdClause = "AND id = %3"; break; case 'civicrm_note': - $contactIdClause = "AND ( entity_id = %3 AND entity_table = 'civicrm_contact' ) OR (entity_id IN (SELECT note.id FROM {$this->db}.log_civicrm_note note WHERE note.entity_id = %3 AND note.entity_table = 'civicrm_contact') AND entity_table = 'civicrm_note')"; + $contactIdClause = "AND ( entity_id = %3 AND entity_table = 'civicrm_contact' ) OR (entity_id IN (SELECT note.id FROM `{$this->db}`.log_civicrm_note note WHERE note.entity_id = %3 AND note.entity_table = 'civicrm_contact') AND entity_table = 'civicrm_note')"; break; case 'civicrm_entity_tag': $contactIdClause = "AND entity_id = %3 AND entity_table = 'civicrm_contact'"; -- 2.25.1