From 6b55cf977c4ff66cae632944b367096470cb9b55 Mon Sep 17 00:00:00 2001 From: Chris Burgess Date: Sat, 15 Jun 2013 10:53:12 +1200 Subject: [PATCH] CRM-12821 Remove any incorrect entries in civicrm_dashboard_contact. --- CRM/Upgrade/Incremental/sql/4.3.alpha1.mysql.tpl | 1 + 1 file changed, 1 insertion(+) diff --git a/CRM/Upgrade/Incremental/sql/4.3.alpha1.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.3.alpha1.mysql.tpl index d28e0a8691..83c192cf8e 100644 --- a/CRM/Upgrade/Incremental/sql/4.3.alpha1.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.3.alpha1.mysql.tpl @@ -653,6 +653,7 @@ ALTER TABLE `civicrm_membership_log` ADD COLUMN `max_related` INT(10) unsigned DEFAULT NULL COMMENT 'Maximum number of related memberships.' AFTER `membership_type_id`; -- CRM-11358 +DELETE FROM civicrm_dashboard_contact WHERE contact_id NOT IN (SELECT id FROM civicrm_contact); INSERT INTO `civicrm_dashboard` (`domain_id`, {localize field='label'}`label`{/localize}, `url`, `permission`, `permission_operator`, `column_no`, `is_minimized`, `is_active`, `weight`, `fullscreen_url`, `is_fullscreen`, `is_reserved`) SELECT id, {localize}'{ts escape="sql"}CiviCRM News{/ts}'{/localize}, 'civicrm/dashlet/blog&reset=1&snippet=5', 'access CiviCRM', NULL, 0, 0, 1, 0, 'civicrm/dashlet/blog&reset=1&snippet=5&context=dashletFullscreen', 1, 1 -- 2.25.1