From b3a1fc3d8444dd65e74479443a97524b3b975b58 Mon Sep 17 00:00:00 2001 From: eileen Date: Wed, 4 Jul 2018 10:29:40 +1200 Subject: [PATCH] Add location_id if missing CRM-20711. On a small number of installs it seems location_id is missing from the group_contact table. This adds if missing --- CRM/Upgrade/Incremental/php/FiveFour.php | 2 ++ 1 file changed, 2 insertions(+) diff --git a/CRM/Upgrade/Incremental/php/FiveFour.php b/CRM/Upgrade/Incremental/php/FiveFour.php index 8ea5630a40..16d3e73e96 100644 --- a/CRM/Upgrade/Incremental/php/FiveFour.php +++ b/CRM/Upgrade/Incremental/php/FiveFour.php @@ -71,6 +71,8 @@ class CRM_Upgrade_Incremental_php_FiveFour extends CRM_Upgrade_Incremental_Base $this->addTask(ts('Upgrade DB to %1: SQL', array(1 => $rev)), 'runSql', $rev); $this->addTask('Add Cancel Button Setting to the Profile', 'addColumn', 'civicrm_uf_group', 'add_cancel_button', "tinyint DEFAULT '1' COMMENT 'Should a Cancel button be included in this Profile form.'"); + $this->addTask('Add location_id if missing to group_contact table (affects some older installs CRM-20711)', 'addColumn', + 'civicrm_group_contact', 'location_id', "int(10) unsigned DEFAULT NULL COMMENT 'Optional location to associate with this membership'"); } /* -- 2.25.1