CiviCRM Core issueshttps://lab.civicrm.org/dev/core/-/issues2022-06-20T21:28:36Zhttps://lab.civicrm.org/dev/core/-/issues/36675.51 import - cannot add a contact to an existing relationship2022-06-20T21:28:36ZAndy Clark5.51 import - cannot add a contact to an existing relationshipI added 3 contacts each with a relationship to another contact. One of the related contacts existed, the other two did not. The new related contacts were added, but the relationship to the existing contact was rejected - see screen prin...I added 3 contacts each with a relationship to another contact. One of the related contacts existed, the other two did not. The new related contacts were added, but the relationship to the existing contact was rejected - see screen print. This is a regression as you should be able to import contacts that relate to existing contacts. Using nightly from 17/6.![screenshot_20220617_175039](/uploads/d358d81d5c1b05674befa4c6b6e34bcd/screenshot_20220617_175039.png)5.51.0https://lab.civicrm.org/dev/core/-/issues/36655.51 import with relationships - count of inserts incorrect2022-06-22T13:38:20ZAndy Clark5.51 import with relationships - count of inserts incorrectWhen inserting contacts with relationships where both the contact and the related contact are new, the count of 'Total number of contact records created or modified during the import.' is incorrect. The related contacts that were correc...When inserting contacts with relationships where both the contact and the related contact are new, the count of 'Total number of contact records created or modified during the import.' is incorrect. The related contacts that were correctly added were not counted. In my test case I had 3 rows, where each contact had a relationship to a contact that didn't previously exist so this was inserted by the upload as well. The count as above was 3 but should have been 6. (Using nightly tarball from 17/6)5.51.0https://lab.civicrm.org/dev/core/-/issues/36635.51 import error when CSV header contains spaces in column names2022-08-04T15:56:32ZJonGold5.51 import error when CSV header contains spaces in column namesMy client attempted to import a CSV with this as the header row:
```
ID,IND/ORG,SALUTATION,FIRSTNAME,LASTNAME,Status,Country,EMAILADDRESS,AGBUHIGHLIGHTSRECIPIENT,AGBUARMENIA,YOUNGPROFESSIONALS,Do Not Mail,Valid Address
```
That yielded ...My client attempted to import a CSV with this as the header row:
```
ID,IND/ORG,SALUTATION,FIRSTNAME,LASTNAME,Status,Country,EMAILADDRESS,AGBUHIGHLIGHTSRECIPIENT,AGBUARMENIA,YOUNGPROFESSIONALS,Do Not Mail,Valid Address
```
That yielded this error/backtrace, which seems connected to the field names. Note that I looked at `civicrm_tmp_d_dflt_53f990c8f2166dca1b59a22af4096233` and the column names were snake-cased (e.g. `do_not_mail`).
```
[error] $Fatal Error Details = Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => exceptionHandler
)
[code] => -2
[message] => DB Error: syntax error
[mode] => 16
[debug_info] => SELECT _id, _status_message, ID, IND/ORG, SALUTATION, FIRSTNAME, LASTNAME, Status, Country, EMAILADDRESS, AGBUHIGHLIGHTSRECIPIENT, AGBUARMENIA, YOUNGPROFESSIONALS, Do Not Mail, Valid Address FROM civicrm_tmp_d_dflt_53f990c8f2166dca1b59a22af4096233 WHERE _status IN ("error","invalid","soft_credit_error","pledge_payment_error") [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Mail, Valid Address FROM civicrm_tmp_d_dflt_53f990c8f2166dca1b59a22af4096233 ...' at line 1]
[type] => DB_Error
[user_info] => SELECT _id, _status_message, ID, IND/ORG, SALUTATION, FIRSTNAME, LASTNAME, Status, Country, EMAILADDRESS, AGBUHIGHLIGHTSRECIPIENT, AGBUARMENIA, YOUNGPROFESSIONALS, Do Not Mail, Valid Address FROM civicrm_tmp_d_dflt_53f990c8f2166dca1b59a22af4096233 WHERE _status IN ("error","invalid","soft_credit_error","pledge_payment_error") [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Mail, Valid Address FROM civicrm_tmp_d_dflt_53f990c8f2166dca1b59a22af4096233 ...' at line 1]
[to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="SELECT _id, _status_message, ID, IND/ORG, SALUTATION, FIRSTNAME, LASTNAME, Status, Country, EMAILADDRESS, AGBUHIGHLIGHTSRECIPIENT, AGBUARMENIA, YOUNGPROFESSIONALS, Do Not Mail, Valid Address FROM civicrm_tmp_d_dflt_53f990c8f2166dca1b59a22af4096233 WHERE _status IN ("error","invalid","soft_credit_error","pledge_payment_error") [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Mail, Valid Address FROM civicrm_tmp_d_dflt_53f990c8f2166dca1b59a22af4096233 ...' at line 1]"]
)
[debug] $backTrace = #0 /code/vendor/civicrm/civicrm-core/CRM/Core/Error.php(954): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /code/vendor/pear/pear-core-minimal/src/PEAR.php(944): CRM_Core_Error::exceptionHandler(Object(DB_Error))
#2 /code/vendor/pear/db/DB.php(997): PEAR_Error->__construct("DB Error: syntax error", -2, 16, (Array:2), "SELECT _id, _status_message, ID, IND/ORG, SALUTATION, FIRSTNAME, LASTNAME, S...")
#3 /code/vendor/pear/pear-core-minimal/src/PEAR.php(575): DB_Error->__construct(-2, 16, (Array:2), "SELECT _id, _status_message, ID, IND/ORG, SALUTATION, FIRSTNAME, LASTNAME, S...")
#4 /code/vendor/pear/pear-core-minimal/src/PEAR.php(223): PEAR::_raiseError(Object(DB_mysqli), NULL, -2, 16, (Array:2), "SELECT _id, _status_message, ID, IND/ORG, SALUTATION, FIRSTNAME, LASTNAME, S...", "DB_Error", TRUE)
#5 /code/vendor/pear/db/DB/common.php(1928): PEAR->__call("raiseError", (Array:7))
#6 /code/vendor/pear/db/DB/mysqli.php(936): DB_common->raiseError(-2, NULL, NULL, "SELECT _id, _status_message, ID, IND/ORG, SALUTATION, FIRSTNAME, LASTNAME, S...", "1064 ** You have an error in your SQL syntax; check the manual that correspon...")
#7 /code/vendor/pear/db/DB/mysqli.php(406): DB_mysqli->mysqliRaiseError()
#8 /code/vendor/pear/db/DB/common.php(1234): DB_mysqli->simpleQuery("SELECT _id, _status_message, ID, IND/ORG, SALUTATION, FIRSTNAME, LASTNAME, S...")
#9 /code/vendor/civicrm/civicrm-packages/DB/DataObject.php(2696): DB_common->query("SELECT _id, _status_message, ID, IND/ORG, SALUTATION, FIRSTNAME, LASTNAME, S...")
#10 /code/vendor/civicrm/civicrm-packages/DB/DataObject.php(1829): DB_DataObject->_query("SELECT _id, _status_message, ID, IND/ORG, SALUTATION, FIRSTNAME, LASTNAME, S...")
#11 /code/vendor/civicrm/civicrm-core/CRM/Core/DAO.php(472): DB_DataObject->query("SELECT _id, _status_message, ID, IND/ORG, SALUTATION, FIRSTNAME, LASTNAME, S...")
#12 /code/vendor/civicrm/civicrm-core/CRM/Core/DAO.php(1637): CRM_Core_DAO->query("SELECT _id, _status_message, ID, IND/ORG, SALUTATION, FIRSTNAME, LASTNAME, S...", TRUE)
#13 /code/vendor/civicrm/civicrm-core/CRM/Import/DataSource.php(568): CRM_Core_DAO::executeQuery("SELECT _id, _status_message, ID, IND/ORG, SALUTATION, FIRSTNAME, LASTNAME, S...")
#14 /code/vendor/civicrm/civicrm-core/CRM/Import/DataSource.php(229): CRM_Import_DataSource->instantiateQueryObject()
#15 /code/vendor/civicrm/civicrm-core/CRM/Import/DataSource.php(212): CRM_Import_DataSource->getRow()
#16 /code/vendor/civicrm/civicrm-core/CRM/Import/Forms.php(473): CRM_Import_DataSource->getRows()
#17 /code/vendor/civicrm/civicrm-core/CRM/Import/Forms.php(528): CRM_Import_Forms->getOutputRows((Array:1))
#18 /code/vendor/civicrm/civicrm-core/CRM/Core/Invoke.php(285): CRM_Import_Forms::outputCSV()
#19 /code/vendor/civicrm/civicrm-core/CRM/Core/Invoke.php(69): CRM_Core_Invoke::runItem((Array:17))
#20 /code/vendor/civicrm/civicrm-core/CRM/Core/Invoke.php(36): CRM_Core_Invoke::_invoke((Array:3))
#21 /code/modules/contrib/civicrm/src/Civicrm.php(88): CRM_Core_Invoke::invoke((Array:3))
#22 /code/modules/contrib/civicrm/src/Controller/CivicrmController.php(80): Drupal\civicrm\Civicrm->invoke((Array:3))
#23 [internal function](): Drupal\civicrm\Controller\CivicrmController->main((Array:3), "")
#24 /code/core/lib/Drupal/Core/EventSubscriber/EarlyRenderingControllerWrapperSubscriber.php(123): call_user_func_array((Array:2), (Array:2))
#25 /code/core/lib/Drupal/Core/Render/Renderer.php(564): Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}()
#26 /code/core/lib/Drupal/Core/EventSubscriber/EarlyRenderingControllerWrapperSubscriber.php(124): Drupal\Core\Render\Renderer->executeInRenderContext(Object(Drupal\Core\Render\RenderContext), Object(Closure))
#27 /code/core/lib/Drupal/Core/EventSubscriber/EarlyRenderingControllerWrapperSubscriber.php(97): Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->wrapControllerExecutionInRenderContext((Array:2), (Array:2))
#28 /code/vendor/symfony/http-kernel/HttpKernel.php(158): Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}()
#29 /code/vendor/symfony/http-kernel/HttpKernel.php(80): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(Symfony\Component\HttpFoundation\Request), 1)
#30 /code/core/lib/Drupal/Core/StackMiddleware/Session.php(58): Symfony\Component\HttpKernel\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, TRUE)
#31 /code/core/lib/Drupal/Core/StackMiddleware/KernelPreHandle.php(48): Drupal\Core\StackMiddleware\Session->handle(Object(Symfony\Component\HttpFoundation\Request), 1, TRUE)
#32 /code/core/modules/page_cache/src/StackMiddleware/PageCache.php(106): Drupal\Core\StackMiddleware\KernelPreHandle->handle(Object(Symfony\Component\HttpFoundation\Request), 1, TRUE)
#33 /code/core/modules/page_cache/src/StackMiddleware/PageCache.php(85): Drupal\page_cache\StackMiddleware\PageCache->pass(Object(Symfony\Component\HttpFoundation\Request), 1, TRUE)
#34 /code/core/lib/Drupal/Core/StackMiddleware/ReverseProxyMiddleware.php(48): Drupal\page_cache\StackMiddleware\PageCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, TRUE)
#35 /code/core/lib/Drupal/Core/StackMiddleware/NegotiationMiddleware.php(51): Drupal\Core\StackMiddleware\ReverseProxyMiddleware->handle(Object(Symfony\Component\HttpFoundation\Request), 1, TRUE)
#36 /code/vendor/stack/builder/src/Stack/StackedHttpKernel.php(23): Drupal\Core\StackMiddleware\NegotiationMiddleware->handle(Object(Symfony\Component\HttpFoundation\Request), 1, TRUE)
#37 /code/core/lib/Drupal/Core/DrupalKernel.php(708): Stack\StackedHttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, TRUE)
#38 /code/index.php(19): Drupal\Core\DrupalKernel->handle(Object(Symfony\Component\HttpFoundation\Request))
#39 {main}
```5.51.0https://lab.civicrm.org/dev/core/-/issues/36625.51: "data too long" error when recording duplicates multiple contacts.2022-06-20T21:26:07ZJonGold5.51: "data too long" error when recording duplicates multiple contacts.My client has been testing the 5.51 import some more, I see this backtrace today:
Now I'm not sure what led to this state of affairs, and that's probably a bug in itself we need to track down - but the "data too long" issue could concei...My client has been testing the 5.51 import some more, I see this backtrace today:
Now I'm not sure what led to this state of affairs, and that's probably a bug in itself we need to track down - but the "data too long" issue could conceivably come up even without the other bug manifesting.
```
[info] $CRM_Queue_Page_AJAX_runNext_error = PEAR_Exception: "DB Error: unknown error"
* ERROR TYPE: DB_Error
* ERROR CODE: -1
* ERROR MESSAGE: DB Error: unknown error
* ERROR MODE: 16
* ERROR USERINFO: UPDATE civicrm_tmp_d_dflt_92a94bde8a533a2019a537a7bf1e22f6 SET _status = 'ERROR', _status_message = 'Record duplicates multiple contacts: 2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,<...snipped a very long list here...>, 149491' WHERE _id = 1 [nativecode=1406 ** Data too long for column '_status_message' at row 1]
#0 /code/vendor/pear/pear-core-minimal/src/PEAR.php(944): CRM_Core_Error::exceptionHandler(Object(DB_Error))
#1 /code/vendor/pear/db/DB.php(997): PEAR_Error->__construct("DB Error: unknown error", -1, 16, (Array:2), "UPDATE civicrm_tmp_d_dflt_92a94bde8a533a2019a537a7bf1e22f6 SET _status = 'ERR...")
#2 /code/vendor/pear/pear-core-minimal/src/PEAR.php(575): DB_Error->__construct(-1, 16, (Array:2), "UPDATE civicrm_tmp_d_dflt_92a94bde8a533a2019a537a7bf1e22f6 SET _status = 'ERR...")
#3 /code/vendor/pear/pear-core-minimal/src/PEAR.php(223): PEAR::_raiseError(Object(DB_mysqli), NULL, -1, 16, (Array:2), "UPDATE civicrm_tmp_d_dflt_92a94bde8a533a2019a537a7bf1e22f6 SET _status = 'ERR...", "DB_Error", TRUE)
#4 /code/vendor/pear/db/DB/common.php(1928): PEAR->__call("raiseError", (Array:7))
#5 /code/vendor/pear/db/DB/mysqli.php(936): DB_common->raiseError(-1, NULL, NULL, "UPDATE civicrm_tmp_d_dflt_92a94bde8a533a2019a537a7bf1e22f6 SET _status = 'ERR...", "1406 ** Data too long for column '_status_message' at row 1")
#6 /code/vendor/pear/db/DB/mysqli.php(406): DB_mysqli->mysqliRaiseError()
#7 /code/vendor/pear/db/DB/common.php(1234): DB_mysqli->simpleQuery("UPDATE civicrm_tmp_d_dflt_92a94bde8a533a2019a537a7bf1e22f6 SET _status = 'ERR...")
#8 /code/vendor/civicrm/civicrm-packages/DB/DataObject.php(2696): DB_common->query("UPDATE civicrm_tmp_d_dflt_92a94bde8a533a2019a537a7bf1e22f6 SET _status = 'ERR...")
#9 /code/vendor/civicrm/civicrm-packages/DB/DataObject.php(1829): DB_DataObject->_query("UPDATE civicrm_tmp_d_dflt_92a94bde8a533a2019a537a7bf1e22f6 SET _status = 'ERR...")
#10 /code/vendor/civicrm/civicrm-core/CRM/Core/DAO.php(472): DB_DataObject->query("UPDATE civicrm_tmp_d_dflt_92a94bde8a533a2019a537a7bf1e22f6 SET _status = 'ERR...")
#11 /code/vendor/civicrm/civicrm-core/CRM/Core/DAO.php(1637): CRM_Core_DAO->query("UPDATE civicrm_tmp_d_dflt_92a94bde8a533a2019a537a7bf1e22f6 SET _status = 'ERR...", TRUE)
#12 /code/vendor/civicrm/civicrm-core/CRM/Import/DataSource.php(555): CRM_Core_DAO::executeQuery("UPDATE civicrm_tmp_d_dflt_92a94bde8a533a2019a537a7bf1e22f6 SET _status = %1, ...", (Array:2))
#13 /code/vendor/civicrm/civicrm-core/CRM/Import/Parser.php(2013): CRM_Import_DataSource->updateStatus(1, "ERROR", "Record duplicates multiple contacts: 2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,...", NULL, (Array:0))
#14 /code/vendor/civicrm/civicrm-core/CRM/Contact/Import/Parser/Contact.php(183): CRM_Import_Parser->setImportStatus(1, "ERROR", "Record duplicates multiple contacts: 2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,...")
#15 /code/vendor/civicrm/civicrm-core/CRM/Import/Parser.php(1911): CRM_Contact_Import_Parser_Contact->import((Array:10))
#16 /code/vendor/civicrm/civicrm-core/CRM/Queue/Task.php(95): CRM_Import_Parser::runImport(Object(CRM_Queue_TaskContext), 5, 5)
#17 /code/vendor/civicrm/civicrm-core/CRM/Queue/Runner.php(257): CRM_Queue_Task->run(Object(CRM_Queue_TaskContext))
#18 /code/vendor/civicrm/civicrm-core/CRM/Queue/Page/AJAX.php(36): CRM_Queue_Runner->runNext(TRUE)
#19 /code/vendor/civicrm/civicrm-core/CRM/Queue/ErrorPolicy.php(89): CRM_Queue_Page_AJAX::{closure}()
#20 /code/vendor/civicrm/civicrm-core/CRM/Queue/Page/AJAX.php(38): CRM_Queue_ErrorPolicy->call(Object(Closure))
#21 /code/vendor/civicrm/civicrm-core/CRM/Core/Invoke.php(285): CRM_Queue_Page_AJAX::runNext()
#22 /code/vendor/civicrm/civicrm-core/CRM/Core/Invoke.php(69): CRM_Core_Invoke::runItem((Array:17))
#23 /code/vendor/civicrm/civicrm-core/CRM/Core/Invoke.php(36): CRM_Core_Invoke::_invoke((Array:4))
#24 /code/modules/contrib/civicrm/src/Civicrm.php(88): CRM_Core_Invoke::invoke((Array:4))
#25 /code/modules/contrib/civicrm/src/Controller/CivicrmController.php(80): Drupal\civicrm\Civicrm->invoke((Array:4))
#26 [internal function](): Drupal\civicrm\Controller\CivicrmController->main((Array:4), "queue:ajax:runNext")
#27 /code/core/lib/Drupal/Core/EventSubscriber/EarlyRenderingControllerWrapperSubscriber.php(123): call_user_func_array((Array:2), (Array:2))
#28 /code/core/lib/Drupal/Core/Render/Renderer.php(564): Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}()
#29 /code/core/lib/Drupal/Core/EventSubscriber/EarlyRenderingControllerWrapperSubscriber.php(124): Drupal\Core\Render\Renderer->executeInRenderContext(Object(Drupal\Core\Render\RenderContext), Object(Closure))
#30 /code/core/lib/Drupal/Core/EventSubscriber/EarlyRenderingControllerWrapperSubscriber.php(97): Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->wrapControllerExecutionInRenderContext((Array:2), (Array:2))
#31 /code/vendor/symfony/http-kernel/HttpKernel.php(158): Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}()
#32 /code/vendor/symfony/http-kernel/HttpKernel.php(80): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(Symfony\Component\HttpFoundation\Request), 1)
#33 /code/core/lib/Drupal/Core/StackMiddleware/Session.php(58): Symfony\Component\HttpKernel\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, TRUE)
#34 /code/core/lib/Drupal/Core/StackMiddleware/KernelPreHandle.php(48): Drupal\Core\StackMiddleware\Session->handle(Object(Symfony\Component\HttpFoundation\Request), 1, TRUE)
#35 /code/core/modules/page_cache/src/StackMiddleware/PageCache.php(106): Drupal\Core\StackMiddleware\KernelPreHandle->handle(Object(Symfony\Component\HttpFoundation\Request), 1, TRUE)
#36 /code/core/modules/page_cache/src/StackMiddleware/PageCache.php(85): Drupal\page_cache\StackMiddleware\PageCache->pass(Object(Symfony\Component\HttpFoundation\Request), 1, TRUE)
#37 /code/core/lib/Drupal/Core/StackMiddleware/ReverseProxyMiddleware.php(48): Drupal\page_cache\StackMiddleware\PageCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, TRUE)
#38 /code/core/lib/Drupal/Core/StackMiddleware/NegotiationMiddleware.php(51): Drupal\Core\StackMiddleware\ReverseProxyMiddleware->handle(Object(Symfony\Component\HttpFoundation\Request), 1, TRUE)
#39 /code/vendor/stack/builder/src/Stack/StackedHttpKernel.php(23): Drupal\Core\StackMiddleware\NegotiationMiddleware->handle(Object(Symfony\Component\HttpFoundation\Request), 1, TRUE)
#40 /code/core/lib/Drupal/Core/DrupalKernel.php(708): Stack\StackedHttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, TRUE)
#41 /code/index.php(19): Drupal\Core\DrupalKernel->handle(Object(Symfony\Component\HttpFoundation\Request))
#42 {main}
```5.51.0https://lab.civicrm.org/dev/core/-/issues/36615.51 regression: Permission issue on CRM_Mailing_BAO_Mailing::getGroupNames()2022-06-21T03:29:59ZJonGold5.51 regression: Permission issue on CRM_Mailing_BAO_Mailing::getGroupNames()I have an extension "unsubscribe group token". From the description:
> When using "ad-hoc" CiviMail, the "{mailing.group}" token evaluates to "Hidden Smart Group x". This evaluates identically to {mailing.group} on regular CiviMails, b...I have an extension "unsubscribe group token". From the description:
> When using "ad-hoc" CiviMail, the "{mailing.group}" token evaluates to "Hidden Smart Group x". This evaluates identically to {mailing.group} on regular CiviMails, but evaluates to the unsubscribe group name on ad-hoc mails. This extension provides a token to display your "Unsubscribe from {group}" text appropriately.
This token calls `CRM_Mailing_BAO_Mailing::getGroupNames()`, which @ufundo recently improved in #3463. However, this now requires the cron user to have the "Access CiviMail" permission.
Perhaps this should have always been the case. Perhaps I shouldn't be using `CRM_Mailing_BAO_Mailing::getGroupNames()` from an extension. I'm not convinced that https://github.com/civicrm/civicrm-core/pull/23570 is wrong to check API permissions - but it *is* a regression.
I'll submit a PR, and if it feels inappropriate to merge, that's cool.JonGoldJonGoldhttps://lab.civicrm.org/dev/core/-/issues/3660When upgrading an extension to use mixins, existing managed entities get deleted2022-07-05T20:39:56ZcolemanwWhen upgrading an extension to use mixins, existing managed entities get deletedI noticed while working on https://github.com/systopia/de.systopia.eck/pull/53/commits/66e1be252f3743aad35c3d028b628f3ea721948d that when switching from the master branch (without mixins) to the working branch (with mixins) that upon cle...I noticed while working on https://github.com/systopia/de.systopia.eck/pull/53/commits/66e1be252f3743aad35c3d028b628f3ea721948d that when switching from the master branch (without mixins) to the working branch (with mixins) that upon clearing caches all managed entities would be deleted and recreated.
In some cases that's not a big deal, but in this case it's quite a problem because of cascading deletes. The option group is a managed entity, so all user-created option values get destroyed in the process!
It must be an order-of-operations thing, where the managed entities get reconciled *before* the `info.xml` file gets scanned for mixins.tottentottenhttps://lab.civicrm.org/dev/core/-/issues/3657Crash importing contacts using 5.51 beta2022-06-17T02:37:42ZAndy ClarkCrash importing contacts using 5.51 betaUsing a simple test file on nightly 5.51 build of 16/6 contact import crashes when hitting 'Continue' on first screen. Screen shot attached. Same thing happened on previous nightly build. Test system was on 5.49.5 prior to that and went...Using a simple test file on nightly 5.51 build of 16/6 contact import crashes when hitting 'Continue' on first screen. Screen shot attached. Same thing happened on previous nightly build. Test system was on 5.49.5 prior to that and went through upgrade to 5.51 beta OK. System is Drupal 7 based. ![screenshot_20220616_094041](/uploads/6d06bb10cbb1a2827829e15fe96cc8a8/screenshot_20220616_094041.png)https://lab.civicrm.org/dev/core/-/issues/3653Upgrading to 5.51 RC fails through the web interface, but works with `cv` and...2022-07-21T00:54:20ZjhungerfordUpgrading to 5.51 RC fails through the web interface, but works with `cv` and `drush`.Overview
----------------------------------------
I commented on this issue in the Town Square:
https://chat.civicrm.org/civicrm/pl/kpcoyh7hx3nzunx34ejbe8h8aw
Running the database upgrade to 5.51 RC by visiting `/civicrm/upgrade?reset=1...Overview
----------------------------------------
I commented on this issue in the Town Square:
https://chat.civicrm.org/civicrm/pl/kpcoyh7hx3nzunx34ejbe8h8aw
Running the database upgrade to 5.51 RC by visiting `/civicrm/upgrade?reset=1` fails with this message:
"DB Error: no such field"
`UPDATE civicrm_queue SET status = NULL WHERE name = 'CRM_Upgrade' [nativecode=1054 ** Unknown column 'status' in 'field list'`
Running the same upgrade with `cv` or `drush` works.
Reproduction steps
----------------------------------------
1. Install an older version of Civi (e.g. 5.49.5) on Drupal 7.88
2. Replace the Civi module with 5.51 RC (civicrm-RC-drupal.tar.gz ( 5.51.beta1-202206120040 ))
3. Visit /civicrm/upgrade?reset=1 in the web interface, and run the upgrade
4. Observe that it crashes with "DB Error: no such field"
5. Try again, to confirm that it consistently fails in the web interface
6. Run the upgrade with `cv upgrade:db` or drush, and observe that it works
Current behaviour
----------------------------------------
After the failure in the web interface, the Drupal log of our production clone contained a message with this string:
`UPDATE civicrm_queue SET status = NULL WHERE name = 'CRM_Upgrade' [nativecode=1054 ** Unknown column 'status' in 'field list'`
I didn't find any upgrade messages in the Drupal log of the clean install, I'm not sure why.
Expected behaviour
----------------------------------------
The web interface upgrade normally works the same as the command line process.
Environment information
----------------------------------------
* __Browser:__ Firefox 91.9.1esr (64-bit)
* __CiviCRM:__ from 5.49.5 to 5.51.beta1 (5.51.beta1-202206120040)
* __PHP:__ 7.3.33-1+0~20211119.91+debian10~1.gbp618351
* __CMS:__ Drupal 7.88
* __Database:__ mariadb Ver 15.1 Distrib 10.3.34-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2
* __Web Server:__ apache2 2.4.38-3+deb10u75.51.0https://lab.civicrm.org/dev/core/-/issues/3652I've just tested 5.51 (5.51.alpha1-202206100340), and "First Name" and "Last ...2023-01-31T04:29:42ZeileenI've just tested 5.51 (5.51.alpha1-202206100340), and "First Name" and "Last Name" seem to have disappeared from the import mapping options.Tracking for https://lab.civicrm.org/dev/core/-/issues/2858#note_75339
I've just tested 5.51 (5.51.alpha1-202206100340), and "First Name" and "Last Name" seem to have disappeared from the import mapping options. I note that in the code ...Tracking for https://lab.civicrm.org/dev/core/-/issues/2858#note_75339
I've just tested 5.51 (5.51.alpha1-202206100340), and "First Name" and "Last Name" seem to have disappeared from the import mapping options. I note that in the code (e.g. the mapFieldDataProvider function) they're now referred to as "first_name" and "last_name", but I can't find them in the field mapping dropdown (see screenshot).
![firstname_lastname_missing](/uploads/209a7788029206c0c7842bc5631aa854/firstname_lastname_missing.jpg)
The saved field mapping has reverted these fields to "- do not import -".
This prevents the import from running. I see the following error message when I try to click Continue to go past the Match Fields screen (step 2 of 4):
"Missing required contact matching fields. email(weight 15) first_name(weight 5) last_name(weight 10) (Sum of all weights should be greater than or equal to threshold: 30)."
I notice that "Organisation Name" is in the list, but Contact Type is definitely set to Individual in the first screen of the import process.5.51.0https://lab.civicrm.org/dev/core/-/issues/3651Activity import error output missing the column the error is about2022-06-14T03:15:51ZDaveDActivity import error output missing the column the error is aboute.g. Create an import file with an invalid date, something like this for Activities
```csv
Type,Subject,Contact,Date
2,something,13,2021-02-03 16
```
The error output will correctly flag the date column as invalid, but does not include...e.g. Create an import file with an invalid date, something like this for Activities
```csv
Type,Subject,Contact,Date
2,something,13,2021-02-03 16
```
The error output will correctly flag the date column as invalid, but does not include it in the output:
```csv
"Line Number",Reason,Type,Subject,Contact,Date
1,"Invalid value for field(s) : Activity Date",2,something,13
```5.51.0https://lab.civicrm.org/dev/core/-/issues/3644Delivery summary doesn't show2022-06-11T14:58:02ZLoganBearDelivery summary doesn't showUpdated to CiviCRM 5.19 - ran one of our biweekly mailings last night and I wanted to check the open count. But Civi says that the mailing isn't completed,![Screen_Shot_2019-11-08_at_10.23.56_AM](/uploads/9723b265e4f977ffebce0033575d5291...Updated to CiviCRM 5.19 - ran one of our biweekly mailings last night and I wanted to check the open count. But Civi says that the mailing isn't completed,![Screen_Shot_2019-11-08_at_10.23.56_AM](/uploads/9723b265e4f977ffebce0033575d5291/Screen_Shot_2019-11-08_at_10.23.56_AM.png)
but the summary shows it's completed.![Screen_Shot_2019-11-08_at_10.23.41_AM](/uploads/24352601bef0fce245cc4198826cb937/Screen_Shot_2019-11-08_at_10.23.41_AM.png)5.19.1https://lab.civicrm.org/dev/core/-/issues/3626"New Mailing" prematurely schedules blasts and old mailings can be resent2022-06-11T14:57:24Ztotten"New Mailing" prematurely schedules blasts and old mailings can be resent## Steps to reproduce
* Open a MySQL console where you can monitor the content of `civicrm_mailing_job`.
* Make a `Mailing => New Mailing`
* Fill in name/subject/recipients/body on the first page.
* Go to the second page
* __Observe__:...## Steps to reproduce
* Open a MySQL console where you can monitor the content of `civicrm_mailing_job`.
* Make a `Mailing => New Mailing`
* Fill in name/subject/recipients/body on the first page.
* Go to the second page
* __Observe__: In the MySQL console, observe that there are no jobs scheduled for this mailing.
* Set a delivery time. *But don't hit `Submit`*. (You're just thinking about delivery... but not actually sending yet.)
* Open an HTML or plain-text preview.
* __Observe__: In the MySQL console, observe that there is now a scheduled job for this mailing.
To resend an old mailing:
* Any mailing will be queued for redelivery if a user with permission to use CiviMail visits URL `civicrm/a/#/mailing/<MAILING_ID>` (we've seen several users end up on this URL, apparently via browser history)
## Mitigating factors
The only way I've found to trigger the premature mailing (so far) has been to explicitly set the delivery date. It's quite bad to be sending prematurely, but I think it's taken a while to recognize because the delivery date is *the last thing* in the entire process -- *most of the time*, one doesn't set the delivery date until everything else has been settled. This probably means the real-world impact hasn't been as bad one might fear.
## Context
This appears to be a regression in 4.7.31. Related PRs:
* https://issues.civicrm.org/jira/browse/CRM-21260
* https://issues.civicrm.org/jira/browse/CRM-21316
* https://issues.civicrm.org/jira/browse/CRM-21749
* https://github.com/civicrm/civicrm-core/pull/11142/
* https://github.com/civicrm/civicrm-core/pull/11653/
## Solution
* Because the fix is in javascript, resolving this bug requires flushing CiviCRM caches (`cv flush` command) after upgrading to CiviCRM 5.0.05.0.0https://lab.civicrm.org/dev/core/-/issues/3623After upgrade to 5.48.0 Error: Mailing cannot be sent. There are missing or i...2022-06-11T14:57:18ZoschopferAfter upgrade to 5.48.0 Error: Mailing cannot be sent. There are missing or invalid fields (subject,name,from_name,from_email,body).After upgrading from CiviCRM 5.47.2 to 5.48.0, any attempted mailing creates an error after clicking "Submit Mailing" with "Mailing cannot be sent. There are missing or invalid fields (subject,name,from_name,from_email,body)." Those fiel...After upgrading from CiviCRM 5.47.2 to 5.48.0, any attempted mailing creates an error after clicking "Submit Mailing" with "Mailing cannot be sent. There are missing or invalid fields (subject,name,from_name,from_email,body)." Those fields are clearly filled in in the mailing, and when submitting a test mailing, it goes through, and the test mailing is sent and delivered.
I'm on Drupal 7. Using CiviMail with Mosaico.https://lab.civicrm.org/dev/core/-/issues/3622[regression] CiviMail crashing on send instead of throwing exception when usi...2022-06-11T14:57:15ZJonGold[regression] CiviMail crashing on send instead of throwing exception when using Job.executeIn 5.27.0+, [PR #17277](https://github.com/civicrm/civicrm-core/pull/17277) is causing CiviMail to crash in the most common configuration on any SMTP error.
For example, if a contact has an invalid email address, then it could produce a...In 5.27.0+, [PR #17277](https://github.com/civicrm/civicrm-core/pull/17277) is causing CiviMail to crash in the most common configuration on any SMTP error.
For example, if a contact has an invalid email address, then it could produce an SMTP error - and cause a failure which prevents other messages from going out.
### Replication
* Create a contact with an email address that will generate an SMTP error. Screenshot below; you know best how to cause this problem in your own env :)
![Selection_998](/uploads/9670a781edd7e8838d9b4ae725f14212/Selection_998.png)
* Send a transactional email to this user. You should get an error like the one in the screenshot.
* View the Civi logs. You should have two new entries; `Ignoring exception thrown by nullHandler` and a backtrace.
* Now, create a CiviMail to a group containing this contact.
* If you send the mailing via `Job.execute`, you get the error but NOT the backtrace; any other recipients in the mailing will not get the mailing, it exits silently (there will be an error in the Scheduled Job log for `send_mailing`). The email is not placed on hold; CiviMail is now broken and won't send any new mailings, nor finish the existing mailing.
* Now, send the same mailing via `Job.send_mailing`. The bad email address is handled correctly (placed on hold, mailing continues, backtrace appears in log).
### Technical notes
* When you run `Job.execute`, `CRM_Core_JobManager` specifies a [custom fatal error handler](https://github.com/civicrm/civicrm-core/blob/master/CRM/Core/JobManager.php#L44).
* `CRM_Core_Error::nullHandler` calls `CRM_Core_Error::debug_log_message`.
* [PR #17277](https://github.com/civicrm/civicrm-core/pull/17277) adds a call to the custom fatal error handler in `CRM_Core_Error::debug_log_message`.
* Since `CRM_Core_JobManager::CRM_Core_JobManager_scheduledJobFatalErrorHandler` throws an exception, this causes the job to exit silently.
#### Correct backtrace
```
Jul 31 12:05:40 [error] Ignoring exception thrown by nullHandler: 10005, Failed to add recipient: onddddd@zabuntu.lan [SMTP: Invalid response code received from SMTP server while sending email. This is often caused by a misconfiguration in Outbound Email settings. Please verify the settings at Administer CiviCRM >> Global Settings >> Outbound Email (SMTP). (code: 550, response: 5.1.1 <onddddd@zabuntu.lan>: Recipient address rejected: User unknown in local recipient table)]
Jul 31 12:05:40 [debug] $backTrace = #0 /home/jon/local/civicrm-buildkit/build/dmaster/web/sites/all/modules/civicrm/CRM/Core/Error.php(963): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /home/jon/local/civicrm-buildkit/build/dmaster/web/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(922): CRM_Core_Error::nullHandler(Object(PEAR_Error))
#2 /home/jon/local/civicrm-buildkit/build/dmaster/web/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(577): PEAR_Error->__construct("Failed to add recipient: onddddd@zabuntu.lan [SMTP: Invalid response code rec...", 10005, 16, (Array:2), NULL)
#3 /home/jon/local/civicrm-buildkit/build/dmaster/web/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(236): PEAR::_raiseError(NULL, "Failed to add recipient: onddddd@zabuntu.lan [SMTP: Invalid response code rec...", 10005)
#4 /home/jon/local/civicrm-buildkit/build/dmaster/web/sites/all/modules/civicrm/vendor/pear/mail/Mail/smtp.php(325): PEAR::__callStatic("raiseError", (Array:2))
#5 /home/jon/local/civicrm-buildkit/build/dmaster/web/sites/all/modules/civicrm/vendor/pear/mail/Mail/smtp.php(258): Mail_smtp->send_or_fail((Array:1), (Array:10), NULL)
#6 /home/jon/local/civicrm-buildkit/build/dmaster/web/sites/all/modules/civicrm/CRM/Utils/Mail/FilteredPearMailer.php(68): Mail_smtp->send((Array:1), (Array:10), NULL)
#7 /home/jon/local/civicrm-buildkit/build/dmaster/web/sites/all/modules/civicrm/CRM/Utils/Mail.php(303): CRM_Utils_Mail_FilteredPearMailer->send((Array:1), (Array:10), NULL)
#8 /home/jon/local/civicrm-buildkit/build/dmaster/web/sites/all/modules/civicrm/CRM/Activity/BAO/Activity.php(1538): CRM_Utils_Mail::send((Array:10))
#9 /home/jon/local/civicrm-buildkit/build/dmaster/web/sites/all/modules/civicrm/CRM/Activity/BAO/Activity.php(1236): CRM_Activity_BAO_Activity::sendMessage("\"a a\" <adminnnnn@zabuntu.lan>", "202", "205", "test2", "", "", "onddddd@zabuntu.lan", 630, (Array:0), "", "")
#10 /home/jon/local/civicrm-buildkit/build/dmaster/web/sites/all/modules/civicrm/CRM/Contact/Form/Task/EmailTrait.php(431): CRM_Activity_BAO_Activity::sendEmail((Array:1), "test2", "", "", "onddddd@zabuntu.lan", "202", "\"a a\" <adminnnnn@zabuntu.lan>", (Array:0), "", "", (Array:1), "", (Array:0), NULL, NULL)
#11 /home/jon/local/civicrm-buildkit/build/dmaster/web/sites/all/modules/civicrm/CRM/Contact/Form/Task/EmailTrait.php(351): CRM_Contact_Form_Task_Email->submit((Array:19))
#12 /home/jon/local/civicrm-buildkit/build/dmaster/web/sites/all/modules/civicrm/CRM/Core/Form.php(505): CRM_Contact_Form_Task_Email->postProcess()
#13 /home/jon/local/civicrm-buildkit/build/dmaster/web/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Upload.php(152): CRM_Core_Form->mainProcess()
#14 /home/jon/local/civicrm-buildkit/build/dmaster/web/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Upload.php(119): CRM_Core_QuickForm_Action_Upload->realPerform(Object(CRM_Contact_Form_Task_Email), "upload")
#15 /home/jon/local/civicrm-buildkit/build/dmaster/web/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Upload->perform(Object(CRM_Contact_Form_Task_Email), "upload")
#16 /home/jon/local/civicrm-buildkit/build/dmaster/web/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Contact_Form_Task_Email), "upload")
#17 /home/jon/local/civicrm-buildkit/build/dmaster/web/sites/all/modules/civicrm/CRM/Core/Controller.php(347): HTML_QuickForm_Page->handle("upload")
#18 /home/jon/local/civicrm-buildkit/build/dmaster/web/sites/all/modules/civicrm/CRM/Utils/Wrapper.php(98): CRM_Core_Controller->run()
#19 /home/jon/local/civicrm-buildkit/build/dmaster/web/sites/all/modules/civicrm/CRM/Core/Invoke.php(285): CRM_Utils_Wrapper->run("CRM_Contact_Form_Task_Email", "Activities", (Array:1))
#20 /home/jon/local/civicrm-buildkit/build/dmaster/web/sites/all/modules/civicrm/CRM/Core/Invoke.php(68): CRM_Core_Invoke::runItem((Array:14))
#21 /home/jon/local/civicrm-buildkit/build/dmaster/web/sites/all/modules/civicrm/CRM/Core/Invoke.php(36): CRM_Core_Invoke::_invoke((Array:4))
#22 /home/jon/local/civicrm-buildkit/build/dmaster/web/sites/all/modules/civicrm/drupal/civicrm.module(456): CRM_Core_Invoke::invoke((Array:4))
#23 /home/jon/local/civicrm-buildkit/build/dmaster/web/includes/menu.inc(527): civicrm_invoke("activity", "email", "add")
#24 /home/jon/local/civicrm-buildkit/build/dmaster/web/index.php(21): menu_execute_active_handler()
#25 {main}
```5.27.4https://lab.civicrm.org/dev/core/-/issues/3589Report on scheduled mailing fails with Notice: Undefined property: CRM_Mailin...2022-06-11T14:55:03ZspalmstromReport on scheduled mailing fails with Notice: Undefined property: CRM_Mailing_BAO_Mailing::$mailing_job_start_date in <joomla_root>/administrator/components/com_civicrm/civicrm/CRM/Mailing/BAO/Mailing.php on line 2031This occurs in Joomla after upgrading to CiviCRM 5.19.0. Line 175 in /administrator/components/com_civicrm/civicrm/CRM/Mailing/DAO/MailingJob.php should read:
'start_date' => [
not
'mailing_job_start_date' => [This occurs in Joomla after upgrading to CiviCRM 5.19.0. Line 175 in /administrator/components/com_civicrm/civicrm/CRM/Mailing/DAO/MailingJob.php should read:
'start_date' => [
not
'mailing_job_start_date' => [5.19.1https://lab.civicrm.org/dev/core/-/issues/3575regression (unreleased I think)2022-06-11T14:54:36Zeileenregression (unreleased I think)Sites with CiviMember disabled cannot create relations
Issue is getContactMembershipCount now checks permissions but on sites with civimember disabled the required permissions will not be held
This regressed due to recent changes in th...Sites with CiviMember disabled cannot create relations
Issue is getContactMembershipCount now checks permissions but on sites with civimember disabled the required permissions will not be held
This regressed due to recent changes in this function but I think the fix is not to call it when civimember is disabled5.35.0https://lab.civicrm.org/dev/core/-/issues/3571OAUTH2 account creation broken2023-04-07T13:52:55ZDaveDOAUTH2 account creation brokenhttps://civicrm.stackexchange.com/questions/40773/cant-add-gmail-account-with-oauth
On the mail accounts page there's no add dropdown just the usual regular add button.
PR cominghttps://civicrm.stackexchange.com/questions/40773/cant-add-gmail-account-with-oauth
On the mail accounts page there's no add dropdown just the usual regular add button.
PR coming5.44.0https://lab.civicrm.org/dev/core/-/issues/3564All unsubscribe group members are excluded from a mailing with a manually spe...2022-06-11T14:54:11ZlolcodeAll unsubscribe group members are excluded from a mailing with a manually specified unsubscribe group (group_type=Base) if the unsubscribe group is a Smart groupAll unsubscribe group members are excluded from a mailing with a manually specified unsubscribe group (group_type=Base) if the unsubscribe group is a Smart group.
**To reproduce:** Create a smart group with some members in it. Some mem...All unsubscribe group members are excluded from a mailing with a manually specified unsubscribe group (group_type=Base) if the unsubscribe group is a Smart group.
**To reproduce:** Create a smart group with some members in it. Some members may also be added and removed manually as usual. Search for some contacts including some who are in that smart group and choose the action to send/schedule a bulk email. When creating the mail select the Smart group as your unsubscribe group.
**The expected result:** The mailing is not sent to any contacts in the search who are in the smart un-subscribe group with the status "Removed".
**The result:** The mailing is not sent to any contacts in the search who are in the smart un-subscribe group at all.5.2.0https://lab.civicrm.org/dev/core/-/issues/3561CiviMail stopped sending email after upgrade to CiviCRM 5.432022-06-11T14:53:42Zlishaw1968lshaw@lacliniquefinanciere.comCiviMail stopped sending email after upgrade to CiviCRM 5.43CiviMail does not send test email after upgrade to CiviCRM 5.43CiviMail does not send test email after upgrade to CiviCRM 5.435.43.1https://lab.civicrm.org/dev/core/-/issues/3554On 'New Mailing' review page, it doesn't show recipients count2022-06-11T14:50:56ZMonish DebOn 'New Mailing' review page, it doesn't show recipients countSimply visit the second page of `New Mailing` and you will notice that 'Recipients' section has an inappropriate message instead of recipient count.
## Context
This appears to be a regression in 4.7.31. Related PR - https://github.com/...Simply visit the second page of `New Mailing` and you will notice that 'Recipients' section has an inappropriate message instead of recipient count.
## Context
This appears to be a regression in 4.7.31. Related PR - https://github.com/civicrm/civicrm-core/pull/110915.0.0Monish DebMonish Deb