Development issueshttps://lab.civicrm.org/groups/dev/-/issues2022-04-22T16:17:16Zhttps://lab.civicrm.org/dev/core/-/issues/3327Duplicate Membership Shows for "Completed" Memberships2022-04-22T16:17:16Zlee.goodingDuplicate Membership Shows for "Completed" MembershipsThis notification shows for memberships that have been marked as completed, which does not make sense for our setup. We do not want people to use the links in that notification as we want to keep a history of when memberships start/end, ...This notification shows for memberships that have been marked as completed, which does not make sense for our setup. We do not want people to use the links in that notification as we want to keep a history of when memberships start/end, gaps between them, etc.
Would it not make more sense to have "completed" or closed memberships not show as a duplicate?https://lab.civicrm.org/dev/core/-/issues/251Fix batch copy for membership type field2019-05-01T06:03:03ZyashodhaFix batch copy for membership type fieldSteps to replicate :
1. Create a profile with membership type field.
2. Click Find Memberships and select a few members and do Update multiple memberships with above profile.
3. Click on copy icon for membership type, it doesn't copy ov...Steps to replicate :
1. Create a profile with membership type field.
2. Click Find Memberships and select a few members and do Update multiple memberships with above profile.
3. Click on copy icon for membership type, it doesn't copy over 1st row to the restyashodhayashodhahttps://lab.civicrm.org/dev/core/-/issues/252Add force search parameters to search forms.2022-08-20T05:03:37ZjitendraAdd force search parameters to search forms.Url parameters in search forms are not complete. There is yet no support to search for financial type id, pay later, etc in Contribution Search form using the URL.Url parameters in search forms are not complete. There is yet no support to search for financial type id, pay later, etc in Contribution Search form using the URL.jitendrajitendrahttps://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/core/-/issues/253Cancelling or An Error during event registration payment should cancel all ad...2022-11-05T05:03:46Zomar_compucorpCancelling or An Error during event registration payment should cancel all additional participates## Problem
If a user is registering for an event with additional participates, and for some reason the payment failed or the user decided to cancel the payment, then only the main user participant record will be set to "cancelled", the ...## Problem
If a user is registering for an event with additional participates, and for some reason the payment failed or the user decided to cancel the payment, then only the main user participant record will be set to "cancelled", the rest of additional participants will stay at "pending incomplete transaction" status.
## Solution
All participants statuses should be changed to cancelled and not just the main user, Also there should be an activity created for each participants that indicate the event registration is cancelled similar to what happen if the payment succeeded.
## Technical notes
The cancelled() and failed() methods of CRM_Core_Payment_BaseIPN class use an instance of the Participant DAO class to change the status to cancelled which results in only changing the first participant :
https://github.com/civicrm/civicrm-core/blob/master/CRM/Core/Payment/BaseIPN.php#L377
https://github.com/civicrm/civicrm-core/blob/master/CRM/Core/Payment/BaseIPN.php#L280
which should be replaced with either a call to Participant BAO create method, or the Participant API to fix the issue.https://lab.civicrm.org/dev/core/-/issues/254Documentation: Error 500 returned for bad addresses (should be 404)2018-11-28T12:53:07ZAllenShawDocumentation: Error 500 returned for bad addresses (should be 404)(Meta: not sure where else to file this issue; please direct me to a more appropriate tracker if one exists.)
Steps to reproduce:
1. Visit a nonexistent url under docs.civicrm.org, e.g. for a project that has no documentation there, e.g...(Meta: not sure where else to file this issue; please direct me to a more appropriate tracker if one exists.)
Steps to reproduce:
1. Visit a nonexistent url under docs.civicrm.org, e.g. for a project that has no documentation there, e.g.
https://docs.civicrm.org/foo/ or https://docs.civicrm.org/foo/en/latest/
2. Observe a Error 500 message.
This really seems like it should be a 404 error: I was looking for a resource that's not there.https://lab.civicrm.org/dev/core/-/issues/255Changes to copied event location reflects in original event location2019-02-05T04:25:52ZyashodhaChanges to copied event location reflects in original event locationSteps to replicate:
1. Create an event X with location A.
2. Create copy of event X say Y and go to location tab for event Y (which will now show location A).
3. Click *Create new location* radio and then click *Use existing location*, ...Steps to replicate:
1. Create an event X with location A.
2. Create copy of event X say Y and go to location tab for event Y (which will now show location A).
3. Click *Create new location* radio and then click *Use existing location*, choose option B.
4. Check event X also has location B.5.5.0yashodhayashodhahttps://lab.civicrm.org/dev/drupal/-/issues/26Double quote (") should not be escaped in CIVICRM_UF_DSN in civicrm.settings.php2020-07-16T17:23:38ZsomnolentsurferDouble quote (") should not be escaped in CIVICRM_UF_DSN in civicrm.settings.phpI'm a complete newbie to both CiviCRM and Drupal, but I've been trying to test out an installation for one of my clients. I completed a fresh, standard installation of Drupal 7, then followed the installation process for CiviCRM in the S...I'm a complete newbie to both CiviCRM and Drupal, but I've been trying to test out an installation for one of my clients. I completed a fresh, standard installation of Drupal 7, then followed the installation process for CiviCRM in the System Administrator Guide.
Once installation was complete, and I had filled in all the details of my database paths and users as requested, I tried to follow the process for setting up scheduled jobs at https://docs.civicrm.org/sysadmin/en/latest/setup/jobs/ using either the CLI or HTTP method.
Whatever I tried, every attempt to run Job.execute resulted in 'DB Error: connect failed'.
With the help of this StackExchange thread (https://civicrm.stackexchange.com/questions/25575/db-error-connect-failed-when-trying-to-call-job-execute-using-cli-php/) I tracked down the logs and discovered that MySQL was rejecting the password of the Drupal database user.
On looking up the password in CIVICRM_UF_DSN in civicrm.settings.php I noticed that a double quote character (") in my password was escaped with a backslash, even though the instructions in the file only say single quote (') or backslash (\) characters should be escaped. Taking the backslash out of the password allowed Job.execute to run as expected.
I had never touched civicrm.settings.php before, so it seems that whichever script had translated the password I entered in the GUI during installation into that file must have erroneously escaped the double quote.https://lab.civicrm.org/dev/core/-/issues/256Wrong A/B test recipient assignment when reaching 2^31 recipients overall2018-07-13T23:42:09ZromainWrong A/B test recipient assignment when reaching 2^31 recipients overallWhen assigning recipients from mailing A to mailing B and C when submitting an A/B mailing, a temporary table is used to hold the recipient ids. The column type used to receive the ids is a signed integer, while the recipient ids in `civ...When assigning recipients from mailing A to mailing B and C when submitting an A/B mailing, a temporary table is used to hold the recipient ids. The column type used to receive the ids is a signed integer, while the recipient ids in `civicrm_mailing_recipients` are unsigned integers.
Therefore, once the number of overall recipients reaches 2<sup>31</sup>, there is a mismatch when joining on ids in those two tables. Because of that, no recipient is assigned to mailing B or C, and mailing A is sent to the whole target recipients set.
This happens in `CRM_Mailing_BAO_Recipients::updateRandomRecipients`.
I will submit a patch.5.5.0https://lab.civicrm.org/dev/wordpress/-/issues/4There seems to be a problem in WordPress documentation for config.settings.ph...2021-10-16T14:48:27Znorman.catesThere seems to be a problem in WordPress documentation for config.settings.php for Multisite installsOK. So I've found what I think is a pretty serious problem with the current Civi CRM setup/documentation for 5.3 (and probably a few subversions before) and Wordpress multisites...
I've posted these problems at Stack Exchange:
https://...OK. So I've found what I think is a pretty serious problem with the current Civi CRM setup/documentation for 5.3 (and probably a few subversions before) and Wordpress multisites...
I've posted these problems at Stack Exchange:
https://civicrm.stackexchange.com/questions/25688/im-having-new-trouble-with-civicrm-in-multisites-in-wordpress
https://civicrm.stackexchange.com/questions/25713/getting-cors-error-from-civicrm-dashboard-dashlets/
I was pointed at the documentation update that should be happening soon:
https://github.com/civicrm/civicrm-sysadmin-guide/pull/104/files
That helped one aspect of it, ie getting the subsites all using the same setup.
But as documented above, there were still problems involving CORS
I finally think I traced it to the following.
There's an entire section up the top of civicrm.settings.php that has these lines:
```php
$civicrm_paths['wp.frontend.base']['url'] = (URL path)
$civicrm_paths['wp.backend.base']['url'] = (URL path to admin)
$civicrm_setting['URL Preferences']['userFrameworkResourceURL'] =(URL path) to civicrm
```
The paths are hardcoded to the main site URL.
This seems to be what's causing these problems I'm having. Because if I change it using the code below, then it appears to work again.
=======================
```php
if(function_exists('is_multisite') && function_exists('home_url')) {
$url = home_url();
}
else {
$protocol = strstr('HTTPS', $_SERVER['SERVER_PROTOCOL']) ? 'https://' : 'http://';
$url = $protocol . $_SERVER['SERVER_NAME'];
}
// Additional settings generated by installer:
$civicrm_paths['wp.frontend.base']['url'] = $url.'/';
$civicrm_paths['wp.backend.base']['url'] = $url.'/wp-admin/';
$civicrm_setting['URL Preferences']['userFrameworkResourceURL'] = $url.'/wp-content/plugins/civicrm/civicrm';
```
Note that this does NOT include the recommended code that is on the current WP multisites documentation page.
BUT, I do not know what the implications are here down the track. Will this cause other problems? I'd really like a dev to weigh in and check if this fix is legitimate or will make something explode down the track.
As mentioned in the GitHub sysadmin guide pages, people are working to update this documentation.
My core confusion is which section applies to what we're trying to do. ie if we want to share CiviCRM across all the subsites, then what's the procedure there. And if they need to be separated, then what's the procedure. I realise this is complicated by the different install bases that exist. Like Drupal, Wordpress, Joomla and any others.
But if each section was clear about what it was doing, that would help. ie. if the instructions are common to all installs, then make that clear. And then specifics for each install platform.https://lab.civicrm.org/dev/core/-/issues/257Improve CustomValue API2018-07-23T10:50:10ZDon WijesooriyaImprove CustomValue APIDuring the few months of working with CiviCRM, I have often found myself limited working with CustomValue API. Not sure if I am missing something but suggesting the following improvements so it would make life a bit easier
**For CustomV...During the few months of working with CiviCRM, I have often found myself limited working with CustomValue API. Not sure if I am missing something but suggesting the following improvements so it would make life a bit easier
**For CustomValue get API**
1. Remove limitation of retrieving only 1 value for multiple custom data groups for Contact entity.
- This appears not to be the case, but [the documentation says only returns 1 row](https://docs.civicrm.org/dev/en/latest/api/custom-data/)
2. Add ability to retrieve values by custom group id/name possibly combined with entity id
- This would make it easier to retrieve all data for a particular custom group, even disregarding entity and entity id
- Add an API parameter like "custom_group_id" perhaps?
3. In the api explorer, add a separate parameter to select Entity (a select option perhaps?)
4. If the entity is selected, make Entity ID a chain select so it would display drop down list of entity ID's related to that entity
5. Add parameter "ID" (custom value id) in the API explorer so we can directly obtain value related to certain row ID coupled with custom group id
6. Reformat the way values are returned from the API. Few suggestions:
- group multiple custom values together into a separate array such as: "values":["id": 1, "latest":"first value" ,"custom_values":[23:"first value", 43:"second value"]] {- make "latest" value display ID rather than actual value, so we can get it from "custom_values" array -}
- if implementing above (2.), group by entity id etc.
7. Make entity_id NOT mandatory instead have separate combinations of 2 or more fields mandatory for eg: as in (5.) above, if custom_value_id is specified, custom_group_id should be mandatory
I think rather than trying to automatically figure out which entities/values to select from, would be better to give more flexibility to the developer via the API and prepare more comprehensive documentation.
**Add "delete" method for CustomValue actions**
Suggested parameters:
- custom_value_id combined with custom_group_id to delete specific custom value row
- custom_field_id to delete all values for that custom field
- custom_group_id to delete all values for that custom group
- {- can combine all of the above with entity_id to delete only for that one -}https://lab.civicrm.org/dev/core/-/issues/258Possible unreleased regression - message template update altered customised t...2018-07-18T22:12:09ZeileenPossible unreleased regression - message template update altered customised templateOn the site that I have upgraded to 5.4 I found my template customisations were gone. The upgrade code should only update the default template and templates in use that are the same as the default (I need to test further as it's conceiva...On the site that I have upgraded to 5.4 I found my template customisations were gone. The upgrade code should only update the default template and templates in use that are the same as the default (I need to test further as it's conceivable my defaults had been updated in error)5.4.0https://lab.civicrm.org/dev/core/-/issues/259OptionGroup Admin UI workflow improvements2018-12-18T12:16:03Zmattwiremjw@mjwconsult.co.ukOptionGroup Admin UI workflow improvementsVarious improvements to the "flow" of the option groups admin pages.
Before
----------------------------------------
* No option to edit option group settings (eg. change the label).
* When clicking "Done" editing options, redirect to t...Various improvements to the "flow" of the option groups admin pages.
Before
----------------------------------------
* No option to edit option group settings (eg. change the label).
* When clicking "Done" editing options, redirect to the option groups list instead of the default admin page.
After
----------------------------------------
* Add option to edit option group settings (the code was already in place, but not exposed in UI).
* Display "is_reserved" status on option group settings.
* Don't allow changing data type on reserved option groups.
* On update optiongroup don't touch is_reserved.
![localhost_8000_civicrm_admin_options_action browse reset 1 4](https://user-images.githubusercontent.com/2052161/42726000-43ca3642-8785-11e8-9ea3-d0228ceb558e.png)
![localhost_8000_civicrm_admin_options_action browse reset 1 5](https://user-images.githubusercontent.com/2052161/42726002-48fc8520-8785-11e8-9ebc-9267444e510f.png)
* When clicking "Done" editing options, redirect to the option groups list instead of the default admin page.
![localhost_8000_civicrm_admin_options_action browse reset 1 6](https://user-images.githubusercontent.com/2052161/42726010-6995ac9e-8785-11e8-8823-111f71f52d07.png)
Technical Details
----------------------------------------
UI only changes that enable editing option groups parameters.
Comments
----------------------------------------
If you are working with multiple option groups, the UI has always been a bit difficult to navigate and various functions are not possible via the UI (such as changing the label of an option group).
PR: https://github.com/civicrm/civicrm-core/pull/124735.5.0https://lab.civicrm.org/dev/financial/-/issues/35Refunding a Contribution that has Sales Tax associated produces Validation Error2018-11-10T13:56:41ZKarinGRefunding a Contribution that has Sales Tax associated produces Validation ErrorTrying to isolate / reproduce some issues with Sales Taxes breaking them down into small bits; this is on 5.3.0
Add Contribution $100 -> Financial Type has Sales Tax associated with it 5% -> Contribution gets recorded as $105 (correctly...Trying to isolate / reproduce some issues with Sales Taxes breaking them down into small bits; this is on 5.3.0
Add Contribution $100 -> Financial Type has Sales Tax associated with it 5% -> Contribution gets recorded as $105 (correctly):
![image](/uploads/fb7908806ae278e41fada823681616bf/image.png)
Edit -> change Contribution Status -> from Completed to Refunded -> hit Save;
![image](/uploads/c847a51745cedf80901b5d8d657293ae/image.png)
Net Amount really is $105 and Fee Amount really is $0 - changing them to anything else would be incorrect.
See https://github.com/civicrm/civicrm-core/pull/9948 for original discussionhttps://lab.civicrm.org/dev/core/-/issues/260Refunding a Contribution that has Sales Tax associated produces Validation Error2018-11-10T13:39:14ZKarinGRefunding a Contribution that has Sales Tax associated produces Validation ErrorTrying to isolate / reproduce some issues with Sales Taxes breaking them down into small bits; this is on 5.3.0
Add Contribution $100 -> Financial Type has Sales Tax associated with it 5% -> Contribution gets recorded as $105 (correctly...Trying to isolate / reproduce some issues with Sales Taxes breaking them down into small bits; this is on 5.3.0
Add Contribution $100 -> Financial Type has Sales Tax associated with it 5% -> Contribution gets recorded as $105 (correctly):
![image](/uploads/ff97c0324f00a6702b052d956be88af2/image.png)
Edit -> change Contribution Status -> from Completed to Refunded -> hit Save;
![image](/uploads/118ca44b7e956503aa7c1360a846a5a4/image.png)
Net Amount really is $105 and Fee Amount really is $0 - changing them to anything else would be incorrect.
See https://github.com/civicrm/civicrm-core/pull/9948 for original discussionhttps://lab.civicrm.org/dev/core/-/issues/261Expose Financial Type on Grant form and View Page2018-07-31T21:50:22ZPradeep Nayakpradpnayak@gmail.comExpose Financial Type on Grant form and View PageIt turns out that `civicrm_grant` actually has a `financial_type_id` field, which doesn't seem to be exposed to the UI.
Submit a PR to
1. Add financial type field on Add/Edit Grant form.
2. Add Financial type section on View Grant page...It turns out that `civicrm_grant` actually has a `financial_type_id` field, which doesn't seem to be exposed to the UI.
Submit a PR to
1. Add financial type field on Add/Edit Grant form.
2. Add Financial type section on View Grant page.
3. Add financial type column in grant's search result.
PR:https://github.com/civicrm/civicrm-core/pull/12493https://lab.civicrm.org/dev/core/-/issues/262Drupal 8 cv & civix cli tools not working2020-02-10T15:54:48ZwannesderoyDrupal 8 cv & civix cli tools not workingIn our Drupal 8 - CiviCRM setup we found that both cv & civix were not working properly due to issues with the autoloading.
We fixed it by simplifying the $autoloader code in the loadBootStrap() method in CRM/Utils/System/Drupal8.php.
...In our Drupal 8 - CiviCRM setup we found that both cv & civix were not working properly due to issues with the autoloading.
We fixed it by simplifying the $autoloader code in the loadBootStrap() method in CRM/Utils/System/Drupal8.php.
The $autoloader var already contains the result of the getLoader() method by requiring the autoload from Drupal.
See my pull request on civicrm-core: https://github.com/civicrm/civicrm-core/pull/12496https://lab.civicrm.org/dev/core/-/issues/263Release candidate regression: Can't create contribution pages.2018-07-18T22:42:07ZJonGoldRelease candidate regression: Can't create contribution pages.I've replicated this locally on the rc, the master branch and on the demo site.
* Create a new contribution page, filling in only the two required fields.
* Press "Submit".
Get this:
```
backTrace
#0 /home/jon/local/civicrm-buildkit/b...I've replicated this locally on the rc, the master branch and on the demo site.
* Create a new contribution page, filling in only the two required fields.
* Press "Submit".
Get this:
```
backTrace
#0 /home/jon/local/civicrm-buildkit/build/rc/sites/all/modules/civicrm/CRM/Core/Error.php(190): CRM_Core_Error::backtrace()
#1 /home/jon/local/civicrm-buildkit/build/rc/sites/all/modules/civicrm/packages/PEAR.php(921): CRM_Core_Error::handle(Object(DB_Error))
#2 /home/jon/local/civicrm-buildkit/build/rc/sites/all/modules/civicrm/packages/DB.php(985): PEAR_Error->__construct("DB Error: unknown error", -1, 16, (Array:2), "INSERT INTO civicrm_contribution_page (title , intro_text , financial_type_id...")
#3 /home/jon/local/civicrm-buildkit/build/rc/sites/all/modules/civicrm/packages/PEAR.php(575): DB_Error->__construct(-1, 16, (Array:2), "INSERT INTO civicrm_contribution_page (title , intro_text , financial_type_id...")
#4 /home/jon/local/civicrm-buildkit/build/rc/sites/all/modules/civicrm/packages/PEAR.php(223): PEAR->_raiseError(Object(DB_mysqli), NULL, -1, 16, (Array:2), "INSERT INTO civicrm_contribution_page (title , intro_text , financial_type_id...", "DB_Error", TRUE)
#5 /home/jon/local/civicrm-buildkit/build/rc/sites/all/modules/civicrm/packages/DB/common.php(1907): PEAR->__call("raiseError", (Array:7))
#6 /home/jon/local/civicrm-buildkit/build/rc/sites/all/modules/civicrm/packages/DB/mysqli.php(933): DB_common->raiseError(-1, NULL, NULL, "INSERT INTO civicrm_contribution_page (title , intro_text , financial_type_id...", "1292 ** Incorrect datetime value: '7' for column 'start_date' at row 1")
#7 /home/jon/local/civicrm-buildkit/build/rc/sites/all/modules/civicrm/packages/DB/mysqli.php(403): DB_mysqli->mysqliRaiseError()
#8 /home/jon/local/civicrm-buildkit/build/rc/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysqli->simpleQuery("INSERT INTO civicrm_contribution_page (title , intro_text , financial_type_id...")
#9 /home/jon/local/civicrm-buildkit/build/rc/sites/all/modules/civicrm/packages/DB/DataObject.php(2443): DB_common->query("INSERT INTO civicrm_contribution_page (title , intro_text , financial_type_id...")
#10 /home/jon/local/civicrm-buildkit/build/rc/sites/all/modules/civicrm/packages/DB/DataObject.php(1068): DB_DataObject->_query("INSERT INTO civicrm_contribution_page (title , intro_text , financial_type_id...")
#11 /home/jon/local/civicrm-buildkit/build/rc/sites/all/modules/civicrm/CRM/Core/DAO.php(571): DB_DataObject->insert()
#12 /home/jon/local/civicrm-buildkit/build/rc/sites/all/modules/civicrm/CRM/Contribute/BAO/ContributionPage.php(59): CRM_Core_DAO->save()
#13 /home/jon/local/civicrm-buildkit/build/rc/sites/all/modules/civicrm/CRM/Contribute/Form/ContributionPage/Settings.php(344): CRM_Contribute_BAO_ContributionPage::create((Array:25))
#14 /home/jon/local/civicrm-buildkit/build/rc/sites/all/modules/civicrm/CRM/Core/Form.php(489): CRM_Contribute_Form_ContributionPage_Settings->postProcess()
#15 /home/jon/local/civicrm-buildkit/build/rc/sites/all/modules/civicrm/CRM/Core/StateMachine.php(160): CRM_Core_Form->mainProcess()
#16 /home/jon/local/civicrm-buildkit/build/rc/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Next.php(61): CRM_Core_StateMachine->perform(Object(CRM_Contribute_Form_ContributionPage_Settings), "next", "Next")
#17 /home/jon/local/civicrm-buildkit/build/rc/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Next->perform(Object(CRM_Contribute_Form_ContributionPage_Settings), "next")
#18 /home/jon/local/civicrm-buildkit/build/rc/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Contribute_Form_ContributionPage_Settings), "next")
#19 /home/jon/local/civicrm-buildkit/build/rc/sites/all/modules/civicrm/CRM/Core/Controller.php(351): HTML_QuickForm_Page->handle("next")
#20 /home/jon/local/civicrm-buildkit/build/rc/sites/all/modules/civicrm/CRM/Core/Invoke.php(309): CRM_Core_Controller->run((Array:4), NULL)
#21 /home/jon/local/civicrm-buildkit/build/rc/sites/all/modules/civicrm/CRM/Core/Invoke.php(84): CRM_Core_Invoke::runItem((Array:14))
#22 /home/jon/local/civicrm-buildkit/build/rc/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:4))
#23 /home/jon/local/civicrm-buildkit/build/rc/sites/all/modules/civicrm/drupal/civicrm.module(445): CRM_Core_Invoke::invoke((Array:4))
#24 /home/jon/local/civicrm-buildkit/build/rc/includes/menu.inc(527): civicrm_invoke("admin", "contribute", "add")
#25 /home/jon/local/civicrm-buildkit/build/rc/index.php(21): menu_execute_active_handler()
#26 {main}
Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
DB Error: unknown error
Error Details
Database Error Code: Incorrect datetime value: '7' for column 'start_date' at row 1, 1292
Additional Details:
Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)
[code] => -1
[message] => DB Error: unknown error
[mode] => 16
[debug_info] => INSERT INTO civicrm_contribution_page (title , intro_text , financial_type_id , is_credit_card_only , is_confirm_enabled , goal_amount , is_active , footer_text , start_date , end_date , created_id , created_date , currency , is_share ) VALUES ('test' , NULL , 3 , 0 , 1 , NULL , 1 , NULL , 7 , NULL , 202 , 20180717100536 , 'USD' , 0 ) [nativecode=1292 ** Incorrect datetime value: '7' for column 'start_date' at row 1]
[type] => DB_Error
[user_info] => INSERT INTO civicrm_contribution_page (title , intro_text , financial_type_id , is_credit_card_only , is_confirm_enabled , goal_amount , is_active , footer_text , start_date , end_date , created_id , created_date , currency , is_share ) VALUES ('test' , NULL , 3 , 0 , 1 , NULL , 1 , NULL , 7 , NULL , 202 , 20180717100536 , 'USD' , 0 ) [nativecode=1292 ** Incorrect datetime value: '7' for column 'start_date' at row 1]
[to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_contribution_page (title , intro_text , financial_type_id , is_credit_card_only , is_confirm_enabled , goal_amount , is_active , footer_text , start_date , end_date , created_id , created_date , currency , is_share ) VALUES ('test' , NULL , 3 , 0 , 1 , NULL , 1 , NULL , 7 , NULL , 202 , 20180717100536 , 'USD' , 0 ) [nativecode=1292 ** Incorrect datetime value: '7' for column 'start_date' at row 1]"]
)
```5.4.0https://lab.civicrm.org/dev/core/-/issues/264Fatal Error on editting Financial Transaction2019-03-15T20:08:39ZtommyboboFatal Error on editting Financial TransactionIn 5.3.0 tested on Dev site and civicrmfr.org demo
1. Create a completed contribution.
2. Edit contribution by increasing contribution amount and net amount.
This will create a new financial transaction with NO Payment Instrument.
3...In 5.3.0 tested on Dev site and civicrmfr.org demo
1. Create a completed contribution.
2. Edit contribution by increasing contribution amount and net amount.
This will create a new financial transaction with NO Payment Instrument.
3. Edit new Financial Transaction to add Payment Instrument. Click Update - Get Spinning Logo Error
ConfigAndLog Records this error.
```
$Fatal Error Details = array(3) {
["message"]=>
string(65) "Mandatory key(s) missing from params array: payment_instrument_id"
["code"]=>
NULL
["exception"]=>
object(CiviCRM_API3_Exception)#323 (8) {
["extraParams":"CiviCRM_API3_Exception":private]=>
array(6) {
["fields"]=>
array(1) {
[0]=>
string(21) "payment_instrument_id"
}
["error_code"]=>
string(17) "mandatory_missing"
["entity"]=>
string(13) "FinancialTrxn"
["action"]=>
string(6) "create"
["is_error"]=>
int(1)
["error_message"]=>
string(65) "Mandatory key(s) missing from params array: payment_instrument_id"
}
["message":protected]=>
string(65) "Mandatory key(s) missing from params array: payment_instrument_id"
["string":"Exception":private]=>
string(0) ""
["code":protected]=>
int(0)
["file":protected]=>
string(65) "/server/public_html/sites/all/modules/civicrm/api/api.php"
["line":protected]=>
int(45)
["trace":"Exception":private]=>
array(15) {
[0]=>
array(4) {
["file"]=>
string(88) "/server/public_html/sites/all/modules/civicrm/CRM/Financial/Form/PaymentEdit.php"
["line"]=>
int(207)
["function"]=>
string(12) "civicrm_api3"
["args"]=>
array(3) {
[0]=>
string(13) "FinancialTrxn"
[1]=>
string(6) "create"
[2]=>
array(9) {
["to_financial_account_id"]=>
string(2) "23"
["trxn_date"]=>
string(19) "2018-07-16 17:23:00"
["total_amount"]=>
float(-10)
["fee_amount"]=>
float(0)
["net_amount"]=>
float(-10)
["currency"]=>
string(3) "USD"
["is_payment"]=>
string(1) "1"
["status_id"]=>
string(1) "1"
["contribution_id"]=>
string(5) "30997"
}
}
}
[1]=>
array(6) {
["file"]=>
string(88) "/server/public_html/sites/all/modules/civicrm/CRM/Financial/Form/PaymentEdit.php"
["line"]=>
int(175)
["function"]=>
string(6) "submit"
["class"]=>
string(30) "CRM_Financial_Form_PaymentEdit"
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
array(4) {
["id"]=>
string(5) "39513"
["payment_instrument_id"]=>
string(1) "3"
["trxn_id"]=>
string(0) ""
["trxn_date"]=>
string(19) "2018-07-16 17:23:00"
}
}
}
```5.3.1https://lab.civicrm.org/dev/financial/-/issues/28Financial Account cannot be change to non deductible2018-07-27T09:41:13ZPradeep Nayakpradpnayak@gmail.comFinancial Account cannot be change to non deductiblehttps://civicrm.stackexchange.com/questions/25765/financial-account-cannot-be-change-to-non-deductible
PR: https://github.com/civicrm/civicrm-core/pull/12500https://civicrm.stackexchange.com/questions/25765/financial-account-cannot-be-change-to-non-deductible
PR: https://github.com/civicrm/civicrm-core/pull/125005.5.0