From 26f88fb35fcd6e7158fadf91e375ad16d01995c1 Mon Sep 17 00:00:00 2001
From: Dave Jenkins <davej+git@circle-interactive.co.uk>
Date: Mon, 19 Jun 2017 18:02:14 +0100
Subject: [PATCH] CRM-20443 - SQL syntax error creating logging triggers if
 column name is reserved word - 4.7 version

---
 CRM/Logging/Schema.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/CRM/Logging/Schema.php b/CRM/Logging/Schema.php
index 0cbe435c5e..b34806019f 100644
--- a/CRM/Logging/Schema.php
+++ b/CRM/Logging/Schema.php
@@ -542,7 +542,7 @@ AND    (TABLE_NAME LIKE 'log_civicrm_%' $nonStandardTableNameString )
       }
       \Civi::$statics[__CLASS__]['columnsOf'][$table] = array();
       while ($dao->fetch()) {
-        \Civi::$statics[__CLASS__]['columnsOf'][$table][] = $dao->Field;
+        \Civi::$statics[__CLASS__]['columnsOf'][$table][] = CRM_Utils_type::escape($dao->Field, 'MysqlColumnNameOrAlias');
       }
     }
     return \Civi::$statics[__CLASS__]['columnsOf'][$table];
-- 
2.25.1