Development issueshttps://lab.civicrm.org/groups/dev/-/issues2018-11-16T00:44:05Zhttps://lab.civicrm.org/dev/core/-/issues/525Extraneous br-tags in rendered note-fields2018-11-16T00:44:05Zthomas_SYSTOPIAExtraneous br-tags in rendered note-fieldsHow to reproduce on a fresh 5.7er CiviCRM:
* Create a contact-inline-custom-group and a note-field with a TextArea- or a RichTextEditor-FieldType.
* Save this field with a multiline text on an arbitrary Contact.
You may see all linebrea...How to reproduce on a fresh 5.7er CiviCRM:
* Create a contact-inline-custom-group and a note-field with a TextArea- or a RichTextEditor-FieldType.
* Save this field with a multiline text on an arbitrary Contact.
You may see all linebreaks displayed doubly.5.9https://lab.civicrm.org/dev/core/-/issues/526Feedback cannot be translated when saving Contribution Page forms in language...2018-11-15T19:32:34ZhaystackFeedback cannot be translated when saving Contribution Page forms in languages other than EnglishWhen saving forms to configure a Contribution Page in languages other than English, the feedback given is not translated or translatable.
Example below (FWIW that's the CiviCRM Admin Utilities theme):
![Screen_Shot_2018-11-15_at_12.37....When saving forms to configure a Contribution Page in languages other than English, the feedback given is not translated or translatable.
Example below (FWIW that's the CiviCRM Admin Utilities theme):
![Screen_Shot_2018-11-15_at_12.37.55](/uploads/a7b2bf0762d271e82c595b4bdc490a16/Screen_Shot_2018-11-15_at_12.37.55.png)
This can be rectified by applying [the same logic as exists for Event Management forms](https://github.com/civicrm/civicrm-core/blob/master/CRM/Event/Form/ManageEvent.php#L376-L378).5.9https://lab.civicrm.org/dev/core/-/issues/527Non translatable fields in profile schema2021-04-22T00:08:01ZsamuelsovNon translatable fields in profile schemaThere are a few fields in profile that should be translatable :
* Public Title
* Description (not a public data but some orgs have staff with different preferred language)
* Redirect URL
* Cancel redirect URL
* Cancel Button Text
* ...There are a few fields in profile that should be translatable :
* Public Title
* Description (not a public data but some orgs have staff with different preferred language)
* Redirect URL
* Cancel redirect URL
* Cancel Button Text
* Submit Button Text
![Screenshot_2018-11-15_Profile_Settings_-_My_profile](/uploads/1cb65d527d439bb236b9e9cbe59993c8/Screenshot_2018-11-15_Profile_Settings_-_My_profile.png)samuelsovsamuelsovhttps://lab.civicrm.org/dev/core/-/issues/528Advanced Search -> Contribution Tab and Contribution Dashboard returns a fata...2018-11-17T02:37:46ZjitendraAdvanced Search -> Contribution Tab and Contribution Dashboard returns a fatal error.On Dmaster
https://dmaster.demo.civicrm.org/civicrm/contact/search/advanced?reset=1 -> Expanding the contribution div section displays a network error
![image](/uploads/1fe2c8909315b51ebded571fcb0d023d/image.png)
Similarly, Contributi...On Dmaster
https://dmaster.demo.civicrm.org/civicrm/contact/search/advanced?reset=1 -> Expanding the contribution div section displays a network error
![image](/uploads/1fe2c8909315b51ebded571fcb0d023d/image.png)
Similarly, Contribution Dashboard returns a fatal error - https://dmaster.demo.civicrm.org/civicrm/contribute?reset=15.9jitendrajitendrahttps://lab.civicrm.org/dev/core/-/issues/529Editing smart group removes search criteria unless criteria tabs are opened f...2018-12-05T20:28:23ZsudomanEditing smart group removes search criteria unless criteria tabs are opened firstWhen editing the search terms in a smart group, If I click "Search" without first opening the drop down tabs that contain info about all of the search criteria, then those terms are removed from the search, returning a different number o...When editing the search terms in a smart group, If I click "Search" without first opening the drop down tabs that contain info about all of the search criteria, then those terms are removed from the search, returning a different number of contacts.
For instance, if my search terms are: `Country = United Kingdom ...AND... Contribution Date - greater than or equal to "January 2nd, 2017 12:00 AM"`, then I need to open the Address Fields and Contributions tabs before clicking "Search", otherwise, I get a much larger set of contacts.
I'm using CiviCRM version 5.3.1 on Drupal 7. Thanks! : )5.8Monish DebMonish Debhttps://lab.civicrm.org/dev/core/-/issues/530Make a_b relationships available as case roles2019-12-02T19:31:10ZalicefruminMake a_b relationships available as case rolesCurrently one can only create case roles for CiviCRM Cases that are one direction (one only sees the options label_b_a). See screen shot below that shows the "New Case Type" Ui with the options for "add role" open (they are all label_b_a...Currently one can only create case roles for CiviCRM Cases that are one direction (one only sees the options label_b_a). See screen shot below that shows the "New Case Type" Ui with the options for "add role" open (they are all label_b_a) as one can see by checking against the Relationship Type table next to it.
![relTypesNewCaseType](/uploads/193cce5a0e6d7c395b8003e3c4593241/relTypesNewCaseType.png)
We are proposing making it so users can choose from the full list of relationships (label_a_b and label_b_a).
Rationale:
---------
1. There could be scenarios where cases should be set up to have case roles in any direction. For example.. an intergenerational case where its children taking care of parents vs a school case where its parents taking care of kids.
2. Jira issue [CRM-19754](https://issues.civicrm.org/jira/browse/CRM-19754) suggests that the options available should be label_a_b. One pr to make this change was accepted [pr 9560](https://github.com/civicrm/civicrm-core/pull/9560) a second [pr 9975](https://github.com/civicrm/civicrm-core/pull/9975) was closed due to in action and incompleteness. Making the Case Types bidirectional would solve the bugs documented in [pr 9975](https://github.com/civicrm/civicrm-core/pull/9975) without a fix up script.
Bugs this change fixes:
----------------------
1) when creating a case type, you can only select B-to-A labels
![image_1_](/uploads/11c127df30b22761b5653353534484da/image_1_.png)
then after creating a case you see the B-to-A "Parent of" label
![image_2_](/uploads/01922f80d41cd2fe8bb227d73d5e36c0/image_2_.png)
after picking the contact, the label becomes the A-to-B "Child of"
![image_4_](/uploads/a29e1194dd5af9c0b64d5945bd1ccf4f/image_4_.png)
2) When viewing a case, the Roles drop-down, only shows the labels in the B to A direction, but when one assigns the case role in the B to A direction the label displayed is in the A to B direction.
3) When editing a Case Activity in the "Send a copy" the role is correct but the label is wrong.
4) Currently, all relationships are showing the B contact, regardless of who the client is
yet they all have the B-to-A label, regardless of who the client is for example:
![Screenshot_2019-03-29_Dr_Rebekah_Cooper_-_Housing_Support_grantdetailreport](/uploads/e00afec39078c45673ab2b7f1cc0c252/Screenshot_2019-03-29_Dr_Rebekah_Cooper_-_Housing_Support_grantdetailreport.png)
In this example Rebekah is the client, and the case has her as the parent of Kathleen and the child of Carylon. In the send a copy box, she's shown as parent of Carylon and her relationship w/ Kathleen is displayed as her being parent of herself.
5) when reassigning a case role that is B-to-A (where the client is on the B side of the relationship), the list of available contacts is the contact type of the B side
since households and organizations are frequently on the B side of a relationship, this makes it difficult-to-impossible to manage a case where the client is a household or organization
![reassign](/uploads/9d71615554a0e1a15a0b6776ab9aac45/reassign.png)
Places in the Code that would need to be adjusted:
-----------------------------------------------
+ CRM/Report/Form/Case/Summary.php
+ CRM/Report/Form/Case/Detail.php
+ CRM/Case/XMLProcessor/Process.php
+ CRM/Case/XMLProcessor.php
+ CRM/Case/ManagedEntities.php
+ CRM/Case/BAO/Query.php
+ CRM/Case/BAO/Case.php
+ ang/crmCaseType.js5.16.0https://lab.civicrm.org/dev/core/-/issues/531Drop support for MySQL 5.1? Maybe more?2020-09-09T05:24:02ZJonGoldDrop support for MySQL 5.1? Maybe more?While reviewing some PRs on the sysadmin docs, it came to my attention that we're currently saying we support MySQL 5.1.3+. MySQL 5.1 has been [EOL since 2013](https://www.fromdual.com/support-for-mysql-from-oracle). 5.5 went EOL at th...While reviewing some PRs on the sysadmin docs, it came to my attention that we're currently saying we support MySQL 5.1.3+. MySQL 5.1 has been [EOL since 2013](https://www.fromdual.com/support-for-mysql-from-oracle). 5.5 went EOL at the end of 2015, with extended support ending this year.
While the impetus to drop support for MySQL isn't as strong as it is for PHP, I think we should consider dropping support before someone reports an issue on an untested configuration and points to the minimum requirements in the docs.
Whether this is just a matter of updating the docs or if we want to set up a check for `MIN_MYSQL_VERSION` and `MIN_RECOMMENDED_MYSQL_VERSION` is something we can discuss. Just updating the docs might be preferable so we don't need to navigate the MySQL/MariaDB/Percona business in code. That said, we should document whether MariaDB/Percona are supported, since we've certainly seen errors particular to one or another.https://lab.civicrm.org/dev/core/-/issues/532Multi-select field not respected in batch search2018-12-10T17:15:43ZPradeep Nayakpradpnayak@gmail.comMulti-select field not respected in batch searchThe "Search by Financial Type" is a multi-select, but if you try to search by multiple values it fails validation (see screenshot 653 attached).
![Selection_653](/uploads/a61c238371a509c511a625d116d56413/Selection_653.png)
PR:https://...The "Search by Financial Type" is a multi-select, but if you try to search by multiple values it fails validation (see screenshot 653 attached).
![Selection_653](/uploads/a61c238371a509c511a625d116d56413/Selection_653.png)
PR:https://github.com/civicrm/civicrm-core/pull/131215.9https://lab.civicrm.org/dev/core/-/issues/533Update recaptcha to v32023-06-30T05:03:20ZMartinUpdate recaptcha to v3Google recaptcha v3 has now been officially released:
https://webmasters.googleblog.com/2018/10/introducing-recaptcha-v3-new-way-to.html
Obviously v2 is still working for the time being but it would be beneficial to update core to use v...Google recaptcha v3 has now been officially released:
https://webmasters.googleblog.com/2018/10/introducing-recaptcha-v3-new-way-to.html
Obviously v2 is still working for the time being but it would be beneficial to update core to use v3. For example one of our clients is currently seeing this issue (significant usability bug in iOS):
https://github.com/google/recaptcha/issues/130
Thanks!https://lab.civicrm.org/dev/core/-/issues/534Print Invoice and Pay Now buttons do not appear on Contact Dashboard2019-04-20T00:34:14ZkcristianoPrint Invoice and Pay Now buttons do not appear on Contact DashboardIn CiviCRM 5.7 do the following:
* Enable Tax and invoicing and select default Invoice Payment page on `/civicrm/admin/setting/preferences/contribute?reset=1`
![image](/uploads/72f491bb82397607aea4539073d18a78/image.png)
* Contact Das...In CiviCRM 5.7 do the following:
* Enable Tax and invoicing and select default Invoice Payment page on `/civicrm/admin/setting/preferences/contribute?reset=1`
![image](/uploads/72f491bb82397607aea4539073d18a78/image.png)
* Contact Dashboard after Contributions/Event Registration
![image](/uploads/cc40c9e2db7c94a86b204880dc1b9891/image.png)
Repeat the above steps on 5.8 RC and Print Invoice and Pay Now Links do not appear where appropriate
![image](/uploads/9f1d524c1dd3c7305bac7fd99ea29ef6/image.png)5.12.1https://lab.civicrm.org/dev/core/-/issues/535Do not allow to edit recurring contribution amount if one line item exist2019-01-28T05:17:49ZmadhaviDo not allow to edit recurring contribution amount if one line item existThis is an improvement in https://issues.civicrm.org/jira/browse/CRM-16398
Currently CiviCRM allows to edit recurring contribution amount if one related contribution exists.
The Recurring contribution edit UI should not allow to edit the...This is an improvement in https://issues.civicrm.org/jira/browse/CRM-16398
Currently CiviCRM allows to edit recurring contribution amount if one related contribution exists.
The Recurring contribution edit UI should not allow to edit the total amount for transactions with one line item.
**Technical Details:**
1. In /Contribute/Form/UpdateSubscription.php updated the check to >= 1 (Greater than or equal to 1)https://lab.civicrm.org/dev/core/-/issues/536Contribution tab is slow to render for contacts with many contributions (in l...2019-04-26T23:08:59ZeileenContribution tab is slow to render for contacts with many contributions (in large database)We are finding that the contribution tab is extremely slow to render on contacts with a large number of contributions. While we are taking at a different scale db to most instances (many millions of contacts and the very slow to load con...We are finding that the contribution tab is extremely slow to render on contacts with a large number of contributions. While we are taking at a different scale db to most instances (many millions of contacts and the very slow to load contacts have > 10,000 donation) from my digging the issues that cause the slowness are not limited to us and the query improvements that work for us are generally applicable.
We are seeing maybe 10 queries that take about 6 seconds each. In each case it is possible to reduce the query to around 0.05 seconds with an index hint. The issue is exacerbated by the fact that several of the slower queries run twice each.
I've pasted all the queries below
1.
SELECT COUNT(*) as count,
SUM(total_amount) as amount,
AVG(total_amount) as average,
currency
FROM civicrm_contribution b
LEFT JOIN civicrm_line_item i ON i.contribution_id = b.id AND i.entity_table = 'civicrm_contribution' AND i.financial_type_id NOT IN (3,1,4,2)
WHERE b.contact_id IN (76) AND b.contribution_status_id = 1 AND b.is_test = 0 AND b.receive_date >= 20180101 AND b.receive_date < 20190101
GROUP BY currency;
2.
------------------------------
SELECT count( DISTINCT civicrm_contribution.id ) as rowCount
FROM civicrm_contact contact_a
LEFT JOIN civicrm_contribution ON civicrm_contribution.contact_id = contact_a.id WHERE ( contact_a.id = '76' )
AND (contact_a.is_deleted = 0) ;
3.
------------------------------------
SELECT COUNT( conts.total_amount ) as total_count,
SUM( conts.total_amount ) as total_amount,
AVG( conts.total_amount ) as total_avg,
conts.currency as currency FROM (
SELECT civicrm_contribution.total_amount, COUNT(civicrm_contribution.total_amount) as civicrm_contribution_total_amount_count,
civicrm_contribution.currency FROM civicrm_contact contact_a LEFT JOIN civicrm_contribution ON civicrm_contribution.contact_id = contact_a.id WHERE ( contact_a.id = '76' ) AND (contact_a.is_deleted = 0) AND (contact_a.is_deleted = 0) AND civicrm_contribution.contribution_status_id = 1 GROUP BY civicrm_contribution.id
) as conts
GROUP BY currency;
4.
------------------------------------
SELECT COUNT( conts.total_amount ) as total_count,
SUM( conts.total_amount ) as total_amount,
AVG( conts.total_amount ) as total_avg,
conts.currency as currency, SUBSTRING_INDEX(GROUP_CONCAT(conts.total_amount
ORDER BY conts.civicrm_contribution_total_amount_count DESC SEPARATOR ';'), ';', 1) as amount,
MAX(conts.civicrm_contribution_total_amount_count) as civicrm_contribution_total_amount_count
FROM (SELECT civicrm_contribution.total_amount, COUNT(civicrm_contribution.total_amount) as civicrm_contribution_total_amount_count,
civicrm_contribution.currency
FROM civicrm_contact contact_a LEFT JOIN civicrm_contribution ON civicrm_contribution.contact_id = contact_a.id WHERE ( contact_a.id = '76' ) AND (contact_a.is_deleted = 0) AND (contact_a.is_deleted = 0) AND civicrm_contribution.contribution_status_id = 1
GROUP BY currency, civicrm_contribution.total_amount ORDER BY civicrm_contribution_total_amount_count DESC) as conts
GROUP BY currency;
5.
---------------------------------------
SELECT count(*) as count FROM civicrm_contact contact_a
LEFT JOIN civicrm_contribution ON civicrm_contribution.contact_id = contact_a.id
WHERE ( contact_a.id = '76' ) AND (contact_a.is_deleted = 0) AND (contact_a.is_deleted = 0)
AND civicrm_contribution.contribution_status_id = 1 AND civicrm_contribution.currency = 'AUD';
6.
------------------------------------
SELECT civicrm_contribution.total_amount as median
FROM civicrm_contact contact_a
LEFT JOIN civicrm_contribution ON civicrm_contribution.contact_id = contact_a.id
WHERE ( contact_a.id = '76' )
AND (contact_a.is_deleted = 0)
AND (contact_a.is_deleted = 0) AND civicrm_contribution.contribution_status_id = 1
AND civicrm_contribution.currency = 'AUD'
ORDER BY median LIMIT 0,1;
7.
------------------------------------
SELECT count(*) as count FROM civicrm_contact contact_a LEFT JOIN civicrm_contribution ON civicrm_contribution.contact_id = contact_a.id WHERE ( contact_a.id = '76' ) AND (contact_a.is_deleted = 0) AND (contact_a.is_deleted = 0) AND civicrm_contribution.contribution_status_id = 1 AND civicrm_contribution.currency = 'NZD';
8.
------------------------------------
SELECT civicrm_contribution.total_amount as median
FROM civicrm_contact contact_a LEFT JOIN civicrm_contribution ON civicrm_contribution.contact_id = contact_a.id WHERE ( contact_a.id = '76' ) AND (contact_a.is_deleted = 0) AND (contact_a.is_deleted = 0) AND civicrm_contribution.contribution_status_id = 1 AND civicrm_contribution.currency = 'NZD'
ORDER BY median LIMIT 0,1;
9.
------------------------------------
SELECT count(*) as count FROM civicrm_contact contact_a LEFT JOIN civicrm_contribution ON civicrm_contribution.contact_id = contact_a.id WHERE ( contact_a.id = '76' ) AND (contact_a.is_deleted = 0) AND (contact_a.is_deleted = 0) AND civicrm_contribution.contribution_status_id = 1 AND civicrm_contribution.currency = 'USD';
10.
------------------------------------
SELECT civicrm_contribution.total_amount as median
FROM civicrm_contact contact_a LEFT JOIN civicrm_contribution ON civicrm_contribution.contact_id = contact_a.id WHERE ( contact_a.id = '76' ) AND (contact_a.is_deleted = 0) AND (contact_a.is_deleted = 0) AND civicrm_contribution.contribution_status_id = 1 AND civicrm_contribution.currency = 'USD'
ORDER BY median LIMIT 0,2;
11.
------------------------------------
SELECT COUNT( conts.total_amount ) as cancel_count,
SUM( conts.total_amount ) as cancel_amount,
AVG( conts.total_amount ) as cancel_avg,
conts.currency as currency FROM (
SELECT civicrm_contribution.total_amount, civicrm_contribution.currency FROM civicrm_contact contact_a LEFT JOIN civicrm_contribution ON civicrm_contribution.contact_id = contact_a.id WHERE ( contact_a.id = '76' ) AND (contact_a.is_deleted = 0) AND (contact_a.is_deleted = 0) AND civicrm_contribution.cancel_date IS NOT NULL
GROUP BY civicrm_contribution.id
) as conts
GROUP BY currency;
12.
------------------------------------
SELECT COUNT( conts.total_amount ) as total_count,
SUM( conts.total_amount ) as total_amount,
AVG( conts.total_amount ) as total_avg,
conts.currency as currency FROM (
SELECT civicrm_contribution.total_amount, COUNT(civicrm_contribution.total_amount) as civicrm_contribution_total_amount_count,
civicrm_contribution.currency FROM civicrm_contact contact_a LEFT JOIN civicrm_contribution ON civicrm_contribution.contact_id = contact_a.id WHERE ( contact_a.id = '76' ) AND (contact_a.is_deleted = 0) AND (contact_a.is_deleted = 0) AND civicrm_contribution.contribution_status_id = 1 GROUP BY civicrm_contribution.id
) as conts
GROUP BY currency;
13.
------------------------------------
SELECT COUNT( conts.total_amount ) as total_count,
SUM( conts.total_amount ) as total_amount,
AVG( conts.total_amount ) as total_avg,
conts.currency as currency, SUBSTRING_INDEX(GROUP_CONCAT(conts.total_amount
ORDER BY conts.civicrm_contribution_total_amount_count DESC SEPARATOR ';'), ';', 1) as amount,
MAX(conts.civicrm_contribution_total_amount_count) as civicrm_contribution_total_amount_count
FROM (SELECT civicrm_contribution.total_amount, COUNT(civicrm_contribution.total_amount) as civicrm_contribution_total_amount_count,
civicrm_contribution.currency FROM civicrm_contact contact_a LEFT JOIN civicrm_contribution ON civicrm_contribution.contact_id = contact_a.id WHERE ( contact_a.id = '76' ) AND (contact_a.is_deleted = 0) AND (contact_a.is_deleted = 0) AND civicrm_contribution.contribution_status_id = 1
GROUP BY currency, civicrm_contribution.total_amount ORDER BY civicrm_contribution_total_amount_count DESC) as conts
GROUP BY currency;
14.
------------------------------------
SELECT count(*) as count FROM civicrm_contact contact_a LEFT JOIN civicrm_contribution ON civicrm_contribution.contact_id = contact_a.id WHERE ( contact_a.id = '76' ) AND (contact_a.is_deleted = 0) AND (contact_a.is_deleted = 0) AND civicrm_contribution.contribution_status_id = 1 AND civicrm_contribution.currency = 'AUD';
15.
------------------------------------
SELECT civicrm_contribution.total_amount as median
FROM civicrm_contact contact_a LEFT JOIN civicrm_contribution ON civicrm_contribution.contact_id = contact_a.id WHERE ( contact_a.id = '76' ) AND (contact_a.is_deleted = 0) AND (contact_a.is_deleted = 0) AND civicrm_contribution.contribution_status_id = 1 AND civicrm_contribution.currency = 'AUD'
ORDER BY median LIMIT 0,1;
16.
------------------------------------
SELECT count(*) as count FROM civicrm_contact contact_a LEFT JOIN civicrm_contribution ON civicrm_contribution.contact_id = contact_a.id WHERE ( contact_a.id = '76' ) AND (contact_a.is_deleted = 0) AND (contact_a.is_deleted = 0) AND civicrm_contribution.contribution_status_id = 1 AND civicrm_contribution.currency = 'NZD';
17.
------------------------------------
SELECT civicrm_contribution.total_amount as median
FROM civicrm_contact contact_a LEFT JOIN civicrm_contribution ON civicrm_contribution.contact_id = contact_a.id WHERE ( contact_a.id = '76' ) AND (contact_a.is_deleted = 0) AND (contact_a.is_deleted = 0) AND civicrm_contribution.contribution_status_id = 1 AND civicrm_contribution.currency = 'NZD'
ORDER BY median LIMIT 0,1;
18.
------------------------------------
SELECT count(*) as count FROM civicrm_contact contact_a LEFT JOIN civicrm_contribution ON civicrm_contribution.contact_id = contact_a.id WHERE ( contact_a.id = '76' ) AND (contact_a.is_deleted = 0) AND (contact_a.is_deleted = 0) AND civicrm_contribution.contribution_status_id = 1 AND civicrm_contribution.currency = 'USD';
19.
------------------------------------
SELECT civicrm_contribution.total_amount as median
FROM civicrm_contact contact_a LEFT JOIN civicrm_contribution ON civicrm_contribution.contact_id = contact_a.id WHERE ( contact_a.id = '76' ) AND (contact_a.is_deleted = 0) AND (contact_a.is_deleted = 0) AND civicrm_contribution.contribution_status_id = 1 AND civicrm_contribution.currency = 'USD'
ORDER BY median LIMIT 0,2;
20.
------------------------------------
SELECT COUNT( conts.total_amount ) as cancel_count,
SUM( conts.total_amount ) as cancel_amount,
AVG( conts.total_amount ) as cancel_avg,
conts.currency as currency FROM (
SELECT civicrm_contribution.total_amount, civicrm_contribution.currency FROM civicrm_contact contact_a LEFT JOIN civicrm_contribution ON civicrm_contribution.contact_id = contact_a.id WHERE ( contact_a.id = '76' ) AND (contact_a.is_deleted = 0) AND (contact_a.is_deleted = 0) AND civicrm_contribution.cancel_date IS NOT NULL
GROUP BY civicrm_contribution.id
) as conts
GROUP BY currency;
21.
------------------------------------
SELECT a.id as `id`, a.contact_id as `contact_id`, a.amount as `amount`, a.currency as `currency`, a.frequency_unit as `frequency_unit`, a.frequency_interval as `frequency_interval`, a.installments as `installments`, a.start_date as `start_date`, a.create_date as `create_date`, a.modified_date as `modified_date`, a.cancel_date as `cancel_date`, a.end_date as `end_date`, a.processor_id as `processor_id`, a.payment_token_id as `payment_token_id`, a.trxn_id as `trxn_id`, a.invoice_id as `invoice_id`, a.contribution_status_id as `contribution_status_id`, a.is_test as `is_test`, a.cycle_day as `cycle_day`, a.next_sched_contribution_date as `next_sched_contribution_date`, a.failure_count as `failure_count`, a.failure_retry_date as `failure_retry_date`, a.auto_renew as `auto_renew`, a.payment_processor_id as `payment_processor_id`, a.financial_type_id as `financial_type_id`, a.payment_instrument_id as `payment_instrument_id`, a.campaign_id as `campaign_id`, a.is_email_receipt as `is_email_receipt`
FROM civicrm_contribution_recur a
WHERE (a.contact_id = "76") AND (a.contribution_status_id IN ("3", "10", "7", "1"))
ORDER BY a.is_test, a.start_date DESC;
22.
------------------------------------
SELECT SQL_CALC_FOUND_ROWS ccs.id, ccs.amount as amount,
ccs.contribution_id,
ccs.pcp_id,
ccs.pcp_display_in_roll,
ccs.pcp_roll_nickname,
ccs.pcp_personal_note,
ccs.soft_credit_type_id,
sov.label as sct_label,
cc.receive_date,
cc.contact_id as contributor_id,
cc.contribution_status_id as contribution_status_id,
cov.label as contribution_status,
cp.title as pcp_title,
cc.currency,
contact.display_name as contributor_name,
cct.name as financial_type
FROM civicrm_contribution_soft ccs
LEFT JOIN civicrm_contribution cc
ON ccs.contribution_id = cc.id
LEFT JOIN civicrm_pcp cp
ON ccs.pcp_id = cp.id
LEFT JOIN civicrm_contact contact ON
ccs.contribution_id = cc.id AND cc.contact_id = contact.id
LEFT JOIN civicrm_financial_type cct ON cc.financial_type_id = cct.id
LEFT JOIN civicrm_option_value sov ON sov.option_group_id = %3 AND ccs.soft_credit_type_id = sov.value
LEFT JOIN civicrm_option_value cov ON cov.option_group_id = %4 AND cc.contribution_status_id = cov.value
WHERE cc.is_test = %2 AND ccs.contact_id = %1 ORDER BY cc.receive_date DESC ;
23.
------------------------------------
SELECT count( x.id ) count FROM (
SELECT contribution.id AS id
FROM civicrm_contribution contribution
LEFT JOIN civicrm_line_item i ON i.contribution_id = contribution.id AND i.entity_table = 'civicrm_contribution' AND i.financial_type_id NOT IN (3,1,4,2)
WHERE contribution.is_test = 0 AND contribution.contact_id = 76
AND contribution.financial_type_id IN (3,1,4,2)
AND i.id IS NULL UNION
SELECT contribution.id
FROM civicrm_contribution contribution INNER JOIN civicrm_contribution_soft softContribution
ON ( contribution.id = softContribution.contribution_id )
WHERE contribution.is_test = 0 AND softContribution.contact_id = 76 ) x;5.13.0https://lab.civicrm.org/dev/core/-/issues/537Owner notification email sending every time the contribution is resaved2020-12-04T10:43:06Zrita_compucorpOwner notification email sending every time the contribution is resavedWhen someone donates to a fundraising page, and then the site's staff member goes and edits the contribution that is related to the fundraising page, and saves the changes (even if there is no change just resaving the contribution) the f...When someone donates to a fundraising page, and then the site's staff member goes and edits the contribution that is related to the fundraising page, and saves the changes (even if there is no change just resaving the contribution) the fundraiser will receive the same email notification again.
Steps:
- create a contribution page and enable fundraising pages to be created under it
- make the payment processor to be Sagepay or Paypal standard
- create a fundraising page
- then log out and start donating to the fundraising page
- after donation the fundraiser will receive an email
- then go to the civi backend, search for the contribution that was just created after donation
- click Edit at that contribution
- no need to change anything on the contribution, just click Save
--> the same owner notification will be sent to the owner again. Every time you update the contribution the owner receives a notification with the same details.
Expected:
- online contribution: the notification should only be sent once, after the successful donation
- offline contribution: the notification should only be sent once, after creating the new contribution from civi backend
Tested on Civi 5.4 and 5.7, same happening on both.5.33.0https://lab.civicrm.org/dev/core/-/issues/538Activity search (advanced search) by subject - is exact match only2022-11-25T05:03:18ZRayWrightActivity search (advanced search) by subject - is exact match onlySearching activity subject (or details) from the advanced search form is set to an exact match (=). This seems less than ideal as most of the time you won't know the exact subject or details. While you can add the wildcard % characters t...Searching activity subject (or details) from the advanced search form is set to an exact match (=). This seems less than ideal as most of the time you won't know the exact subject or details. While you can add the wildcard % characters to search, the standalone activity search form operates as you'd expect using the LIKE term.
Can the advanced search (activities section) be made to match this behavior?
Here's a detailed breakdown verified on the demo site:
* Run an Advanced search for an activity that contains "Tell a Friend" in the subject line - no results.
* Run a standalone activity search (Search > Find Activities) for an activity that contains "Tell a Friend" in the subject line - returns all the activities that subject line contains the search term, including "Subject for Tell a Friend".
* Same problem when you search details or both.
Here is the on-screen feedback for the search results:
**Advanced Search**
```
No matches found for:
Activity targeted to ...AND...
Activity Text (Subject Only) = 'Tell a Friend' ...AND...
Activity Status In Completed
```
**Find Activies**
```
Activity targeted to ...AND...
Activity Text (Subject Only) Like '%Tell a Friend%' ...AND...
Activity Status In Completed
```https://lab.civicrm.org/dev/core/-/issues/539Create a hook for custom relative date filters (CRM-16195)2024-03-25T15:18:49ZJonGoldCreate a hook for custom relative date filters (CRM-16195)To summarize: From the time relative date filters debuted in 4.2(?) until 4.7, each release added a number of relative date filters that one person needed and the rest of the world didn't. To prevent this happening forever, we moved rel...To summarize: From the time relative date filters debuted in 4.2(?) until 4.7, each release added a number of relative date filters that one person needed and the rest of the world didn't. To prevent this happening forever, we moved relative dates into an OptionGroup, and intended to give the ability to create new ones.
I worked on this last year but some cleanup PRs got stalled. They're all merged now so I'm submitting this.
While @eileen did work recently to support relative dates like "32 months in the past", it's still not possible to do relative dates like, "from 6 months ago to the end of this year", or "from Thanksgiving to Christmas". A former client of mine had reports that went from October to September, but this was NOT their fiscal year.
A simple hook facilitates the creation of custom relative date filters. I'll submit tests, but you can see an extension that uses it here: https://github.com/MegaphoneJon/com.megaphonetech.relativedatetest5.9JonGoldJonGoldhttps://lab.civicrm.org/dev/core/-/issues/540Civicrm Contact Dashboard returns fatal error2018-11-22T01:41:11Zluke.stewartCivicrm Contact Dashboard returns fatal errorSimilar to https://github.com/civicrm/civicrm-core/pull/13112
Visiting the contact dashboard at https://dmaster.demo.civicrm.org/civicrm/user?reset=1 results in the following error:
> Sorry, due to an error, we are unable to fulfill you...Similar to https://github.com/civicrm/civicrm-core/pull/13112
Visiting the contact dashboard at https://dmaster.demo.civicrm.org/civicrm/user?reset=1 results in the following error:
> 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.
> Cannot determine api action for CRM_Contribute_Form_Search.CRM_Core_Action "NO DESCRIPTION SET
![image](/uploads/a3f9baf8ad2032192723162c6a73f8ad/image.png)5.8https://lab.civicrm.org/dev/core/-/issues/541Contact custom fields are not imported when basic type custom field is includ...2022-12-04T05:03:21ZjitendraContact custom fields are not imported when basic type custom field is included in import fileTo replicate -
1. Create a custom group which extends `Contact`. Add some fields to it.
2. Create a custom group which extends `Individual`. Similarly, add some fields.
3. Import contact with a csv file holding values of both the above ...To replicate -
1. Create a custom group which extends `Contact`. Add some fields to it.
2. Create a custom group which extends `Individual`. Similarly, add some fields.
3. Import contact with a csv file holding values of both the above custom fields.
4. Only custom fields that extends `Contact` will be imported. The one created at step 2 will be ignored.jitendrajitendrahttps://lab.civicrm.org/dev/core/-/issues/542Case Manager is not shown for closed cases.2021-06-30T15:07:09ZjitendraCase Manager is not shown for closed cases.Current Status
-----
When closing a case, all case roles (relationships) are given an end date. This keeps them from cluttering up core screens (e.g. contact summary activity tab) where only active relationships should be shown. However...Current Status
-----
When closing a case, all case roles (relationships) are given an end date. This keeps them from cluttering up core screens (e.g. contact summary activity tab) where only active relationships should be shown. However it causes undesired behavior when viewing closed cases: all the case roles are gone.
One proposed solution is to show all disabled relationships when viewing a closed case. However this isn't quite right as it is then impossible to distinguish current roles from roles that ended before the case was closed.
Proposal
-----
(after discussion at NY Sprint btw @eileen @colemanw & @DaveD)
1. Stop ending/disabling relationships when a case is closed.
2. Update core screens to filter out relationships from closed cases when displaying active relationships (e.g. contact summary activity tab)
3. Add upgrade script to reactivate & remove end date from all activities that ended on the same date their case was closed.
Further reading
-------
Past discussions of this at https://civicrm.stackexchange.com/questions/27215/case-roles-on-closed-cases5.40.0jitendrajitendrahttps://lab.civicrm.org/dev/core/-/issues/543Disabled Campaigns showing up in the campaign drop-down menu.2022-09-20T05:03:22ZyosefromanoDisabled Campaigns showing up in the campaign drop-down menu.Disabled Campaigns showing up in the campaign drop-down menu.
I tested in dmaster by adding 2 campaigns: Active, Not Active.
I disabled the campaign called not-active.
Went into search and reports to see if it showed up in the campaign...Disabled Campaigns showing up in the campaign drop-down menu.
I tested in dmaster by adding 2 campaigns: Active, Not Active.
I disabled the campaign called not-active.
Went into search and reports to see if it showed up in the campaign drop-down, and it did :(
![Screen_Shot_2018-11-22_at_1.43.57_PM](/uploads/b59df03dafca6e55a9186f675b9fbaf0/Screen_Shot_2018-11-22_at_1.43.57_PM.png)
![Screen_Shot_2018-11-22_at_1.43.49_PM](/uploads/5935e4a7fc8f149621bbc986892b158b/Screen_Shot_2018-11-22_at_1.43.49_PM.png)
![Screen_Shot_2018-11-22_at_1.44.13_PM](/uploads/bbd812af33b72be715d2473d7aa3dda7/Screen_Shot_2018-11-22_at_1.44.13_PM.png)https://lab.civicrm.org/dev/core/-/issues/544Contact Subtype field at Reports does not support contacts with multiple subt...2024-01-16T05:03:26ZscardiniusContact Subtype field at Reports does not support contacts with multiple subtypesHow to reproduce:
* open "Reports > Contact Reports > Constituent Summary" report
* click "Filters" tab
* select "Is one of" for "Contact Subtype" field
* choose subtype "Student"
* click "Refresh results" button
* look at results: Ther...How to reproduce:
* open "Reports > Contact Reports > Constituent Summary" report
* click "Filters" tab
* select "Is one of" for "Contact Subtype" field
* choose subtype "Student"
* click "Refresh results" button
* look at results: There are contacts which have only one subtype "Student"
* click "Developer" tab
* look at WHERE clause `contact_civireport.contact_sub_type IN ('Student')`
This condition should looks like this:
`contact_civireport.contact_sub_type LIKE '%Student%'`