Development issueshttps://lab.civicrm.org/groups/dev/-/issues2019-04-22T18:56:39Zhttps://lab.civicrm.org/dev/drupal/-/issues/46Search list column sort2019-04-22T18:56:39ZjcisaacSearch list column sortSpecs: **CiviCRM 4.6.37** and **Drupal 7.59**.
When executing a search of contributions, the default sort is by date. If wanting to sort by any other column, it doesn’t work – just reloads the page.Specs: **CiviCRM 4.6.37** and **Drupal 7.59**.
When executing a search of contributions, the default sort is by date. If wanting to sort by any other column, it doesn’t work – just reloads the page.https://lab.civicrm.org/dev/financial/-/issues/46(Regression) Contribution page amounts change on save when > $1,0002019-02-28T23:10:03ZJonGold(Regression) Contribution page amounts change on save when > $1,000Attached is a video replicating the bug on dmaster.demo.civicrm.org.
When specifying a donation amount of $1000 or more (on a monolingual en_US site), the amount is saved as `$1,000.00`.
When you press save again, the comma is treated as...Attached is a video replicating the bug on dmaster.demo.civicrm.org.
When specifying a donation amount of $1000 or more (on a monolingual en_US site), the amount is saved as `$1,000.00`.
When you press save again, the comma is treated as a decimal separator, and so it's resaved as $1.
[thousandseparatorbug-2019-02-27_16.07.04.mkv](/uploads/3efa6a65f2585256b3792f512ce29416/thousandseparatorbug-2019-02-27_16.07.04.mkv)5.11JonGoldJonGoldhttps://lab.civicrm.org/dev/joomla/-/issues/5[civicrm.root] wrongly evaluated on Joomla2020-03-25T00:09:10Zaydunsaidan.saunders@squiffle.uk[civicrm.root] wrongly evaluated on JoomlaUnder some circumstances, `[civicrm.root]` is evaluated as `/components/com_civicrm/civicrm/` but should be `/administrator/components/com_civicrm/civicrm/` resulting in various failures.
A workaround is to use the path instead of the v...Under some circumstances, `[civicrm.root]` is evaluated as `/components/com_civicrm/civicrm/` but should be `/administrator/components/com_civicrm/civicrm/` resulting in various failures.
A workaround is to use the path instead of the variable.
For example, see https://civicrm.stackexchange.com/questions/27652/location-of-civicrm-css-on-joomlahttps://lab.civicrm.org/dev/wordpress/-/issues/38Ensure front-end hooks are only registered on main query2019-10-14T22:23:05ZhaystackEnsure front-end hooks are only registered on main query[nc3man reported on Mattermost](https://chat.civicrm.org/civicrm/pl/5dmagkea7fn9xfm3yztkuem7qh) and [StackExchange](https://civicrm.stackexchange.com/q/33247/520) that the Benevolent Pro theme makes a sub-query prior to the main query. T...[nc3man reported on Mattermost](https://chat.civicrm.org/civicrm/pl/5dmagkea7fn9xfm3yztkuem7qh) and [StackExchange](https://civicrm.stackexchange.com/q/33247/520) that the Benevolent Pro theme makes a sub-query prior to the main query. This unsets `get_query_var( 'page' )` and thus the CiviCRM basepage fails to render CiviCRM content.
The solution is to ensure that front-end hooks are only registered on main query. PR to follow.5.19.0haystackhaystackhttps://lab.civicrm.org/dev/core/-/issues/47Add "clone" functionality to scheduled jobs2018-06-17T23:18:56Zmattwiremjw@mjwconsult.co.ukAdd "clone" functionality to scheduled jobsThis adds a "clone" or "copy" function to the scheduled jobs page. It is implemented as an API (job.clone) which can be called via a link from the scheduled jobs listing.
Ref https://github.com/civicrm/civicrm-core/pull/11945This adds a "clone" or "copy" function to the scheduled jobs page. It is implemented as an API (job.clone) which can be called via a link from the scheduled jobs listing.
Ref https://github.com/civicrm/civicrm-core/pull/119455.4.0https://lab.civicrm.org/dev/drupal/-/issues/47It is no longer possible to have the default country not set2019-02-04T02:07:38ZhowardshandIt is no longer possible to have the default country not setReported this previously at https://issues.civicrm.org/jira/browse/CRM-18100, and it was fixed, though I can't find the ticket for the fix.
Did a new install of 5.7.3 and default country is required. All sandboxes show the same requirem...Reported this previously at https://issues.civicrm.org/jira/browse/CRM-18100, and it was fixed, though I can't find the ticket for the fix.
Did a new install of 5.7.3 and default country is required. All sandboxes show the same requirement.https://lab.civicrm.org/dev/financial/-/issues/47Payment Instrument not set on Pending Contributions' payments when marked "Co...2019-12-17T22:10:48ZJonGoldPayment Instrument not set on Pending Contributions' payments when marked "Completed".There's an inconsistency in how payments are recorded in CiviCRM depending on how you mark them completed.
#### Scenario 1
* Record a pending contribution for a contact with whatever payment instrument you like.
* Complete the payment b...There's an inconsistency in how payments are recorded in CiviCRM depending on how you mark them completed.
#### Scenario 1
* Record a pending contribution for a contact with whatever payment instrument you like.
* Complete the payment by selecting **More » Record Payment** and entering the payment.
* Click the **pencil** to edit the resulting payment. Everything looks fine.
#### Scenario 2
* Record a pending contribution for a contact with whatever payment instrument you like.
* Complete the payment by selecting **Edit** and changing the contribution status to **Completed**.
* Click the **pencil** to edit the resulting payment. The payment instrument is blank. Moreover, any attempt to change the payment instrument results in a fatal error (similar to core#264). See below.
The backtrace below seems like a symptom of the root cause, which is in the second step (changing the contribution status) not the third step.
```
CiviCRM_API3_Exception: "Mandatory key(s) missing from params array: payment_instrument_id"
#0 /example.org/sites/all/modules/civicrm/CRM/Financial/Form/PaymentEdit.php(213): civicrm_api3("FinancialTrxn", "create", (Array:9))
#1 /example.org/sites/all/modules/civicrm/CRM/Financial/Form/PaymentEdit.php(181): CRM_Financial_Form_PaymentEdit->submit((Array:5))
#2 /example.org/sites/all/modules/civicrm/CRM/Core/Form.php(489): CRM_Financial_Form_PaymentEdit->postProcess()
#3 /example.org/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Submit.php(74): CRM_Core_Form->mainProcess()
#4 /example.org/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Submit->perform(Object(CRM_Financial_Form_PaymentEdit), "submit")
#5 /example.org/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Financial_Form_PaymentEdit), "submit")
#6 /example.org/sites/all/modules/civicrm/CRM/Core/Controller.php(351): HTML_QuickForm_Page->handle("submit")
#7 /example.org/sites/all/modules/civicrm/CRM/Utils/Wrapper.php(113): CRM_Core_Controller->run()
#8 /example.org/sites/all/modules/civicrm/CRM/Core/Invoke.php(283): CRM_Utils_Wrapper->run("CRM_Financial_Form_PaymentEdit", NULL, NULL)
#9 /example.org/sites/all/modules/civicrm/CRM/Core/Invoke.php(84): CRM_Core_Invoke::runItem((Array:14))
#10 /example.org/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
#11 /example.org/sites/all/modules/civicrm/drupal/civicrm.module(345): CRM_Core_Invoke::invoke((Array:3))
#12 [internal function](): civicrm_invoke("payment", "edit")
#13 /example.org/includes/menu.inc(350): call_user_func_array("civicrm_invoke", (Array:2))
#14 /example.org/index.php(22): menu_execute_active_handler()
#15 {main}
```https://lab.civicrm.org/dev/translation/-/issues/23Angular asset cache and multi-lingual2024-01-29T10:06:18ZbgmAngular asset cache and multi-lingualAngular extensions, such as CiviMail (classic) or Mosaico, will not always be displayed in the correct language when the Angular asset cache is enabled/auto (Admin > System Settings > Debugging). Tested on Drupal 7 (in case that makes a ...Angular extensions, such as CiviMail (classic) or Mosaico, will not always be displayed in the correct language when the Angular asset cache is enabled/auto (Admin > System Settings > Debugging). Tested on Drupal 7 (in case that makes a different with the "auto" setting of that cache).
How to reproduce on dmaster:
* Make sure you have the civicrm-l10n.tar.gz translation files (it's the case on dmaster.demo.civicrm.org)
* Go to Administer > Localisation, and enable another language, such as French (you don't need to enable multi-lingual).
* Use the CiviCRM Language Switch to set the language to French
* Go to Mailing > New Mailing (classic or mosaico, same bug)
* Now go back to the dashboard, set the language to English
* Go to Mailing > New Mailing, and notice that the UI is still in French.https://lab.civicrm.org/dev/wordpress/-/issues/39Refactor WordPress Code2020-06-06T12:58:42ZGhost UserRefactor WordPress CodeThe entire project could benefit from more modern coding practices I’d recommend the WordPress maintainers consider checking out https://phptherightway.com/
Performance is still a major issue with CiviCRM and WordPress.The entire project could benefit from more modern coding practices I’d recommend the WordPress maintainers consider checking out https://phptherightway.com/
Performance is still a major issue with CiviCRM and WordPress.https://lab.civicrm.org/dev/core/-/issues/48PDF Letter only generates a single letter when multiple contact IDs are speci...2018-04-17T07:09:08Zmattwiremjw@mjwconsult.co.ukPDF Letter only generates a single letter when multiple contact IDs are specifiedRef https://github.com/civicrm/civicrm-core/pull/11946Ref https://github.com/civicrm/civicrm-core/pull/119465.1.0https://lab.civicrm.org/dev/drupal/-/issues/48Column next_sched_contribution should be next_sched_contribution_date for Vie...2020-04-15T06:55:32ZherbdoolColumn next_sched_contribution should be next_sched_contribution_date for Views integrationIn https://github.com/civicrm/civicrm-drupal/blob/a6a3276330d54ce88fe78cdf9f9034421d56f20c/modules/views/components/civicrm.contribute.inc#L1057 it's referencing a table column that doesn't exist (anymore?).In https://github.com/civicrm/civicrm-drupal/blob/a6a3276330d54ce88fe78cdf9f9034421d56f20c/modules/views/components/civicrm.contribute.inc#L1057 it's referencing a table column that doesn't exist (anymore?).5.14.0https://lab.civicrm.org/dev/financial/-/issues/48Recording a contribution that completes a pending payment should update Date ...2019-03-29T18:03:39ZJonGoldRecording a contribution that completes a pending payment should update Date ReceivedI know the long-term solution is #43 - remove redundant fields from the Contribution entity - but this seems worthwhile as a short-term fix.
Pending payments require a "Date Received" - which is a bit counterintuitive but necessary beca...I know the long-term solution is #43 - remove redundant fields from the Contribution entity - but this seems worthwhile as a short-term fix.
Pending payments require a "Date Received" - which is a bit counterintuitive but necessary because of the pre-Civi 4.3 data model. However, recording a payment to complete a contribution should update the Date Received.
Posting here to get concept approval before moving forward.https://lab.civicrm.org/dev/translation/-/issues/29Missing strings in the translation files (Date Received, Paid By)2019-08-06T15:06:04ZbgmMissing strings in the translation files (Date Received, Paid By)From the offline contribution receipt, there are strings that are always in English.
* Received Date
* Paid By
![Capture_d_écran_de_2019-08-06_08-55-38](/uploads/9186c620cfac07db2c9140813d0feb54/Capture_d_écran_de_2019-08-06_08-55-38.p...From the offline contribution receipt, there are strings that are always in English.
* Received Date
* Paid By
![Capture_d_écran_de_2019-08-06_08-55-38](/uploads/9186c620cfac07db2c9140813d0feb54/Capture_d_écran_de_2019-08-06_08-55-38.png)
I looked at Transifex and the strings seem to be missing. They are not in the gettext mo files either.https://lab.civicrm.org/dev/wordpress/-/issues/40Symlinks cause breakage with path variables like [civicrm.files]2019-12-22T14:36:56ZAllenShawSymlinks cause breakage with path variables like [civicrm.files]CiviCRM is presenting problems when certain directories referenced with path variables such as [civicrm.files] contain symlinks.
**Symptoms**
Symptoms seen so far seem to include failure to load extension resources (e.g., script and st...CiviCRM is presenting problems when certain directories referenced with path variables such as [civicrm.files] contain symlinks.
**Symptoms**
Symptoms seen so far seem to include failure to load extension resources (e.g., script and style files). For example, on one site of mine which has the following configuration
* Site url: http://mysite.example.com
* docroot symlinked from the users' home directory `/home/myuser/www -> /var/www/mysite`
* civicrm root at `/var/www/mysite/wp-content/plugins/civicrm/civicrm`
* civicrm extensions at `/var/www/mysite/wp-content/uploads/civicrm/ext`
* "Extensions Directory" setting set to `[civicrm.files]/ext/`
* an extension which declares a managed entity ContactType with property `"image_URL" => CRM_Core_Resources::singleton()->getUrl('myextension', 'images/icon.png', TRUE)`
The following happens when civicrm cache is rebuilt (an action which updates managed entities):
* If cache is rebuilt from the browser via Administer > Cleanup Caches and Update Paths, the contact type icon url is [+correctly+] updated to `http://mysite.example.com/wp-content/uploads/civicrm/ext/myextension/images/icon.png`
* If cache is rebuilt from the command line with `cd /var/www/mysite; cv flush` or `cv --cwd=/var/www/mysite flush`, the contact type icon url is [+correctly+] updated to `http://mysite.example.com/wp-content/uploads/civicrm/ext/myextension/images/icon.png`
* If cache is rebuilt from the command line with `cd /home/myuser/www; cv flush` or `cv --cwd=/home/myuser/www flush`, the contact type icon url is **{-incorrectly-}** updated to `http://mysite.example.com/var/www/mysite/wp-content/uploads/civicrm/ext/myextension/images/icon.png`
**Analysis and prior discussion**
* This issue is referenced on SE here: https://civicrm.stackexchange.com/a/28287/907
* Discussion on MM (https://chat.civicrm.org/civicrm/pl/xxiwai9h1jgd5b9iwnmheq5y5a) indicates that `CRM_Utils_File::relativize()` might benefit from use of PHP's `realpath()` to de-reference symlinks:
@kcristiano says on MM ([permalink](https://chat.civicrm.org/civicrm/pl/mtj7pw816t8odm1pi6dk8ieahh)):
> We had issues with WP engine and Pantheon and it lead to updating CRM_Utils_System_Wordpress in function getCiviSourceStorage to use $civiRelPath = CRM_Utils_File::relativize(realpath($civicrm_root), realpath($cmsPath));
> This solved some issues, but I noticed if an older site had the path to the symlink set in the settings file eg /srv/www/cvwp/wp-content/uploads/civicrm instead of it's real location of /srv/www/cvwp_content/uploads/civicrm Problems would occur. In my example there is a symlink to wp-content loking at the cvwp_content directory.
> This gets worse if all of wp-content is moved including plugins, or if the plugins directory is moved.
> On a new install we detect the relpath and it works, at least in my tetsing, but in the real world there are issues
@AllenShaw says on MM ([permalink](https://chat.civicrm.org/civicrm/pl/8nctusdxs3fq8p1akcp3hjk9gr)):
> My debugging yesterday also pointed me to CRM_Utils_File::relativize(). ... perhaps using realpath() inside of CRM_Utils_File::relativize() will cover more cases; ... because that's where the string-based path replacement is happening, which is why somehting like /srv/www/cvwp/wp-content/uploads/civicrm would not be properly matched to its real location of /srv/www/cvwp_content/uploads/civicrm. ... I think it's that string-based path replacement that's really causing the problem.https://lab.civicrm.org/dev/core/-/issues/49It's possible to make a negative adjustment on membership price.2023-05-11T05:03:25ZsudomanIt's possible to make a negative adjustment on membership price.When a user visits a CiviCRM membership page that allows price adjustments, then they may enter both positive and negative values to adjust the price of the membership.
I think that it shouldn't be possible to enter in negative values, ...When a user visits a CiviCRM membership page that allows price adjustments, then they may enter both positive and negative values to adjust the price of the membership.
I think that it shouldn't be possible to enter in negative values, as that reduces the cost of the membership.https://lab.civicrm.org/dev/drupal/-/issues/49Clearing CiviCRM cache not regenerating the angular-modules.js2022-12-02T01:43:08ZshaneonabikeClearing CiviCRM cache not regenerating the angular-modules.js**What Happened**
I realize this //could be// an edge case, but I accidentally deleted the angular-modules.js file when installing D8 with CiviCRM.
**What did I expect**
Either that an error message on /civicrm/a/#/status indicating ho...**What Happened**
I realize this //could be// an edge case, but I accidentally deleted the angular-modules.js file when installing D8 with CiviCRM.
**What did I expect**
Either that an error message on /civicrm/a/#/status indicating how I could rebuild this file and/or when clearing the CiviCRM cache it would be regenerated.
**What I tried**
- Tried to clear the cache (nothing changed)
- Tried to run composer update (nothing changed)
- Wasn't sure where or how to run bower update in order to attempt that part
I would be happy to add additional information on the wiki as well if that helps with relation to this. I just thought that perhaps we could put some additional messages do indicate that angular is not found and therefore some parts might not work properly.https://lab.civicrm.org/dev/financial/-/issues/49No way to customize contribution receipt based on individual entering data wh...2021-11-23T17:28:26ZJonGoldNo way to customize contribution receipt based on individual entering data when giving "On behalf of" an organizationWhen giving on behalf of an organization, we don't store the contact ID of the person who actually entered the contribution, nor do we pass it to the receipt in `$tplParams`. My PR will resolve the latter issue, since it's a safe fix th...When giving on behalf of an organization, we don't store the contact ID of the person who actually entered the contribution, nor do we pass it to the receipt in `$tplParams`. My PR will resolve the latter issue, since it's a safe fix that doesn't affect folks who don't choose to use its functionality.JonGoldJonGoldhttps://lab.civicrm.org/dev/core/-/issues/1522, as decimal separator, and [space] as thousand separators leads to api errors2020-03-17T22:27:15Zjaapjansma, as decimal separator, and [space] as thousand separators leads to api errors**Steps to reproduce**
1. At Administer --> Localisation --> Languages, Currencies and Location: set , as a decimal separator
2. At Administer --> Localisation --> Languages, Currencies and Location: Set space as thousand separator (So ...**Steps to reproduce**
1. At Administer --> Localisation --> Languages, Currencies and Location: set , as a decimal separator
2. At Administer --> Localisation --> Languages, Currencies and Location: Set space as thousand separator (So that 1234.56 is displayed as 1 234,56)
3. Go to api 3 explorer (Support --> Developers --> Api explorer v3)
4. Create a contribution with total_amount = 250.00 (keep the dot and the two zero's).
**Expected result**
Contribution created with a total amount of € 250,00
**Actual result**
Api error: `total_amount is not a valid amount: 250.00`
**Caused by**
This is caused by the statement in _https://github.com/civicrm/civicrm-core/blob/master/CRM/Utils/Rule.php#L603_
This statement expects at least . in either decimal separator or thousand separator.
```php
if ($config->monetaryDecimalPoint &&
$config->monetaryDecimalPoint != '.' &&
// CRM-7122 also check for Thousands Separator in config settings
$config->monetaryThousandSeparator != '.' &&
substr_count($value, '.')
) {
return FALSE;
}
```
**Analyses**
Below an analyses of the _contribution.create_ api with different localization settings and inputs.
| Currency | Decimal sep. | Thousand sep. | Contribution.create total_amount | Raw Value | Display as | 5.13 | 5.20 |
|----------|--------------|---------------|----------------------------------|------------|------------------|----------|----------|
| $ | . | , | 1,234,567.89 | 1234567.89 | $ 1,234,567.89 | OK | OK |
| $ | . | , | 1234567.89 | 1234567.89 | $ 1,234,567.89 | OK | OK |
| $ | . | [space] | 1 234 567.89 | 1234567.89 | $ 1 234 567.89 | OK | OK |
| $ | . | [space] | 1234567.89 | 1234567.89 | $ 1 234 567.89 | **Fail** | **Fail** |
| € | . | , | 1,234,567.89 | 1234567.89 | € 1,234,567.89 | OK | OK |
| € | . | , | 1234567.89 | 1234567.89 | € 1,234,567.89 | OK | OK |
| € | , | . | 1.234.567,89 | 1234567.89 | € 1.234.567,89 | OK | OK |
| € | , | . | 1234567.89 | 1234567.89 | € 1.234.567,89 | OK | OK |
| € | , | [space] | 1 234 567,89 | 1234567.89 | € 1 234 567,89 | OK | OK |
| € | , | [space] | 1234567.89 | 1234567.89 | € 1 234 567,89 | **Fail** | **Fail** |
| NOK | . | , | 1,234,567.89 | 1234567.89 | NOK 1,234,567.89 | OK | OK |
| NOK | . | , | 1234567.89 | 1234567.89 | NOK 1,234,567.89 | OK | OK |
| NOK | , | . | 1.234.567,89 | 1234567.89 | NOK 1.234.567,89 | OK | OK |
| NOK | , | . | 1234567.89 | 1234567.89 | NOK 1.234.567,89 | OK | OK |
| NOK | , | [space] | 1 234 567,89 | 1234567.89 | NOK 1 234 567,89 | OK | OK |
| NOK | , | [space] | 1234567.89 | 1234567.89 | NOK 1 234 567,89 | **Fail** | **Fail** |
**See also**
This bug is introduced by https://issues.civicrm.org/jira/browse/CRM-7122
**Question before fixing this**
What exactly is this if statement checking for? 5.23.0https://lab.civicrm.org/dev/translation/-/issues/30Allow setting a custom L10n/I18n resource directory2022-05-11T15:17:53ZhomotechsualAllow setting a custom L10n/I18n resource directoryCiviCRM Core contains some code which gets the resource directory for i18n files - at the moment this is set as a "static variable" within the [function here](https://github.com/civicrm/civicrm-core/blob/042ca9cb6f9a50aacf057f384d1733ee9...CiviCRM Core contains some code which gets the resource directory for i18n files - at the moment this is set as a "static variable" within the [function here](https://github.com/civicrm/civicrm-core/blob/042ca9cb6f9a50aacf057f384d1733ee9d9e906e/CRM/Core/I18n.php#L300).
It would be beneficial if we could set this properly to a directory of our choosing and would allow proper I18n support on Drupal 8 without having to place the L10n folder inside `/vendor/civicrm/civicrm-core` which complicates composer updates, completely breaks with composer best practices and adds an additional manual step to get going with CiviCRM and Drupal 8.
Allowing a custom setting for this would also allow us to set a sane default ([civicrm.files]/l10n)? which we can then use to "composerify" the inclusion of the L10n tarball (e.g: https://github.com/drupal-composer/drupal-l10n)5.23.0https://lab.civicrm.org/dev/wordpress/-/issues/41Scheduled Reminder - Error message: DB Error: unknown error2020-06-06T12:59:00ZlandbryoScheduled Reminder - Error message: DB Error: unknown errorOther CiviCRM scheduled jobs appear to be working correctly, but as of 12/30 the following error message appears for this one job. Any help would be greatly appreciated.
WordPress v 5.2.5
CiviCRM v5.13.2
![Scheduled Reminder Error](/u...Other CiviCRM scheduled jobs appear to be working correctly, but as of 12/30 the following error message appears for this one job. Any help would be greatly appreciated.
WordPress v 5.2.5
CiviCRM v5.13.2
![Scheduled Reminder Error](/uploads/e443b1e442167385ed6eaf8eddb9cdd1/image.png)
```
Jan 01 00:30:03 [info] $Fatal Error Details = Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => exceptionHandler
)
[code] => -1
[message] => DB Error: unknown error
[mode] => 16
[debug_info] => INSERT INTO civicrm_action_log (contact_id, entity_id, entity_table, action_schedule_id)
SELECT e.contact_id as contact_id, e.id as entity_id, "civicrm_participant" as entity_table, 5 as action_schedule_id
FROM civicrm_participant e
INNER JOIN civicrm_event r ON e.event_id = r.id
INNER JOIN civicrm_contact c ON c.id = e.contact_id AND c.is_deleted = 0 AND c.is_deceased = 0
LEFT JOIN civicrm_action_log reminder ON reminder.contact_id = e.contact_id AND
reminder.entity_id = e.id AND
reminder.entity_table = 'civicrm_participant' AND
reminder.action_schedule_id = 5
WHERE (e.role_id IN (6)) AND (r.event_type_id IN ("8")) AND (r.is_active = 1) AND (r.is_template = 0) AND (e.status_id IN (1)) AND (reminder.id IS NULL) AND ('20200101003003' >= DATE_SUB(start_date, INTERVAL 14 day)) AND (DATE_SUB(20200101003003, INTERVAL 1 DAY ) <= start_date)
[nativecode=1292 ** Truncated incorrect DOUBLE value: '1�5']
[type] => DB_Error
[user_info] => INSERT INTO civicrm_action_log (contact_id, entity_id, entity_table, action_schedule_id)
SELECT e.contact_id as contact_id, e.id as entity_id, "civicrm_participant" as entity_table, 5 as action_schedule_id
FROM civicrm_participant e
INNER JOIN civicrm_event r ON e.event_id = r.id
INNER JOIN civicrm_contact c ON c.id = e.contact_id AND c.is_deleted = 0 AND c.is_deceased = 0
LEFT JOIN civicrm_action_log reminder ON reminder.contact_id = e.contact_id AND
reminder.entity_id = e.id AND
reminder.entity_table = 'civicrm_participant' AND
reminder.action_schedule_id = 5
WHERE (e.role_id IN (6)) AND (r.event_type_id IN ("8")) AND (r.is_active = 1) AND (r.is_template = 0) AND (e.status_id IN (1)) AND (reminder.id IS NULL) AND ('20200101003003' >= DATE_SUB(start_date, INTERVAL 14 day)) AND (DATE_SUB(20200101003003, INTERVAL 1 DAY ) <= start_date)
[nativecode=1292 ** Truncated incorrect DOUBLE value: '1�5']
[to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="INSERT INTO civicrm_action_log (contact_id, entity_id, entity_table, action_schedule_id)
SELECT e.contact_id as contact_id, e.id as entity_id, "civicrm_participant" as entity_table, 5 as action_schedule_id
FROM civicrm_participant e
INNER JOIN civicrm_event r ON e.event_id = r.id
INNER JOIN civicrm_contact c ON c.id = e.contact_id AND c.is_deleted = 0 AND c.is_deceased = 0
LEFT JOIN civicrm_action_log reminder ON reminder.contact_id = e.contact_id AND
reminder.entity_id = e.id AND
reminder.entity_table = 'civicrm_participant' AND
reminder.action_schedule_id = 5
WHERE (e.role_id IN (6)) AND (r.event_type_id IN ("8")) AND (r.is_active = 1) AND (r.is_template = 0) AND (e.status_id IN (1)) AND (reminder.id IS NULL) AND ('20200101003003' >= DATE_SUB(start_date, INTERVAL 14 day)) AND (DATE_SUB(20200101003003, INTERVAL 1 DAY ) <= start_date)
[nativecode=1292 ** Truncated incorrect DOUBLE value: '1�5']"]
)
Jan 01 00:30:03 [info] $backTrace = #0 /home/username/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(952): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /home/username/public_html/wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(922): CRM_Core_Error::exceptionHandler(Object(DB_Error))
#2 /home/username/public_html/wp-content/plugins/civicrm/civicrm/packages/DB.php(985): PEAR_Error->__construct("DB Error: unknown error", -1, 16, (Array:2), "INSERT INTO civicrm_action_log (contact_id, entity_id, entity_table, action_s...")
#3 /home/username/public_html/wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(575): DB_Error->__construct(-1, 16, (Array:2), "INSERT INTO civicrm_action_log (contact_id, entity_id, entity_table, action_s...")
#4 /home/username/public_html/wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(223): PEAR->_raiseError(Object(DB_mysqli), NULL, -1, 16, (Array:2), "INSERT INTO civicrm_action_log (contact_id, entity_id, entity_table, action_s...", "DB_Error", TRUE)
#5 /home/username/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1907): PEAR->__call("raiseError", (Array:7))
#6 /home/username/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/mysqli.php(933): DB_common->raiseError(-1, NULL, NULL, "INSERT INTO civicrm_action_log (contact_id, entity_id, entity_table, action_s...", "1292 ** Truncated incorrect DOUBLE value: '1�5'")
#7 /home/username/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/mysqli.php(403): DB_mysqli->mysqliRaiseError()
#8 /home/username/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1216): DB_mysqli->simpleQuery("INSERT INTO civicrm_action_log (contact_id, entity_id, entity_table, action_s...")
#9 /home/username/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(2415): DB_common->query("INSERT INTO civicrm_action_log (contact_id, entity_id, entity_table, action_s...")
#10 /home/username/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(1607): DB_DataObject->_query("INSERT INTO civicrm_action_log (contact_id, entity_id, entity_table, action_s...")
#11 /home/username/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(439): DB_DataObject->query("INSERT INTO civicrm_action_log (contact_id, entity_id, entity_table, action_s...")
#12 /home/username/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(1414): CRM_Core_DAO->query("INSERT INTO civicrm_action_log (contact_id, entity_id, entity_table, action_s...", TRUE)
#13 /home/username/public_html/wp-content/plugins/civicrm/civicrm/Civi/ActionSchedule/RecipientBuilder.php(215): CRM_Core_DAO::executeQuery("INSERT INTO civicrm_action_log (contact_id, entity_id, entity_table, action_s...")
#14 /home/username/public_html/wp-content/plugins/civicrm/civicrm/Civi/ActionSchedule/RecipientBuilder.php(156): Civi\ActionSchedule\RecipientBuilder->buildRelFirstPass()
#15 /home/username/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/BAO/ActionSchedule.php(360): Civi\ActionSchedule\RecipientBuilder->build()
#16 /home/username/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/BAO/ActionSchedule.php(375): CRM_Core_BAO_ActionSchedule::buildRecipientContacts(2, "20200101003003", (Array:2))
#17 /home/username/public_html/wp-content/plugins/civicrm/civicrm/api/v3/Job.php(221): CRM_Core_BAO_ActionSchedule::processQueue("20200101003003", (Array:2))
#18 /home/username/public_html/wp-content/plugins/civicrm/civicrm/Civi/API/Provider/MagicFunctionProvider.php(101): civicrm_api3_job_send_reminder((Array:2))
#19 /home/username/public_html/wp-content/plugins/civicrm/civicrm/Civi/API/Kernel.php(168): Civi\API\Provider\MagicFunctionProvider->invoke((Array:9))
#20 /home/username/public_html/wp-content/plugins/civicrm/civicrm/Civi/API/Kernel.php(99): Civi\API\Kernel->runRequest((Array:9))
#21 /home/username/public_html/wp-content/plugins/civicrm/civicrm/api/api.php(23): Civi\API\Kernel->runSafe("Job", "send_reminder", (Array:1), NULL)
#22 /home/username/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/JobManager.php(145): civicrm_api("Job", "send_reminder", (Array:1))
#23 /home/username/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/JobManager.php(78): CRM_Core_JobManager->executeJob(Object(CRM_Core_ScheduledJob))
#24 /home/username/public_html/wp-content/plugins/civicrm/civicrm/api/v3/Job.php(134): CRM_Core_JobManager->execute(FALSE)
#25 /home/username/public_html/wp-content/plugins/civicrm/civicrm/Civi/API/Provider/MagicFunctionProvider.php(101): civicrm_api3_job_execute((Array:2))
#26 /home/username/public_html/wp-content/plugins/civicrm/civicrm/Civi/API/Kernel.php(168): Civi\API\Provider\MagicFunctionProvider->invoke((Array:9))
#27 /home/username/public_html/wp-content/plugins/civicrm/civicrm/Civi/API/Kernel.php(99): Civi\API\Kernel->runRequest((Array:9))
#28 /home/username/public_html/wp-content/plugins/civicrm/civicrm/api/api.php(23): Civi\API\Kernel->runSafe("Job", "execute", (Array:2), NULL)
#29 /home/username/public_html/wp-content/plugins/civicrm/civicrm/bin/cli.class.php(122): civicrm_api("Job", "execute", (Array:2))
#30 /home/username/public_html/wp-content/plugins/civicrm/civicrm/bin/cli.php(32): civicrm_cli->callApi()
#31 {main}
```