Development issueshttps://lab.civicrm.org/groups/dev/-/issues2023-12-22T05:03:24Zhttps://lab.civicrm.org/dev/core/-/issues/3208Contribution Detail Report: cannot sort by Contribution Status, when filter "...2023-12-22T05:03:24ZbgmContribution Detail Report: cannot sort by Contribution Status, when filter "Contribution OR Soft Credit = Both"I found that this odd combination of criteria will crash the Contribution Detail report:
* Sort: Contribution Status
* Filters: Contribution OR Soft Credit? = Both
This will result in a fatal error: "The used SELECT statements have a d...I found that this odd combination of criteria will crash the Contribution Detail report:
* Sort: Contribution Status
* Filters: Contribution OR Soft Credit? = Both
This will result in a fatal error: "The used SELECT statements have a different number of columns".
More specifically:
```
CREATE TEMPORARY TABLE civireport_contribution_detail_temp3 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci
(SELECT * FROM civicrm_tmp_e_dflt_2be28f58f1295cc154076c2ded818b52)
UNION ALL
(SELECT * FROM civireport_contribution_detail_temp2)
```
where `temp1` has `civicrm_contribution_contribution_status_id`, but `temp2` does not.
I don't think it's a recent regression. I tested in CiviCRM 5.12 (master) and 5.8.https://lab.civicrm.org/dev/user-interface/-/issues/49Search Kit builder UX improvements2023-12-21T22:33:04ZnicolSearch Kit builder UX improvementsFollowing discussion at the sprint with @gibsonoliver, @davem, @colemanw, @christhompson, @callanpaterson {please add others} – am aggregating some of the feedback.
**What this isn't**. A proposal for a UX rewrite, which would normally ...Following discussion at the sprint with @gibsonoliver, @davem, @colemanw, @christhompson, @callanpaterson {please add others} – am aggregating some of the feedback.
**What this isn't**. A proposal for a UX rewrite, which would normally start with a whole process of user feedback & profiling, workshoping, wireframing and so on which is a whole different proposal.
**What this is.** Low hanging fruit, ie optimisations that could make this interface more intuitive, especially for people not familiar with mysql builder, or more used to Drupal Views syntax.
Proposals are grouped in four areas:
1. **Language**. For e.g. changing '_Where_' to '_Filter_', and '_Having_' to '_Filter within Results_', which would make clear both do similar things (filter), but how they are different.
2. **Help tooltips**. An (i) icon that can be clicked for a quick explanation of a term, plus a link to the docs where possible (ie 'WITH is a connection to another entity, like a MySQL JOIN or Views RELATIONSHIP. Learn more >>')
3. **Pre-built Reports** as Search Kit displays in the UI out-the-box. ie recreate some common CiviReports as SK displays that people can then tweak/clone/deconstruct, and in doing so learn a bit of the interface/structure. Inspired by the comment 'Tweaking is easier than creating'.
4. **Reorder elements** of the page to make the user journey more obvious. These should be doable either through CSS grid reordering, or minimal markup tweaks. E.g. (brainstormed ideas not proposals):
- ensure all related blocks are within a parent visual container/border to keep them separate when queries get longer,
- put some elements (ie group or query info) behind an 'advanced' expanding region,
- move left column of searches and displays into top tabs to increase available page width,
- rethink two columns in favour of list of blocks, similar to advanced search.
In addition @artfulrobot raised the issue of adding descriptive class names to regions to make it easier to target them.https://lab.civicrm.org/dev/core/-/issues/1083Non-deductible amount not working2023-12-21T11:11:54ZJoeMurrayNon-deductible amount not workingOn 5.14 and dmaster 5.16.alpha1 when a price set is configured with an option that includes a non-deductible amount, then a purchase is made of that option, the non-deductible amount is not appearing on the contribution.
Price Set Field...On 5.14 and dmaster 5.16.alpha1 when a price set is configured with an option that includes a non-deductible amount, then a purchase is made of that option, the non-deductible amount is not appearing on the contribution.
Price Set Field with non-deductible $5 on $10 price:
![2019-06-27_14-44-40](/uploads/3954b396bb81d67c5f01cf5c6464b85a/2019-06-27_14-44-40.png)
Contribution for $10 with $0 non-deductible:
![2019-06-27_14-43-59](/uploads/9c43a1a6c2a0381ed94c403901228821/2019-06-27_14-43-59.png)EdselopezEdselopezhttps://lab.civicrm.org/dev/core/-/issues/3780Add an ability to set a field as hidden in formbuilder2023-12-21T07:20:06ZKurund JalmiAdd an ability to set a field as hidden in formbuilderKurund JalmiKurund Jalmihttps://lab.civicrm.org/dev/core/-/issues/3207Reports need validation on Email Delivery fields2023-12-21T05:03:21ZandrewcormickdockeryReports need validation on Email Delivery fieldsSee attached image. When trying to send reports via the Email Delivery tab, the emails do not get sent if invalid characters are included in either the To or the CC fields. In our case, the user included extraneous spaces and commas, a...See attached image. When trying to send reports via the Email Delivery tab, the emails do not get sent if invalid characters are included in either the To or the CC fields. In our case, the user included extraneous spaces and commas, as shown in the diagram. No warning is given to the user in this instance, which leads to confusion when the emails don't get sent, and a system administrator needs to examine errors on the back end to determine the problem and correct it. It would be much preferable for appropriate validation to occur on these fields to prevent invalid values from being entered in the first place, with messages being displayed towards the user entering the invalid values.
URL for this screen: https://example.com/civicrm/report/instance/####?reset=1&output=criteria where #### is the report instance ID.
CiviCRM version: 5.35.2
![image](/uploads/3992c1afe0180afe2815b0ca7ec2f6a0/image.png)https://lab.civicrm.org/dev/core/-/issues/3206Cannot save a copy of a report without the "administer reports" permission2023-12-21T05:03:20ZbgmCannot save a copy of a report without the "administer reports" permissionTo reproduce:
* Create a user with the following permissions
* access CiviReport
* access Report Criteria
* save Report Criteria
* Go to an existing report (or a template)
* Refresh the results
* Under Actions, click "save as"
Re...To reproduce:
* Create a user with the following permissions
* access CiviReport
* access Report Criteria
* save Report Criteria
* Go to an existing report (or a template)
* Refresh the results
* Under Actions, click "save as"
Result: javascript error: "TypeError: $refresh_field.html() is undefined"
![report-saveas-2021-08-05_14-45](/uploads/fe812c8f50c77c51a5a010987cd9b86d/report-saveas-2021-08-05_14-45.png)https://lab.civicrm.org/dev/core/-/issues/2773Proposal - re-jig demo roles to add restricted user2023-12-21T00:33:11ZeileenProposal - re-jig demo roles to add restricted userUPDATED spec - I added a new role 'Advisor' rather than altering an existing role. With the buildkit PR merged a contact is created with this role (advisor/advisor) who can view 'Summer Programme Volunteers' - not many permissions have b...UPDATED spec - I added a new role 'Advisor' rather than altering an existing role. With the buildkit PR merged a contact is created with this role (advisor/advisor) who can view 'Summer Programme Volunteers' - not many permissions have been added to this new role - the fact the person doesn't have administer CiviCRM is by design - the rest is just where the chips fell
Original issue / proposal
In general it's a pain to test users with less than admin permissions on Civi. I want to start scoping the steps to have one or more extra users on demo sites with less permissions
1) rename role CIVICRM_WEBTEST_USER to 'General User'
2) add 'Restricted user' role
3) add new account 'restricted' password 'restricted' to have this role
4) ideally move the permissions for each role to a json or similar file for easier config
5) the new role would have ? same permissions as 'General User' except for not having 'view all contacts' and 'edit all contacts'
6) the new user would be a member of existing group 'Administrators'
7) we would figure out how to add acl access for that group to 'Newsletter subscribers' (which is modestly well populated in our stock demo site)https://lab.civicrm.org/dev/drupal/-/issues/100Edit rights when access does not allow it2023-12-21T00:31:59ZedvanleeuwenEdit rights when access does not allow itI have a role which does not have edit rights for contacts. It is part of an access group which has Edit rights on the group of contacts to be managed.
Does the ACL overrule the Drupal rights?
(For memberships: limiting access from Dru...I have a role which does not have edit rights for contacts. It is part of an access group which has Edit rights on the group of contacts to be managed.
Does the ACL overrule the Drupal rights?
(For memberships: limiting access from Drupal does not give edit rights, which I think acts correctly)https://lab.civicrm.org/dev/core/-/issues/4635ACL's causing invalid SQL2023-12-21T00:30:37Zaydunsaidan.saunders@squiffle.ukACL's causing invalid SQLI've just been tracking down a problem where calls to `CRM_Contact_BAO_Contact_Permission::allow()` result in a DB syntax error.
The problem is in `CRM_ACL_BAO_ACL::getGroupClause()` see [here](https://github.com/civicrm/civicrm-core/b...I've just been tracking down a problem where calls to `CRM_Contact_BAO_Contact_Permission::allow()` result in a DB syntax error.
The problem is in `CRM_ACL_BAO_ACL::getGroupClause()` see [here](https://github.com/civicrm/civicrm-core/blob/master/CRM/ACL/BAO/ACL.php#L506-L536).
`$groupIDs` is set but only contains invalid or inactive groups, so the `$foundGroupIDs` is empty resulting in the invalid SQL: `... WHERE group_id in ( ) AND ...`5.67.0https://lab.civicrm.org/dev/core/-/issues/4845CiviEvent with approvals: Registration form not pre-filled with (custom) part...2023-12-20T19:21:06ZTobias Voigttobias.voigt@civiservice.deCiviEvent with approvals: Registration form not pre-filled with (custom) participant dataI'm not sure wether this is a proposal or an issue. I'm using the approval workflow for CiviEvent where participants get a confirmation link after they've been approved by admins.
While this works great for simple registration use cases...I'm not sure wether this is a proposal or an issue. I'm using the approval workflow for CiviEvent where participants get a confirmation link after they've been approved by admins.
While this works great for simple registration use cases, where only contact information is gathered in the initial registration form, this feature regrettably can't be used for more comlex use cases, where the initial form also contains additional (custom) participant data (e.g. "Do you want the vegetarian option for dinner?").
So, if there's any fields for custom participant data in the initial registration form, users would fill out the form and send it. Afterwards, admins approve the registration and a confirmation link is sent out to the approved user. If he/she clicks on the confirmation link and chooses to confirm, all contact data gets pre-filled into the form - BUT: the participant data - which is already stored in the database from the initial form - is not pre-filled and has to be filled out again.
This drastically limits the scope of use cases this feature could work for, since in almost all our client's projects we work with additional / custom participant data.
So my question is: Is this a bug and the participant data should actually be loaded during the confirmation process? Or was this feature never intended? Or maybe the feature was intended but never realized? In any case: What might be the scope of development work necessary to not only pre-fill the confirmation form with contact data but also with participant data?https://lab.civicrm.org/dev/core/-/issues/4832CiviReport 'Available for Dashboard' checkbox lost functionality2023-12-20T19:20:26ZbrienneCiviReport 'Available for Dashboard' checkbox lost functionalityOverview
----------------------------------------
The ‘Available for Dashboard?’ checkbox on CiviReports has lost its functionality.
Reproduction steps
----------------------------------------
1. On an existing or new CiviReport, click ...Overview
----------------------------------------
The ‘Available for Dashboard?’ checkbox on CiviReports has lost its functionality.
Reproduction steps
----------------------------------------
1. On an existing or new CiviReport, click on the **Access** tab
* If it is a new report, add a title on the **Title and Format** tab to make sure the report can be easily found.
1. Check the box next to the *Available for Dashboard?* label
1. Save the report from the *Actions* menu.
1. Go to the CiviCRM home page and do a hard reload (or even a cache clear)
1. Note that the report is either still present as an available dashlet ~~or not listed at all.~~
Current behaviour
----------------------------------------
Unchecking the *Available for Dashboard?* box on an existing CiviReport that is already available as a dashlet does not remove the report from the list of available dashlets on the CiviCRM home page
~~Checking the *Available for Dashboard?* on a new or existing CiviReport does not add it to the list of available dashlets on the CiviCRM page.~~
Deleting a report also does not remove the dashlet from the available options, however, the user will encounter a non-fatal error message that ‘You have tried to access a report that does not exist.’
Expected behaviour
----------------------------------------
The *Available for Dashboard?* checkbox should accurately control whether the report is or is not available as a dashlet.
Environment information
----------------------------------------
* __CiviCRM:__ 5.67.0https://lab.civicrm.org/dev/core/-/issues/4846API Deprecation2023-12-20T19:19:58ZtreseroAPI DeprecationLots of these in the log for mailings
[warning] Deprecated function CRM_Mailing_BAO_MailingComponent::retrieve, use API.
CRM_Core_Error::deprecatedFunctionWarning
CRM_Mailing_BAO_MailingComponent::retrieve
CRM_Mailing_Form_Component::se...Lots of these in the log for mailings
[warning] Deprecated function CRM_Mailing_BAO_MailingComponent::retrieve, use API.
CRM_Core_Error::deprecatedFunctionWarning
CRM_Mailing_BAO_MailingComponent::retrieve
CRM_Mailing_Form_Component::setDefaultValues
CRM_Core_Form::buildForm
Array
(
[civi.tag] => deprecated
)
Trying to make an email template, and I get this.
Wish I could help more.https://lab.civicrm.org/dev/core/-/issues/4871Afform - Reset button click does not refresh the search result table with emp...2023-12-20T19:19:39ZjitendraAfform - Reset button click does not refresh the search result table with empty filtersTo replicate:
- Create a search kit to search for contacts.
- Add a form builder with a filter input Display Name. Also enable Reset button.
- View the search form and search for display name:
![image](/uploads/61162fab96405b82341a39ddb...To replicate:
- Create a search kit to search for contacts.
- Add a form builder with a filter input Display Name. Also enable Reset button.
- View the search form and search for display name:
![image](/uploads/61162fab96405b82341a39ddb461d9d6/image.png)
- Click Reset and search again.
**Expected**: The search refreshes the table with empty displayname and returns all contacts.
**Actual**: The search does not refresh the table.
![image](/uploads/7b807b8aee9ee97d3b8c5b5c98a133aa/image.png)
Note: If i clear the textbox manually and hit search, the search is working fine.https://lab.civicrm.org/dev/core/-/issues/4868Add action for copy activity2023-12-20T19:16:21ZyashodhaAdd action for copy activityWe do have copy action on various entities like _Contribution Page_, _Events_.
It might be handy to have the same for _Activity _as well.
Also provide _Save as New_ feature/ when clicked we can have a new activity created with addition...We do have copy action on various entities like _Contribution Page_, _Events_.
It might be handy to have the same for _Activity _as well.
Also provide _Save as New_ feature/ when clicked we can have a new activity created with additional tweaks based on a pre-existing activity. This would come esp handy for activities which have lots of Activity Contacts/Targets/assignees and custom dat awith the original activity acting as a template.yashodhayashodhahttps://lab.civicrm.org/dev/core/-/issues/4865The "X" on advanced search accordions isn't doing the right thing anymore2023-12-20T19:15:35ZDaveDThe "X" on advanced search accordions isn't doing the right thing anymoreFollowup to https://lab.civicrm.org/dev/core/-/issues/4856
It looks like it's been a problem since at least 5.63.
What used to happen was if you just collapsed the accordion, it still used whatever search criteria had been entered (bec...Followup to https://lab.civicrm.org/dev/core/-/issues/4856
It looks like it's been a problem since at least 5.63.
What used to happen was if you just collapsed the accordion, it still used whatever search criteria had been entered (because after the search the form still needs to retain the search criteria even with them collapsed), and in fact even just opening the accordion would make it do the table joins (e.g. if you open the contributions accordion it's the same as "only show me contacts who have at least one contribution"). That's all working now again after 4856. But the "X" at the far right of the accordion header was there to completely remove the criteria and table joins from the query. That's not working anymore, and broke before any accordion changes.
It is _sort of_ working in the sense that it will clear contribution date for example, but not some other fields like id or transaction. And in both cases the accordion still pops open after search. Also note the defaults disappear so it's now including test and template contributions.
And additionally, for transaction, if you repeat and close the accordion again and click search again, you get a crash because it tries to pass array for some reason to mysqli_escape_string.https://lab.civicrm.org/dev/core/-/issues/4507ctrl.recipients[entityType] is undefined2023-12-20T16:55:15ZStoobctrl.recipients[entityType] is undefinedUpon upgrade to 5.64.0 the Recipients box in CiviMail new mailing (or continue draft) stopped working with this error in js console.
```
TypeError: $element.crmAutocomplete is not a function
Angular 30
jQuery 7
api3 crm.aja...Upon upgrade to 5.64.0 the Recipients box in CiviMail new mailing (or continue draft) stopped working with this error in js console.
```
TypeError: $element.crmAutocomplete is not a function
Angular 30
jQuery 7
api3 crm.ajax.js:120
Angular 14
```
We were using Mosiaco 2.1. Upgrading to 3.2.1691060437 didn't fix the issue.
This bug it affects Traditional and Mosaico mailings equally _**even with Mosaico extension disabled completely**_. So I think the problem is part of CiviMail itself. We are using Drupal 9.5.10, if that matters, and Civi seems functional otherwise.
![recipients1](/uploads/79862d01942c2d7a9edd83423e8ab7c7/recipients1.png)
![recipients2](/uploads/153d826994e70023eb234b3f83716beb/recipients2.png)https://lab.civicrm.org/dev/core/-/issues/174Consistently use swappable cache interfaces2023-12-20T06:26:25ZtottenConsistently use swappable cache interfaces# Background
CiviCRM caches were originally (and are primarily) stored in the table `civicrm_cache`. This design is great for small sites (easy to deploy on server with less software to administer). However, for larger sites that get va...# Background
CiviCRM caches were originally (and are primarily) stored in the table `civicrm_cache`. This design is great for small sites (easy to deploy on server with less software to administer). However, for larger sites that get value from using multiple MySQL servers, it's not so great: cache data (by its nature) is frequently written+read, but it's expensive to write cache data when there are multiple MySQL servers... and the overhead doesn't give us much benefit because the data is fundamentally expendable. A lighter system (like Memcache/Redis) would be more generally appropriate.
You might recall that CiviCRM's cache subsystem can optionally incorporate Memcache/Redis (since roughly 4.3ish?). This appears as `CRM_Utils_Cache_*`, and it started some great improvements (e.g. using faster cache providers; and swapping cache providers). Notably, the functionality uses Memcache/Redis as an *extra cache tier* (i.e. when reading a cache, it first checks memcache; then it falls back to checking `civicrm_cache` in MySQL). This helps *read performance* (because your cache-hit usually returns faster), but it doesn't help *write performance* (because you need to propagate cache-writes to every tier). Using *only* Memcache/Redis (as a single tier -- without MySQL) would be even better for performance.
I don't believe that the status quo reflects a technical necessity. (If you can handle deployment/configuration of Memcache/Redis a front-tier... then you can probably handle it as the main tier.) Rather, it reflects a development practicality: *the app was originally written to only use `civicrm_cache`*. Consequently, there are a handful of oddball use-cases/code-paths which directly access `civicrm_cache` or `CRM_Core_BAO_Cache`, and it would've been harder to do anything if it had required finding+fixing all of them.
# Scope
The general scope of this ticket is to hunt down the oddball use-cases/code-paths which directly reference `civicrm_cache` or `CRM_Core_BAO_Cache`. I expect the project to produce a handful of distinct PRs. To avoid redundantly documenting this, I'm aiming for each PR to have a more concrete discussion about the use-cases/code-paths being cleaned up.
# PR List
* [12330 - CRM_Utils_Cache_Redis::flush() - Respect prefixes](https://github.com/civicrm/civicrm-core/pull/12330) (m)
* [12331 - CRM_Utils_Cache - Always use a prefix. Standardize delimiter](https://github.com/civicrm/civicrm-core/pull/12331) (m)
* [12336 - systemStatusCheckResult - Migrate from settings to cache](https://github.com/civicrm/civicrm-core/pull/12336) (m)
* [12342 - Caching - Comply with PSR-16 interfaces](https://github.com/civicrm/civicrm-core/pull/12342) (m)
* [215 - Import PSR-16 compliance test](https://github.com/civicrm/civicrm-packages/pull/215) (m)
* [12348 - Cache-keys for CRM_Utils_Cache_* should avoid reserved chars](https://github.com/civicrm/civicrm-core/pull/12348) (m)
* ~~[12350 - civicrm_cache - Allow storage of binary data](https://github.com/civicrm/civicrm-core/pull/12350)~~
* [12354 - civicrm_cache - Allow storage of binary data](https://github.com/civicrm/civicrm-core/pull/12354) (m)
* [~~12360~~ - Full PSR-16 compliance for ...](https://github.com/civicrm/civicrm-core/pull/12360) (*depends: ~~12342, 12348, 12354~~*). Cherry-picked to form smaller PRs:
* [12376 - Add various utilities to support PSR-16](https://github.com/civicrm/civicrm-core/pull/12376) (m)
* [12378 - ArrayCache, Redis](https://github.com/civicrm/civicrm-core/pull/12378) (m)
* [12379 - SqlGroup](https://github.com/civicrm/civicrm-core/pull/12379) (m)
* [12380 - Memcache(d)](https://github.com/civicrm/civicrm-core/pull/12380) (m)
* [12381 - APCcache](https://github.com/civicrm/civicrm-core/pull/12381) (m)
* [12389 - Add test to prevent hidden interactions among caches](https://github.com/civicrm/civicrm-core/pull/12389) (m)
* [12362 - Forms/Sessions - Store state via Civi::cache('session')](https://github.com/civicrm/civicrm-core/pull/12362) (*depends: 12360*)
* [12368 - ~~civicrm_cache - Finish transition from DATETIME to TIMESTAMP](https://github.com/civicrm/civicrm-core/pull/12368)~~ (m)
See also
--------
* dev/core#217 - Allow replacement of PrevNextCache implementation (for search screens)
* dev/core#284 - Aggressive cache clearing significantly increases test time5.9tottentottenhttps://lab.civicrm.org/dev/core/-/issues/3203When using the Search Kit and Form Builder to implement a front-end Search Li...2023-12-20T05:03:24Zjustinfreeman (Agileware)When using the Search Kit and Form Builder to implement a front-end Search Listing, how do include a Reset button to clear the search criteria?When using the Search Kit and Form Builder to implement a front-end Search Listing, how do include a Reset button to clear the search criteria?
Ideally, this button would be displayed AFTER the Search button.
![Screenshot_20211112_1744...When using the Search Kit and Form Builder to implement a front-end Search Listing, how do include a Reset button to clear the search criteria?
Ideally, this button would be displayed AFTER the Search button.
![Screenshot_20211112_174423](/uploads/a065207345c884f41eae014ae25e1a8d/Screenshot_20211112_174423.png)https://lab.civicrm.org/dev/core/-/issues/3201Participant Listing report Unknown column 'contact_civireport.age_at_event2023-12-20T05:03:24ZEmerykZielinskiParticipant Listing report Unknown column 'contact_civireport.age_at_eventHey all,
when I try to sort Participant Listing report by age of the Participant (in the time of the event) i get the following error:
`[debug] $backTrace = #0 /var/www/html/sites/all/modules/civicrm/CRM/Core/Error.php(208): CRM_Core_E...Hey all,
when I try to sort Participant Listing report by age of the Participant (in the time of the event) i get the following error:
`[debug] $backTrace = #0 /var/www/html/sites/all/modules/civicrm/CRM/Core/Error.php(208): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /var/www/html/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(922): CRM_Core_Error::handle(Object(DB_Error))
#2 /var/www/html/sites/all/modules/civicrm/packages/DB.php(987): PEAR_Error->__construct("DB Error: no such field", -19, 16, (Array:2), "SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_so...")
#3 /var/www/html/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(575): DB_Error->__construct(-19, 16, (Array:2), "SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_so...")
#4 /var/www/html/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(223): PEAR->_raiseError(Object(DB_mysqli), NULL, -19, 16, (Array:2), "SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_so...", "DB_Error", TRUE)
#5 /var/www/html/sites/all/modules/civicrm/packages/DB/common.php(1920): PEAR->__call("raiseError", (Array:7))
#6 /var/www/html/sites/all/modules/civicrm/packages/DB/mysqli.php(933): DB_common->raiseError(-19, NULL, NULL, "SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_so...", "1054 ** Unknown column 'contact_civireport.age_at_event' in 'field list'")
#7 /var/www/html/sites/all/modules/civicrm/packages/DB/mysqli.php(403): DB_mysqli->mysqliRaiseError()
#8 /var/www/html/sites/all/modules/civicrm/packages/DB/common.php(1229): DB_mysqli->simpleQuery("SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_so...")
#9 /var/www/html/sites/all/modules/civicrm/packages/DB/DataObject.php(2416): DB_common->query("SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_so...")
#10 /var/www/html/sites/all/modules/civicrm/packages/DB/DataObject.php(1607): DB_DataObject->_query("SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_so...")
#11 /var/www/html/sites/all/modules/civicrm/CRM/Core/DAO.php(435): DB_DataObject->query("SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_so...")
#12 /var/www/html/sites/all/modules/civicrm/CRM/Core/DAO.php(1428): CRM_Core_DAO->query("SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_so...", TRUE)
#13 /var/www/html/sites/all/modules/civicrm/CRM/Report/Form.php(3076): CRM_Core_DAO::executeQuery("SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_so...")
#14 /var/www/html/sites/all/modules/civicrm/CRM/Report/Form.php(3561): CRM_Report_Form->buildRows("SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_so...", (Array:0))
#15 /var/www/html/sites/all/modules/civicrm/CRM/Report/Form/Event/ParticipantListing.php(616): CRM_Report_Form->postProcess()
#16 /var/www/html/sites/all/modules/civicrm/CRM/Core/Form.php(495): CRM_Report_Form_Event_ParticipantListing->postProcess()
#17 /var/www/html/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Submit.php(74): CRM_Core_Form->mainProcess()
#18 /var/www/html/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Submit->perform(Object(CRM_Report_Form_Event_ParticipantListing), "submit")
#19 /var/www/html/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Report_Form_Event_ParticipantListing), "submit")
#20 /var/www/html/sites/all/modules/civicrm/CRM/Core/Controller.php(351): HTML_QuickForm_Page->handle("submit")
#21 /var/www/html/sites/all/modules/civicrm/CRM/Utils/Wrapper.php(114): CRM_Core_Controller->run()
#22 /var/www/html/sites/all/modules/civicrm/CRM/Report/Page/Instance.php(90): CRM_Utils_Wrapper->run("CRM_Report_Form_Event_ParticipantListing", NULL, (Array:0))
#23 /var/www/html/sites/all/modules/civicrm/CRM/Core/Invoke.php(284): CRM_Report_Page_Instance->run((Array:4), NULL)
#24 /var/www/html/sites/all/modules/civicrm/CRM/Core/Invoke.php(84): CRM_Core_Invoke::runItem((Array:14))
#25 /var/www/html/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:4))
#26 /var/www/html/sites/all/modules/civicrm/drupal/civicrm.module(444): CRM_Core_Invoke::invoke((Array:4))
#27 /var/www/html/includes/menu.inc(527): civicrm_invoke("report", "instance", "26")
#28 /var/www/html/index.php(21): menu_execute_active_handler()
#29 {main}`
is there a way to set up the column `contact_civireport.age_at_event` by myself?https://lab.civicrm.org/dev/core/-/issues/4524Tax calculate wrong on Membership signup page2023-12-19T22:19:50ZPradeep Nayakpradpnayak@gmail.comTax calculate wrong on Membership signup pageCiviCRM: 5.64.1
PHP - 8.1
Replicate:
**Financial Account**
1. Tax 1, type=liability, is tax = checked, tax rate= 16%
2. Tax 1, type=liability, is tax = checked, tax rate= 13%
**Financial Type**
1. Assign tax 1 as Sales tax account is ...CiviCRM: 5.64.1
PHP - 8.1
Replicate:
**Financial Account**
1. Tax 1, type=liability, is tax = checked, tax rate= 16%
2. Tax 1, type=liability, is tax = checked, tax rate= 13%
**Financial Type**
1. Assign tax 1 as Sales tax account is to Member dues FT
2. Assign tax 2 as Sales tax account is to Donation FT
**Price Set**
Create a price set to FT = member dues and extends=Membership.
Price fields:
1. Membership, select HTML type, membership type General, amount= 84.48, FT= Member dues
2. Misc, select HTML type, label='Zero', Amount=0, FT=Campaign
3. Donation, Text HTML type, unit price=0.89
Create Online membership page, FT=Member dues and use the price set created above under membership section.
Try doing a online submission
![Screenshot_2023-08-22_at_15.02.05](/uploads/ea2da6a60b5d12483801580b250d4ff3/Screenshot_2023-08-22_at_15.02.05.png)
**Expected Result:**
![Screenshot_2023-08-22_at_15.03.28](/uploads/7fff93e304bc73f6adb312c8a90a828f/Screenshot_2023-08-22_at_15.03.28.png)
**Actual result**
![Screenshot_2023-08-22_at_15.02.49](/uploads/3d3af70ea32b2a5c5bac95cfb5df18c2/Screenshot_2023-08-22_at_15.02.49.png)5.69.0