Development issueshttps://lab.civicrm.org/groups/dev/-/issues2023-11-23T07:09:32Zhttps://lab.civicrm.org/dev/core/-/issues/661Membership receipts do not display Credit Card information2023-11-23T07:09:32ZcommonpikeMembership receipts do not display Credit Card informationFrom https://issues.civicrm.org/jira/browse/CRM-18027
(also https://civicrm.stackexchange.com/questions/15150)
Most of the issues mentioned there seem to be solved in 5.8.1, however, Credit Card information is still not showing up (and ...From https://issues.civicrm.org/jira/browse/CRM-18027
(also https://civicrm.stackexchange.com/questions/15150)
Most of the issues mentioned there seem to be solved in 5.8.1, however, Credit Card information is still not showing up (and leaving strange blanks in the email).
**To reproduce issue:**
1. Register as a new, paying, member, using Credit Card
2. Read the e-mail sent as 'Receipt - Membership signup'
**Details**
In the system template "Memberships - Receipt (on-line)",
in the latest default,
where the source, in the text version, says
```
===========================================================
{ts}Credit Card Information{/ts}
===========================================================
{$credit_card_type}
{$credit_card_number}
{ts}Expires{/ts}: {$credit_card_exp_date|truncate:7:''|crmDate}
{/if}
```
the generated output is
```
===========================================================
Credit Card Information
===========================================================
Expires:
```
The HTML version and the PDF have the same problem.
![Screen_Shot_2019-01-11_at_14.25.50](/uploads/95b1c84df44d3003a81cb93b8b2d79ee/Screen_Shot_2019-01-11_at_14.25.50.png)https://lab.civicrm.org/dev/financial/-/issues/37Can't search by check number for checks entered with "Record Payment"2021-10-19T05:02:37ZJonGoldCan't search by check number for checks entered with "Record Payment"Someone reported this [on Stack Exchange](https://civicrm.stackexchange.com/q/27989/12), and it's pretty easy to replicate with their steps: "when you edit a pending pay later contribution, add a check number, change status to complete a...Someone reported this [on Stack Exchange](https://civicrm.stackexchange.com/q/27989/12), and it's pretty easy to replicate with their steps: "when you edit a pending pay later contribution, add a check number, change status to complete and then i go to search contributions, enter the payment method and search by check number i get no result."
`check_number` is a field both in `civicrm_contribution` and `civicrm_financial_trxn`. I suspect this is for historical reasons rather than anything anyone considers correct in 2019.
* To solve the immediate issue, "Find Contributions" should search the check number field of related financial transactions rather than the contribution itself.
* I think there's a strong argument that `civicrm_contribution.check_number` should be deprecated altogether, but that's a much larger issue.https://lab.civicrm.org/dev/core/-/issues/600Word Replacements: entering a string with HTML will reset all replacements2023-04-12T20:56:13ZbgmWord Replacements: entering a string with HTML will reset all replacementsHow to reproduce:
* On a single language site, go to Administer > Customize data and screen > Word Replacements
* Enter a few replacements, it doesn't matter if they are valid.
* Save, so far so good.
Then add a new replacement with ht...How to reproduce:
* On a single language site, go to Administer > Customize data and screen > Word Replacements
* Enter a few replacements, it doesn't matter if they are valid.
* Save, so far so good.
Then add a new replacement with html: `<p>test</p>`, and click save.
Result: word replacements table will be completely empty.
I debugged a bit and this is because `CRM_Core_BAO_WordReplacement.php::getConfigArraysAsAPIParams()` uses `unserialize` on the strings that are stored in `civicrm_domain` (ugh). The unserialize fails because of the HTML, so it returns FALSE, and the function ends up returning an empty array, which is then used to re-populate the `civicrm_word_replacement` table.https://lab.civicrm.org/dev/core/-/issues/470Current employer dissapears when disabling expired relationships2024-03-15T18:12:06ZfrancescbassasCurrent employer dissapears when disabling expired relationshipsOriginal issue: https://issues.civicrm.org/jira/browse/CRM-21851
Affected versions: at least from 5.0.0
---
How to reproduce:
1) Create a current relationship on individual A as *employee of* organization B and mark as *current emplo...Original issue: https://issues.civicrm.org/jira/browse/CRM-21851
Affected versions: at least from 5.0.0
---
How to reproduce:
1) Create a current relationship on individual A as *employee of* organization B and mark as *current employer*
2) Create a past relationship on individual A as *employee of* organization B without marking as current employer
At this point on summary tab of individual A appears organization B as his Employer.
3) Run *Disable expired relationships* cron job
At this point on summary tab there is no organization at Employer field although there is one active employee relationship and past relationship was disabled.5.17.0https://lab.civicrm.org/dev/core/-/issues/464Disabling "Search Primary Details Only" breaks export of primary address2023-06-16T21:12:50ZmfbDisabling "Search Primary Details Only" breaks export of primary addressMigrated from https://issues.civicrm.org/jira/browse/CRM-21423
Disabling the "Search Primary Details Only"* setting switch leads to wrong export of contact primary address.
Reason is that a requested location_type is not set and Export...Migrated from https://issues.civicrm.org/jira/browse/CRM-21423
Disabling the "Search Primary Details Only"* setting switch leads to wrong export of contact primary address.
Reason is that a requested location_type is not set and Export.php's call to CRM_Contact_BAO_Query does not set the default search to use primary location.
A fix was proposed at https://github.com/civicrm/civicrm-core/pull/11274 but has been closed as more tests would need to be written.
\* My anecdotal experience is that, if the user has been merging contacts w/ multiple email addresses such that secondary email addresses are fairly common, then there's a frequent need to search across all email addresses, so this setting does need to be disabled.https://lab.civicrm.org/dev/financial/-/issues/32Authorize.net Fees Not Reflected In Civi2019-01-12T19:07:11ZguyiacAuthorize.net Fees Not Reflected In CiviWhen credit card payments are made using the Authorize.net payment processor packaged natively in Civi, the credit card fees are not fed back from Authorize to Civi, and as a result do not show up in Civi. This was brought forward by one...When credit card payments are made using the Authorize.net payment processor packaged natively in Civi, the credit card fees are not fed back from Authorize to Civi, and as a result do not show up in Civi. This was brought forward by one of my clients (Helena Carvalho of AHCC) during the accounting integration presentation at CiviCamp Hartford, and confirmed by Brian Shaughnessy right after the presentation.https://lab.civicrm.org/dev/core/-/issues/411Default currency shown on forms if payment is made with different currency2023-11-23T07:47:00ZjitendraDefault currency shown on forms if payment is made with different currencyDefault currency shown on View participant and contribution page if payment is made with different currency
Steps to reproduce -
- Create a priceset with some price fields.
- Create a contribution page with currency = EUR or any other ...Default currency shown on View participant and contribution page if payment is made with different currency
Steps to reproduce -
- Create a priceset with some price fields.
- Create a contribution page with currency = EUR or any other currency other than the default USD.
- Create a payment by submitting the contribution page.
- The payment shown on the contact summary page stated in USD even though it should have been taken in EUR.
Similarly, default currency is shown for participants registered for the event using EUR.
---
There are still 102 matches found where similar formatting is done.
```
$ grep -irn "crmMoney}" templates/ | wc -l
102
```
We need to fix all instances in core.
Ref https://github.com/civicrm/civicrm-core/pull/12875 for the first fixjitendrajitendrahttps://lab.civicrm.org/dev/translation/-/issues/17RTL issue: form label should be at right, and their input fields, at the left.2018-10-22T18:50:53ZcalbasiRTL issue: form label should be at right, and their input fields, at the left.I'm not sure if I should create this issue here or at civicrm core repository. Doing here, as first step to make a Merge Request at Github repository.
I'm attaching an screenshot of the wrong output. It's wrong, at least, in Arabic, but...I'm not sure if I should create this issue here or at civicrm core repository. Doing here, as first step to make a Merge Request at Github repository.
I'm attaching an screenshot of the wrong output. It's wrong, at least, in Arabic, but I suppose it's wrong for all other RTL languages. It's, too, a basic feature, because forms are used everywhere...
This issue happens at custom profile but also at system/default profiles.![Captura_2018-09-13_17-20-29](/uploads/3bdba1980909fd4fb5a0ea96979bd24d/Captura_2018-09-13_17-20-29.png)
![Captura_2018-09-13_17-17-19](/uploads/e6b36a362c68005b37c0a74e0d106194/Captura_2018-09-13_17-17-19.png)https://lab.civicrm.org/dev/financial/-/issues/30Date filter on searching personal campaign pages2018-10-12T07:26:46ZmvuDate filter on searching personal campaign pagesWhen searching for personal campaign pages, we implemented a date filter, where you can search for any active personal campaign pages, that were active during this period of time:
![image](/uploads/6fe01b3760b06d8c847aea1186a6e9cc/imag...When searching for personal campaign pages, we implemented a date filter, where you can search for any active personal campaign pages, that were active during this period of time:
![image](/uploads/6fe01b3760b06d8c847aea1186a6e9cc/image.png)
Can we make a PR into core?https://lab.civicrm.org/dev/wordpress/-/issues/3Create CiviCRM Block for new Gutenberg Editor2023-12-07T22:18:11ZkcristianoCreate CiviCRM Block for new Gutenberg EditorWP is introducing a new editor in v 5.0 - https://github.com/WordPress/gutenberg
As of this post: https://make.wordpress.org/core/2018/07/06/whats-new-in-gutenberg-6th-july/ Gutenberg has been declared to be at the MVP stage and a me...WP is introducing a new editor in v 5.0 - https://github.com/WordPress/gutenberg
As of this post: https://make.wordpress.org/core/2018/07/06/whats-new-in-gutenberg-6th-july/ Gutenberg has been declared to be at the MVP stage and a merge proposal will be submitted "soon". The current target date is "august", but that can move.
Based on the above, it would be a good time to explore what will be needed to convert our CiviCRM shortcode button to a Gutenberg block.https://lab.civicrm.org/dev/drupal/-/issues/25View Relationship Type: Event to Participant Contact2020-07-16T17:23:38ZjohnffView Relationship Type: Event to Participant ContactSuccess! I have successfully added a new View Relationship type that allows you to connect a Contact to your Event, and even select it by role id.
But! Only the contact's core fields are in. Now, we can easily create another relationshi...Success! I have successfully added a new View Relationship type that allows you to connect a Contact to your Event, and even select it by role id.
But! Only the contact's core fields are in. Now, we can easily create another relationship to bring in the Contact's custom fields, but I can't see any barrier to bringing them in by default. How are custom fields connected to a table?https://lab.civicrm.org/dev/financial/-/issues/25event registration: support partial payments when constructing contribution2020-02-17T04:43:01Zlcdwebevent registration: support partial payments when constructing contributionThe contribution BAO add method supports two parameters that can be used to create a contribution with a partial payment: partial_payment_total and partial_amount_to_pay.
I'd like to modify CRM_Event_Form_Registration::processContributi...The contribution BAO add method supports two parameters that can be used to create a contribution with a partial payment: partial_payment_total and partial_amount_to_pay.
I'd like to modify CRM_Event_Form_Registration::processContribution() to add support for these parameters. Doing so would enable hook based modifications to pass a partial payment amount (e.g. to support a "deposit" amount on an event registration). There should be minimal impact on existing functionality as those params are not actively used. We would simply support them if they are passed to that function.
(looking for concept approval)lcdweblcdwebhttps://lab.civicrm.org/dev/financial/-/issues/20Online PayNow 'overcharges' partially paid contributions2023-06-16T09:30:23ZMonish DebOnline PayNow 'overcharges' partially paid contributionsJust noticed that when using the Pay Now functionality from the contact dashboard it does NOT take in account partially paid contributions.
Instead, a payment screen for the full contribution is shown. This can lead to overcharging peop...Just noticed that when using the Pay Now functionality from the contact dashboard it does NOT take in account partially paid contributions.
Instead, a payment screen for the full contribution is shown. This can lead to overcharging people and does not add to the fragile trust relationship we (and many non-profits) have with their donors & participants. Therefor I qualified it as a major issue.
I think the desired behavior is that the payment screen would show the build up of the total like now (it uses the price set where applicable) and under all that the required (remaining) payment should be shown (and used for the payment).
Online Pay Now functionality was introduced here:
https://issues.civicrm.org/jira/browse/CRM-19263
We use it by mailing the constructed link to our users with outstanding contributions, like:
https://mysite/civicrm/contribute/transact?reset=1&id=7&ccid=1234&cs=355345fdgda60b2d1a89f22fc643b&cid=4321
I added a screenshot of the contribution that was partially paid (20 paid out of a total of 50), and the corresponding Pay Now screen showing and charging 50, and a mockup of how it should be shown (or at least it should charge the remaining 30 and not the full 50)
Original JIRA ticket : https://issues.civicrm.org/jira/browse/CRM-21700jitendrajitendrahttps://lab.civicrm.org/dev/drupal/-/issues/24[webform_civicrm] - monies display properly but don't get processed when usin...2020-07-16T17:23:38ZKarinG[webform_civicrm] - monies display properly but don't get processed when using webform_calculator module to calculate e.g. participant fees![image](/uploads/c6a3f46f1ca9a57819370b9c3f4012dd/image.png)
![image](/uploads/ed87bfaed0cda7b8e3061573c4168735/image.png)
![image](/uploads/7ca2158df886d944766a86459a23be2f/image.png)
![image](/uploads/f7eb9556cd07695f72bed3f28ab4c8...![image](/uploads/c6a3f46f1ca9a57819370b9c3f4012dd/image.png)
![image](/uploads/ed87bfaed0cda7b8e3061573c4168735/image.png)
![image](/uploads/7ca2158df886d944766a86459a23be2f/image.png)
![image](/uploads/f7eb9556cd07695f72bed3f28ab4c8dd/image.png)
![image](/uploads/595a14b6ec110408df2560e23fce1673/image.png)colemanwcolemanwhttps://lab.civicrm.org/dev/financial/-/issues/18Proposal - Money formatting2021-03-24T01:03:07Zmattwiremjw@mjwconsult.co.ukProposal - Money formattingWe need to look at a better approach to formatting money within CiviCRM. It should properly handle currencies, decimal places, "1000" separater (ie 1,000.00 and 1.000,00).
Some approaches:
- Money formatting functions: https://github.c...We need to look at a better approach to formatting money within CiviCRM. It should properly handle currencies, decimal places, "1000" separater (ie 1,000.00 and 1.000,00).
Some approaches:
- Money formatting functions: https://github.com/civicrm/civicrm-core/pull/12055
- Allow higher precision decimals to be entered so tax can be calculated correctly: https://github.com/civicrm/civicrm-core/pull/10641
- MoneyPHP?
cc @eileen This is a tracking issue so I can close down PRs.https://lab.civicrm.org/dev/core/-/issues/76Multiple roles per participant causes incorrect participant counts (was: Civi...2023-11-12T15:46:22ZUpperholmeMultiple roles per participant causes incorrect participant counts (was: CiviEvent no longer respects Max Participants)Since upgrading to 5.0 I find that events continue to allow front end registrations despite the number of counted participants exceeding the max number set on the event configuration. The on-screen alert is not displayed, and registratio...Since upgrading to 5.0 I find that events continue to allow front end registrations despite the number of counted participants exceeding the max number set on the event configuration. The on-screen alert is not displayed, and registration remains open.
as a temporary workaround I'm having to closely monitor registrations and manually turn off online registration and edit the event information to provide an 'event full' message when capacity is reached.https://lab.civicrm.org/dev/financial/-/issues/13PayPal Express recurring notifications don't work for test transaction2023-11-23T07:32:26Zcarbar1103PayPal Express recurring notifications don't work for test transactionI set up a PayPal Express payment processor and a contribution page to take donations, both recurring and one-off. When taking one-off donations, everything worked as expected. However, for recurring donations, the initial contribution...I set up a PayPal Express payment processor and a contribution page to take donations, both recurring and one-off. When taking one-off donations, everything worked as expected. However, for recurring donations, the initial contribution remained pending and PayPal IPN reported a 500 error.
I managed to track down the issue to the handlePaymentExpress() method in the CRM/Core/Payment/PayPalProIPN.php file.
At around line 578, it does this:
` $result = civicrm_api3('contribution', 'getsingle', array('invoice_id' => $input['invoice']));
`
Unfortunately, this only works for live contributions. I fixed this by changing where it retrieves the recurring contribution from
` $contributionRecur = civicrm_api3('contribution_recur', 'getsingle', array(
'return' => 'contact_id, id',
'invoice_id' => $input['invoice'],
));
`
to
` $contributionRecur = civicrm_api3('contribution_recur', 'getsingle', array(
'return' => 'contact_id, id, is_test, payment_processor_id',
'invoice_id' => $input['invoice'],
));
`
and changed line 578 to
` $result = civicrm_api3('contribution', 'getsingle', array('invoice_id' => $input['invoice'], 'contribution_test' => $contributionRecur['is_test']));
`
However, the contribution still remained pending. The other error was a few lines further down:
` $paymentProcessorID = self::getPayPalPaymentProcessorID();
`
This returned the wrong processor id, so I changed it to do this
` $paymentProcessorID = $contributionRecur['payment_processor_id'];
`
I have no idea if these changes will break anything else, but they seem to work for me
Regards,
Carlhttps://lab.civicrm.org/dev/translation/-/issues/8Multilingual installation with logging enabled gives error when custom field ...2020-07-14T14:56:53ZtbuytaerMultilingual installation with logging enabled gives error when custom field is changedLogging of custom fields on a multilingual installation does not work, which makes it impossible to view changes if one of the changes is a custom field.
Steps to reproduce:
1. install a fresh CiviCRM installation: 5.0 (the issue also ...Logging of custom fields on a multilingual installation does not work, which makes it impossible to view changes if one of the changes is a custom field.
Steps to reproduce:
1. install a fresh CiviCRM installation: 5.0 (the issue also existed in versions before)
2. enable **Multiple Languages Support** on http://example.org/civicrm/admin/setting/localization?reset=1
3. enable **logging** on http://example.org/civicrm/admin/setting/misc?reset=1
4. change a custom field of a contact
5. view the changelog of that contact and click on the change
This results in follwing Database error:
> Database Error Code: Table 'databasename.log_civicrm_custom_group_en_US' doesn't exist, 1146
> Additional Details:
> Array
> (
> [callback] => Array
> (
> [0] => CRM_Core_Error
> [1] => handle
> )
>
> [code] => -18
> [message] => DB Error: no such table
> [mode] => 16
> [debug_info] => SELECT id, title FROM `databasename`.log_civicrm_custom_group_en_US WHERE log_date <= '2018-04-09 17:40:29' AND table_name = 'civicrm_value_constituent_information_1' ORDER BY log_date DESC LIMIT 1 [nativecode=1146 ** Table 'databasename.log_civicrm_custom_group_en_US' doesn't exist]
> [type] => DB_Error
> [user_info] => SELECT id, title FROM `databasename`.log_civicrm_custom_group_en_US WHERE log_date <= '2018-04-09 17:40:29' AND table_name = 'civicrm_value_constituent_information_1' ORDER BY log_date DESC LIMIT 1 [nativecode=1146 ** Table 'databasename.log_civicrm_custom_group_en_US' doesn't exist]
> [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT id, title FROM `databasename`.log_civicrm_custom_group_en_US WHERE log_date <= '2018-04-09 17:40:29' AND table_name = 'civicrm_value_constituent_information_1' ORDER BY log_date DESC LIMIT 1 [nativecode=1146 ** Table 'databasename.log_civicrm_custom_group_en_US' doesn't exist]"]
> )
*I replaced the actual database name with 'databasename' in the error message above*https://lab.civicrm.org/dev/drupal/-/issues/16[webform_civicrm] - edits to 'cart' display when using installments functiona...2020-07-16T17:23:38ZKarinG[webform_civicrm] - edits to 'cart' display when using installments functionalityWorking on this with CompuCorp
**Before:**
![image](/uploads/7ed8454c61bf9b3b098e7281d7e1b5ca/image.png)
Imagine this was configured as pay in 2 installments (two payments of $96/each) - how about something like this:
**After:**
![im...Working on this with CompuCorp
**Before:**
![image](/uploads/7ed8454c61bf9b3b098e7281d7e1b5ca/image.png)
Imagine this was configured as pay in 2 installments (two payments of $96/each) - how about something like this:
**After:**
![image](/uploads/73dc36a7fb0d1e6b590f77bb666f2a0e/image.png)https://lab.civicrm.org/dev/core/-/issues/31Cancelled auto-renew membership and scheduled reminders don't play nice2023-04-28T01:39:33ZkonadaveCancelled auto-renew membership and scheduled reminders don't play niceRecently upgraded a site from 4.6.21 to 4.7.27. Payment processor is iATS Payments, if that makes any difference.
When an auto-renew membership is cancelled, the contribution_recur_id field in civicrm_membership for that membership is l...Recently upgraded a site from 4.6.21 to 4.7.27. Payment processor is iATS Payments, if that makes any difference.
When an auto-renew membership is cancelled, the contribution_recur_id field in civicrm_membership for that membership is left as is.
Stated using scheduled reminders after the upgrade, and have one set up to send an email to auto-renew memberships one week in advance of their renewal so they're not surprised when their credit card is charged. Cancelled auto-renew memberships are receiving this reminder.
I honestly don't have time to do any testing or going exploring through code at the moment. For all I know this has been reported previously and is already fixed. But if it hasn't, I'm thinking that contribution_recur_id should be cleared when the recurring contribution is cancelled, or scheduled reminders should make sure the contribution_recur_id is not cancelled.