From 77c9ce31d267f3855c0e53244fd8b8a0ce23897c Mon Sep 17 00:00:00 2001 From: Seamus Lee Date: Wed, 11 Jul 2018 06:57:12 +1000 Subject: [PATCH] Add in Release notes for 5.3.1 and duplicate 5.3.0 upgrade mysql to ensure all sites get the upgrade steps just in case Update Release notes based on changed SAs --- CRM/Upgrade/Incremental/sql/5.3.1.mysql.tpl | 19 +++++++++++++++++++ release-notes/5.3.1.md | 19 +++++++++++++++++++ 2 files changed, 38 insertions(+) create mode 100644 CRM/Upgrade/Incremental/sql/5.3.1.mysql.tpl create mode 100644 release-notes/5.3.1.md diff --git a/CRM/Upgrade/Incremental/sql/5.3.1.mysql.tpl b/CRM/Upgrade/Incremental/sql/5.3.1.mysql.tpl new file mode 100644 index 0000000000..2e2057d6dd --- /dev/null +++ b/CRM/Upgrade/Incremental/sql/5.3.1.mysql.tpl @@ -0,0 +1,19 @@ +{* file to handle db changes in 5.3.1 during upgrade *} +{* Re run upgrades from 5.3.0 Just in case they were missed somehow due to dodgy tarball *} +ALTER TABLE civicrm_custom_group ALTER column is_multiple SET DEFAULT 0; +UPDATE civicrm_custom_group SET is_multiple = 0 WHERE is_multiple IS NULL; +ALTER TABLE civicrm_custom_group ALTER column is_active SET DEFAULT 1; +ALTER TABLE civicrm_custom_field ALTER column is_view SET DEFAULT 0; +UPDATE civicrm_custom_field SET is_view = 0 WHERE is_view IS NULL; +ALTER TABLE civicrm_custom_field ALTER column is_required SET DEFAULT 0; +UPDATE civicrm_custom_field SET is_required = 0 WHERE is_required IS NULL; +ALTER TABLE civicrm_custom_field ALTER column is_searchable SET DEFAULT 0; +UPDATE civicrm_custom_field SET is_searchable = 0 WHERE is_required IS NULL; +ALTER TABLE civicrm_custom_field ALTER column is_active SET DEFAULT 1; + +SET @UKCountryId = (SELECT id FROM civicrm_country cc WHERE cc.name = 'United Kingdom'); +INSERT IGNORE INTO civicrm_state_province (country_id, abbreviation, name) +VALUES (@UKCountryId, 'MON', 'Monmouthshire'); + +{* dev/core/#152 *} +UPDATE `civicrm_custom_field` set `html_type` = "Multi-Select" WHERE `html_type` = "AdvMulti-Select"; diff --git a/release-notes/5.3.1.md b/release-notes/5.3.1.md new file mode 100644 index 0000000000..5c919b7ade --- /dev/null +++ b/release-notes/5.3.1.md @@ -0,0 +1,19 @@ +# CiviCRM 5.3.1 + +Released July 18, 2018 + +- **[Security advisories](#security)** +- **[Features](#features)** +- **[Bugs resolved](#bugs)** +- **[Miscellany](#misc)** +- **[Credits](#credits)** + +## Security advisories + +- **[CIVI-SA-2018-01](https://civicrm.org/advisory/civi-sa-2018-01-sql-injection-in-get-cases-ajax-api)** SQL injection in get-cases AJAX API +- **[CIVI-SA-2018-02](https://civicrm.org/advisory/civi-sa-2018-02-reflected-xss-in-contribution-reports)** Reflected XSS in Contribution Reports +- **[CIVI-SA-2018-03](https://civicrm.org/advisory/civi-sa-2018-03-reflected-xss-in-error-message)** Reflected XSS in error message +- **[CIVI-SA-2018-04](https://civicrm.org/advisory/civi-sa-2018-04-sql-injection-in-custom-groups)** SQL injection in Custom Groups +- **[CIVI-SA-2018-05](https://civicrm.org/advisory/civi-sa-2018-05-reflected-xss-in-contact-merge-screen)** Reflected XSS in Contact Merge Screen +- **[CIVI-SA-2018-06](https://civicrm.org/advisory/civi-sa-2018-06-reflected-xss-in-context-parameter)** Reflected XSS in "New Membership" Form + -- 2.25.1