Merge pull request #2370 from kurund/CRM-14087

[civicrm-core.git] / CRM / Contact / BAO / GroupContactCache.php

diff --git a/CRM/Contact/BAO/GroupContactCache.php b/CRM/Contact/BAO/GroupContactCache.php
index 9e40ef412f41d6c0ad3f3c4154b24958fc41aa19..be50a15fb4b64cbff433f3d1641f0d72a70ea789 100644 (file)
--- a/CRM/Contact/BAO/GroupContactCache.php
+++ b/CRM/Contact/BAO/GroupContactCache.php
@@ -491,7 +491,7 @@ WHERE  civicrm_group_contact.status = 'Added'
       $result = CRM_Core_DAO::executeQuery($insertSql);
       CRM_Core_DAO::executeQuery(
         "INSERT IGNORE INTO civicrm_group_contact_cache (contact_id, group_id)
-        SELECT DISTINCT id, group_id FROM $tempTable
+        SELECT DISTINCT $idName, group_id FROM $tempTable
       ");
       CRM_Core_DAO::executeQuery(" DROP TABLE $tempTable");
     }