From a747c3f54eda42d90ce7311c9b0643169eaaceae Mon Sep 17 00:00:00 2001 From: jitendrapurohit Date: Mon, 18 Apr 2016 12:28:53 +0530 Subject: [PATCH] fix navigation menu ordering --- CRM/Upgrade/Incremental/sql/4.7.7.mysql.tpl | 13 +++++++++++++ 1 file changed, 13 insertions(+) diff --git a/CRM/Upgrade/Incremental/sql/4.7.7.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.7.7.mysql.tpl index 4993ac8315..a6430c44a5 100644 --- a/CRM/Upgrade/Incremental/sql/4.7.7.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.7.7.mysql.tpl @@ -1 +1,14 @@ {* file to handle db changes in 4.7.7 during upgrade *} +-- Fix weight interchange of `Extensions` and `Connections` navigation menu +SELECT @parent_id := id from `civicrm_navigation` where name = 'System Settings' AND domain_id = {$domainID}; +UPDATE + `civicrm_navigation` AS nav1 + JOIN `civicrm_navigation` AS nav2 ON + nav1.name = 'Connections' + AND nav2.name = 'Manage Extensions' + AND nav2.has_separator = 1 + AND nav1.parent_id = @parent_id + AND nav1.weight > nav2.weight +SET + nav1.weight = nav2.weight, + nav2.weight = nav1.weight; -- 2.25.1