# CiviCRM 5.23.0
Released March 4, 2020
- **[Synopsis](#synopsis)**
- **[Features](#features)**
- **[Bugs resolved](#bugs)**
- **[Miscellany](#misc)**
- **[Credits](#credits)**
- **[Feedback](#feedback)**
## Synopsis
| *Does this version...?* | |
|:--------------------------------------------------------------- |:-------:|
| Fix security vulnerabilities? | no |
| **Change the database schema?** | **yes** |
| **Alter the API?** | **yes** |
| Require attention to configuration options? | no |
| **Fix problems installing or upgrading to a previous version?** | **yes** |
| **Introduce features?** | **yes** |
| **Fix bugs?** | **yes** |
## Features
### Core CiviCRM
- **Add PDF letter functionality for Activities using new token processor
([14662](https://github.com/civicrm/civicrm-core/pull/14662))**
Adds the ability to create PDF letters that include activity tokens from the
activity search.
- **Add utf8 to utfmb8 conversion api command
([15969](https://github.com/civicrm/civicrm-core/pull/15969))**
Adds an API to convert the database from utf8 to utf8mb4. This is intended to
help early adopters using the utf8mb4 standard (which includes support for
emojis) with CiviCRM.
- **Move exportui extension into core
([16335](https://github.com/civicrm/civicrm-core/pull/16335))**
Updates the 'Select Fields' screen on step 3 of the Export wizard.
- **Allow setting a custom L10n/I18n resource directory
([dev/translation#30](https://lab.civicrm.org/dev/translation/issues/30):
[15408](https://github.com/civicrm/civicrm-core/pull/15408) and
[16583](https://github.com/civicrm/civicrm-core/pull/16583))**
Adds a new setting for the "L10n/I18n resource directory" which allows site
administrators to specify the location of the l10n directory (and allows the
directory to be outside of the main code base).
- **Proposal to add a new hook_civicrm_alterExternUrl
([dev/core#1100](https://lab.civicrm.org/dev/core/issues/1100):
[15475](https://github.com/civicrm/civicrm-core/pull/15475))**
Adds a new hook `hook_civicrm_alterExternUrl` which can be used by extension
developers to alter Extern scripts.
- **Support MySQL 8.0 now that it is GA
(Work Towards [dev/core#392](https://lab.civicrm.org/dev/core/issues/392):
[16204](https://github.com/civicrm/civicrm-core/pull/16204),
[16202](https://github.com/civicrm/civicrm-core/pull/16202) and
[16207](https://github.com/civicrm/civicrm-core/pull/16207))**
Works toward supporting MySQL 8.0 by:
+ Ensuring that the log_date column on logging tables is NOT NULL in MySQL 8.
+ Ensuring that `CRM_Utils_QueryFormatterTest` passes on MySQL 8.
+ Fixing the handling of dates in `getMembershipStarts` function to ensure
date is passed to query as yyyy-mm-dd to fix test failure on MySQL 8.
- **Field Names now Reserved Words in MySQL8
([dev/core#1143](https://lab.civicrm.org/dev/core/issues/1143):
[16206](https://github.com/civicrm/civicrm-core/pull/16206),
[16203](https://github.com/civicrm/civicrm-core/pull/16203),
[16201](https://github.com/civicrm/civicrm-core/pull/16201),
[16193](https://github.com/civicrm/civicrm-core/pull/16193) and
[16214](https://github.com/civicrm/civicrm-core/pull/16214))**
MySQL8 reserves the words "description" and "grouping" which CiviCRM uses as
field names. These changes work to ensure that these fields play nicely when
using MySQL8.
- **CQ: Migrate simple Preferences & Settings forms to using a Generic class.
(Work Towards [dev/core#495](https://lab.civicrm.org/dev/core/issues/495):
[16224](https://github.com/civicrm/civicrm-core/pull/16224),
[16234](https://github.com/civicrm/civicrm-core/pull/16234),
[16235](https://github.com/civicrm/civicrm-core/pull/16235),
[16236](https://github.com/civicrm/civicrm-core/pull/16236),
[16237](https://github.com/civicrm/civicrm-core/pull/16237),
[16233](https://github.com/civicrm/civicrm-core/pull/16233),
[16232](https://github.com/civicrm/civicrm-core/pull/16232),
[16228](https://github.com/civicrm/civicrm-core/pull/16228),
[16229](https://github.com/civicrm/civicrm-core/pull/16229) and
[16227](https://github.com/civicrm/civicrm-core/pull/16227))**
Makes admin settings field labels translatable.
- **composer.json - Update civicrm-setup
([16423](https://github.com/civicrm/civicrm-core/pull/16423))**
Improves civicrm-setup for scripted installations of Druapl8 with `cv` and GUI
based installations on WordPress.
- **Replace all instances of CRM_Core_Fatal with throw new CRM_Core_Exception
(Work Towards [dev/core#560](https://lab.civicrm.org/dev/core/issues/560):
[16433](https://github.com/civicrm/civicrm-core/pull/16433))**
Work towards throwing exceptions instead of fatal errors.
- **Google+ references should be removed as it phases out (Work Towards
[dev/core#711](https://lab.civicrm.org/dev/core/issues/711):
[16099](https://github.com/civicrm/civicrm-core/pull/16099) and
[16185](https://github.com/civicrm/civicrm-core/pull/16185))**
Google is phasing out Google+ this begins work to remove all visible
references to Google+ from CiviCRM.
- **"config_backend" should be thoroughly removed (Work Towards
[dev/core#1387](https://lab.civicrm.org/dev/core/issues/1387):
[15842](https://github.com/civicrm/civicrm-core/pull/15842))**
Ensures that the column `civicrm_domain.config_backend` is not created on new
sites and drops the column `civicrm_domain.config_backend` for sites that
started on 4.7-5.20. Additionally, this deprecates some functions related to
the setting `civicrm_domain.config_backend`.
- **Address ID field should be exportable
([dev/core#1512](https://lab.civicrm.org/dev/core/issues/1512):
[16240](https://github.com/civicrm/civicrm-core/pull/16240))**
Makes Address ID an exportable field.
- **APIv3 - Only scan files for deprecation checks in Entity.get
([16460](https://github.com/civicrm/civicrm-core/pull/16460))**
Improves performance of APIv3 by stopping scanning nonexistent files.
- **Add debug info to api4 output
([16351](https://github.com/civicrm/civicrm-core/pull/16351))**
Improves API4 by adding debug info and displaying the query.
- **APIv4 - don't throw exception when updating/deleting 0 items
([16374](https://github.com/civicrm/civicrm-core/pull/16374))**
Improves APIv4's update and delete actions when operating on 0 items so that
they do not throw exceptions, instead they return 0 results.
- **APIv4 - Variable substitution in docblocks
([16449](https://github.com/civicrm/civicrm-core/pull/16449))**
Makes the help text more meaningful in the APIv4 Explorer by always referring to
the correct entity & action names.
- **APIv4 Explorer css tweaks
([16431](https://github.com/civicrm/civicrm-core/pull/16431))**
Makes the checkboxes in the APIv4 explorer line up better and makes them bold
when checked.
- **APIv4 docs improvements
([16411](https://github.com/civicrm/civicrm-core/pull/16411))**
Improves APIv4 docs and their display in the explorer.
- **APIv4 Explorer - Better UI for defaults param
([16454](https://github.com/civicrm/civicrm-core/pull/16454))**
Improves APIv4 so that it handles defaults param with select2 instead of a
text box. Also shows the new way of using the variadic addSelect function.
- **Api4 - improve docblocks & display links in explorer
([16373](https://github.com/civicrm/civicrm-core/pull/16373))**
Improves documentation for most APIv4 entities by adding clickable links
to documentation displayed in the APIv4 explorer.
- **Implement PaymentProcessor and PaymentProcessorType APIv4 Entities
([15624](https://github.com/civicrm/civicrm-core/pull/15624))**
Adds `PaymentProcesor` and `PaymentProcessorType` entities to APIv4.
- **Update function to repair indexes to take table as a parameter
([16146](https://github.com/civicrm/civicrm-core/pull/16146))**
Makes it so the `System.getmissingindices` and `System.updateindexes` APIs
accept 'tables' as a parameter (array or string) and limits the results to the
specified tables if supplied.
- **Api4 - Support wildcard * in select clause
([16302](https://github.com/civicrm/civicrm-core/pull/16302))**
Adds support for the * wildcard in the SELECT clause of APIv4 Get actions.
- **Api4 - Filter returned fields by contact type
([16300](https://github.com/civicrm/civicrm-core/pull/16300))**
Ensures that civicrm_api4('Contact', 'get' ...) filters the fields returned
based on contact type.
- **Api4 - Convert field values to correct data type
([16274](https://github.com/civicrm/civicrm-core/pull/16274))**
Ensures that Api4 returns field values as the correct data type (instead of
always as a raw string).
- **Api4 - format output consistently across get/create/update.
([16305](https://github.com/civicrm/civicrm-core/pull/16305))**
Improves consistency of output in Api4.
- **Add more functionality to the api4 $index param
([16257](https://github.com/civicrm/civicrm-core/pull/16257))**
Improves APIv4 by making the `$index` param support 4 modes: Integer, String,
Non-associative array and Associative array and documenting them more clearly.
- **Use markdown in php docblocks & display in APIv4 Explorer
([16425](https://github.com/civicrm/civicrm-core/pull/16425))**
Reformats some docblocks to use markdown, and uses the marked.js library to
display the docblocks clearly in the APIv4 Explorer.
- **Civi\Test - Allow `headless()->apply()` (etc) to execute without setup.sh
([16405](https://github.com/civicrm/civicrm-core/pull/16405))**
Makes it possible to run the headless test suites without running setup.sh.
- **Allow most values of $civicrm_paths['XXX']['url'] to be relative
([16403](https://github.com/civicrm/civicrm-core/pull/16403))**
Allows system administrators to override various path and URL computations
using a relative URL.
- **composer.json - Explicitly set target PHP platform
([16421](https://github.com/civicrm/civicrm-core/pull/16421))**
Refines the way in which composer resolves dependencies - so as to prefer
packages that are compatible with CiviCRM's declared minimum requirement.
- **Add function to set entitySubType for entity forms
([16017](https://github.com/civicrm/civicrm-core/pull/16017))**
Makes it so entity subtype can be set in a standard way and is used if set.
- **Add metadata to is_primary fields
([16113](https://github.com/civicrm/civicrm-core/pull/16113))**
Improves field information for `is_primary` for the sake of Form Builder.
- **Check field to carry over custom data by default when the other contact has
none ([16246](https://github.com/civicrm/civicrm-core/pull/16246))**
Improves the contact merge screen by defaulting to checking the box to
carryover any custom data fields where the contact being merged into has no
data.
- **Add resolved to return array for get_conflicts
([15829](https://github.com/civicrm/civicrm-core/pull/15829))**
Enhances the `Contact.get_merge_conflicts` API call to also include an array
of resolved conflicts.
### CiviCase
- **Add case tokens to email activities
([dev/core#522](https://lab.civicrm.org/dev/core/issues/522):
[16105](https://github.com/civicrm/civicrm-core/pull/16105))**
Adds the ability to use case tokens in PDF Letters and single emails.
- **Restrict case roles by group
([15570](https://github.com/civicrm/civicrm-core/pull/15570))**
Adds a setting to restrict contacts available to be selected for a case role
by group.
### CiviContribute
- **Add columns to Contribution Detail report: Employer, Location Type,
Preferred Communication Method
([dev/core#1573](https://lab.civicrm.org/dev/core/issues/1573):
[16458](https://github.com/civicrm/civicrm-core/pull/16458))**
Improves the Contribution Detail report by making the fields 'Employer',
'Location Type', 'Preferred Communication Method' available as columns.
- **Add "Contributor Name" to Offline Contribution Receipts
([16286](https://github.com/civicrm/civicrm-core/pull/16286))**
Adds the display name of the contributor to Offline Contribution Receipts.
- **Add pre/post hooks on ContributionSoft entity
([16264](https://github.com/civicrm/civicrm-core/pull/16264))**
Add Pre and post hooks for the `ContributionSoft` entity.
- **Deprecate creating partially paid contributions, other than by partially
paying a contribution.
([15855](https://github.com/civicrm/civicrm-core/pull/15855))**
Adds deprecation noise when an attempt is made to set a contribution to
partially paid other than by adding a payment (using Payment.create). This is
necessary not only because we have a preferred workflow but also because
setting to "Partially Paid" doesn't actually create the `financial_trxn` that
is required if done via `Contribution.create` flow.
### CiviEvent
- **Expose "is_show_location" to control display of event locations
([dev/core#1511](https://lab.civicrm.org/dev/core/issues/1511):
[16230](https://github.com/civicrm/civicrm-core/pull/16230))**
Exposes an option to show event location on the event configuration tab.
### CiviMail
- **Make Deja Vu Sans the default font for mailing labels
([dev/core#1502](https://lab.civicrm.org/dev/core/issues/1502):
[16216](https://github.com/civicrm/civicrm-core/pull/16216))**
Updates the default font for mailing labels to be "Deja Vu Sans" which is a
font that supports unicode characters.
- **Pass through mailing id to alterMailContent hook
([dev/core#1253](https://lab.civicrm.org/dev/core/issues/1253):
[15306](https://github.com/civicrm/civicrm-core/pull/15306))**
Improves the `hook_civicrm_alterMailContent` hook by passing the mailing ID to
it so that developers can access data about the mailing that the content is
part of.
- **Eventually google will require OAUTH for bounce processing and may require
it for outbound SMTP through gmail servers
(Work Towards [dev/mail#59](https://lab.civicrm.org/dev/mail/issues/59):
[16231](https://github.com/civicrm/civicrm-core/pull/16231),
[16518](https://github.com/civicrm/civicrm-core/pull/16518),
[16307](https://github.com/civicrm/civicrm-core/pull/16307) and
[16306](https://github.com/civicrm/civicrm-core/pull/16306))**
Adds the ability to connect to IMAP server using XOAUTH2 protocol. Updates the
version of zetacomponents/mail package to a version that will support XAUTH2.
- **Allow personalised 'view in browser' links for mass emails
([dev/core#1064](https://lab.civicrm.org/dev/core/issues/1064):
[14591](https://github.com/civicrm/civicrm-core/pull/14591))**
Improves the CiviMail "view in browser" experience by allowing personalized
links.
### CiviMember
- **When viewing a membership show if the status is overridden
([16341](https://github.com/civicrm/civicrm-core/pull/16341))**
Adds the text "(Overridden)" next to the membership status when viewing a
membership for which the status has been overridden.
- **Auto renew text appears at top of membership edit form
([dev/core#1519](https://lab.civicrm.org/dev/core/issues/1519):
[16269](https://github.com/civicrm/civicrm-core/pull/16269))**
Improves the placement of the Auto Renew help text on the Membership edit
form.
- **Improve accessibility of membership edit form
([dev/core#1520](https://lab.civicrm.org/dev/core/issues/1520):
[16272](https://github.com/civicrm/civicrm-core/pull/16272))**
Updates the help text link text on the membership edit form to be meaningful
to improve accessibility.
- **Permit modified_id as a parameter for membership create api
([16166](https://github.com/civicrm/civicrm-core/pull/16166))**
Adds `modified_id` as a parameter for APIv3 `membership.create`.
### Wordpress Integration
- **WordPress Version Update
([dev/wordpress#2](https://lab.civicrm.org/dev/wordpress/issues/2):
[16211](https://github.com/civicrm/civicrm-core/pull/16211))**
Ensures the WordPress plugin version is updated by distmaker.
- **Pass language code to CiviCRM for Wordpress
([16446](https://github.com/civicrm/civicrm-core/pull/16446))**
Ensures CiviCRM will always pick up the language that WordPress is configured
to use instead of having to configure the language in both CiviCRM and
WordPress.
- **Update civicrm.settings.php.template to default to CLEANURL for WP
([16284](https://github.com/civicrm/civicrm-core/pull/16284))**
Makes it so that new WordPress/CiviCRM sites default to having CleanUrls.
## Bugs resolved
### Core CiviCRM
- **No Household Member Relationship Created when an Individual shares a
relationship with a household
([dev/core#1319](https://lab.civicrm.org/dev/core/issues/1319):
[16447](https://github.com/civicrm/civicrm-core/pull/16447))**
Fixes a regression in core where sharing an address with a household stopped
creating a household member relationship so that there is a checkbox (that
defaults to checked) to create a household member relationship when sharing
an address with a household.
- **Add mechanism for avoiding conflicts when deduping
([dev/core#1355](https://lab.civicrm.org/dev/core/issues/1355):
[15670](https://github.com/civicrm/civicrm-core/pull/15670))**
Improves dedupe functionality so that it aborts early if two (or more)
dedupe jobs are running at the same time and attempt to act on the same
contact.
- **Clear asset builder cache when clearing cache
([dev/core#1395](https://lab.civicrm.org/dev/core/issues/1395):
[15857](https://github.com/civicrm/civicrm-core/pull/15857))**
Ensures the "dyn" folder gets cleared when clearing CiviCRM caches.
- **Smart groups with deleted/disabled custom fields throw fatal error on its
usage. (Work Towards [dev/core#1471](https://lab.civicrm.org/dev/core/issues/1471):
[16267](https://github.com/civicrm/civicrm-core/pull/16267))**
Adds an alert on the system status page when deleted custom fields are used in
a smart group.
- **Invalid links to extension directory
([dev/core#1550](https://lab.civicrm.org/dev/core/issues/1550):
[16394](https://github.com/civicrm/civicrm-core/pull/16394))**
Fixes an invalid link to the extension directory in help text.
- **CQ: Eliminate 'contribution_invoice_settings' 'Setting' in favour of
following our standard (Work Towards
[dev/core#1558](https://lab.civicrm.org/dev/core/issues/1558):
[16397](https://github.com/civicrm/civicrm-core/pull/16397),
[16398](https://github.com/civicrm/civicrm-core/pull/16398),
[16412](https://github.com/civicrm/civicrm-core/pull/16412) and
[16424](https://github.com/civicrm/civicrm-core/pull/16424))**
Works towards eliminating the 'contribution_invoice_settings' 'Setting' in
favor of following the CiviCRM standard by ensuring the `credit_notes_prefix`
is retrieved the standard way, refactoring some old code and adding some data
conversion code for the non-standard setting.
- **Errors in link ReCaptcha and Extension Directory
([dev/translation#33](https://lab.civicrm.org/dev/translation/issues/33):
[16387](https://github.com/civicrm/civicrm-core/pull/16387))**
Fixes a link with incorrect quoting leading to malformed html and a link with
an incorrect anchor.
- **Incorrect Contact Reference option for Postal Code in civicrm_data.sql
([dev/translation#34](https://lab.civicrm.org/dev/translation/issues/34):
[16352](https://github.com/civicrm/civicrm-core/pull/16352))**
Fixes a bug where custom fields of the type "contact reference" would
display the country instead of the postal code so that they show the country
as expected.
- **Getting Started dashlet does not cache per language
([dev/translation#35](https://lab.civicrm.org/dev/translation/issues/35):
[16354](https://github.com/civicrm/civicrm-core/pull/16354))**
Ensures the CiviCRM Resources dashlet displays in the user's language.
- **Call hook_civicrm_copy for RecurringEntity
([16466](https://github.com/civicrm/civicrm-core/pull/16466))**
Ensures that `hook_civicrm_copy` is called when entities are copied via
RecurringEntity.
- **CRM_Utils_XML::parseFile() - Fix obscure segfault
([16463](https://github.com/civicrm/civicrm-core/pull/16463))**
Fixes a Segfault error for users with a very specific config (Macs running php
7.4.1 or 7.3.9 MAMP 5.6).
- **Add require_once to api3TestTrait
([16461](https://github.com/civicrm/civicrm-core/pull/16461))**
Ensures the `api3TestTrait` includes the file for the
`_civicrm_api3_get_options_from_params` function instead of relying on it
being loaded tangentially.
- **Cleanup API_Exception usage
([16432](https://github.com/civicrm/civicrm-core/pull/16432))**
Fixes mis-capitalized exception class name, and moves a APIv3-only check to the
right place.
- **IconPicker widget improvements
([15760](https://github.com/civicrm/civicrm-core/pull/15760))**
Fixes some style issues with the icon picker widget and adds some controls to
the dialog.
- **CRM_Core_Menu - Fix warnings during local test run
([16406](https://github.com/civicrm/civicrm-core/pull/16406))**
Fixes the warning `Warning: simplexml_load_file(): I/O warning : failed to
load external entity` when running the test suite on Drupal 8 sites on OSX.
- **Add user friendly error message on merge error
([dev/core#1540](https://lab.civicrm.org/dev/core/issues/1540):
[16340](https://github.com/civicrm/civicrm-core/pull/16340))**
Adds a user friendly error when attempting to merge two contacts from the
Advanced Search Screen when no Supervised rule is present on the site, before
this change a fatal error was thrown.
- **Enotice fix ([16293](https://github.com/civicrm/civicrm-core/pull/16293))**
Fixes an "Warning: Invalid argument supplied foreach()" e-notice on the edit
smart group screen.
- **Force reCaptcha is not working when pay later enabled
([16282](https://github.com/civicrm/civicrm-core/pull/16282))**
Ensures that ReCaptcha is always on even if only pay later is enabled as a
payment method.
- **Dedupe rules don't work with custom fields/Variable type error during import
process ([dev/core#1597](https://lab.civicrm.org/dev/core/issues/1597) and
[dev/core#1595](https://lab.civicrm.org/dev/core/issues/1595):
[16558](https://github.com/civicrm/civicrm-core/pull/16558))**
Fixes a regression where dedupe rules were failing when attempting to use a
custom field as the match field.
- **Select_string only accepts integers: 1
([dev/translation#36](https://lab.civicrm.org/dev/translation/issues/36):
[16599](https://github.com/civicrm/civicrm-core/pull/16599))**
Fixes an error for translated sites when trying to perform a contact search.
- **Advanced Search: "active period" filter regression
([dev/core#1592](https://lab.civicrm.org/dev/core/issues/1592):
[16535](https://github.com/civicrm/civicrm-core/pull/16535))**
Fixes a bug in Advanced Search where the filter "active period" (for
relationships) is not respected.
- **Advanced search links on mailing reports page give "DB Error: syntax error"
([dev/core#1551](https://lab.civicrm.org/dev/core/issues/1551):
[16534](https://github.com/civicrm/civicrm-core/pull/16534))**
Fixes a regression where this url
"civicrm/contact/search/advanced?force=1&mailing_id=1" throws a fatal error.
- **Upgrade fails when civicrm_managed table contains a row including
entity_type='PaymentProcessorType';
([dev/core#1498](https://lab.civicrm.org/dev/core/issues/1498):
[16521](https://github.com/civicrm/civicrm-core/pull/16521))**
- **Fix loading with alternate packages path (system-level)
([16407](https://github.com/civicrm/civicrm-core/pull/16407))**
- **Fix loading with alternate packages path (UI-level)
([16409](https://github.com/civicrm/civicrm-core/pull/16409))**
- **setup.sh - Fixes for running in basic composer file-structure
([16408](https://github.com/civicrm/civicrm-core/pull/16408))**
- **Make $civicrm_paths less sensitive to trailing slashes. Add tests.
([16404](https://github.com/civicrm/civicrm-core/pull/16404))**
- **Prevent PropertBag from being so noisy about deprecation warnings
([16390](https://github.com/civicrm/civicrm-core/pull/16390))**
- **Wrong parameter passed to executeQuery function
([16353](https://github.com/civicrm/civicrm-core/pull/16353))**
- **Update temp table handler to support utf8mb4 if that is the db collation
([15992](https://github.com/civicrm/civicrm-core/pull/15992))**
- **Enforce isSkipLineItem for membership payment entity in Order.create
([15891](https://github.com/civicrm/civicrm-core/pull/15891))**
- **Fetch Only Active Custom Group Extend Values
([15759](https://github.com/civicrm/civicrm-core/pull/15759))**
- **Ensure that we always return a raw urlencoded url for extenal urls to fix
Flexmailer tests
([16265](https://github.com/civicrm/civicrm-core/pull/16265))**
- **Country/State PseudoConstant not sorted according to the locale
([16258](https://github.com/civicrm/civicrm-core/pull/16258))**
- **Change check.gif to an actual gif (was a PNG)
([16220](https://github.com/civicrm/civicrm-core/pull/16220))**
- **Fix Error handling following DB Package upgrade
([16213](https://github.com/civicrm/civicrm-core/pull/16213))**
- **Do not escape html in report header and footers on API create
([dev/core#1286](https://lab.civicrm.org/dev/core/issues/1286):
[15383](https://github.com/civicrm/civicrm-core/pull/15383))**
- **Editing a group description inline causes the recent items list to display
blank instead of the group title
([dev/core#1506](https://lab.civicrm.org/dev/core/issues/1506):
[16197](https://github.com/civicrm/civicrm-core/pull/16197))**
- **Recent items list has blank entry and E_NOTICE's when viewing an Email
activity from activities tab
([dev/core#1507](https://lab.civicrm.org/dev/core/issues/1507):
[16195](https://github.com/civicrm/civicrm-core/pull/16195))**
- **'Merge All Contacts with the Same Address' doesn't consider Household
replace individuals that share same address. ([CRM-21858
](https://issues.civicrm.org/jira/browse/CRM-21858) and
[dev/core#1364](https://lab.civicrm.org/dev/core/issues/1364):
[16369](https://github.com/civicrm/civicrm-core/pull/16369))**
- **Scheduled reminder emails sent to contacts with do_not_email set or with
email on hold ([dev/core#1378](https://lab.civicrm.org/dev/core/issues/1378):
[15778](https://github.com/civicrm/civicrm-core/pull/15778))**
- **Update BAO_Acl internal functions to protected & unused to deprecated
([16189](https://github.com/civicrm/civicrm-core/pull/16189))**
- **Deactivating CiviContribute causes SQL error
([dev/core#547](https://lab.civicrm.org/dev/core/issues/547):
[16365](https://github.com/civicrm/civicrm-core/pull/16365))**
### CiviCase
- **Changing a civicase activity's label breaks the max_instances check
([dev/core#1116](https://lab.civicrm.org/dev/core/issues/1116):
[16347](https://github.com/civicrm/civicrm-core/pull/16347))**
- **Case Resource shows contact names that are not accessible to logged in user
([dev/core#1499](https://lab.civicrm.org/dev/core/issues/1499):
[16150](https://github.com/civicrm/civicrm-core/pull/16150))**
- **Fix activity.case_id token to always display the first case ID
([16208](https://github.com/civicrm/civicrm-core/pull/16208))**
### CiviContribute
- **Positive integer expected for recurring interval even when user is not
making a recurring contribution
([dev/core#1588](https://lab.civicrm.org/dev/core/issues/1588):
[16532](https://github.com/civicrm/civicrm-core/pull/16532))**
Fixes a Fatal error when the recurring option "Support recurring intervals" is
enabled on a contribution page.
- **Make getTotalPayments return 0 instead of NULL
([16129](https://github.com/civicrm/civicrm-core/pull/16129))**
- **Email address token on the confirmation message not working for a pay later
contribution. ([dev/core#1255](https://lab.civicrm.org/dev/core/issues/1255):
[15314](https://github.com/civicrm/civicrm-core/pull/15314))**
- **Paypal IPN fails when contact is merged
([dev/core#1249](https://lab.civicrm.org/dev/core/issues/1249):
[15307](https://github.com/civicrm/civicrm-core/pull/15307))**
- **`,` as decimal separator, and [space] as thousand separators leads to api
errors ([dev/core#1522](https://lab.civicrm.org/dev/core/issues/1522):
[16392](https://github.com/civicrm/civicrm-core/pull/16392))**
- **Fix retrieving contribution_status_id for manual payment processor
([16018](https://github.com/civicrm/civicrm-core/pull/16018))**
- **Set contribution status to refunded when it has been refunded
([16148](https://github.com/civicrm/civicrm-core/pull/16148))**
### CiviEvent
- **"Confirm Event Invitation" message template has a bad variable
([dev/event#32](https://lab.civicrm.org/dev/event/issues/32):
[16367](https://github.com/civicrm/civicrm-core/pull/16367))**
Fixes the URL for self-service updates links in the "Confirm Event Invitation"
message template to include the participant ID so that they link correctly.
- **Respect form value for register_date on participant form
([16439](https://github.com/civicrm/civicrm-core/pull/16439))**
Fixes a bug where the participant registration date is exposed on the
backoffice event form, but when a credit card payment is being submitted it is
ignored.
- **Scheduled reminders are incorrectly sent from event templates when
"additional group" is selected
([dev/event#28](https://lab.civicrm.org/dev/event/issues/28):
[16311](https://github.com/civicrm/civicrm-core/pull/16311))**
- **"Confirm from waitlist" doesn't consider whether participant roles are
counted. ([dev/event#23](https://lab.civicrm.org/dev/event/issues/23):
[16098](https://github.com/civicrm/civicrm-core/pull/16098))**
- **Event registration form doesn't prevent multiple signups for waitlisted
participants. ([dev/event#30](https://lab.civicrm.org/dev/event/issues/30):
[16358](https://github.com/civicrm/civicrm-core/pull/16358))**
- **Permission error on event info page for anonymous users
([dev/core#1517](https://lab.civicrm.org/dev/core/issues/1517):
[16266](https://github.com/civicrm/civicrm-core/pull/16266))**
### CiviMember
- **Changing the membership type causes multiple copies of related membership
text on edit membership page
([dev/core#1537](https://lab.civicrm.org/dev/core/issues/1537):
[16326](https://github.com/civicrm/civicrm-core/pull/16326))**
- **search builder: member since field ignored
([dev/core#1602](https://lab.civicrm.org/dev/core/issues/1602):
[16578](https://github.com/civicrm/civicrm-core/pull/16578))**
Ensures that "Search Builder" respects the "Member Since" field.
### Drupal Integration
- **composer.json - Relax psr/log constraint. Improve D8 compatibility.
([16471](https://github.com/civicrm/civicrm-core/pull/16471))**
Fixes a composer conflict when installing CiviCRM on Drupal 8.7.
- **Drupal8: Enabling language breaks a fresh CiviCRM install
([dev/drupal#85](https://lab.civicrm.org/dev/drupal/issues/85):
[15912](https://github.com/civicrm/civicrm-core/pull/15912))**
- **Drupal8 - Contact Report does not load any values in the ACL Group/Role
field ([dev/drupal#89](https://lab.civicrm.org/dev/drupal/issues/89):
[16273](https://github.com/civicrm/civicrm-core/pull/16273) and
[15318](https://github.com/civicrm/civicrm-core/pull/15318))**
- **CiviCRM session instance not working when Masquerading in Drupal 7
([dev/drupal#98](https://lab.civicrm.org/dev/drupal/issues/98):
[16177](https://github.com/civicrm/civicrm-core/pull/16177))**
- **Wiki link in OG Sync module description gives a 404
([dev/drupal#102](https://lab.civicrm.org/dev/drupal/issues/102):
[595](https://github.com/civicrm/civicrm-drupal/pull/595))**
## Miscellany
- **Duplicate code (for real)
([16363](https://github.com/civicrm/civicrm-core/pull/16363) and
[16567](https://github.com/civicrm/civicrm-core/pull/16567))**
- **Mailing Subscribe Form: remove nbsp from descriptions
([16186](https://github.com/civicrm/civicrm-core/pull/16186))**
- **Remove SymfonyComponents/YAML package
([285](https://github.com/civicrm/civicrm-packages/pull/285))**
- **Update DB_Object
([280](https://github.com/civicrm/civicrm-packages/pull/280))**
- **Update gettext to latest tagged release
([227](https://github.com/civicrm/civicrm-packages/pull/227))**
- **Upgrade DB package to be version 1.9.3
([276](https://github.com/civicrm/civicrm-packages/pull/276))**
- **Update copyright headers following merge of #14662
([16199](https://github.com/civicrm/civicrm-core/pull/16199))**
- **Add tax rates to metadata
([16253](https://github.com/civicrm/civicrm-core/pull/16253))**
- **Add helper for getting participantValues
([16355](https://github.com/civicrm/civicrm-core/pull/16355))**
- **Update docs link for edit scheduled job parameters
([16299](https://github.com/civicrm/civicrm-core/pull/16299))**
- **Start to use function rather than multiple queries for event details add
test ([16329](https://github.com/civicrm/civicrm-core/pull/16329))**
- **Simplify event title retrieval, use cache, add test
([16345](https://github.com/civicrm/civicrm-core/pull/16345))**
- **Change function buildEventFeeForm to non-static
([16337](https://github.com/civicrm/civicrm-core/pull/16337))**
- **Finish removal of deferred_revenue_enabled from non-standard setting
([16395](https://github.com/civicrm/civicrm-core/pull/16395))**
- **Api4 - Improve Entity::get
([16346](https://github.com/civicrm/civicrm-core/pull/16346))**
- **Api4 - Make abstract function abstract
([16343](https://github.com/civicrm/civicrm-core/pull/16343))**
- **Api4 - Use explicit adder functions rather than magicMethod
([16372](https://github.com/civicrm/civicrm-core/pull/16372))**
- **Update contributor-key.yml
([16268](https://github.com/civicrm/civicrm-core/pull/16268))**
- **Update my contributor details
([16184](https://github.com/civicrm/civicrm-core/pull/16184))**
- **APIv4 documentation & code cleanup
([16457](https://github.com/civicrm/civicrm-core/pull/16457))**
- **Fix minor typo in help text.
([16303](https://github.com/civicrm/civicrm-core/pull/16303))**
- **Extract code for isPaymentOnExistingContribution.
([16327](https://github.com/civicrm/civicrm-core/pull/16327))**
- **Remove function that exactly matches parent class.
([16316](https://github.com/civicrm/civicrm-core/pull/16316))**
- **Remove unsupported and unused package DB_Table
([277](https://github.com/civicrm/civicrm-packages/pull/277))**
- **Remove $ids as parameter for Membership::add
([16192](https://github.com/civicrm/civicrm-core/pull/16192))**
- **Remove unused code in Case/Form/Activity postProcess
([16304](https://github.com/civicrm/civicrm-core/pull/16304))**
- **Remove never passed-in parameter from addPayments
([16262](https://github.com/civicrm/civicrm-core/pull/16262))**
- **Remove duplicate line of code
([16317](https://github.com/civicrm/civicrm-core/pull/16317))**
- **Remove unreachable code lines.
([16349](https://github.com/civicrm/civicrm-core/pull/16349))**
- **Remove unused code
([16371](https://github.com/civicrm/civicrm-core/pull/16371))**
- **Remove irrelevant code.
([16348](https://github.com/civicrm/civicrm-core/pull/16348))**
- **Remove unindexed join from getACLRoles query
([16183](https://github.com/civicrm/civicrm-core/pull/16183))**
- **Remove unmaintained unsupported System_Command package
([283](https://github.com/civicrm/civicrm-packages/pull/283))**
- **fix typo's in the text
([16361](https://github.com/civicrm/civicrm-core/pull/16361))**
- **fix more typo's in the text
([16368](https://github.com/civicrm/civicrm-core/pull/16368))**
- **Fix unit tests after gettext merge
([282](https://github.com/civicrm/civicrm-packages/pull/282))**
- **Update recently-added PathUrlTest to be more representative
([16607](https://github.com/civicrm/civicrm-core/pull/16607))**
- **Fix tests to use buildFeeFn
([16389](https://github.com/civicrm/civicrm-core/pull/16389))**
- **Add unit test to back office form when a payment is made against a partially
paid contribution
([16437](https://github.com/civicrm/civicrm-core/pull/16437))**
- **Revised version of test from #15725
([15948](https://github.com/civicrm/civicrm-core/pull/15948))**
- **Update failing test to match intervening changes elsewhere
([16270](https://github.com/civicrm/civicrm-core/pull/16270))**
- **Fix unit test so price set params are valid
([16344](https://github.com/civicrm/civicrm-core/pull/16344))**
- **Update Export unit test to pass on MySQL 8
([16375](https://github.com/civicrm/civicrm-core/pull/16375))**
- **Basic extraction of paid event processing
([16281](https://github.com/civicrm/civicrm-core/pull/16281))**
- **Refactor CRM_Contact_BAO_Contact::importableFields() to use metadata
([16222](https://github.com/civicrm/civicrm-core/pull/16222))**
- **[REF] Remove setting of unused function.
([16315](https://github.com/civicrm/civicrm-core/pull/16315))**
- **[REF] Remove apparent copy & paste code.
([16308](https://github.com/civicrm/civicrm-core/pull/16308))**
- **[REF] Move the bounce to the start of the form submit
([16333](https://github.com/civicrm/civicrm-core/pull/16333))**
- **[REF] Eliminate silly parameter from function signature.
([16330](https://github.com/civicrm/civicrm-core/pull/16330))**
- **[REF] Extract code that assigns event variables to the tpl
([16325](https://github.com/civicrm/civicrm-core/pull/16325))**
- **[REF] Fix return value on deleting financial type
([16280](https://github.com/civicrm/civicrm-core/pull/16280))**
- **[REF] Move handling of default payment instrument for a payment proc…
([16279](https://github.com/civicrm/civicrm-core/pull/16279))**
- **[REF] Move use of priceSetID & amount_override to where they are used
([16252](https://github.com/civicrm/civicrm-core/pull/16252))**
- **[REF] Cleanup CRM_Member_BAO_Membership::buildMembershipTypeValues
([16059](https://github.com/civicrm/civicrm-core/pull/16059))**
- **[REF] Remove enclosed & escaped variables
([16249](https://github.com/civicrm/civicrm-core/pull/16249))**
- **[REF] Minor code simplification in dedupe.
([16245](https://github.com/civicrm/civicrm-core/pull/16245))**
- **[REF] move sessionStart functionality to System subclass
([16241](https://github.com/civicrm/civicrm-core/pull/16241))**
- **[REF] Update fetchAll function signature to match parent function
([16198](https://github.com/civicrm/civicrm-core/pull/16198))**
- **REF Simplify if statement on case activity form
([16210](https://github.com/civicrm/civicrm-core/pull/16210))**
- **[REF] Eliminate ['userID'] as an input for BAO_Membership::create
([16196](https://github.com/civicrm/civicrm-core/pull/16196))**
- **[REF] Move the storing of custom data into the add function rather th…
([16191](https://github.com/civicrm/civicrm-core/pull/16191))**
- **[REF] Remove never-passed param from getLineItems
([16251](https://github.com/civicrm/civicrm-core/pull/16251))**
- **[REF] Extract location wrangling code.
([16247](https://github.com/civicrm/civicrm-core/pull/16247))**
- **[REF] rename lineItem & lineItems variable
([16254](https://github.com/civicrm/civicrm-core/pull/16254))**
- **[REF] Activate fetchAll function in DataObject file
([281](https://github.com/civicrm/civicrm-packages/pull/281))**
- **[REF] Reduce places where we pass ids into Mailing::create
([16263](https://github.com/civicrm/civicrm-core/pull/16263))**
- **[REF] Remove ids and fully deprecate passing it to Contribution::create
([16256](https://github.com/civicrm/civicrm-core/pull/16256))**
- **[REF] Pass params into function rather than this weird check for whether
params exists. ([16438](https://github.com/civicrm/civicrm-core/pull/16438))**
- **[REF] Move assignment of BalanceAmount
([16334](https://github.com/civicrm/civicrm-core/pull/16334))**
- **[REF] Fix CRM_Core_BAO_UFGroup::createUFJoin to not receive by reference.
([16260](https://github.com/civicrm/civicrm-core/pull/16260))**
- **[REF] Interim code cleanup - make the usage of addPayments clearer
([16441](https://github.com/civicrm/civicrm-core/pull/16441))**
- **[REF] Remove unused variable
([16434](https://github.com/civicrm/civicrm-core/pull/16434))**
- **[REF] Add test for line item, extract fn
([16402](https://github.com/civicrm/civicrm-core/pull/16402))**
- **[REF] Ensure that the from is correctly modified in both the main que…
([16422](https://github.com/civicrm/civicrm-core/pull/16422))**
- **[REF] Remove some unused variables
([16414](https://github.com/civicrm/civicrm-core/pull/16414))**
- **REF Extract code to build pcp_supporter_text and enable translation
([16271](https://github.com/civicrm/civicrm-core/pull/16271))**
- **[REF] Remove unused variables
([16396](https://github.com/civicrm/civicrm-core/pull/16396))**
- **[REF] Extract function to export header row
([16364](https://github.com/civicrm/civicrm-core/pull/16364))**
- **[REF] Extract & share code to determine revenue recognition date.
([16388](https://github.com/civicrm/civicrm-core/pull/16388))**
- **[NFC] code cleanup
([16310](https://github.com/civicrm/civicrm-core/pull/16310))**
- **[NFC] Code cleanup
([16309](https://github.com/civicrm/civicrm-core/pull/16309))**
- **[NFC] code cleanup
([16301](https://github.com/civicrm/civicrm-core/pull/16301))**
- **[NFC] Minor code cleanup
([16290](https://github.com/civicrm/civicrm-core/pull/16290))**
- **[NFC] Extend unit test to cover for recent refactor by eileen to ensure sup…
([16332](https://github.com/civicrm/civicrm-core/pull/16332))**
- **[NFC] Code formatting
([16331](https://github.com/civicrm/civicrm-core/pull/16331))**
- **[NFC] Code cleanup
([16314](https://github.com/civicrm/civicrm-core/pull/16314))**
- **NFC Convert Manage PCP page to short array syntax
([16320](https://github.com/civicrm/civicrm-core/pull/16320))**
- **[NFC] Add in more assertions around the content of line items and tot…
([16218](https://github.com/civicrm/civicrm-core/pull/16218))**
- **[NFC] Doc Block fix should be bool no boolean as per coding standards
([596](https://github.com/civicrm/civicrm-drupal/pull/596))**
- **[NFC] Code comments
([16248](https://github.com/civicrm/civicrm-core/pull/16248))**
- **[NFC] Minor cleanup in test class
([16250](https://github.com/civicrm/civicrm-core/pull/16250))**
- **[NFC] Skip utf8mb4 test on MySQL versions lower than 5.7
([16483](https://github.com/civicrm/civicrm-core/pull/16483))**
- **[NFC] Test update following PR #16150, assertEquals first param is th…
([16219](https://github.com/civicrm/civicrm-core/pull/16219))**
- **[NFC] Explicitly specify that it is the Payment processor Type Name n…
([16275](https://github.com/civicrm/civicrm-core/pull/16275))**
- **NFC Fix TokenRow docblock
([16452](https://github.com/civicrm/civicrm-core/pull/16452))**
- **[NFC] Minor test cleanup.
([16450](https://github.com/civicrm/civicrm-core/pull/16450))**
- **[NFC] Remove unused local variables from
CRM_Contribute_Form_AdditionalPayment::processCreditCard
([16342](https://github.com/civicrm/civicrm-core/pull/16342))**
- **[NFC] throw exceptions, single quotes, declare exceptions, remove unused
param ([16415](https://github.com/civicrm/civicrm-core/pull/16415))**
- **(NFC) Update Var declaration to be standard in CRM folder
([16382](https://github.com/civicrm/civicrm-core/pull/16382))**
- **(NFC) Civi/*.php - Update for
Drupal.Commenting.VariableComment.IncorrectVarType
([16379](https://github.com/civicrm/civicrm-core/pull/16379))**
- **NFC Add parameter definition to membershipstatus.calc
([16370](https://github.com/civicrm/civicrm-core/pull/16370))**
- **[NFC] Ensure that annon permissions are correctly assigned when enabling
civicrm webtest module in backdrop
([16547](https://github.com/civicrm/civicrm-core/pull/16547))**
- **[NFC] Fix style error
([16549](https://github.com/civicrm/civicrm-core/pull/16549))**
## Credits
This release was developed by the following code authors:
a-n The Artists Information Company - William Mortada; AGH Strategies - Andrew
Hunt; Agileware - Pengyi Zhang; Andrei Mondoc; British Humanist Association -
Andrew West; Caltha - Tomasz Pietrzkowski; Chris Burgess; Circle Interactive -
Pradeep Nayak; CiviCoop - Jaap Jansma; CiviCRM - Coleman Watts, Tim Otten;
CiviDesk - Yashodha Chaku; CompuCorp - Vinu Varshith Sekar; Coop SymbioTIC -
Mathieu Lutfy, Samuel Vanhove; Dave D; Electronic Frontier Foundation - Mark
Burdett; Fuzion - Jitendra Purohit; GMCVO Databases - Jade Gaunt; JMA Consulting -
Seamus Lee; John Kingsnorth; Joinery - Allen Shaw; Joris Vercammen; Megaphone
Technology Consulting - Jon Goldberg; MJCO - Mikey O'Toole; MJW Consulting -
Matthew Wire; myDropWizard - David Snopek; Progressive Technology Project -
Jamie McClelland; Squiffle Consulting - Aidan Saunders; Tadpole Collective -
Kevin Cristiano; Third Sector Design - Michael McAndrew; Timbsoft Technologies -
Tunbola Ogunwande; Web Access - Kurund Jalmi; Wikimedia Foundation - Eileen
McNaughton, Elliott Eggleston
Most authors also reviewed code for this release; in addition, the following
reviewers contributed their comments:
AGH Strategies - Alice Frumin; Agileware - Justin Freeman; Andrew
Cormick-Dockery; Artful Robot - Rich Lott; Christian Wach; CiviDesk - Nicolas
Ganivet; CompuCorp - Shitij Gugnani; Francesc Bassas i Bullich; Fuzion - Luke
Stewart, Peter Davis; Greenpeace Central and Eastern Europe - Patrick Figel; JMA
Consulting - Joe Murray, Monish Deb; Korlon - Stuart Gaston; Lighthouse Design
and Consulting - Brian Shaughnessy; mikantchap; Richard van Oosterhout; SYSTOPIA
Organisationsberatung - Björn Endres; tapashdatta;
## Feedback
These release notes are edited by Alice Frumin and Andrew Hunt. If you'd like
to provide feedback on them, please log in to https://chat.civicrm.org/civicrm
and contact `@agh1`.