release-notes/4.7.23.md

   1 # CiviCRM 4.7.23
   2
   3 Released August 2, 2017
   4
   5 - **[Features](#features)**
   6 - **[Bugs resolved](#bugs)**
   7 - **[Miscellany](#misc)**
   8 - **[Credits](#credits)**
   9
  10 | Does this version                                               |         |
  11 |:--------------------------------------------------------------- |:-------:|
  12 | fix security vulnerabilities?                                   | no      |
  13 | **change the database schema?**                                 | **yes** |
  14 | **alter the API?**                                              | **yes** |
  15 | **require attention to configuration options?**                 | **yes** |
  16 | **fix problems installing or upgrading to a previous version?** | **yes** |
  17 | **introduce features?**                                         | **yes** |
  18 | **fix bugs?**                                                   | **yes** |
  19
  20 ## <a name="features"></a>Features
  21
  22 ### Core CiviCRM
  23
  24 - **[CRM-20830](https://issues.civicrm.org/jira/browse/CRM-20830) Improve
  25   handling of overdue activities
  26   ([10618](https://github.com/civicrm/civicrm-core/pull/10618))**
  27
  28   Activity statuses can now be edited to denote whether activities with a given
  29   status should be considered "complete" or not.  This attribute is now the
  30   basis for determining whether an activity is overdue.  In addition to UI
  31   indications of being overdue, the API can return this value for each activity.
  32
  33 - **[CRM-20803](https://issues.civicrm.org/jira/browse/CRM-20803) Enable Farsi
  34   (fa_IR), Serbian (sr_RS), Ukrainian (uk_UA) in the languages option group so
  35   that we can install in those languages
  36   ([10667](https://github.com/civicrm/civicrm-core/pull/10667))**
  37
  38   These languages can now be used for installation of CiviCRM.
  39
  40 - **[CRM-20759](https://issues.civicrm.org/jira/browse/CRM-20759) Import, add
  41   'Primary' as an address location
  42   ([10738](https://github.com/civicrm/civicrm-core/pull/10738),
  43   [10565](https://github.com/civicrm/civicrm-core/pull/10565),
  44   [10594](https://github.com/civicrm/civicrm-core/pull/10594),
  45   [10554](https://github.com/civicrm/civicrm-core/pull/10554), and
  46   [10547](https://github.com/civicrm/civicrm-core/pull/10547))**
  47
  48   Columns in imports can now import to fields in the matching contact's primary
  49   address, regardless of location type.
  50
  51 - **[CRM-20793](https://issues.civicrm.org/jira/browse/CRM-20793) Add filter -
  52   activity date and status on search criteria of activity listing
  53   ([10588](https://github.com/civicrm/civicrm-core/pull/10588))**
  54
  55   The activity tab on a contact record now allows filtering by date and status
  56   besides just activity type.  In addition, a site-wide option toggles whether a
  57   user's filters on one contact's activities persist as they visit other
  58   contacts.
  59
  60 - **[CRM-20847](https://issues.civicrm.org/jira/browse/CRM-20847) Support custom
  61   api with composite primary keys
  62   ([10599](https://github.com/civicrm/civicrm-core/pull/10599))**
  63
  64   This change adds testing for custom APIs using the basic get function and
  65   avoids automatically selecting the `id` field if there is no such field in the
  66   spec.
  67
  68 - **[CRM-20842](https://issues.civicrm.org/jira/browse/CRM-20842) Change api
  69   explorer page title
  70   ([10633](https://github.com/civicrm/civicrm-core/pull/10633))**
  71
  72   The API Explorer now explicitly states it is demonstrating API v3.
  73
  74 - **[CRM-20780](https://issues.civicrm.org/jira/browse/CRM-20780) Add settings
  75   file option to define CMS_ROOT
  76   ([10574](https://github.com/civicrm/civicrm-core/pull/10574))**
  77
  78   The CiviCRM settings file can now explicitly set the path to the CMS root.
  79
  80 - **[CRM-20169](https://issues.civicrm.org/jira/browse/CRM-20169) Add support
  81   for alterReportVar hook in Activity Report
  82   ([9886](https://github.com/civicrm/civicrm-core/pull/9886))**
  83
  84   Extensions can now modify the SQL of the Activity Report.
  85
  86 - **[CRM-20721](https://issues.civicrm.org/jira/browse/CRM-20721) Add parameter
  87   to dateQueryBuilder fn to change date value to desired format
  88   ([10497](https://github.com/civicrm/civicrm-core/pull/10497))**
  89
  90   Queries on fields formatted in ways other than the typical MySQL date format
  91   can now use the standard date query builder method in the contact BAO.
  92
  93 - **[CRM-20600](https://issues.civicrm.org/jira/browse/CRM-20600) Expose
  94   AngularJS screens to hooks
  95   ([10644](https://github.com/civicrm/civicrm-core/pull/10644)) (follow-up
  96   work)**
  97
  98   A message now displays both before and after upgrade if a site's configuration
  99   is likely to prevent successful asset-caching.
 100
 101 - **[CRM-20673](https://issues.civicrm.org/jira/browse/CRM-20673) Tag and group
 102   edit form: implement Select2 for tags
 103   ([10634](https://github.com/civicrm/civicrm-core/pull/10634)) (completes
 104   previous work)**
 105
 106   Tags are now listed in the widget in the same order as they are displayed for
 107   management.
 108
 109 - **[CRM-20622](https://issues.civicrm.org/jira/browse/CRM-20622) contact edit:
 110   tags and groups panel layout/styling
 111   ([10429](https://github.com/civicrm/civicrm-core/pull/10429))**
 112
 113   The tag and group editing interface now uses standard markup rather than
 114   unique, outdated approaches.
 115
 116 ### CiviCase
 117
 118 - **[CRM-19778](https://issues.civicrm.org/jira/browse/CRM-19778) Allowed
 119   statuses per case-type
 120   ([10552](https://github.com/civicrm/civicrm-core/pull/10552))**
 121
 122   The available options in the API for case status can now be filtered to those
 123   appropriate for a given case type.
 124
 125 - **[CRM-20794](https://issues.civicrm.org/jira/browse/CRM-20794) Colors for
 126   case status ([10586](https://github.com/civicrm/civicrm-core/pull/10586))
 127   (preliminary work)**
 128
 129   When editing case statuses, you may now select a color.  However, case display
 130   does not yet show the status colors.
 131
 132 - **[CRM-20756](https://issues.civicrm.org/jira/browse/CRM-20756) Multi tab
 133   structure ([10545](https://github.com/civicrm/civicrm-core/pull/10545))
 134   (preliminary work)**
 135
 136   The AngularJS `ui.bootstrap` library is now included in CiviCRM.
 137
 138 - **[CRM-20816](https://issues.civicrm.org/jira/browse/CRM-20816) Case
 139   multi/single client settings
 140   ([10609](https://github.com/civicrm/civicrm-core/pull/10609))**
 141
 142   Settings for redacting activity emails, allowing multiple clients per case,
 143   and the sort order of activity types can now be modified in an administrative
 144   form rather than exclusively in XML files defining case types.
 145
 146 ### CiviContribute
 147
 148 - **[CRM-20778](https://issues.civicrm.org/jira/browse/CRM-20778) Use
 149   civicontribute permission for contribution recur.cancel
 150   ([10569](https://github.com/civicrm/civicrm-core/pull/10569))**
 151
 152   The permissions to view, modify, cancel, and delete recurring contributions
 153   now mirror the corresponding permissions needed for working with payments.
 154
 155 - **[CRM-20682](https://issues.civicrm.org/jira/browse/CRM-20682) Include human
 156   readable contribution's custom field label in token widget for Thankyou letter
 157   ([10467](https://github.com/civicrm/civicrm-core/pull/10467))**
 158
 159   Contribution custom field tokens are now listed among the available tokens in
 160   the Thank-you Letter form.  They had been processed, but there was no
 161   indication that they were available.
 162
 163 - **[CRM-20860](https://issues.civicrm.org/jira/browse/CRM-20860) Add in
 164   password type field availability and apply to payment processor fields
 165   ([10649](https://github.com/civicrm/civicrm-core/pull/10649))**
 166
 167   Field metadata can now specify the HTML field type of `Password` which adds a
 168   `HTML_QuickForm_password` field element.  This is implemented on payment
 169   processor settings fields.
 170
 171 ### CiviMember
 172
 173 - **[CRM-20901](https://issues.civicrm.org/jira/browse/CRM-20901) Add submit
 174   credit card membership link on membership form
 175   ([10689](https://github.com/civicrm/civicrm-core/pull/10689))**
 176
 177   The backend add membership form now has a link to the backend credit card
 178   membership form.
 179
 180 ### Backdrop Integration
 181
 182 - **Port of civicrm_engage to Backdrop
 183   ([28](https://github.com/civicrm/civicrm-backdrop/pull/28))**
 184
 185 ### Drupal Integration
 186
 187 - **[CRM-20751](https://issues.civicrm.org/jira/browse/CRM-20751) Support Drupal
 188   aliases for event links in Views
 189   ([456](https://github.com/civicrm/civicrm-drupal/pull/456) and
 190   [455](https://github.com/civicrm/civicrm-drupal/pull/455))**
 191
 192   If a CiviCRM event has a Drupal alias set for it, views linking to the event
 193   will now link to the alias rather than the CiviCRM URL.
 194
 195 ## <a name="bugs"></a>Bugs resolved
 196
 197 ### Core CiviCRM
 198
 199 - **[CRM-20873](https://issues.civicrm.org/jira/browse/CRM-20873) CIVICRM-118 DB
 200   Error: no such field / Unknown column 'civicrm_custom_group.is_public' breaks
 201   CiviCRM database update process
 202   ([10662](https://github.com/civicrm/civicrm-core/pull/10662))**
 203
 204   This fixes a bug in upgrading from 4.7.18 or earlier to 4.7.19 or later.  Code
 205   used by the upgrade to load the available custom data for an entity relies
 206   upon a field that is not made available until after the upgrade.
 207
 208 - **[CRM-20849](https://issues.civicrm.org/jira/browse/CRM-20849) Multiple
 209   extensions using the same autoloader prefix will overwrite previous
 210   ([10637](https://github.com/civicrm/civicrm-core/pull/10637))**
 211
 212 - **[CRM-20739](https://issues.civicrm.org/jira/browse/CRM-20739) contact import
 213   doesn't add to group on fill if matching without ID
 214   ([10507](https://github.com/civicrm/civicrm-core/pull/10507))**
 215
 216 - **[CRM-20666](https://issues.civicrm.org/jira/browse/CRM-20666) enable
 217   uploading of files to activities that are up to 255 characters in length
 218   ([10449](https://github.com/civicrm/civicrm-core/pull/10449))**
 219
 220   File names of activity uploads had previously been capped at 60 characters.
 221
 222 - **[CRM-20776](https://issues.civicrm.org/jira/browse/CRM-20776) Menu structure
 223   ([10573](https://github.com/civicrm/civicrm-core/pull/10573))**
 224
 225   This fixes incorrect handling of URL paths, queries and fragments in the
 226   navigation menu.  This was a particular problem for AngularJS pages.
 227
 228 - **[CRM-20640](https://issues.civicrm.org/jira/browse/CRM-20640) contribution
 229   summary report: duplicates values with group filter
 230   ([10603](https://github.com/civicrm/civicrm-core/pull/10603) and
 231   [10596](https://github.com/civicrm/civicrm-core/pull/10596))**
 232
 233   Reports with group filters would display rows twice if multiple groups were
 234   selected in the filter and contacts were in more than one of those groups.
 235
 236 - **[CRM-20953](https://issues.civicrm.org/jira/browse/CRM-20953) Importing
 237   contacts with deceased_date not setting is_deceased
 238   ([10742](https://github.com/civicrm/civicrm-core/pull/10742))**
 239
 240 - **[CRM-20871](https://issues.civicrm.org/jira/browse/CRM-20871) crmUiSelect
 241   fails to update when model changes
 242   ([10659](https://github.com/civicrm/civicrm-core/pull/10659))**
 243
 244 - **[CRM-20809](https://issues.civicrm.org/jira/browse/CRM-20809) Move
 245   extensions cache from $extensionsDir to $uploadDir
 246   ([10604](https://github.com/civicrm/civicrm-core/pull/10604))**
 247
 248   Cached data about extensions was stored in the extensions directory, which may
 249   not be an appropriate place and may not be writable.  It is now stored in the
 250   upload directory.
 251
 252 - **[CRM-20828](https://issues.civicrm.org/jira/browse/CRM-20828) Saved field
 253   mappings drop down is limited to 1
 254   ([10615](https://github.com/civicrm/civicrm-core/pull/10615))**
 255
 256 - **[CRM-20509](https://issues.civicrm.org/jira/browse/CRM-20509) Checking
 257   Contribution Note field in reports results in no rows
 258   ([10631](https://github.com/civicrm/civicrm-core/pull/10631))**
 259
 260   When displaying note fields in reports, the query would limit the results to
 261   rows that had notes.
 262
 263 - **[CRM-20351](https://issues.civicrm.org/jira/browse/CRM-20351)
 264   hook_civicrm_buildForm invoked twice on a bunch of forms
 265   ([10068](https://github.com/civicrm/civicrm-core/pull/10068))**
 266
 267 - **[CRM-20774](https://issues.civicrm.org/jira/browse/CRM-20774) Add check for
 268   existing index keys(different values) while creating missing indices.
 269   ([10572](https://github.com/civicrm/civicrm-core/pull/10572) and
 270   [10566](https://github.com/civicrm/civicrm-core/pull/10566))**
 271
 272   The check and resolution for missing indexes would previously be unaware of
 273   variations in the keys for equivalent indexes.
 274
 275 - **[CRM-20722](https://issues.civicrm.org/jira/browse/CRM-20722) 'Lock wait
 276   timeout exceeded' error triggered on smart group cache rebuild
 277   ([10498](https://github.com/civicrm/civicrm-core/pull/10498))**
 278
 279   This avoids an error when rebuilding the smart group cache on sites that have
 280   a very large number of smart groups.
 281
 282 - **[CRM-20443](https://issues.civicrm.org/jira/browse/CRM-20443) SQL syntax
 283   error creating logging triggers if column name is reserved word
 284   ([10530](https://github.com/civicrm/civicrm-core/pull/10530))**
 285
 286 - **[CRM-20950](https://issues.civicrm.org/jira/browse/CRM-20950) Contact import
 287   mapping to wrong location type (unreleased regression)
 288   ([10736](https://github.com/civicrm/civicrm-core/pull/10736) and
 289   [10735](https://github.com/civicrm/civicrm-core/pull/10735))**
 290
 291 - **[CRM-20754](https://issues.civicrm.org/jira/browse/CRM-20754) memory leak in
 292   CLI CSV import ([10537](https://github.com/civicrm/civicrm-core/pull/10537))**
 293
 294   This resolves a problem of accumulating too much data in the
 295   `PEAR_DB_DATAOBJECT` cache on large imports.
 296
 297 - **[CRM-19702](https://issues.civicrm.org/jira/browse/CRM-19702) Fatal error
 298   when merging contact records with custom file fields
 299   ([9784](https://github.com/civicrm/civicrm-core/pull/9784))**
 300
 301 - **[CRM-19653](https://issues.civicrm.org/jira/browse/CRM-19653) Custom field
 302   checkboxes migrated incorrectly on merge (part deux)
 303   ([10407](https://github.com/civicrm/civicrm-core/pull/10407))**
 304
 305 - **[CRM-19821](https://issues.civicrm.org/jira/browse/CRM-19821) Remove
 306   performance degrading joins from activity search (& api calls)
 307   ([10274](https://github.com/civicrm/civicrm-core/pull/10274))**
 308
 309 - **[CRM-20743](https://issues.civicrm.org/jira/browse/CRM-20743) users without
 310   reserved tag permission may still modify the tag
 311   ([10522](https://github.com/civicrm/civicrm-core/pull/10522))**
 312
 313   While users lacking the "Administer reserved tags" permission were barred from
 314   deleting or moving reserved tags, this prevents them from editing the tag name
 315   and description.
 316
 317 - **[CRM-20621](https://issues.civicrm.org/jira/browse/CRM-20621) manage tags:
 318   the tag usage count is not accurate
 319   ([10441](https://github.com/civicrm/civicrm-core/pull/10441))**
 320
 321 ### CiviCase
 322
 323 - **[CRM-20802](https://issues.civicrm.org/jira/browse/CRM-20802)
 324   CaseType.create - Stale definition retained in memory
 325   ([10591](https://github.com/civicrm/civicrm-core/pull/10591))**
 326
 327   Cached case type information was retained even after modifying the case type.
 328
 329 ### CiviContribute
 330
 331 - **[CRM-20765](https://issues.civicrm.org/jira/browse/CRM-20765) Missing id for
 332   'onBehalfOfOrg' section
 333   ([10550](https://github.com/civicrm/civicrm-core/pull/10550))**
 334
 335   The `<div>` containing on-behalf section on contribution pages lacks the
 336   `onBehalfOfOrg` ID attribute that it had in 4.6.
 337
 338 - **[CRM-20753](https://issues.civicrm.org/jira/browse/CRM-20753) Net amount
 339   doesn't respect localization
 340   ([10536](https://github.com/civicrm/civicrm-core/pull/10536))**
 341
 342 - **[CRM-20891](https://issues.civicrm.org/jira/browse/CRM-20891) Pay later
 343   option incorrectly shows as completed when combining membership and donation
 344   ([10683](https://github.com/civicrm/civicrm-core/pull/10683))**
 345
 346   Using a contribution page with "separate membership payment" set, a pay-later
 347   contribution would incorrectly mark the membership contribution completed.
 348
 349 - **[CRM-20848](https://issues.civicrm.org/jira/browse/CRM-20848) Upgrade to
 350   4.7.19 sets price_field to inactive if default Financial Types are disabled
 351   ([10675](https://github.com/civicrm/civicrm-core/pull/10675))**
 352
 353 - **[CRM-20857](https://issues.civicrm.org/jira/browse/CRM-20857) Deferred
 354   Revenue report -  DB Error: unknown error
 355   ([10646](https://github.com/civicrm/civicrm-core/pull/10646))**
 356
 357   The Deferred Revenue report would have an error on if a database server's
 358   `sql_mode` was set to `only_full_group_by`.
 359
 360 - **[CRM-20867](https://issues.civicrm.org/jira/browse/CRM-20867) Class not
 361   found ([10656](https://github.com/civicrm/civicrm-core/pull/10656))**
 362
 363   This fixes a fatal error in the additional payment form due to a typo in the
 364   name of the `CRM_Contribute_BAO_Contribution` class.
 365
 366 - **[CRM-20649](https://issues.civicrm.org/jira/browse/CRM-20649) Notice error
 367   when creating Price set
 368   ([10431](https://github.com/civicrm/civicrm-core/pull/10431))**
 369
 370   Validation of a price set name would generate a PHP notice if the name was
 371   blank.
 372
 373 - **[CRM-20823](https://issues.civicrm.org/jira/browse/CRM-20823) Price Set
 374   field with an Expiry Date still being 'required' after being expired.
 375   ([10613](https://github.com/civicrm/civicrm-core/pull/10613))**
 376
 377 - **[CRM-20752](https://issues.civicrm.org/jira/browse/CRM-20752) Editing a
 378   Cancelled Pledge updates the status of it to Pending/Inprogress
 379   ([10535](https://github.com/civicrm/civicrm-core/pull/10535))**
 380
 381 - **[CRM-20812](https://issues.civicrm.org/jira/browse/CRM-20812) Notice on live
 382   contribution when only pay later is selected
 383   ([10606](https://github.com/civicrm/civicrm-core/pull/10606))**
 384
 385 - **[CRM-20761](https://issues.civicrm.org/jira/browse/CRM-20761) Formrule error
 386   when priceset is selected on contribution page
 387   ([10549](https://github.com/civicrm/civicrm-core/pull/10549))**
 388
 389   When enabling a contribution amounts section and selecting a price set on a
 390   contribution page's settings form, validation would fail, looking for a
 391   contribution amount label.
 392
 393 - **[CRM-20401](https://issues.civicrm.org/jira/browse/CRM-20401) Cancel/modify
 394   URL receipt links not correct for Paypal Website Payments Pro
 395   ([10424](https://github.com/civicrm/civicrm-core/pull/10424))**
 396
 397 - **[CRM-20745](https://issues.civicrm.org/jira/browse/CRM-20745) Post date of
 398   recur not respected in credit card pledge payment
 399   ([10524](https://github.com/civicrm/civicrm-core/pull/10524))**
 400
 401 - **[CRM-20773](https://issues.civicrm.org/jira/browse/CRM-20773) Contribution
 402   tab shows Receive Date twice instead of Thank You date
 403   ([10607](https://github.com/civicrm/civicrm-core/pull/10607))**
 404
 405 - **[CRM-20387](https://issues.civicrm.org/jira/browse/CRM-20387) Sales Tax and
 406   Invoicing code overwrites existing CiviCRM invoice ID
 407   ([10298](https://github.com/civicrm/civicrm-core/pull/10298))**
 408
 409   A new `invoice_number` field is added to the `civicrm_contribution` table to
 410   record the ID of the manually-generated invoice.
 411
 412 - **[CRM-20488](https://issues.civicrm.org/jira/browse/CRM-20488) Lift
 413   restrictions for contact type soft credit
 414   ([10532](https://github.com/civicrm/civicrm-core/pull/10532) and
 415   [10419](https://github.com/civicrm/civicrm-core/pull/10419))**
 416
 417   Users could not soft-credit an organization if the contribution originated
 418   from a contribution page where honor/memory is enabled.
 419
 420 - **[CRM-19478](https://issues.civicrm.org/jira/browse/CRM-19478) API not
 421   handling Paypal recurring IPN where p=null for Contribution Page
 422   ([10447](https://github.com/civicrm/civicrm-core/pull/10447))**
 423
 424 - **[CRM-20495](https://issues.civicrm.org/jira/browse/CRM-20495) "Contribution
 425   amounts section" checkbox setting on contribution pages always shows as
 426   checked. ([10521](https://github.com/civicrm/civicrm-core/pull/10521))**
 427
 428 - **[CRM-20747](https://issues.civicrm.org/jira/browse/CRM-20747)
 429   {contribution.campaign} token not working on Contribution ThankYou letter
 430   ([10533](https://github.com/civicrm/civicrm-core/pull/10533))**
 431
 432 ### CiviMember
 433
 434 - **[CRM-19017](https://issues.civicrm.org/jira/browse/CRM-19017) Scheduled
 435   membership reminders have stopped working
 436   ([10652](https://github.com/civicrm/civicrm-core/pull/10652))**
 437
 438 - **[CRM-20716](https://issues.civicrm.org/jira/browse/CRM-20716) Array to
 439   string issue on php7 when creating membership activity
 440   ([10492](https://github.com/civicrm/civicrm-core/pull/10492))**
 441
 442 - **[CRM-20650](https://issues.civicrm.org/jira/browse/CRM-20650) Translate
 443   strings (ts) in CiviMember dashboard and Contribute manage
 444   ([10432](https://github.com/civicrm/civicrm-core/pull/10432))**
 445
 446 - **[CRM-18177](https://issues.civicrm.org/jira/browse/CRM-18177) When Renewing
 447   an existing membership, if CC details are incorrect, Membership is set to
 448   Cancelled preventing contact from trying again
 449   ([10770](https://github.com/civicrm/civicrm-core/pull/10770)) (fix to problem
 450   introduced in original bug fix)**
 451
 452 - **[CRM-20850](https://issues.civicrm.org/jira/browse/CRM-20850) Replace fatal
 453   with statusBounce in membership form
 454   ([10638](https://github.com/civicrm/civicrm-core/pull/10638))**
 455
 456   When a user links to edit a linked contribution from a membership and they
 457   don't have permission to edit the contribution, they should be redirected with
 458   an error notice rather than being shown a fatal error.
 459
 460 - **[CRM-20667](https://issues.civicrm.org/jira/browse/CRM-20667) Additonal Line
 461   item created from Membership backoffice form
 462   ([10450](https://github.com/civicrm/civicrm-core/pull/10450))**
 463
 464 - **[CRM-20805](https://issues.civicrm.org/jira/browse/CRM-20805) Fatal Error
 465   when adding new membership type on a contribution page.
 466   ([10597](https://github.com/civicrm/civicrm-core/pull/10597))**
 467
 468 - **[CRM-20668](https://issues.civicrm.org/jira/browse/CRM-20668) Notice error
 469   ([10452](https://github.com/civicrm/civicrm-core/pull/10452))**
 470
 471   This fixes a PHP notice when creating a membership using a price set on the
 472   backend.
 473
 474 - **[CRM-20675](https://issues.civicrm.org/jira/browse/CRM-20675) Membership
 475   status update creates renewal activity
 476   ([10457](https://github.com/civicrm/civicrm-core/pull/10457))**
 477
 478 - **[CRM-20567](https://issues.civicrm.org/jira/browse/CRM-20567) backoffice
 479   membership via price set errors with non-aggregated column
 480   ([10346](https://github.com/civicrm/civicrm-core/pull/10346))**
 481
 482   This is one of several errors that appear when `sql_mode` was set to
 483   `only_full_group_by`.
 484
 485 - **[CRM-20720](https://issues.civicrm.org/jira/browse/CRM-20720) CIVICRM-128
 486   Unable to sort Price Options for Price Fieldset. Weight values are not being
 487   set at all in database.
 488   ([10542](https://github.com/civicrm/civicrm-core/pull/10542))**
 489
 490 - **[CRM-20670](https://issues.civicrm.org/jira/browse/CRM-20670) Cannot edit
 491   membership type if lots of members already exist
 492   ([10534](https://github.com/civicrm/civicrm-core/pull/10534) and
 493   [10455](https://github.com/civicrm/civicrm-core/pull/10455))**
 494
 495 ### CiviEvent
 496
 497 - **[CRM-20741](https://issues.civicrm.org/jira/browse/CRM-20741) Cancellation
 498   message shown as error
 499   ([10515](https://github.com/civicrm/civicrm-core/pull/10515))**
 500
 501 - **[CRM-20633](https://issues.civicrm.org/jira/browse/CRM-20633) custom field
 502   set displayed twice on register event Participant
 503   ([10551](https://github.com/civicrm/civicrm-core/pull/10551))**
 504
 505   When switching event types on the backend form to add an event participant,
 506   custom fields common to all event types would be added repeatedly.
 507
 508 - **[CRM-20775](https://issues.civicrm.org/jira/browse/CRM-20775) Wrong is full
 509   results for API event get
 510   ([10568](https://github.com/civicrm/civicrm-core/pull/10568))**
 511
 512   When Max Number of Participants event field is left empty, the API would
 513   return `1` for the `is_full`property instead of `0`.
 514
 515 - **[CRM-19745](https://issues.civicrm.org/jira/browse/CRM-19745) Image URL
 516   field doesn't show up on CiviEvent Additional Participants Profile
 517   ([9777](https://github.com/civicrm/civicrm-core/pull/9777))**
 518
 519 ### CiviMail
 520
 521 - **[CRM-20781](https://issues.civicrm.org/jira/browse/CRM-20781) Truncate long
 522   text in mail listing
 523   ([10576](https://github.com/civicrm/civicrm-core/pull/10576))**
 524
 525   Long values in columns would crowd other columns off the screen or into
 526   illegibility.
 527
 528 - **[CRM-20902](https://issues.civicrm.org/jira/browse/CRM-20902) DB Syntax
 529   error on Mailing Opened Report
 530   ([10690](https://github.com/civicrm/civicrm-core/pull/10690))**
 531
 532 - **[CRM-20746](https://issues.civicrm.org/jira/browse/CRM-20746) CiviMail -
 533   text part of resubscribe confirmation mail contains html
 534   ([10528](https://github.com/civicrm/civicrm-core/pull/10528))**
 535
 536 - **[CRM-20412](https://issues.civicrm.org/jira/browse/CRM-20412) mailing
 537   report: unique opens detail view inaccurate
 538   ([10558](https://github.com/civicrm/civicrm-core/pull/10558))**
 539
 540 - **[CRM-20411](https://issues.civicrm.org/jira/browse/CRM-20411) mailing tab
 541   listing: MySQL 5.7 group by error
 542   ([10562](https://github.com/civicrm/civicrm-core/pull/10562) and
 543   [10541](https://github.com/civicrm/civicrm-core/pull/10541))**
 544
 545 - **[CRM-20713](https://issues.civicrm.org/jira/browse/CRM-20713) db error when
 546   populating mailing recipients because sms_provider_id is 'null'
 547   ([10487](https://github.com/civicrm/civicrm-core/pull/10487))**
 548
 549 ### Backdrop Integration
 550
 551 - **Fix spelling to canvass for civicrm_engage
 552   ([40](https://github.com/civicrm/civicrm-backdrop/pull/40))**
 553
 554 - **Bug fixes - issues #22, #31, #33
 555   ([39](https://github.com/civicrm/civicrm-backdrop/pull/39))**
 556
 557 - **Improve Views checkbox value handling
 558   ([37](https://github.com/civicrm/civicrm-backdrop/pull/37))**
 559
 560 - **add new views handlers to hook_autoload_info
 561   ([38](https://github.com/civicrm/civicrm-backdrop/pull/38))**
 562
 563 - **Merge in civicrm/drupal from Dec 15, 2015 to June 21, 2017
 564   ([36](https://github.com/civicrm/civicrm-backdrop/pull/36))**
 565
 566 ### Drupal Integration
 567
 568 - **[CRM-20525](https://issues.civicrm.org/jira/browse/CRM-20525) Webform Pay
 569   later sends Receipt email rather than Invoice email
 570   ([10306](https://github.com/civicrm/civicrm-core/pull/10306))**
 571
 572 - **[CRM-19976](https://issues.civicrm.org/jira/browse/CRM-19976) Drush: cannot
 573   disable civicrm debug
 574   ([457](https://github.com/civicrm/civicrm-drupal/pull/457))**
 575
 576   While `drush civicrm-enable-debug` was defined, this adds the
 577   `civicrm-disable-debug` command.
 578
 579 ### Joomla Integration
 580
 581 - **[CRM-19914](https://issues.civicrm.org/jira/browse/CRM-19914)
 582   civicrmHooks.php issues on windows
 583   ([10571](https://github.com/civicrm/civicrm-core/pull/10571))**
 584
 585   This resolves problems locating the `civicrmHooks.php` file on Joomla sites in
 586   Windows.
 587
 588 ## <a name="misc"></a>Miscellany
 589
 590 - **[CRM-20837](https://issues.civicrm.org/jira/browse/CRM-20837) Make setting
 591   bug more explicit
 592   ([10627](https://github.com/civicrm/civicrm-core/pull/10627))**
 593
 594 - **[CRM-20677](https://issues.civicrm.org/jira/browse/CRM-20677) Use
 595   generalised function to retrieve financial account
 596   ([10463](https://github.com/civicrm/civicrm-core/pull/10463))**
 597
 598 - **[CRM-20786](https://issues.civicrm.org/jira/browse/CRM-20786) Move
 599   deprecated utils functions to the import classes
 600   ([10578](https://github.com/civicrm/civicrm-core/pull/10578),
 601   [10580](https://github.com/civicrm/civicrm-core/pull/10580),
 602   [10579](https://github.com/civicrm/civicrm-core/pull/10579), and
 603   [10581](https://github.com/civicrm/civicrm-core/pull/10581))**
 604
 605 - **[CRM-20771](https://issues.civicrm.org/jira/browse/CRM-20771) Ensure that
 606   AddColumn in CRM_Upgrade_Incremental_Base can support translatable columns
 607   ([10561](https://github.com/civicrm/civicrm-core/pull/10561))**
 608
 609 - **[CRM-20833](https://issues.civicrm.org/jira/browse/CRM-20833) Change
 610   namespace for APIv4 entities
 611   ([10632](https://github.com/civicrm/civicrm-core/pull/10632) and
 612   [10625](https://github.com/civicrm/civicrm-core/pull/10625))**
 613
 614   The namespace is now `Civi\Api4\Entity` rather than `Civi\Api4`.
 615
 616 - **[CRM-19726](https://issues.civicrm.org/jira/browse/CRM-19726)
 617   `CiviMailUtils::clearMessages()` should clear all messages by default
 618   ([10669](https://github.com/civicrm/civicrm-core/pull/10669))**
 619
 620 - **Misspelling ([10619](https://github.com/civicrm/civicrm-core/pull/10619))**
 621
 622 - **[CRM-20797](https://issues.civicrm.org/jira/browse/CRM-20797) Use is_payment
 623   to retrieve payments
 624   ([10587](https://github.com/civicrm/civicrm-core/pull/10587))**
 625
 626 - **Replace a couple of calls to deprecated function
 627   ([10527](https://github.com/civicrm/civicrm-core/pull/10527))**
 628
 629 - **[CRM-20758](https://issues.civicrm.org/jira/browse/CRM-20758) Fix deprecated
 630   fn call on import screen
 631   ([10544](https://github.com/civicrm/civicrm-core/pull/10544))**
 632
 633 - **[CRM-20541](https://issues.civicrm.org/jira/browse/CRM-20541) Edge case
 634   where DB connection is not available
 635   ([447](https://github.com/civicrm/civicrm-drupal/pull/447))**
 636
 637   Certain static variables now use Drupal's built-in system.
 638
 639 ## <a name="credits"></a>Credits
 640
 641 This release was developed by the following code authors:
 642
 643 AGH Strategies - Andrew Hunt; Arun Singh; Australian Greens - Seamus Lee; Brooks
 644 Digital - Spencer Brooks; CEDC - Laryn Kragt Bakker; Circle Interactive - Dave
 645 Jenkins; CiviCRM - Coleman Watts, Tim Otten; CiviDesk - Yashodha Chaku;
 646 CompuCorp - Michael Devery; Coop SymbioTIC - Mathieu Lutfy; Dave Greenberg;
 647 Electronic Frontier Foundation - Mark Burdett; Francesc Bassas i Bullich;
 648 Freeform Solutions - Herb van den Dool; Fuzion - Chris Burgess, Eileen
 649 McNaughton, Jitendra Purohit; Gizra - Aron Novak; JMA Consulting - Edsel Lopez,
 650 Monish Deb, Pradeep Nayak; John Kingsnorth; Joinery - Allen Shaw; Joost Fock;
 651 Klaas Eikelboom; Lighthouse Design and Consulting - Brian Shaughnessy; Mattias
 652 Michaux; Megaphone Technology Consulting - Jon Goldberg; MJW Consulting -
 653 Matthew Wire; Oxfam Germany - Thomas Schüttler; Progressive Technology Project -
 654 Jamie McClelland; Squiffle Consulting - Aidan Saunders; Wikimedia Foundation -
 655 Eileen McNaughton, Maggie Epps
 656
 657 Most authors also reviewed code for this release; in addition, the following
 658 reviewers contributed their comments:
 659
 660 Agileware - Agileware Team; Arkadiusz Rzadkowolski; Blackfly Solutions - Alan
 661 Dixon; CiviDesk - Nicolas Ganivet; CompuCorp - Davi Alexandre, Guanhuan Chen,
 662 Jamie Novick, Mirela Stanila; DevMate - Adam Kwiatkowski; Donald Hirst; DotPro -
 663 Diego Viegas; F. M. Andrimont; Fuzion - Peter Davis, Torrance Hodgson; JMA
 664 Consulting - Joe Murray, Pradeep Nayak; Johan Vervloet; Jvillage Network - Dina
 665 London; Korlon - Stuart Gaston; Lueck Data Systems - Michael Lueck; MC3 - Graham
 666 Mitchell; Nathan Brettell; Oxfam Germany - Thomas Schüttler; Peter Bull; Phil
 667 McKerracher; Semper IT - Karin Gerritsen; Skvare - Mark Hanna; Stephen
 668 Palmstrom; Tadpole Collective - Kevin Cristiano; Upleaf - Osvaldo Gomez;
 669 Wikimedia Foundation - Elliott Eggleston