5 - **[Synopsis](#synopsis)**
6 - **[Features](#features)**
7 - **[Bugs resolved](#bugs)**
8 - **[Miscellany](#misc)**
9 - **[Credits](#credits)**
10 - **[Feedback](#feedback)**
12 ## <a name="synopsis"></a>Synopsis
14 | *Does this version...?* | |
15 |:--------------------------------------------------------------- |:-------:|
16 | Fix security vulnerabilities? | no |
17 | Change the database schema? | **yes** |
18 | Alter the API? | **yes** |
19 | Require attention to configuration options? | no |
20 | Fix problems installing or upgrading to a previous version? | **yes** |
21 | Introduce features? | **yes** |
22 | Fix bugs? | **yes** |
24 ## <a name="features"></a>Features
28 - **Minimum supported PHP version is 7.0
29 ([14437](https://github.com/civicrm/civicrm-core/pull/14437))**
31 CiviCRM now requires PHP 7.0 or higher. While sites running PHP 5.6 will be
32 able to upgrade to CiviCRM 5.14.0, they will see an error message saying it is
33 no longer supported. Upcoming changes to CiviCRM will not be evaluated with
34 regard to PHP 5.6 compatibility, and new sites installing CiviCRM must have
37 - **civi.api.prepare - Allow dynamic wrappers (preliminary work for
38 [dev/core#873](https://lab.civicrm.org/dev/core/issues/873):
39 [14047](https://github.com/civicrm/civicrm-core/pull/14047))**
41 This furthers the goal of allowing users to A/B test subject lines in Mosaico
42 by allowing extension developers to dynamically wrap an API using a listener
43 for the new civi.api.prepare event.
45 - **Make DAO fields more consistent
46 ([14072](https://github.com/civicrm/civicrm-core/pull/14072))**
48 This PR makes it so the 'where' field is populated regardless of whether
49 import or export is set. The goal of this pull request is to simplify some of
50 the metadata based magic by trying to get the meaning of import & export
51 closer to the original intent.
53 - **Hook to alter menubar css variables & fix breakpoint in WP
54 ([14135](https://github.com/civicrm/civicrm-core/pull/14135) and
55 [14420](https://github.com/civicrm/civicrm-core/pull/14420))**
57 A new hook, `hook_civicrm_getAssetUrl()`, allows modifying parameters for a
58 semi-static asset like a CSS file that takes certain parameters. The result
59 is that the menu bar is more flexible and configurable, and this fixes a
60 couple of issues with it in WordPress at certain widths.
62 - **Replace jcalendar instances with datepicker (continues
63 [dev/core#561](https://lab.civicrm.org/dev/core/issues/561):
64 [14150](https://github.com/civicrm/civicrm-core/pull/14150) and
65 [14099](https://github.com/civicrm/civicrm-core/pull/14099))**
67 The campaign search form and pledge forms now use datepicker instead of the
68 deprecated jcalendar for choosing dates.
70 - **Result filter criteria doesn't show IS NULL/IS NOT NULL for operations
71 ([dev/core#865](https://lab.civicrm.org/dev/core/issues/865):
72 [14028](https://github.com/civicrm/civicrm-core/pull/14028))**
74 Allow users to access to the operations `IS NULL` and `IS NOT NULL` when
75 choosing report filters for multiselect fields.
77 - **Allow url to set IS NULL/ NOT NULL in report for operations
78 ([dev/core#876](https://lab.civicrm.org/dev/core/issues/876):
79 [14052](https://github.com/civicrm/civicrm-core/pull/14052))**
81 Makes it so that the newly added filter options IS NULL/ NOT NULL (added
82 above) can be passed via URL.
84 - **Convert dedupe select to select 2 and remove not-used var
85 ([14161](https://github.com/civicrm/civicrm-core/pull/14161))**
87 On the Dedupe rules form, the "Field" drop-downs are converted to Select2
90 - **Add function filterLinks to return an array of links for an entity that can
91 be used by the API / form layer to generate a link
92 ([14112](https://github.com/civicrm/civicrm-core/pull/14112))**
94 Adds the function filterLinks (CRM_Core_Action::filterLinks()) which can be
95 used to generate link html client-side. This function is currently unused,
96 added in preparation for CiviCase link refactoring.
98 - **Add serialize metadata to tag used_for field
99 ([14096](https://github.com/civicrm/civicrm-core/pull/14096))**
101 Add schema metadata to the Tag `used_for` field, which is a comma separated
104 - **Cron Status Check - Better hyperlinks
105 ([14085](https://github.com/civicrm/civicrm-core/pull/14085))**
107 Improves the System Status check "Cron Not Running" by including a link to
108 most up to date documentation.
110 - **Add pseudoconstant to UFField dao
111 ([14041](https://github.com/civicrm/civicrm-core/pull/14041))**
113 Improves the UFField API by exposing the option list for the field
114 `fieldname`, before this change it was displayed as a text field instead of a
117 - **CQ: Switch core forms to be Entity Forms (continues
118 [dev/core#818](https://lab.civicrm.org/dev/core/issues/818):
119 [13887](https://github.com/civicrm/civicrm-core/pull/13887)))**
121 The group settings form now relies upon a standard entity form for the most
122 part, with most fields defined by metadata. This removes boilerplate code
123 from the specific form function, standardizing the form and facilitating later
124 form improvements that can be made across the board.
128 - **CQ: Refactor Recurring Contribution Forms (continues
129 [dev/core#846](https://lab.civicrm.org/dev/core/issues/846):
130 [13994](https://github.com/civicrm/civicrm-core/pull/13994) and
131 [13993](https://github.com/civicrm/civicrm-core/pull/13993)))**
133 This begins the process of converting recurring contribution forms to use
134 entity forms. It standardizes the way in which the payment processor is
135 loaded in the 3 forms that update subscriptions.
137 - **Call Payment.create from payment.cancel
138 ([13689](https://github.com/civicrm/civicrm-core/pull/13689))**
140 This change improves the Payment.create API by adding handling for negative
141 amounts and moves the Payment.cancel API to use the Payment.create API instead
142 of a bespoke function.
144 - **Switch to using ContributionRecur.cancel API from CancelSubscription form
145 ([14033](https://github.com/civicrm/civicrm-core/pull/14033))**
147 This change makes it so the CancelSubscription Form uses the
148 ContributionRecur.cancel API instead of a bespoke function.
150 - **Update MasterCard icon to match branding guidelines
151 ([14078](https://github.com/civicrm/civicrm-core/pull/14078))**
153 Updates the MasterCard icon to match the MasterCard branding guidelines:
154 https://brand.mastercard.com/brandcenter/mastercard-brand-mark/downloads.html
158 - **Event Cart: add support for the Credit Card type icons
159 ([14175](https://github.com/civicrm/civicrm-core/pull/14175))**
161 Adds support for the Credit Card type icons (Amex, visa etc.) to Event Cart
164 ### Drupal Integration
166 - **Drupal Views : relationships for standard groups
167 ([CRM-20006](https://issues.civicrm.org/jira/browse/CRM-20006):
168 [507](https://github.com/civicrm/civicrm-drupal/pull/507))**
170 Adds relationships for standard groups to the CiviCRM/Drupal Views
173 - **Enable contribution views to filter on empty Receipt and Thank You dates
174 ([573](https://github.com/civicrm/civicrm-drupal/pull/573))**
176 Adds a view filter on "Thank You date" and "Receipt Date" for empty/not empty
177 which can be used to create a view showing contributions that
178 have/have not been thanked.
180 ## <a name="bugs"></a>Bugs resolved
184 - **Email processor filing all emails as .unknown attachments
185 ([dev/core#940](https://lab.civicrm.org/dev/core/issues/940):
186 [14208](https://github.com/civicrm/civicrm-core/pull/14208))**
188 Fixes a regression where emails being sent to the email-to-activity mailbox
189 were being saved with a `.unknown` extension and no content.
191 - **.ics files should be whitelisted as file types for upload
192 ([dev/core#974](https://lab.civicrm.org/dev/core/issues/974):
193 [14531](https://github.com/civicrm/civicrm-core/pull/14351))**
195 - **Regression - faster activity tab in 5.13 won't sort by source_name now
196 ([dev/core#934](https://lab.civicrm.org/dev/core/issues/934):
197 [14194](https://github.com/civicrm/civicrm-core/pull/14194) and
198 [14204](https://github.com/civicrm/civicrm-core/pull/14204))**
200 - **Search displaying Related Contacts produces fatal error
201 ([dev/core#1002](https://lab.civicrm.org/dev/core/issues/1002):
202 [14409](https://github.com/civicrm/civicrm-core/pull/14409))**
204 - **Error randomly appearing when Financial type ACL is enabled
205 ([dev/core#918](https://lab.civicrm.org/dev/core/issues/918):
206 [14165](https://github.com/civicrm/civicrm-core/pull/14165) and
207 [14168](https://github.com/civicrm/civicrm-core/pull/14168))**
209 Fixes an undefined index error `Undefined index: status in
210 CRM_Utils_Check_Component_FinancialTypeAcls::checkFinancialAclReport()` when a
211 site has a Financial Type ACL enabled.
213 - **utf8mb4 warning keeps coming back up
214 ([dev/core#880](https://lab.civicrm.org/dev/core/issues/880):
215 [14123](https://github.com/civicrm/civicrm-core/pull/14123))**
217 This change makes it so users only receive the Mysql utf8mb4 status check
218 once, before this change the status check would show up whenever apache was
221 - **Fix import primary phone, primary email, add tests
222 ([14043](https://github.com/civicrm/civicrm-core/pull/14043))**
224 Fixes a bug where importing a phone (or email) & choosing 'Primary' as the
225 location type resulted in the creation of a duplicate, sometimes with no
228 - **Fix upgrade message db setting location
229 ([14083](https://github.com/civicrm/civicrm-core/pull/14083))**
231 Updates the upgrade message "This database uses InnoDB Full Text Search for
232 optimized searching. The upgrade procedure has not been tested with this
233 feature. You should disable (and later re-enable) the feature by navigating
234 to..." to point to the right settings form "Administer => Customize Data and
235 Screens => Search Preferences" instead of "Administer => System Settings =>
238 - **fix getAddressColumns() to respect tableAlias
239 ([14014](https://github.com/civicrm/civicrm-core/pull/14014))**
241 Fixes `CRM_Report_Form::getAddressColumns()` function so that it no longer
242 returns an error when used twice.
244 - **Ensure edit tooltip is always initially hidden in contact summary block
245 ([14065](https://github.com/civicrm/civicrm-core/pull/14065))**
247 Ensures when a user does not have permission to edit a contact summary block,
248 the little "Edit" tooltip is hidden.
250 - **Skip adding core resources when building assets
251 ([14010](https://github.com/civicrm/civicrm-core/pull/14010))**
253 - **Advanced Search - Mailing column headers out of alignment
254 ([dev/core#248](https://lab.civicrm.org/dev/core/issues/248):
255 [14134](https://github.com/civicrm/civicrm-core/pull/14134))**
257 - **Validate queue_id is a positive integer before passing to the BAO
258 ([14355](https://github.com/civicrm/civicrm-core/pull/14355))**
262 - **Case activity query performs poorly on large databases
263 ([dev/core#832](https://lab.civicrm.org/dev/core/issues/832):
264 [14086](https://github.com/civicrm/civicrm-core/pull/14086) and
265 [14139](https://github.com/civicrm/civicrm-core/pull/14139))**
267 This change enhances performance of CiviCase by streamlining the Case Activity
268 Query which was crashing the server for some sites with large databases by
269 producing too many temporary files.
271 - **Make `hook_civicrm_pre()` and `hook_civicrm_post()` fire on CaseContacts
272 ([14030](https://github.com/civicrm/civicrm-core/pull/14030))**
276 - **Always bootstrap CRM_Utils_System on legacy IPN endpoint
277 ([dev/drupal#66](https://lab.civicrm.org/dev/drupal/issues/66),
278 [dev/core#973](https://lab.civicrm.org/dev/core/issues/973), and
279 [dev/core#1017](https://lab.civicrm.org/dev/core/issues/1017):
280 [14406](https://github.com/civicrm/civicrm-core/pull/14406) and
281 [14430](https://github.com/civicrm/civicrm-core/pull/14430))**
283 This fixes a recent regression where recurring payments would fail to be
284 recorded in CiviCRM if the contribution was set to notify the legacy IPN URL.
286 - **Create contribution before taking payment, per contribution page workflow
287 ([13837](https://github.com/civicrm/civicrm-core/pull/13837))**
289 Makes it so the Contribution is created before the payment processor is
290 called, so there is always a contribution record even if payment fails.
294 - **Event Cart: pass the contactID to fix payment on Stripe
295 ([14173](https://github.com/civicrm/civicrm-core/pull/14173))**
297 Fixes a bug where a user could not complete an Event Registration using Event
298 Cart and the Stripe payment processor.
300 - **Event Cart: fix sending of email receipts
301 ([14170](https://github.com/civicrm/civicrm-core/pull/14170))**
303 Fixes fatal error being thrown when an email receipt was sent from an Event
306 - **Event Cart: honor the allow_same_participant_emails setting
307 ([14174](https://github.com/civicrm/civicrm-core/pull/14174))**
309 Ensures the Event Cart Checkout process honors the "allow participants with
310 the same email address".
312 - **Event Cart: fix start_date formatting in line items during checkout
313 ([14169](https://github.com/civicrm/civicrm-core/pull/14169))**
315 Ensures start dates are formatted according to the site's localization
316 preference during the Event Cart checkout process.
318 - **CRM-18570 When creating a new event using a template the new event screen is
319 taking the default values directly from the custom fields, and not from what's
320 saved in the event template.
321 ([dev/core#553](https://lab.civicrm.org/dev/core/issues/553):
322 [14063](https://github.com/civicrm/civicrm-core/pull/14063))**
326 - **Fixed double protocol being added in link by CKEditor.
327 ([14128](https://github.com/civicrm/civicrm-core/pull/14128))**
329 Fixes a bug where adding action tokens using the CKEditor link interface, and
330 then editing them could cause double protocols (ex: http://https:// or
333 - **Fix ts() usage in CRM_SMS_Form_Schedule
334 ([14111](https://github.com/civicrm/civicrm-core/pull/14111))**
336 Allows translation of the "Send Mass SMS" form.
340 - **Batch update membership type
341 ([dev/core#338](https://lab.civicrm.org/dev/core/issues/338):
342 [14064](https://github.com/civicrm/civicrm-core/pull/14064))**
344 Fixes a regression when batch updating membership types and copying values
347 - **Membership status processor ignoring records where is_override=0
348 ([dev/core#881](https://lab.civicrm.org/dev/core/issues/881):
349 [14059](https://github.com/civicrm/civicrm-core/pull/14059) and
350 [14073](https://github.com/civicrm/civicrm-core/pull/14073))**
352 - **Back-office membership renewals don't display an on-screen notification
353 ([dev/membership#9](https://lab.civicrm.org/dev/membership/issues/9):
354 [14088](https://github.com/civicrm/civicrm-core/pull/14088))**
356 - **Fix test / possible live error on submitting credit card renewals
357 ([14412](https://github.com/civicrm/civicrm-core/pull/14412))**
359 This resolves intermittent errors in unit tests when renewing memberships due
360 to the `receive_date` not being set.
362 - **Fixed auto populate of contact reference field on membership signup form
363 ([14077](https://github.com/civicrm/civicrm-core/pull/14077))**
365 ### Drupal Integration
367 - **Civi 5.12.1 renders Quicksearch unreadable on Drupal 8
368 ([dev/drupal#56](https://lab.civicrm.org/dev/drupal/issues/56):
369 [14080](https://github.com/civicrm/civicrm-core/pull/14080))**
371 Fixes a regression where the text in the Quicksearch box was too light to read
372 so that it is darker and easier to read.
374 - **Don't render an empty mailto link for empty email addresses
375 ([540](https://github.com/civicrm/civicrm-drupal/pull/540))**
377 Fixes a bug in Views where an "email address" field set to output as a
378 `mailto:` link would still make a link if no email exists.
380 - **Column next_sched_contribution should be next_sched_contribution_date for
382 ([dev/drupal#48](https://lab.civicrm.org/dev/drupal/issues/48):
383 [578](https://github.com/civicrm/civicrm-drupal/pull/578))**
385 ### Joomla Integration
387 - **Fix bug preventing affecting `cv --user` on Joomla
388 ([13890](https://github.com/civicrm/civicrm-core/pull/13890))**
390 ## <a name="misc"></a>Miscellany
392 - **Bump php version to match core requirements
393 ([567](https://github.com/civicrm/civicrm-drupal/pull/567))**
395 - **CiviUnitTestCase - Extract traits to facilitate extension testing
396 (preliminary work for
397 [dev/core#873](https://lab.civicrm.org/dev/core/issues/873):
398 [14044](https://github.com/civicrm/civicrm-core/pull/14044))**
400 - **Refactor dedupe merger (preliminary work for
401 [dev/core#723](https://lab.civicrm.org/dev/core/issues/723):
402 [14144](https://github.com/civicrm/civicrm-core/pull/14144) and
403 [14146](https://github.com/civicrm/civicrm-core/pull/14146))**
405 - **Replace all instances of CRM_Core_Fatal with throw new CRM_Core_Exception
406 (continues [dev/core#560](https://lab.civicrm.org/dev/core/issues/560):
407 [14143](https://github.com/civicrm/civicrm-core/pull/14143))**
409 - **[REF] Add unit tests on contribution recur trxn_id, contribution recur
410 processor id (preparation for
411 [dev/core#830](https://lab.civicrm.org/dev/core/issues/830):
412 [14119](https://github.com/civicrm/civicrm-core/pull/14119))**
414 - **Remove instances of $dao->free (continues
415 [dev/core#562](https://lab.civicrm.org/dev/core/issues/562):
416 [14070](https://github.com/civicrm/civicrm-core/pull/14070),
417 [14071](https://github.com/civicrm/civicrm-core/pull/14071) and
418 [14037](https://github.com/civicrm/civicrm-core/pull/14037))**
420 - **(NFC) Add tests of retreiving notes for display on a contact record a…
421 ([14094](https://github.com/civicrm/civicrm-core/pull/14094))**
423 - **(NFC) Update CRM/Contact to match new coder style
424 ([14022](https://github.com/civicrm/civicrm-core/pull/14022))**
426 - **(NFC) Minor code style fixes
427 ([14015](https://github.com/civicrm/civicrm-core/pull/14015))**
429 - **(NFC) Add in unit test checking that E2E test returns sensible contac…
430 ([14076](https://github.com/civicrm/civicrm-core/pull/14076))**
432 - **NFC Whitespace formatting for formButtons.tpl
433 ([14107](https://github.com/civicrm/civicrm-core/pull/14107))**
435 - **(NFC) Expand unit test to show off double protocol error
436 ([14141](https://github.com/civicrm/civicrm-core/pull/14141))**
438 - **[REF] move gathering of location info to relevant function (towards
439 dev/core#723) ([14142](https://github.com/civicrm/civicrm-core/pull/14142))**
441 - **[REF] Move the qfbug handling to it's own function (towards dev/core#723)
442 ([14140](https://github.com/civicrm/civicrm-core/pull/14140))**
444 - **[REF] Use events for CMS resource loading
445 ([14131](https://github.com/civicrm/civicrm-core/pull/14131))**
447 - **[REF] extract getConflicts function
448 ([14148](https://github.com/civicrm/civicrm-core/pull/14148))**
450 - **[REF] Extract get cfields function
451 ([14151](https://github.com/civicrm/civicrm-core/pull/14151))**
453 - **[REF] Use variable for menubar height
454 ([14122](https://github.com/civicrm/civicrm-core/pull/14122))**
456 - **[REF] Clean up CRM_Contribute_Form_SearchTest
457 ([14068](https://github.com/civicrm/civicrm-core/pull/14068))**
459 - **[REF] Extract formatLocationBlock from import parsing
460 ([14040](https://github.com/civicrm/civicrm-core/pull/14040))**
462 - **[REF] function extraction in dedupe code
463 ([14157](https://github.com/civicrm/civicrm-core/pull/14157))**
465 - **[REF] cleanup input parameters on extracted function
466 ([14050](https://github.com/civicrm/civicrm-core/pull/14050))**
468 - **(REF) Fix accepted params in CustomValueTable::setValues
469 ([14079](https://github.com/civicrm/civicrm-core/pull/14079))**
471 - **(REF) Fix unnecessary required param in contact BAO update
472 ([14075](https://github.com/civicrm/civicrm-core/pull/14075))**
474 - **(REF) Reduce redundant code in CRM_Utils_Type::validate
475 ([14011](https://github.com/civicrm/civicrm-core/pull/14011))**
477 - **REF Replace hardcoded IDs with pseudoconstants in activity form
478 ([14108](https://github.com/civicrm/civicrm-core/pull/14108))**
480 - **(REF) Standardize UFField create function
481 ([14084](https://github.com/civicrm/civicrm-core/pull/14084))**
483 - **[REF] calll formatLocationBlock from parent function.
484 ([14105](https://github.com/civicrm/civicrm-core/pull/14105))**
486 - **(REF; dev/core#873) MailingAB - Migrate "copy winner" logic from JS to PHP
487 ([14045](https://github.com/civicrm/civicrm-core/pull/14045))**
489 - **REF Don't pass activity object to addCaseActivityLinks
490 ([14110](https://github.com/civicrm/civicrm-core/pull/14110))**
492 - **REF Use shared function to check inbound email permissions
493 ([14109](https://github.com/civicrm/civicrm-core/pull/14109))**
495 - **[REF] Follow up tidy up on import fixes
496 ([14117](https://github.com/civicrm/civicrm-core/pull/14117))**
498 - **Readability cleanup on EventIncome report (towards bringing it under
499 testing) ([13963](https://github.com/civicrm/civicrm-core/pull/13963))**
501 - **Remove deprecated function
502 ([14039](https://github.com/civicrm/civicrm-core/pull/14039))**
504 - **Revert "dev/core#553: Creating new event takes value from default value not
505 from saved template for custom fields"
506 ([14121](https://github.com/civicrm/civicrm-core/pull/14121))**
508 - **Update docblock for doPayment function
509 ([13844](https://github.com/civicrm/civicrm-core/pull/13844))**
511 - **[cleanup] remove CRM_Report_Form_Extended
512 ([14149](https://github.com/civicrm/civicrm-core/pull/14149))**
514 ## <a name="credits"></a>Credits
516 This release was developed by the following code authors:
518 AGH Strategies - Alice Frumin, Andrew Hunt; Agileware - Alok Patel; Australian
519 Greens - Seamus Lee; Christian Wach; CiviCRM - Coleman Watts, Tim Otten;
520 CiviDesk - Yashodha Chaku; Coop SymbioTIC - Mathieu Lutfy; Dave D; Electronic
521 Frontier Foundation - Mark Burdett; Freeform Solutions - Herb van den Dool;
522 Fuzion - Luke Stewart; Guillaume Rischard; JMA Consulting - Monish Deb; John
523 Kingsnorth; Korlon - Stuart Gaston; Lighthouse Design and Consulting - Brian
524 Shaughnessy; Megaphone Technology Consulting - Jon Goldberg; MJW Consulting -
525 Matthew Wire; Pradeep Nayak; Squiffle Consulting - Aidan Saunders; Tadpole
526 Collective - Kevin Cristiano; Wikimedia Foundation - Eileen McNaughton
528 Most authors also reviewed code for this release; in addition, the following
529 reviewers contributed their comments:
531 AGH Strategies - Tommy Bobo; DevApp - Adam Kwiatkowski; Fuzion - Jitendra
532 Purohit; JMA Consulting - Joe Murray; Nicol Wistreich; Palante - Morgan
533 Robinson; Skvare - Mark Hanna; Tapash Datta;
535 ## <a name="feedback"></a>Feedback
537 These release notes are edited by Alice Frumin and Andrew Hunt. If you'd like
538 to provide feedback on them, please log in to https://chat.civicrm.org/civicrm