CRM-12951 DB Error: syntax error in logging contact report

Francesc Bassas i Bullich added a comment - 2013-06-26 15:53 This error is due to a syntax error in the /CRM/Logging/Differ.php file in line 76: $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')"; should be $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')"; note `{$this->db}`

Francesc Bassas i Bullich added a comment - 2013-06-26 15:59 Fixed

David Greenberg added a comment - 2013-06-26 16:37 Can u review and apply "patch" if you agree.

Deepak Srivastava added a comment - 2013-06-28 11:17 Patch applied. thanks.