CiviCRM Core issueshttps://lab.civicrm.org/dev/core/-/issues2023-12-05T22:29:38Zhttps://lab.civicrm.org/dev/core/-/issues/4840Searchkit In Place Edit might load slow.2023-12-05T22:29:38ZjaapjansmaSearchkit In Place Edit might load slow.When creating the search kit for the permissions screen of the Standalone CiviCRM.
It turned out that the data loads very slow, because all permissions are shown for every role. And the in-place-edit makes this screen loading very slow. ...When creating the search kit for the permissions screen of the Standalone CiviCRM.
It turned out that the data loads very slow, because all permissions are shown for every role. And the in-place-edit makes this screen loading very slow.
@colemanw thought the permission check within in the in-place-edit was causing this.
See this PR which adds the permissions screen to standalone CiviCRM: https://github.com/civicrm/civicrm-core/pull/28523https://lab.civicrm.org/dev/core/-/issues/3083getNonDeductibleAmountFromPriceSet should take into account the financial typ...2023-12-05T21:36:19ZherbdoolgetNonDeductibleAmountFromPriceSet should take into account the financial type of the price field optionOverview
----------------------------------------
`getNonDeductibleAmountFromPriceSet()` gets called in a couple places to calculate the non-deductible amount of contributions. While the calling method will take into account the financi...Overview
----------------------------------------
`getNonDeductibleAmountFromPriceSet()` gets called in a couple places to calculate the non-deductible amount of contributions. While the calling method will take into account the financial type of the contribution when assigning the non-deductible amount, `getNonDeductibleAmountFromPriceSet()` does *not* take into account the financial type of the price set option. I believe it should be.
Reproduction steps
----------------------------------------
1. Create price set and add two fields: one with financial type Donation (deductible) = `$10` and other Event Fee (non-deductible) = `$20`. Make the Event Fee have a random non-deductible amount of say `$2.50`.
2. Add a contribution in the backend to a contact and choose this new price set.
3. Look at the resulting contribution.
Current behaviour
----------------------------------------
The contribution has non-deductible = `$2.50` for a `$30` contribution.
Expected behaviour
----------------------------------------
I expect the non-deducible to be `$20`, the full price of the Event Fee. The contribution should be setting the non-deductible to be equal that of the merchandise price field, regardless of the actual non-deductible amount for that field. If a price field is non-deductible then it is 100% non-deductible based on the financial type.https://lab.civicrm.org/dev/core/-/issues/4778Menu missing - error in console2023-12-05T10:17:19ZDaveDMenu missing - error in consoleI updated a dev site and now I get an error which mangles the menu.
```
"Undefined array key "adv_search_legacy""
...\sites\all\modules\civicrm\CRM\Admin\Page\AJAX.php(89)
```
Likely here: https://github.com/civicrm/civicrm-core/pull/2...I updated a dev site and now I get an error which mangles the menu.
```
"Undefined array key "adv_search_legacy""
...\sites\all\modules\civicrm\CRM\Admin\Page\AJAX.php(89)
```
Likely here: https://github.com/civicrm/civicrm-core/pull/28072/files5.68.0https://lab.civicrm.org/dev/core/-/issues/3075Possible regression - ContributionRecur.getoptionschanged2023-12-05T05:03:21ZeileenPossible regression - ContributionRecur.getoptionschangedIn 5.47 we have changed the pseudoconstant on ContributionRecur.payment_processor_id to get the title rather than the name. This caused breakage on our site as we have not filled in payment_processor.title so we got an array like
`[1 =...In 5.47 we have changed the pseudoconstant on ContributionRecur.payment_processor_id to get the title rather than the name. This caused breakage on our site as we have not filled in payment_processor.title so we got an array like
`[1 => NULL, 2 => NULL]`
When this was array-flipped it fatalled.
On reflection I'm going to re-write the relevant bit of our code but could it affect others?
payment_processor.title was added to core recently-ish and was optional. It's possible some sites would leave it blank in order to have 'nothing' show on the front end. In which case correctly the pseudoconstant could 'look like' a regression. Or perhaps other sites do what we did.
**The right answer**
I think the 'correct' structure would be to have
name = unique machine name
master_id = way to link test processor to the master
title = display value
frontend_title = as shown on front end pages
The use of frontend_title is consistent with elsewhere (I think Justin pushed for that on other entities) and would get away from the need to use a title like 'Credit card' when you really want 'Eway'.
I suspect switching to using 'master_id' would be a transition rather than a quick change but the use of 'name' for this seems to keep biting us.
**The immediate question**
- does it make sense to add an upgrade to Five Forty Seven `UPDATE civicrm_payment_processor SET title = name WHERE title IS NULL` and / or `UPDATE civicrm_payment_processor SET title = name WHERE title = ''` - or do we think it might break more than it fixes.
@colemanw @seamuslee @mattwire @KarinGhttps://lab.civicrm.org/dev/core/-/issues/3125Release 5.46.3 includes jquery-ui 1.13.0 rather than 1.13.12023-12-05T05:03:20ZkenRelease 5.46.3 includes jquery-ui 1.13.0 rather than 1.13.1Overview
----------------------------------------
Release 5.46.3 includes jquery-ui 1.13.0 rather than 1.13.1
Reproduction steps
----------------------------------------
1. View bower_components/jquery-ui/bower.json
1. Version is 1.13.0Overview
----------------------------------------
Release 5.46.3 includes jquery-ui 1.13.0 rather than 1.13.1
Reproduction steps
----------------------------------------
1. View bower_components/jquery-ui/bower.json
1. Version is 1.13.0https://lab.civicrm.org/dev/core/-/issues/4466Roles - Define default taxonomy (for standalone deployments)2023-12-04T21:13:40ZtottenRoles - Define default taxonomy (for standalone deployments)Now that we have a mechanism for [defining users and roles in standalone](https://lab.civicrm.org/dev/core/-/issues/4053), there's another question: What roles should we define by default? How do we maintain those roles? A few ideas:
* ...Now that we have a mechanism for [defining users and roles in standalone](https://lab.civicrm.org/dev/core/-/issues/4053), there's another question: What roles should we define by default? How do we maintain those roles? A few ideas:
* __Light-touch with open taxonomy.__ This is what D7 does -- you just get 2-3 roles (anonymous, authenticated, admin). Then the site-builder can fill-in more roles to taste. When you upgrade, you may need to re-tune the roles.
* __Strong defaults with hackable taxonomy__ This is what WP does -- you get several roles out-of-the-box. Site-builders are not particularly encouraged to refine them, but it is possible (esp using APIs/add-ons). When you upgrade, it can (*I assume*) add or update roles.
* __Library of example roles__: This idea comes from looking at Google Cloud -- they have an extensive library of roles. Some of the roles are similar/overlapping (e.g. there are older and newer flavors of "File Admin"/"Storage Admin"). The upshot is that you get a presumption of continuity while still allowing the taxonomy to evolve. The downside is that the list is a bit overwhelming. But treating these as templates might mitigate that (*library of possible roles is long -- but the local site only enables a handful*).
There are some related questions - if you have strong defaults or a library of examples, then how do you deal with extensions (*i.e. the list of available perms may fluctuate depending on the extensions*).https://lab.civicrm.org/dev/core/-/issues/4722[PHP 8.1] fseek deprecation in PHPgettext2023-12-04T21:08:50Zjofranzfranz@systopia.de[PHP 8.1] fseek deprecation in PHPgettextOverview
----------------------------------------
Noisy error on cli
Reproduction steps
----------------------------------------
Performing a cache clear on cli
Current behaviour
----------------------------------------
```[PHP Depre...Overview
----------------------------------------
Noisy error on cli
Reproduction steps
----------------------------------------
Performing a cache clear on cli
Current behaviour
----------------------------------------
```[PHP Deprecation] fseek(): Passing null to parameter #2 ($offset) of type int is deprecated at .../drupal/vendor/civicrm/civicrm-packages/PHPgettext/streams.php:125```
Expected behaviour
----------------------------------------
There should be no deprecation warnings.
Environment information
----------------------------------------
<!-- Some of the items below may not be relevant for every bug - if in doubt please include more information than you think is neccessary. -->
* __CiviCRM:__ _5.66.0_ <!-- If this problem relates to an upgrade, then specify both old and new versions -->
* __PHP:__ _8.1_
* __CMS:__ _Drupal 9.5.11_https://lab.civicrm.org/dev/core/-/issues/3128Cases dashlet sometimes gives error when sort by subject2023-12-04T13:49:19ZDaveDCases dashlet sometimes gives error when sort by subjectPulling this out from https://lab.civicrm.org/dev/core/-/issues/1624 as a separate issue.
_Sometimes_, sorting by the subject on a cases dashlet will give a datatables error. The actual error if you look at the network response is `Colu...Pulling this out from https://lab.civicrm.org/dev/core/-/issues/1624 as a separate issue.
_Sometimes_, sorting by the subject on a cases dashlet will give a datatables error. The actual error if you look at the network response is `Column 'subject' in order clause is ambiguous`.
```
Error Field Error Value
Type DB_Error
Code -1
Message DB Error: unknown error
Mode 16
UserInfo SELECT civicrm_case.id as case_id, civicrm_case.subject as case_subject, civicrm_contact.id as contact_id, civicrm_contact.sort_name as sort_name, civicrm_phone.phone as phone, civicrm_contact.contact_type as contact_type, civicrm_contact.contact_sub_type as contact_sub_type, t_act.activity_type_id as activity_type_id, civicrm_case.case_type_id as case_type_id, civicrm_case.status_id as case_status_id, t_act.status_id as status_id, civicrm_case.start_date as case_start_date, GROUP_CONCAT(DISTINCT IF(case_relationship.contact_id_b = 2, case_relation_type.label_a_b, case_relation_type.label_b_a) SEPARATOR ', ') as case_role, t_act.activity_date_time as activity_date_time, t_act.id as activity_id, case_status.label AS case_status, civicrm_case_type.title AS case_type FROM civicrm_case INNER JOIN civicrm_case_contact ON civicrm_case.id = civicrm_case_contact.case_id INNER JOIN civicrm_contact ON civicrm_case_contact.contact_id = civicrm_contact.id LEFT JOIN civicrm_case_type ON civicrm_case.case_type_id = civicrm_case_type.id LEFT JOIN civicrm_option_group option_group_case_status ON ( option_group_case_status.name = 'case_status' ) LEFT JOIN civicrm_option_value case_status ON ( civicrm_case.status_id = case_status.value AND option_group_case_status.id = case_status.option_group_id ) LEFT JOIN civicrm_case_activity ca4 ON civicrm_case.id = ca4.case_id LEFT JOIN civicrm_activity t_act ON t_act.id = ca4.activity_id AND t_act.is_current_revision = 1 LEFT JOIN civicrm_phone ON civicrm_phone.contact_id = civicrm_contact.id AND civicrm_phone.is_primary = 1 LEFT JOIN civicrm_relationship case_relationship ON ((case_relationship.contact_id_a = civicrm_case_contact.contact_id AND case_relationship.contact_id_b = 2) OR (case_relationship.contact_id_b = civicrm_case_contact.contact_id AND case_relationship.contact_id_a = 2)) AND case_relationship.is_active AND case_relationship.case_id = civicrm_case.id LEFT JOIN civicrm_relationship_type case_relation_type ON case_relation_type.id = case_relationship.relationship_type_id AND case_relation_type.id = case_relationship.relationship_type_id WHERE (1) AND civicrm_case.is_deleted = 0 AND civicrm_contact.is_deleted <> 1 AND (case_relationship.contact_id_b = 2 OR case_relationship.contact_id_a = 2) AND case_relationship.is_active AND civicrm_case.status_id IN (1,3) GROUP BY case_id ORDER BY subject asc LIMIT 0, 10 [nativecode=1052 ** Column 'subject' in order clause is ambiguous]
DebugInfo SELECT civicrm_case.id as case_id, civicrm_case.subject as case_subject, civicrm_contact.id as contact_id, civicrm_contact.sort_name as sort_name, civicrm_phone.phone as phone, civicrm_contact.contact_type as contact_type, civicrm_contact.contact_sub_type as contact_sub_type, t_act.activity_type_id as activity_type_id, civicrm_case.case_type_id as case_type_id, civicrm_case.status_id as case_status_id, t_act.status_id as status_id, civicrm_case.start_date as case_start_date, GROUP_CONCAT(DISTINCT IF(case_relationship.contact_id_b = 2, case_relation_type.label_a_b, case_relation_type.label_b_a) SEPARATOR ', ') as case_role, t_act.activity_date_time as activity_date_time, t_act.id as activity_id, case_status.label AS case_status, civicrm_case_type.title AS case_type FROM civicrm_case INNER JOIN civicrm_case_contact ON civicrm_case.id = civicrm_case_contact.case_id INNER JOIN civicrm_contact ON civicrm_case_contact.contact_id = civicrm_contact.id LEFT JOIN civicrm_case_type ON civicrm_case.case_type_id = civicrm_case_type.id LEFT JOIN civicrm_option_group option_group_case_status ON ( option_group_case_status.name = 'case_status' ) LEFT JOIN civicrm_option_value case_status ON ( civicrm_case.status_id = case_status.value AND option_group_case_status.id = case_status.option_group_id ) LEFT JOIN civicrm_case_activity ca4 ON civicrm_case.id = ca4.case_id LEFT JOIN civicrm_activity t_act ON t_act.id = ca4.activity_id AND t_act.is_current_revision = 1 LEFT JOIN civicrm_phone ON civicrm_phone.contact_id = civicrm_contact.id AND civicrm_phone.is_primary = 1 LEFT JOIN civicrm_relationship case_relationship ON ((case_relationship.contact_id_a = civicrm_case_contact.contact_id AND case_relationship.contact_id_b = 2) OR (case_relationship.contact_id_b = civicrm_case_contact.contact_id AND case_relationship.contact_id_a = 2)) AND case_relationship.is_active AND case_relationship.case_id = civicrm_case.id LEFT JOIN civicrm_relationship_type case_relation_type ON case_relation_type.id = case_relationship.relationship_type_id AND case_relation_type.id = case_relationship.relationship_type_id WHERE (1) AND civicrm_case.is_deleted = 0 AND civicrm_contact.is_deleted <> 1 AND (case_relationship.contact_id_b = 2 OR case_relationship.contact_id_a = 2) AND case_relationship.is_active AND civicrm_case.status_id IN (1,3) GROUP BY case_id ORDER BY subject asc LIMIT 0, 10 [nativecode=1052 ** Column 'subject' in order clause is ambiguous]
PEAR_Exception: DB Error: unknown error in ...\sites\all\modules\civicrm\vendor\pear\pear-core-minimal\src\PEAR.php on line 922
- DB_Error: DB Error: unknown error in unknown on line unknown
Exception trace
# Function Location
0 CRM_Core_Error::exceptionHandler(Object(DB_Error)) ...\sites\all\modules\civicrm\vendor\pear\pear-core-minimal\src\PEAR.php:922
1 PEAR_Error->__construct('DB Error: unknow…', -1, 16, Array, 'SELECT civicrm_c…') ...\sites\all\modules\civicrm\vendor\pear\db\DB.php:997
2 DB_Error->__construct(-1, 16, Array, 'SELECT civicrm_c…') ...\sites\all\modules\civicrm\vendor\pear\pear-core-minimal\src\PEAR.php:575
3 PEAR::_raiseError(Object(DB_mysqli), null, -1, 16, Array, 'SELECT civicrm_c…', 'DB_Error', true) ...\sites\all\modules\civicrm\vendor\pear\pear-core-minimal\src\PEAR.php:223
4 PEAR->__call('raiseError', Array) ...\sites\all\modules\civicrm\vendor\pear\db\DB\common.php:1928
5 DB_common->raiseError(-1, null, null, 'SELECT civicrm_c…', '1052 ** Column '…') ...\sites\all\modules\civicrm\vendor\pear\db\DB\mysqli.php:936
6 DB_mysqli->mysqliRaiseError() ...\sites\all\modules\civicrm\vendor\pear\db\DB\mysqli.php:406
7 DB_mysqli->simpleQuery('SELECT civicrm_c…') ...\sites\all\modules\civicrm\vendor\pear\db\DB\common.php:1234
8 DB_common->query('SELECT civicrm_c…') ...\sites\all\modules\civicrm\packages\DB\DataObject.php:2696
9 DB_DataObject->_query('SELECT civicrm_c…') ...\sites\all\modules\civicrm\packages\DB\DataObject.php:1829
10 DB_DataObject->query('SELECT civicrm_c…') ...\sites\all\modules\civicrm\CRM\Core\DAO.php:472
11 CRM_Core_DAO->query('SELECT civicrm_c…', true) ...\sites\all\modules\civicrm\CRM\Core\DAO.php:1637
12 CRM_Core_DAO::executeQuery('SELECT civicrm_c…') ...\sites\all\modules\civicrm\CRM\Case\BAO\Case.php:583
13 CRM_Case_BAO_Case::getCases(false, Array) ...\sites\all\modules\civicrm\CRM\Case\Page\AJAX.php:186
14 CRM_Case_Page_AJAX::getCases() ...\sites\all\modules\civicrm\CRM\Core\Invoke.php:285
15 CRM_Core_Invoke::runItem(Array) ...\sites\all\modules\civicrm\CRM\Core\Invoke.php:69
16 CRM_Core_Invoke::_invoke(Array) ...\sites\all\modules\civicrm\CRM\Core\Invoke.php:36
17 CRM_Core_Invoke::invoke(Array) ...\sites\all\modules\civicrm\drupal\civicrm.module:471
18 civicrm_invoke('ajax', 'get-cases') ...\includes\menu.inc:527
19 menu_execute_active_handler() ...\index.php:21
20 {main}
Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
DB Error: unknown error
```https://lab.civicrm.org/dev/core/-/issues/4820Contact ID is no longer available in Advanced Search2023-12-04T10:00:53ZJonGoldContact ID is no longer available in Advanced SearchThis regressed in Civi 5.67. See screenshot of 5.66 below.
I did a `git bisect` and traced this to https://github.com/civicrm/civicrm-core/pull/27854. I thought it would be a trivial fix and maybe it is but not at my current brain capa...This regressed in Civi 5.67. See screenshot of 5.66 below.
I did a `git bisect` and traced this to https://github.com/civicrm/civicrm-core/pull/27854. I thought it would be a trivial fix and maybe it is but not at my current brain capacity.
![Selection_2071](/uploads/3d8aaf0674b6ccd2d6aba2e9a8351ce4/Selection_2071.png)https://lab.civicrm.org/dev/core/-/issues/4816CiviMail: Bounce processing is broken with 5.672023-12-04T09:57:49ZDetlev SieberCiviMail: Bounce processing is broken with 5.67## Overview
CiviMail has implemented elaborated bounce processing features: When an email sent by CiviMail is not accepted by the recipient mail server, a bounce mail is sent to the bounce mail account configured in .../civicrm/admin/ma...## Overview
CiviMail has implemented elaborated bounce processing features: When an email sent by CiviMail is not accepted by the recipient mail server, a bounce mail is sent to the bounce mail account configured in .../civicrm/admin/mailSettings&reset=1
The scheduled job fetch_bounces is parsing these bounce mails, using the verp address.
Normally, the bounce mail will be moved to a mail folder called /CiviMail/processed, if it can be traced to an email sent by CiviMail.
If however the bounce mail cannot be connected to a mail sent via CiviMail, the bounce mail is moved to /CiviMail/ignored
The connection is done via the verp address of the bounce mail, e.g.:
[mail+b+\<civicrm_mailing_job.id\>+\<civicrm_mailing_event_queue.id\>+\<hash\>@](mailto:mail+b+10193+10096107+c7dd2e9e8eb2f242@digitalcourage.de)\<domain.org\>
Since 5.67 it seems that this functionality is broken:
Any bounce mails are moved to the ignored folder. No bounce processing is performed anymore.
This issue might be a duplicate of #4775
I have reproduced this on two different CiviCRM installs on WordPress.5.68.0https://lab.civicrm.org/dev/core/-/issues/3129The way the Most Recent Activity column on Find Cases is calculated makes no ...2023-12-04T05:03:27ZDaveDThe way the Most Recent Activity column on Find Cases is calculated makes no senseIt shares code with the Case Dashboard, where the Most Recent Activity column only appears in a section for cases that have _recent_ activity. But on Find Cases depending on your search criteria it will of course include cases that do no...It shares code with the Case Dashboard, where the Most Recent Activity column only appears in a section for cases that have _recent_ activity. But on Find Cases depending on your search criteria it will of course include cases that do not have recent activity. For those cases, the column displays blank, when it really should simply display the most recent activity, whenever it was.
To reproduce, create a case and complete an activity. Wait 2 weeks. Then do a find cases and look at the Most Recent Activity column for that case.
Does Find Cases even need this column?https://lab.civicrm.org/dev/core/-/issues/4811Angularjs.bootstrap behaves differently when opening in a popup on older CMSes2023-12-04T04:39:25ZseamusleeAngularjs.bootstrap behaves differently when opening in a popup on older CMSesOverview
----------------------------------------
When trying to have a form builder form integrated on a Smarty Page. On CMSes that ship by default older jQuery versions e.g. Drupal 7. The form builder form does not render correctly in ...Overview
----------------------------------------
When trying to have a form builder form integrated on a Smarty Page. On CMSes that ship by default older jQuery versions e.g. Drupal 7. The form builder form does not render correctly in the popup.
Reproduction steps
----------------------------------------
1. Create a basic Drupal 7 + CiviCRM site with buildkit
1. Clone the searchkit branch of the [Line Item editor Extension](https://lab.civicrm.org/extensions/lineitemedit/-/tree/searchkit?ref_type=heads)
1. Enable Line Item extension
4. Do a find contribution search and try and edit any contribution and see that the angular js table does not load correctly to list the line items. But if you open it in a new tab find it renders correctly
Environment information
----------------------------------------
* __CiviCRM:__ Master
* __CMS:__ Drupal 75.69.0colemanwcolemanwhttps://lab.civicrm.org/dev/core/-/issues/4828Can't view/edit grants2023-12-03T18:47:17ZJonGoldCan't view/edit grantsOverview
----------------------------------------
Can't view/edit grants.
This is a 5.67 regression, from https://github.com/civicrm/civicrm-core/pull/27411.
Reproduction steps
----------------------------------------
1. Enable CiviGra...Overview
----------------------------------------
Can't view/edit grants.
This is a 5.67 regression, from https://github.com/civicrm/civicrm-core/pull/27411.
Reproduction steps
----------------------------------------
1. Enable CiviGrant.
1. Create a grant.
1. Go to **Grants » Find Grant**. Search for your grant.
1. Click **View**.
This is also true if you click **View** from a contact's *Grants* tab.
Additionally, while **Edit** works, the **Edit** and **Delete** buttons you see when viewing a grant do not.
Current behaviour
----------------------------------------
Empty grant view template.
Expected behaviour
----------------------------------------
Data should display.
Comments
----------------------------------------
There are two issues here. I have a partial fix but I can't work on this further.
* The View template contains tokens that aren't being passed to it. It's getting loaded from an `include` in `templates/CRM/Grant/Form/Grant.tpl` now, which it previously wasn't. We can use most of the values passed in `{$form}` for an Edit page, but we don't have a good way to display selects in View mode.
* When viewing the page, the grant ID and contact ID aren't being calculated correctly for the "Edit" and "Delete" button URLs.
To be honest, I'm not sure how this passed review. I can't find a single way to get a grant to display.colemanwcolemanwhttps://lab.civicrm.org/dev/core/-/issues/3477SearchKit - dashboard tables2023-12-03T16:32:00Zaydunsaidan.saunders@squiffle.ukSearchKit - dashboard tablesOverview
----------------------------------------
This is about how we can produce dashboard-like summary data with SearchKit to replace existing dashboards and make them more customisable.
For example, consider the Cases dashboard:
...Overview
----------------------------------------
This is about how we can produce dashboard-like summary data with SearchKit to replace existing dashboards and make them more customisable.
For example, consider the Cases dashboard:
- the rows are Case Types
- the columns are the values of Case Status
- the table cells are counts of matching cases, linked to another search
Option 1
--------
SearchKit can produce the counts with eg:
![image](/uploads/16d551f0332f28f4f2a5ef8a6e4a1ff4/image.png)
Maybe a new Display type could restructure the data to produce the desired format.
(Note that is should be based off of CaseType rather than Cases so that types with no cases are shown. But CaseType is not currently available.)
Option 2
--------
See https://gist.github.com/aydun/d49197c81205b463ef5cdef38c97b317
The recently added data segmentation functionality adds 'virtual fields' for group-by purposes. Maybe we could add virtual fields based around the idea of the gist to create virtual fields from an option group so an option group of case_status becomes a set of fields `sum(status_id=1), sum(status_id=2)` etc.
However, I don't think SearchKit/Api4 can produce sql like that - but maybe it can!
Both of these would need to accommodate linking the cells to another parameterized search.
Option 3
----------------------------------------
Something else ...https://lab.civicrm.org/dev/core/-/issues/4830PHP 7.4 Don't Drop2023-12-03T07:01:29ZtreseroPHP 7.4 Don't DropPlease don't. I have tried multiple times to upgrade to PHP 8.1+ and there are still major issues.
Many issues with the intl php libraries and extensions. And other things. I've reverted multiple times back to php 7.4 to keep my site fu...Please don't. I have tried multiple times to upgrade to PHP 8.1+ and there are still major issues.
Many issues with the intl php libraries and extensions. And other things. I've reverted multiple times back to php 7.4 to keep my site functioning.https://lab.civicrm.org/dev/core/-/issues/3030Adding new contact note: `Column 'note_date' cannot be null`2023-12-03T05:03:31ZmasettoAdding new contact note: `Column 'note_date' cannot be null`Overview
----------------------------------------
Adding a new note to the contact, civicrm crashes.
Reproduction steps
----------------------------------------
1. Open a **Contact**.
1. Add a new Note, enter a subject and a text, but ...Overview
----------------------------------------
Adding a new note to the contact, civicrm crashes.
Reproduction steps
----------------------------------------
1. Open a **Contact**.
1. Add a new Note, enter a subject and a text, but not a "Note Date" (it is not required). Click **Save**.
1. Got an error "**Fatal error: DB Error: constraint violation**".
Current behaviour
----------------------------------------
```
"message" => "DB Error: constraint violation"
"exception" => PEAR_Exception {#1974
#cause: DB_Error {#1973
+userinfo: "INSERT INTO `civicrm_note` (`entity_table` , `entity_id` , `note` , `contact_id` , `note_date` , `subject` , `privacy` ) VALUES ('civicrm_contact' , 19862 , 'nota di prova' , 19867 , NULL , 'test' , NULL ) [nativecode=1048 ** Column 'note_date' cannot be null]"
```
Environment information
----------------------------------------
* __CiviCRM:__ 5.45.1
* __PHP:__ 7.4
* __CMS:__ WordPress 5.8
* __Database:__ MySQL 5.7.7https://lab.civicrm.org/dev/core/-/issues/4767Clean install of 5.68-RC fails on WP2023-12-02T16:06:41ZkcristianoClean install of 5.68-RC fails on WPClean install of CiviCRM 5.68.beta1-202311110239 on WP (both 6.3.2 and 6.4.1) using php 8.1 fails:
php log:
```
[11-Nov-2023 14:09:40 UTC] PHP Fatal error: Uncaught CRM_Core_Exception: [-5: DB Error: already exists
thrown in /home/...Clean install of CiviCRM 5.68.beta1-202311110239 on WP (both 6.3.2 and 6.4.1) using php 8.1 fails:
php log:
```
[11-Nov-2023 14:09:40 UTC] PHP Fatal error: Uncaught CRM_Core_Exception: [-5: DB Error: already exists
thrown in /home/cividev/buildkit/build/wpempty/web/wp-content/plugins/civicrm/civicrm/api/api.php on line 138
```
Nothing in the ConfigAndLog files.
I also logged this issue - https://github.com/civicrm/civicrm-buildkit/issues/825 as I thought it was a buildkit issue.
Same issue with 5.69-alpha.https://lab.civicrm.org/dev/core/-/issues/4425Standalone: language change does not stick2023-12-02T12:21:46ZbgmStandalone: language change does not stickTo reproduce:
- Administer > System Settings > Extensions: Enable the [update language](https://civicrm.org/extensions/update-language-files) extension, saves time, if you haven't already downloaded the translation files
- Administer > ...To reproduce:
- Administer > System Settings > Extensions: Enable the [update language](https://civicrm.org/extensions/update-language-files) extension, saves time, if you haven't already downloaded the translation files
- Administer > Localization > Languages: Enable two languages (no need for multilingual, just enable a second language)
You should then be able to display pages in different languages, using the `lcMessages=xx_YY` parameter. Ex:
- https://crm.example.org/civicrm?lcMessages=en_US
- https://crm.example.org/civicrm?lcMessages=fr_CA (adapt to the locale you enabled)
This works for a single page. However, CiviCRM should normally save the language in the `$session` object. See `CRM_Core_BAO_ConfigSetting::applyLocale`. It does not seem to be happening.
(I'll try to circle back, just wanted to log my findings so far)5.69.0https://lab.civicrm.org/dev/core/-/issues/3113Export Contacts from Search Builder with contribute Note get DB Error2023-12-02T05:03:30ZsunilExport Contacts from Search Builder with contribute Note get DB ErrorOverview
----------------------------------------
Export Contacts from Search Builder with contribute Note get DB Error
Reproduction steps
----------------------------------------
1. Create contribution record with contribution note
1. ...Overview
----------------------------------------
Export Contacts from Search Builder with contribute Note get DB Error
Reproduction steps
----------------------------------------
1. Create contribution record with contribution note
1. go to search builder,
`Contribution Status = Completed` and `Contribution Note IS NOT EMPTY`
1. Search Contact, you get exepected result.
1. Select contact and choose action `Export Contact`
1. Got an error "**Fatal error: DB error**".
[nativecode=1054 ** Unknown column 'civicrm_note.note' in 'where clause']"]
Somewhere `civicrm_note` table from join disaapear in export operation.
Tested on 5.27 to 5.45 and latest dmaster site.https://lab.civicrm.org/dev/core/-/issues/3123Blog.tpl has text-wrap css for "#civicrm-news-feed .collapsed .crm-accordion...2023-12-02T05:03:29ZTrixorBlog.tpl has text-wrap css for "#civicrm-news-feed .collapsed .crm-accordion-header"I spent some time finding more info about the text-wrap CSS option, but I can't find a browser that supports it. Within CiviCRM there is a reference within the monaco-editor (bower_components) for CSS white-space (cssMode.js & cssWorker....I spent some time finding more info about the text-wrap CSS option, but I can't find a browser that supports it. Within CiviCRM there is a reference within the monaco-editor (bower_components) for CSS white-space (cssMode.js & cssWorker.js). So far I can tell it is only in the Blog.tpl. Not a big deal, but maybe remove or replace it.