CiviCRM Core issueshttps://lab.civicrm.org/dev/core/-/issues2022-08-13T13:33:41Zhttps://lab.civicrm.org/dev/core/-/issues/3712Errors with multiple-contact reference field handling2022-08-13T13:33:41ZAdam WoodErrors with multiple-contact reference field handlingFurther to #2939, another issue has come to light with the way CiviCRM core handles contact reference fields with multiple selection.
In `_civicrm_api3_custom_data_get()`, the possibility of multiple selection is not allowed for. This m...Further to #2939, another issue has come to light with the way CiviCRM core handles contact reference fields with multiple selection.
In `_civicrm_api3_custom_data_get()`, the possibility of multiple selection is not allowed for. This means that an array of values can be passed to `CRM_Core_DAO::getFieldValue()` which fails because it expects a scalar `$searchValue`.
```php
// Shim to restore legacy behavior of ContactReference custom fields
if (!empty($fieldInfo[$id]) && $fieldInfo[$id]['data_type'] === 'ContactReference') {
$returnArray['custom_' . $id . '_id'] = $returnArray[$key . '_id'] = $val;
$returnArray['custom_' . $id] = $returnArray[$key] = CRM_Core_DAO::getFieldValue('CRM_Contact_DAO_Contact', $val, 'sort_name');
}
```
You also get a PHP warning `Warning: Illegal offset type`, and on PHP 8 this would result in a fatal error.
Suggested modification to code:
```php
// Shim to restore legacy behavior of ContactReference custom fields
if (!empty($fieldInfo[$id]) && $fieldInfo[$id]['data_type'] === 'ContactReference') {
$returnArray['custom_' . $id . '_id'] = $returnArray[$key . '_id'] = $val;
if (is_array($val)) {
$lookupValues = [];
foreach ($val as $contactId) {
$lookupValues[] = CRM_Core_DAO::getFieldValue('CRM_Contact_DAO_Contact', $contactId, 'sort_name');
}
$returnArray['custom_' . $id] = $returnArray[$key] = $lookupValues;
}
else {
$returnArray['custom_' . $id] = $returnArray[$key] = CRM_Core_DAO::getFieldValue('CRM_Contact_DAO_Contact', $val, 'sort_name');
}
}
```5.53.0https://lab.civicrm.org/dev/core/-/issues/3710Grants not shown for contact2022-08-02T04:13:05ZAdam WoodGrants not shown for contactSince the migration of CiviGrant to an extension, grants are no longer showing for a contact:
![image](/uploads/724db8ea7bf8523e2de84820d5aa4411/image.png)
This has been observed persistently on versions 5.47.3 and 5.50.4. I have tried v...Since the migration of CiviGrant to an extension, grants are no longer showing for a contact:
![image](/uploads/724db8ea7bf8523e2de84820d5aa4411/image.png)
This has been observed persistently on versions 5.47.3 and 5.50.4. I have tried various obvious things e.g. purging caches, disabling / re-enabling CiviGrant.https://lab.civicrm.org/dev/core/-/issues/3709Feature request - Filter case activities to only activity types in civicase2022-07-08T04:10:23ZkristinecFeature request - Filter case activities to only activity types in civicaseOverview
----------------------------------------
When viewing a case, users should only be able to filter on activity types available to the civicase.
Example use-case
----------------------------------------
1. Find any case and click...Overview
----------------------------------------
When viewing a case, users should only be able to filter on activity types available to the civicase.
Example use-case
----------------------------------------
1. Find any case and click on "Manage". Or, just view a contact's case.
2. Click on Search Filters to expand options. See Activity type dropdown (see attached image)![case_activity_filter](/uploads/57d7278ac571f0db3e2aa2632f8204fa/case_activity_filter.png).
Current behaviour
----------------------------------------
Currently, click on the Activity Type dropdown will list all activity types in civicase.
Proposed behaviour
----------------------------------------
Users should only be able to see activity types that are part of the case. For example: here's two case types with their activity types:
Housing Support: Medical evaluation, secure temporary housing
Adult Day Care Referral: Medical evaluation, mental health evaluation, ADC referral
When viewing John Doe's "Housing Support" case, it doesn't seem to make sense that users can filter on the activity type "ADC referral" if this activity type will never appear on this case. The "ADC referral" was not added as an option in the "Housing Support" case.
Comments
----------------------------------------
Not sure if this would be considered an extension or part of civicore. Also, wouldn't mind marking this as a paid issue in case others might be interested in contributing.5.52.0https://lab.civicrm.org/dev/core/-/issues/3708Feature request - Add link type to case activity setup2024-03-10T05:03:23ZkristinecFeature request - Add link type to case activity setupOverview
----------------------------------------
In CiviCase, create an option to add an internal/external link on the list of activity types.
Example use-case
----------------------------------------
1. Click on **Administer -> CiviC...Overview
----------------------------------------
In CiviCase, create an option to add an internal/external link on the list of activity types.
Example use-case
----------------------------------------
1. Click on **Administer -> CiviCase -> Case Types -> Edit Housing Support**.
2. Click on **Activity Types** tab
Current behaviour
----------------------------------------
Currently, admins can only add activity types in civicrm (using the "Add activity type" dropdown).
Proposed behaviour
----------------------------------------
Admin users could really benefit from an "add link type" setting. I propose two fields: title and path/url. This would allow admins to link to webforms/afforms in the future for additional data entry but leveraging their features (e.g., conditional fields, layout control, etc.). For example, user clicks on a case and in the dropdown, sees "Benefits Evaluation", but this is an internal path link rather than a civicase form.
Comments
----------------------------------------
Not sure if this would be considered an extension or part of civicore. Also, wouldn't mind marking this as a paid issue in case others might be interested in contributing![Link_Type](/uploads/fb77e6502f97f54e0ef323cd6abaf71e/Link_Type.png).https://lab.civicrm.org/dev/core/-/issues/3707Rc import with Wordpress goes to the right url but doesn't 'refresh'2022-07-05T15:47:07ZeileenRc import with Wordpress goes to the right url but doesn't 'refresh'After doing an import in WP the queue runner seems to redirect to the right url but doesn't seem to refresh to it - see how the url is correct but the page below it is the civicrm homepage
![image](/uploads/dd1c1ac79bfac977086c271c762f1...After doing an import in WP the queue runner seems to redirect to the right url but doesn't seem to refresh to it - see how the url is correct but the page below it is the civicrm homepage
![image](/uploads/dd1c1ac79bfac977086c271c762f1ea6/image.png)
If I hit enter on the url I get
![image](/uploads/badd5f37ab99e3e3b6d99474f055a938/image.png)5.51.0https://lab.civicrm.org/dev/core/-/issues/3706RC regression: Valid URLs failing URL validation2022-09-29T14:42:49ZJonGoldRC regression: Valid URLs failing URL validation### Steps to replicate
* Have `php-intl` installed.
* On the master branch, try adding this website to a contact:
```
https://mysite.org/index.php/apps/files/?dir=/Talk/Test%20Folder1/Test%20Folder%202&fileid=597195
```
On 5.50, this sa...### Steps to replicate
* Have `php-intl` installed.
* On the master branch, try adding this website to a contact:
```
https://mysite.org/index.php/apps/files/?dir=/Talk/Test%20Folder1/Test%20Folder%202&fileid=597195
```
On 5.50, this saves correctly, on master branch it fails validation.
In [PR 23755](https://github.com/civicrm/civicrm-core/pull/23755) URL validation uses `idn_to_ascii` ([CRM_Utils_Rule line 224](https://github.com/eileenmcnaughton/civicrm-core/blob/8b3f43f48bdc91c7ed07237f2d8ef1033ffe24b2/CRM/Utils/Rule.php#L224)).JonGoldJonGoldhttps://lab.civicrm.org/dev/core/-/issues/3704APIv4 'Invalid field' but really permission problem2024-03-07T05:03:20Zaydunsaidan.saunders@squiffle.ukAPIv4 'Invalid field' but really permission problemI used APIv4 Explorer to create this:
```
$results = \Civi\Api4\Email::update()
->addValue('on_hold', 0)
->addWhere('email', '=', 'test@example.org')
->addWhere('contact_id.is_deleted', '=', FALSE)
->addWhere('on_hold', '=', 1)
...I used APIv4 Explorer to create this:
```
$results = \Civi\Api4\Email::update()
->addValue('on_hold', 0)
->addWhere('email', '=', 'test@example.org')
->addWhere('contact_id.is_deleted', '=', FALSE)
->addWhere('on_hold', '=', 1)
->execute();
```
I copied it into a script, ran it and got the message:
```
Invalid field 'contact_id.is_deleted'
```
That caused a bit of head-scratching and double-checking I hadn't got weird characters in there until trying `update(FALSE)` - it worked.
An error message about lack of permission would be much more helpful than the current 'Invalid field'.
CiviCRM: 5.50.3https://lab.civicrm.org/dev/core/-/issues/37015.51 - Import - Notice error on map fields form2023-03-20T10:09:00Ztschuettler5.51 - Import - Notice error on map fields formReproduction steps
----------------------------------------
1. Enable Debugging: https://dmaster.demo.civicrm.org/civicrm/admin/setting/debug?reset=1
1. Import a contact
1. Got an e-notice on the match fields forms: `Notice: Undefined i...Reproduction steps
----------------------------------------
1. Enable Debugging: https://dmaster.demo.civicrm.org/civicrm/admin/setting/debug?reset=1
1. Import a contact
1. Got an e-notice on the match fields forms: `Notice: Undefined index: isCheked in include() (line 35 of /srv/buildkit/build/dmaster/web/sites/default/files/civicrm/templates_c/en_US/%%72/72E/72E39105%%MapField.tpl.php).`
Current behaviour
----------------------------------------
The e-notice will appear regardless whether a saved field mapping is used or not.
Forcing an form validiation when trying to go to the preview form will not show the e-notice, since the form rule will set the template variable.
Expected behaviour
----------------------------------------
No e-notice shown.
Comments
----------------------------------------
I can reproduce this with 5.50.4 and since there don't seem to be any recent change, I would assume that it is no (recent) regression.
I can't wrap my head around, what the javascript in https://github.com/civicrm/civicrm-core/blob/4a01628cfa19ac305b5734e8ea36713f363b8d91/templates/CRM/Contact/Import/Form/MapField.tpl#L24-L34 is actually supposed to achieve, but here is an uneducated fix for making the e-notice go away: https://github.com/civicrm/civicrm-core/pull/239065.61.0https://lab.civicrm.org/dev/core/-/issues/3700Search Kit: More options on field transformations of a Date Field2023-02-16T16:00:40ZGhost UserSearch Kit: More options on field transformations of a Date FieldOverview
----------------------------------------
We are trying to replicate the behaviour that the Contribution Summary Report has. We want the Search Kit to be able to group by Month and Year. As in the image below:
![image](/uploads/...Overview
----------------------------------------
We are trying to replicate the behaviour that the Contribution Summary Report has. We want the Search Kit to be able to group by Month and Year. As in the image below:
![image](/uploads/681b1ed526a0554aa11029b7dae99034/image.png)
Current behaviour
----------------------------------------
Currently, in v.5.52, you can group by by Month.
![image](/uploads/53a95111430b13d4b44d69317d62d059/image.png)
But when showing the results it shows just a date instead of showing just the Month.
![image](/uploads/a4286678845bd0ffae98cc3d88569fe7/image.png)
This happens because in field transformations there is no option of selecting what to show in a Date Field. Currently only Aggregation options are showed, so it is treated as an integer.
![image](/uploads/a4f5a3c8ae92343f3cf18504bf7cecde/image.png)
Proposed behaviour
----------------------------------------
In field transformation it should show different options that let you choose what to show. For example, select between Day/Month/Year so that the column is showed as the Contribution Summary Report.https://lab.civicrm.org/dev/core/-/issues/3699CRM-12989 Editing memberships, contributions, event registrations or contact ...2024-02-29T05:03:25Zjustinfreeman (Agileware)CRM-12989 Editing memberships, contributions, event registrations or contact profile in multiple tabs replaces dataReviving an Jira Bug Report which is marked "In progress" and still causing issues for users today. See https://issues.civicrm.org/jira/browse/CRM-12989
> When you have memberships being edited in multiple tabs the information from one ...Reviving an Jira Bug Report which is marked "In progress" and still causing issues for users today. See https://issues.civicrm.org/jira/browse/CRM-12989
> When you have memberships being edited in multiple tabs the information from one will replace another.
>
> To replicate (this works on the current demo)
>
> 1. Access Memberships dashboard
> 2. For one record (A) right click 'edit' and open into a new tab
> 3. Then for another record (B) right click 'edit' and open into a new tab
> 4. Go to the tab for record A, make no changes and press 'Save'
>
> After doing the above you will see all of the details (Level, Date, Source, Since, Start/End Dates) for record A will be saved to B along with the success message displaying you have successfully updated the record for the name of record B.
>
> I'm assuming this is some kind of session error but it's a major error that we've just discovered on a client's setup that has caused membership records to now have the wrong levels set.
Relates to https://lab.civicrm.org/documentation/docs/user-en/-/issues/347https://lab.civicrm.org/dev/core/-/issues/3698Too many custom groups2024-03-08T05:03:22ZkristinecToo many custom groupsTwo years ago, I reported an issue with "too many custom fields" [Issue #1330](https://lab.civicrm.org/dev/core/-/issues/1330). It seems that I have now surpass the limit for the **custom groups** instead of _custom fields_. If I add cus...Two years ago, I reported an issue with "too many custom fields" [Issue #1330](https://lab.civicrm.org/dev/core/-/issues/1330). It seems that I have now surpass the limit for the **custom groups** instead of _custom fields_. If I add custom group number 94, accessing some cases produces an error "case_id is not valid : 1.". Keeping the number of custom groups at 93 removes the error.https://lab.civicrm.org/dev/core/-/issues/3697libxml_disable_entity_loader is deprecated in php8, which comes up if your sy...2022-06-29T12:34:47ZDaveDlibxml_disable_entity_loader is deprecated in php8, which comes up if your system temp dir has spaces in the pathIt's a little confusing. And it's not really a civi issue. I should post this over at symfony, but in case anyone else comes up against it here it is. It may or may not be more common on windows, where the temp folder might be something ...It's a little confusing. And it's not really a civi issue. I should post this over at symfony, but in case anyone else comes up against it here it is. It may or may not be more common on windows, where the temp folder might be something like `C:\users\ACME Widgets\Appdata\Local\Temp`, as opposed to `/tmp`.
The version of symfony/dependency-injection that ships with core is 3.4. It includes a simple guard, so that it only calls libxml_disable_entity_loader based on libxml version. https://github.com/symfony/dependency-injection/blob/3.4/Loader/XmlFileLoader.php#L623. So spaces are irrelevant.
In 4.3, dependency-injection removes this guard, but leaves it calling libxml_disable_entity_loader ALWAYS.
In 4.4, they added a fancier guard. Since drupal 9+ ends up with v4.4 (at least for me, and it seems for [E2E tests too]( https://test.civicrm.org/job/CiviCRM-D8-Matrix/905/BKPROF=max,BLDTYPE=drupal9-clean,CIVIVER=master,SUITES=phpunit-e2e,label=bknix-tmp/consoleText)), everything's ok as long as there's no spaces in the path.
In php8, what happens is shouldEnableEntityLoader() ends up returning true anyway, because the little test that function is doing fails validation when there's spaces, i.e. `<xsd:include schemaLocation="file:///'.str_replace('\\', '/', $tmpfile).'" />` doesn't give a correct encoding for the schemaLocation.
It comes up for example when creating the container, e.g. after clearing cache.
And it's the same code in symfony in v5 and v6.https://lab.civicrm.org/dev/core/-/issues/3696Should MessageTemplate.send support tplParams with Smarty disabled?2024-03-09T05:03:24ZRichShould MessageTemplate.send support tplParams with Smarty disabled?The api3 MessageTemplate.send action has supported `tplParams` since its inception in 2013, exposed explicitly in the api spec since 2015.
They allow a way to specify content for arbitrary email template parameters: `{$paramname}` - whi...The api3 MessageTemplate.send action has supported `tplParams` since its inception in 2013, exposed explicitly in the api spec since 2015.
They allow a way to specify content for arbitrary email template parameters: `{$paramname}` - which are different to `[entity.tokens]`. It's **super useful** for transactional mail where you want to include extra info as a one-off.
The api has done this by assigning the given key value pairs as Smarty variables.
More recently (2020) the api action added support for disabling Smarty, since it wasn't playing nicely with message template content generated by Mosaico.
Without Smarty, `tplParams` does not work.
## I would like to see support for `tplParams` without Smarty.
I think the concept of a message template is that it is a flexible template for emails. (Adding token support for one-off context-sensitive use-cases is very inefficient and is likely to end up with hackish situations where the data that needs to be in the email does not need to be in the database.)
I mistakenly thought that it used to work this way, and so I wrote a PR to fix what I saw as a regression, adding tests to boot. https://github.com/civicrm/civicrm-core/pull/19062 however this stalled, because it turns out it wasn't a regression, and so was felt to need more discussion. Hence this post.
The PR is a minor change and I can't see that it has any negative consequences/side effects (very few people will disable smarty anyway), but it does mean the tplParams feature is supported with/out Smarty, which I think is valuable.
There could be nicer ways to specify such content, but this isn't a proposal about a whole new way of doing things.
Thoughts?https://lab.civicrm.org/dev/core/-/issues/3694Get offline contribution-receipt fully working with preview screen2024-03-18T05:03:27ZeileenGet offline contribution-receipt fully working with preview screenThere is a long-term goal to get all templates working in the preview screen. This focusses on the backoffice contribution receipt.
Aside from the Usability benefit the process adds test cover and will eventually allow us to remove a si...There is a long-term goal to get all templates working in the preview screen. This focusses on the backoffice contribution receipt.
Aside from the Usability benefit the process adds test cover and will eventually allow us to remove a significant amount of unreliable and hard-to-read code (even the first PR wound up removing some data leakage). It also means the templates can be fired form outside the forms and separates the logic from the forms - which is important for alternate form layers
This involves that all variables in it can be provided by the workflow-template / example combo
- [ ] `$lineItem` -> supported variable -> `$lineItems` https://github.com/civicrm/civicrm-core/pull/23870
- [ ] `$getTaxDetails` - no longer used in default template https://github.com/civicrm/civicrm-core/pull/23870
- [ ] `$dataArray` -> supported variable -> `$taxRateBreakdown` https://github.com/civicrm/civicrm-core/pull/23870
- [ ] Amount before Tax - add a new token for this & use that - it is `{contribution.total_amount}` - `{contribution.tax_amount}` & can be added at apiv4 level - similar to https://github.com/civicrm/civicrm-core/pull/23802
- [ ] `$ccContribution`, `$formValues.hidden_CreditCard` - probably of marginal value - check the specific values instead before displaying or not
- [ ] `$billingName`, `$address` - add billing tokens - builds on https://github.com/civicrm/civicrm-core/pull/23845
- [ ] `$credit_card_type`, `$credit_card_number`, `$credit_card_exp_date` - potentially Payment tokens?
- [ ] `$customGroup` - propose removal https://lab.civicrm.org/dev/core/-/issues/3693
- [ ] `$softCreditTypes` `$softCredits` - fix is similar to line items - keep but rationalise & handle in WorkFlow Template
- [ ] `$formValues.product_name`, `$formValues.product_name`, `$formValues.product_option`, `$formValues.product_sku` `$fulfilled_date` - fix is similar to line items - keep but rationalise & handle in WorkFlow Template
Note `$formValues.receipt_text` REALLY IS tied to the form - as it is not stored in the DB - so that is an appropriate use of formValues.https://lab.civicrm.org/dev/core/-/issues/3693Proposal - remove `CustomGroups` section from default contribution backoffice...2024-03-05T05:03:25ZeileenProposal - remove `CustomGroups` section from default contribution backoffice receiptI'm proposing we remove the following chunk of code from the back-office contribution receipt where it has not been customised
```
{if !empty($customGroup)}
{foreach from=$customGroup item=value key=customName}
<tr>
...I'm proposing we remove the following chunk of code from the back-office contribution receipt where it has not been customised
```
{if !empty($customGroup)}
{foreach from=$customGroup item=value key=customName}
<tr>
<th {$headerStyle}>
{$customName}
</th>
</tr>
{foreach from=$value item=v key=n}
<tr>
<td {$labelStyle}>
{$n}
</td>
<td {$valueStyle}>
{$v}
</td>
</tr>
{/foreach}
{/foreach}
{/if}
```
This code adds details about all the custom fields associated with the contribution. For many sites this is not an issue as there are none :-)
However, for those that have contribution custom fields there are generally a mix of fields that are public facing and private facing (I've seen organisations accidentally send out commission information in the past).
It is now possible to use contribution tokens in all contribution workflow templates so the idea would be that
- if the offline template is uncustomised and the site has contribution custom fields they get a pre-upgrade message
- the message would say that if they upgrade the above section will be removed & emails would not have custom field information going forwards and point them to version-specific-upgrade-docs
- the upgrade docs would offer two options (not recommended) - put back the above block, which may not be supported forever or (recommended) construct the fields they want with tokens on the 'pdf letter for contributions screen' and copy it backhttps://lab.civicrm.org/dev/core/-/issues/3692Replace all calls to deprecated method CRM_Core_PseudoConstant::activityType()2024-03-11T05:03:24ZherbdoolReplace all calls to deprecated method CRM_Core_PseudoConstant::activityType()There are calls to `CRM_Core_PseudoConstant::activityType()` (deprecated) in many places such as `$activityTypes = CRM_Core_PseudoConstant::activityType(TRUE, FALSE, FALSE, 'name');` ~~but the actual method accepts no parameters. And cha...There are calls to `CRM_Core_PseudoConstant::activityType()` (deprecated) in many places such as `$activityTypes = CRM_Core_PseudoConstant::activityType(TRUE, FALSE, FALSE, 'name');` ~~but the actual method accepts no parameters. And changes to that method predate the migration from SVN... so some guesswork needs to be done~~.
Update: oops I just noticed it has `func_get_args()` so it is accepting parameters after all.
In some cases it seems that it can be replaced with `CRM_Core_PseudoConstant::getKey('CRM_Activity_BAO_Activity', 'activity_type_id', 'ACTIVITYNAME')` but in other cases it actually does need a list of activity types. And in some cases needs to filter out disabled components, which is what the original method is doing.https://lab.civicrm.org/dev/core/-/issues/3691Improve code comments for Activity: parent_id and source_record_id2022-06-25T11:47:09ZherbdoolImprove code comments for Activity: parent_id and source_record_idI've done some investigating of the codebase to try to figure out what two columns for Activity entity are for and whether I can. I think I've figured it mostly out but not sure where to document. At the very least I'll improve the comme...I've done some investigating of the codebase to try to figure out what two columns for Activity entity are for and whether I can. I think I've figured it mostly out but not sure where to document. At the very least I'll improve the comments in the codebase. We don't seem to have a section in the dev guide to deal with this.
So if someone creates a generic activity and schedules a follow-up, the new follow-up activity references the first activity in `parent_id` column. Then assigning it to a contact will send an email to that contact and create an activity. And that activity references the follow-up activity in the source_record_id column. I haven't found much documentation yet, except in the parent_id column description where it says that it's for "follow-up items" but claims that it is "not currently implemented." Hm...
The description of `source_record_id` also seems to be the only documentation:
> Artificial FK to original transaction (e.g. contribution) IF it is not an Activity. Table can be figured out through activity_type_id, and further through component registry.
As far as I can tell, "table can be figured out", means just checking for particular activity types before trying to figure out the "FK", and assuming the code creating the activity assigned the `activity_type_id` properly.
I'm not really sure what "component registry" means here. As far as I can tell from the code, the component doesn't matter. It's only based on checking the right `activity_type_id`.
If Activity was created fresh now I'm guessing it would have gotten entity_table and entity_id instead of this older approach?5.52.0https://lab.civicrm.org/dev/core/-/issues/3690Form Builder/Search Kit: Date filters do not work when picking dates2022-09-03T14:27:07ZJonGoldForm Builder/Search Kit: Date filters do not work when picking datesWhen creating a Form Builder form based on a Search Kit, the "Receive Date" filter doesn't work if you use "Pick Date".
### Steps to Replicate
* Create a SK that groups Contributions by Financial Type, and displays a count of IDs and a ...When creating a Form Builder form based on a Search Kit, the "Receive Date" filter doesn't work if you use "Pick Date".
### Steps to Replicate
* Create a SK that groups Contributions by Financial Type, and displays a count of IDs and a sum of Total Amount. Screenshot and exported SK are below.
* Embed the search in a Form Builder form, and add a "Date Received" filter. Screenshot and afform markup below.
* Use the form to filter by *Date Received* is **This calendar year**. Observe that it filters correctly.
* Change the *Date Received* to **Choose Date Range** and select 1/1/2022-12/31/2022 (or just 1/1/2022-today).
### Expected Result
Same as filtering by "This calendar year".
![Selection_1547](/uploads/55fa1017e814c8d80fb0071eb75eee49/Selection_1547.png)
### Actual Result
Date filter is ignored.
![Selection_1548](/uploads/bb092e9b7871e36fae3a385df6c68a72/Selection_1548.png)
#### Search Kit
![Selection_1545](/uploads/0aeaa229651b9a46e24c1aff105727e7/Selection_1545.png)
```
[
{
"name": "SavedSearch_date_test",
"entity": "SavedSearch",
"cleanup": "unused",
"update": "unmodified",
"params": {
"version": 4,
"values": {
"name": "date_test",
"label": "date test",
"form_values": null,
"mapping_id": null,
"search_custom_id": null,
"api_entity": "Contribution",
"api_params": {
"version": 4,
"select": [
"COUNT(id) AS COUNT_id",
"SUM(total_amount) AS SUM_total_amount"
],
"orderBy": [],
"where": [],
"groupBy": [
"financial_type_id"
],
"join": [],
"having": []
},
"expires_date": null,
"description": null
}
}
}
]
```
#### Form Builder
![Selection_1546](/uploads/333e237b15b1c16742d67c40cf453d7c/Selection_1546.png)
```
<div af-fieldset="">
<af-field name="receive_date" defn="{input_type: 'Select', search_range: true, input_attrs: {}}" />
<crm-search-display-table search-name="date_test" display-name=""></crm-search-display-table>
</div>
```colemanwcolemanwhttps://lab.civicrm.org/dev/core/-/issues/3689error upgrading from CiviCRM 5.36.0 to 5.50.3.2022-06-26T23:17:29Zcaliginouserror upgrading from CiviCRM 5.36.0 to 5.50.3.--previously posted on stackexchange, no replies - https://civicrm.stackexchange.com/q/42177/5858
I'm on wordpress 6.0, linux, upgrading from CiviCRM 5.36.0 to 5.50.3.
When I try and run the upgrade script i.e. wp-admin/admin.php?page=...--previously posted on stackexchange, no replies - https://civicrm.stackexchange.com/q/42177/5858
I'm on wordpress 6.0, linux, upgrading from CiviCRM 5.36.0 to 5.50.3.
When I try and run the upgrade script i.e. wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fupgrade&reset=1
I get the following error in my debug log and the upgrade fails:
Current behaviour
----------------------------------------
```
Jun 22 20:55:28 [error] $Fatal Error Details = Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => exceptionHandler
)
[code] => -14
[message] => DB Error: no database selected
[mode] => 16
[debug_info] => SELECT *
FROM `civicrm_component`
[nativecode=2006 ** MySQL server has gone away]
[type] => DB_Error
[user_info] => SELECT *
FROM `civicrm_component`
[nativecode=2006 ** MySQL server has gone away]
[to_string] => [db_error: message="DB Error: no database selected" code=-14 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="SELECT *
FROM `civicrm_component`
[nativecode=2006 ** MySQL server has gone away]"]
)
Jun 22 20:56:14 [debug] $backTrace = #0 /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(954): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /var/www/html/wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(922): CRM_Core_Error::exceptionHandler(Object(DB_Error))
#2 /var/www/html/wp-content/plugins/civicrm/civicrm/vendor/pear/db/DB.php(997): PEAR_Error->__construct("DB Error: no database selected", -14, 16, (Array:2), "SELECT * \n FROM `civicrm_component` \n \n \n \n \n \n [nativecode=2006 *...")
#3 /var/www/html/wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(575): DB_Error->__construct(-14, 16, (Array:2), "SELECT * \n FROM `civicrm_component` \n \n \n \n \n \n [nativecode=2006 *...")
#4 /var/www/html/wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(223): PEAR::_raiseError(Object(DB_mysqli), NULL, -14, 16, (Array:2), "SELECT * \n FROM `civicrm_component` \n \n \n \n \n \n [nativecode=2006 *...", "DB_Error", TRUE)
#5 /var/www/html/wp-content/plugins/civicrm/civicrm/vendor/pear/db/DB/common.php(1928): PEAR->__call("raiseError", (Array:7))
#6 /var/www/html/wp-content/plugins/civicrm/civicrm/vendor/pear/db/DB/mysqli.php(936): DB_common->raiseError(-14, NULL, NULL, "SELECT * \n FROM `civicrm_component` \n \n \n \n \n \n [nativecode=2006 *...", "2006 ** MySQL server has gone away")
#7 /var/www/html/wp-content/plugins/civicrm/civicrm/vendor/pear/db/DB/mysqli.php(391): DB_mysqli->mysqliRaiseError(-14)
#8 /var/www/html/wp-content/plugins/civicrm/civicrm/vendor/pear/db/DB/common.php(1234): DB_mysqli->simpleQuery("SELECT * \n FROM `civicrm_component` \n \n \n \n \n \n")
#9 /var/www/html/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(2696): DB_common->query("SELECT * \n FROM `civicrm_component` \n \n \n \n \n \n")
#10 /var/www/html/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(451): DB_DataObject->_query("SELECT * \n FROM `civicrm_component` \n \n \n \n \n \n")
#11 /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Core/Component.php(74): DB_DataObject->find(FALSE)
#12 /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Core/Component.php(37): CRM_Core_Component::getComponents()
#13 /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Core/Component.php(116): CRM_Core_Component::_info(FALSE)
#14 /var/www/html/wp-content/plugins/civicrm-admin-utilities/includes/civicrm-admin-utilities-single.php(2269): CRM_Core_Component::getEnabledComponents()
#15 /var/www/html/wp-includes/class-wp-hook.php(307): CiviCRM_Admin_Utilities_Single->shortcuts_menu_add(Object(WP_Admin_Bar))
#16 /var/www/html/wp-includes/class-wp-hook.php(331): WP_Hook->apply_filters(NULL, (Array:1))
#17 /var/www/html/wp-includes/plugin.php(524): WP_Hook->do_action((Array:1))
#18 /var/www/html/wp-includes/admin-bar.php(95): do_action_ref_array("admin_bar_menu", (Array:1))
#19 /var/www/html/wp-includes/class-wp-hook.php(307): wp_admin_bar_render("")
#20 /var/www/html/wp-includes/class-wp-hook.php(331): WP_Hook->apply_filters("", (Array:1))
#21 /var/www/html/wp-includes/plugin.php(476): WP_Hook->do_action((Array:1))
#22 /var/www/html/wp-admin/admin-header.php(267): do_action("in_admin_header")
#23 /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Utils/System/Base.php(312): require_once("/var/www/html/wp-admin/admin-header.php")
#24 /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Utils/System.php(202): CRM_Utils_System_Base->theme("<div id=\"crm-container\" class=\"crm-container\" lang=\"en\" xml:lang=\"en\"...", FALSE, FALSE)
#25 /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(452): CRM_Utils_System::theme("<div id=\"crm-container\" class=\"crm-container\" lang=\"en\" xml:lang=\"en\"...")
#26 /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(39): CRM_Core_Error::handleUnhandledException(Object(PEAR_Exception))
#27 /var/www/html/wp-content/plugins/civicrm/civicrm.php(1199): CRM_Core_Invoke::invoke((Array:2))
#28 /var/www/html/wp-includes/class-wp-hook.php(307): CiviCRM_For_WordPress->invoke("")
#29 /var/www/html/wp-includes/class-wp-hook.php(331): WP_Hook->apply_filters("", (Array:1))
#30 /var/www/html/wp-includes/plugin.php(476): WP_Hook->do_action((Array:1))
#31 /var/www/html/wp-admin/admin.php(259): do_action("toplevel_page_CiviCRM")
```https://lab.civicrm.org/dev/core/-/issues/3688Public group title is not shown anymore2023-08-24T21:16:13ZMariaVPublic group title is not shown anymoreI have noticed that the public group title is not shown anymore:
![grafik](/uploads/911d39beeaaf08a3c8ac470ba5dec98c/grafik.png)
When I choose "Newsletter" as a public title, I get an email with the internal title.
![grafik](/uploads/...I have noticed that the public group title is not shown anymore:
![grafik](/uploads/911d39beeaaf08a3c8ac470ba5dec98c/grafik.png)
When I choose "Newsletter" as a public title, I get an email with the internal title.
![grafik](/uploads/49b088764632b824f1c2e87c0bdd0023/grafik.png)5.65.0