Development issueshttps://lab.civicrm.org/groups/dev/-/issues2019-11-04T04:08:32Zhttps://lab.civicrm.org/dev/core/-/issues/449Bug: log_civicrm_group table grows insanely quickly2019-11-04T04:08:32ZAgilewareBug: log_civicrm_group table grows insanely quicklyBest demonstrated by example:
```
select count(id) `entries`, count(distinct id) `ids`, min(log_date) `since`, now() `now` from log_civicrm_group;
```
| entries | ids | since | now |
|---------|-----|-----...Best demonstrated by example:
```
select count(id) `entries`, count(distinct id) `ids`, min(log_date) `since`, now() `now` from log_civicrm_group;
```
| entries | ids | since | now |
|---------|-----|---------------------|---------------------|
| 31813 | 223 | 2018-10-16 14:14:51 | 2018-10-17 11:03:18 |
This is for a < 22hr period after I cleared this table to try and solve a data migration issue; before, this particular log table had grown to nearly 7 gigabytes (for the same 223 distinct group ids).
What appears to be happening is that every time the group_rebuild job is called, the cache_date is being NULLed and filled back in, creating two additional pointless log entries.
Per group id, I counted up to 250 log entries where only these fields had changed.
I think it should be possible to fix this by one of:
1. Disabling logging the the group_rebuild API call runs; or
2. excluding changes to just the cache_date and refresh_date fields from the civicrm_group triggers
Agileware ref CIVICRM-10015.12.0https://lab.civicrm.org/dev/core/-/issues/397Dedupe for Individual Birth Date Results in Error2019-02-13T20:28:31ZjasonobrownDedupe for Individual Birth Date Results in Error```
civicrm: $Fatal Error Details = Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)
[code] => -1
[message] => DB Error: unknown error
[mode] => 16
[debug_in...```
civicrm: $Fatal Error Details = Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)
[code] => -1
[message] => DB Error: unknown error
[mode] => 16
[debug_info] => INSERT INTO dedupe (id1, id2, weight) SELECT t1.id id1, t2.id id2, 5 weight FROM civicrm_contact t1 JOIN civicrm_contact t2 USING (birth_date) JOIN dedupe_copy ON dedupe_copy.id1 = t1.id AND dedupe_copy.id2 = t2.id WHERE t1.contact_type = 'Individual' AND t2.contact_type = 'Individual' AND t1.id < t2.id AND t1.birth_date IS NOT NULL AND t1.birth_date <> '' GROUP BY id1, id2, weight ON DUPLICATE KEY UPDATE weight = weight + VALUES(weight) [nativecode=1292 ** Incorrect date value: '' for column 'birth_date' at row 1]
[type] => DB_Error
[user_info] => INSERT INTO dedupe (id1, id2, weight) SELECT t1.id id1, t2.id id2, 5 weight FROM civicrm_contact t1 JOIN civicrm_contact t2 USING (birth_date) JOIN dedupe_copy ON dedupe_copy.id1 = t1.id AND dedupe_copy.id2 = t2.id WHERE t1.contact_type = 'Individual' AND t2.contact_type = 'Individual' AND t1.id < t2.id AND t1.birth_date IS NOT NULL AND t1.birth_date <> '' GROUP BY id1, id2, weight ON DUPLICATE KEY UPDATE weight = weight + VALUES(weight) [nativecode=1292 ** Incorrect date value: '' for column 'birth_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 dedupe (id1, id2, weight) SELECT t1.id id1, t2.id id2, 5 weight FROM civicrm_contact t1 JOIN civicrm_contact t2 USING (birth_date) JOIN dedupe_copy ON dedupe_copy.id1 = t1.id AND dedupe_copy.id2 = t2.id WHERE t1.contact_type = 'Individual' AND t2.contact_type = 'Individual' AND t1.id < t2.id AND t1.birth_date IS NOT NULL AND t1.birth_date <> '' GROUP BY id1, id2, weight ON DUPLICATE KEY UPDATE weight = weight + VALUES(weight) [nativecode=1292 ** Incorrect date value: '' for column 'birth_date' at row 1]"]
)
```5.12.0https://lab.civicrm.org/dev/core/-/issues/190custom data with multiple records profile: after submission, profile view sho...2019-02-24T19:02:48Zlcdwebcustom data with multiple records profile: after submission, profile view shows first record instead of most recentTo reproduce:
* create a custom data set with multiple records enabled. create a field or two.
* create a profile that includes the fields and the email field (to enable duplicate matching). make sure "update contact" is selected in the...To reproduce:
* create a custom data set with multiple records enabled. create a field or two.
* create a profile that includes the fields and the email field (to enable duplicate matching). make sure "update contact" is selected in the advanced setting.
* open the profile in create view
* submit the form with values
* go back and submit the form a second time with different values
* notice that after submitting the second time, the profile view displays values from the first time you submitted the form, not the most recent5.12.0lcdweblcdwebhttps://lab.civicrm.org/dev/core/-/issues/907[php 7.2 support] deprecation notice in cli.clas2019-04-30T09:24:54Zeileen[php 7.2 support] deprecation notice in cli.clasThis won't cause any issues but gives a deprecation notice & needs fixing
PHP Deprecated: The each() function is deprecated. This message will be suppressed on further calls in
/home/kaiva276/menscommission.in/wp-content/plugins/civi...This won't cause any issues but gives a deprecation notice & needs fixing
PHP Deprecated: The each() function is deprecated. This message will be suppressed on further calls in
/home/kaiva276/menscommission.in/wp-content/plugins/civicrm/civicrm/bin/cli.class.php
(row appears to have changed as that is 5.10)
https://github.com/civicrm/civicrm-core/blob/62bf1e4237e6332b29aace76c1c5fbaf8a52bdff/bin/cli.class.php#L1495.13.0https://lab.civicrm.org/dev/core/-/issues/904PR 13333 breaks the Save and New button on a new case2019-05-07T23:05:09ZDaveDPR 13333 breaks the Save and New button on a new caseIf I take out the second "submitOnce" line in CRM/Case/Form/Activity/OpenCase.php then it works again.If I take out the second "submitOnce" line in CRM/Case/Form/Activity/OpenCase.php then it works again.5.13.0https://lab.civicrm.org/dev/core/-/issues/891mailing preview fails when viewUrl token present and mailing hash enabled.2019-04-25T06:07:12Zlcdwebmailing preview fails when viewUrl token present and mailing hash enabled.This is similar to: https://lab.civicrm.org/dev/mail/issues/41
The presence of the mailing.viewUrl token with the mailing hash setting enabled expects the Mailing ID, which is not passed with the preview action (for performance reasons).This is similar to: https://lab.civicrm.org/dev/mail/issues/41
The presence of the mailing.viewUrl token with the mailing hash setting enabled expects the Mailing ID, which is not passed with the preview action (for performance reasons).5.13.0lcdweblcdwebhttps://lab.civicrm.org/dev/core/-/issues/865Result filter criteria doesn't show IS NULL/IS NOT NULL for operations2019-04-15T05:32:20ZyashodhaResult filter criteria doesn't show IS NULL/IS NOT NULL for operationsWe can not search all contributions that are not associated with a campaign currently in report. We should expose IS NULL/IS NOT NULL for other operators as wellWe can not search all contributions that are not associated with a campaign currently in report. We should expose IS NULL/IS NOT NULL for other operators as well5.13.0yashodhayashodhahttps://lab.civicrm.org/dev/core/-/issues/840Notice error when deleting profile2019-04-01T20:36:27ZPradeep Nayakpradpnayak@gmail.comNotice error when deleting profileTo replicate: Delete profile
`Notice: Undefined property: CRM_UF_Form_Group::$deleteMessage in /var/www/vhosts/xxxx/httpdocs/portal-login/wp-content/plugins/civicrm/civicrm/CRM/Core/Form/EntityFormTrait.php on line 65`
CiviCRM version...To replicate: Delete profile
`Notice: Undefined property: CRM_UF_Form_Group::$deleteMessage in /var/www/vhosts/xxxx/httpdocs/portal-login/wp-content/plugins/civicrm/civicrm/CRM/Core/Form/EntityFormTrait.php on line 65`
CiviCRM version: 5.11.05.13.0https://lab.civicrm.org/dev/core/-/issues/837Notice error while creating smart group using Contribution Aggregate custom s...2019-03-31T20:27:05ZPradeep Nayakpradpnayak@gmail.comNotice error while creating smart group using Contribution Aggregate custom search```
Notice: Undefined index: contribution_date_relative in CRM_Contact_Form_Search_Custom_ContributionAggregate->where() (line 204 of /Users/pradeep/Sites/drupal7/sites/all/modules/civicrm/CRM/Contact/Form/Search/Custom/ContributionAggre...```
Notice: Undefined index: contribution_date_relative in CRM_Contact_Form_Search_Custom_ContributionAggregate->where() (line 204 of /Users/pradeep/Sites/drupal7/sites/all/modules/civicrm/CRM/Contact/Form/Search/Custom/ContributionAggregate.php).
Notice: Undefined index: contribution_date_low in CRM_Contact_Form_Search_Custom_ContributionAggregate->where() (line 205 of /Users/pradeep/Sites/drupal7/sites/all/modules/civicrm/CRM/Contact/Form/Search/Custom/ContributionAggregate.php).
Notice: Undefined index: contribution_date_high in CRM_Contact_Form_Search_Custom_ContributionAggregate->where() (line 206 of /Users/pradeep/Sites/drupal7/sites/all/modules/civicrm/CRM/Contact/Form/Search/Custom/ContributionAggregate.php).
Notice: Undefined index: contribution_date_relative in CRM_Contact_Form_Search_Custom_ContributionAggregate->where() (line 204 of /Users/pradeep/Sites/drupal7/sites/all/modules/civicrm/CRM/Contact/Form/Search/Custom/ContributionAggregate.php).
Notice: Undefined index: contribution_date_low in CRM_Contact_Form_Search_Custom_ContributionAggregate->where() (line 205 of /Users/pradeep/Sites/drupal7/sites/all/modules/civicrm/CRM/Contact/Form/Search/Custom/ContributionAggregate.php).
Notice: Undefined index: contribution_date_high in CRM_Contact_Form_Search_Custom_ContributionAggregate->where() (line 206 of /Users/pradeep/Sites/drupal7/sites/all/modules/civicrm/CRM/Contact/Form/Search/Custom/ContributionAggregate.php).
Notice: Undefined index: contribution_date_relative in CRM_Contact_Form_Search_Custom_ContributionAggregate->where() (line 204 of /Users/pradeep/Sites/drupal7/sites/all/modules/civicrm/CRM/Contact/Form/Search/Custom/ContributionAggregate.php).
Notice: Undefined index: contribution_date_low in CRM_Contact_Form_Search_Custom_ContributionAggregate->where() (line 205 of /Users/pradeep/Sites/drupal7/sites/all/modules/civicrm/CRM/Contact/Form/Search/Custom/ContributionAggregate.php).
Notice: Undefined index: contribution_date_high in CRM_Contact_Form_Search_Custom_ContributionAggregate->where() (line 206 of /Users/pradeep/Sites/drupal7/sites/all/modules/civicrm/CRM/Contact/Form/Search/Custom/ContributionAggregate.php).
```5.13.0https://lab.civicrm.org/dev/core/-/issues/836Do not track CSS urls2019-03-31T20:27:29ZseamusleeDo not track CSS urlsAt the moment in Civimail if someone inserts a link tag like
```
<link href='https://fonts.googleapis.com/css?family=Roboto+Condensed:400,700|Zilla+Slab:500,700' rel='stylesheet' type='text/css'>
```
CiviMail will convert it into a tr...At the moment in Civimail if someone inserts a link tag like
```
<link href='https://fonts.googleapis.com/css?family=Roboto+Condensed:400,700|Zilla+Slab:500,700' rel='stylesheet' type='text/css'>
```
CiviMail will convert it into a trackable url5.13.0https://lab.civicrm.org/dev/core/-/issues/829Swaziland has changed its name to Eswatini2019-03-28T20:07:12Zlord_tSwaziland has changed its name to EswatiniSwaziland country has changed name to Eswatini so in CiviCRM it also has to be changed.
> On 19 April 2018, King Mswati III announced that the Kingdom of Swaziland had renamed itself the Kingdom of Eswatini, reflecting the extant Swazi...Swaziland country has changed name to Eswatini so in CiviCRM it also has to be changed.
> On 19 April 2018, King Mswati III announced that the Kingdom of Swaziland had renamed itself the Kingdom of Eswatini, reflecting the extant Swazi name for the state eSwatini, to mark the 50th anniversary of Swazi independence. The new name, **Eswatini**, [...]
Source: https://en.wikipedia.org/wiki/Eswatini#Independence_(1968%E2%80%93present)
Patch: https://github.com/civicrm/civicrm-core/pull/139025.13.0https://lab.civicrm.org/dev/core/-/issues/819Search results: Actions: Export contacts: DB Error: Syntax error occurs when ...2019-03-27T20:08:45ZPradeep Nayakpradpnayak@gmail.comSearch results: Actions: Export contacts: DB Error: Syntax error occurs when not all necessary fields are selectedSTR:
* Navigate to "Search→Find Contacts"
* Leave the search fields empty and click "Search"
* Select any Individual
* Click the "Actions" dropdown
* Select "Export Contacts"
* Click the "Select fields for export" radio button
* Click ...STR:
* Navigate to "Search→Find Contacts"
* Leave the search fields empty and click "Search"
* Select any Individual
* Click the "Actions" dropdown
* Select "Export Contacts"
* Click the "Select fields for export" radio button
* Click "Continue"
* On the Select Fields to Export step, click the "Select record type" dropdown
* Select "Individual"
* Leave the "Select field" dropdown empty
* Click "Export"
**Result:** DB Error: syntax error occurs. Please take a look at the attachment
![ExportError-Before](/uploads/e97b8cb4b4dfb1ae5fed72dafcd4e459/ExportError-Before.gif)5.13.0https://lab.civicrm.org/dev/core/-/issues/812Contribution row displayed even if contact has 0 contributions.2019-03-22T12:47:10ZjitendraContribution row displayed even if contact has 0 contributions.For a contact who has no contribution, an empty row is displayed on the contact summary page.
Screenshot from dmaster -
![image](/uploads/dac551024d803fc3c59464f397aa79d0/image.png)
If any of the link is clicked on the row, it results...For a contact who has no contribution, an empty row is displayed on the contact summary page.
Screenshot from dmaster -
![image](/uploads/dac551024d803fc3c59464f397aa79d0/image.png)
If any of the link is clicked on the row, it results into an error -
![image](/uploads/54f210db421782c0c987ece4dea9d16f/image.png)
This was working in the latest rc version. Seems to have broken after https://github.com/civicrm/civicrm-core/pull/13720 .5.13.0jitendrajitendrahttps://lab.civicrm.org/dev/core/-/issues/811Autocomplete select list disabled options2019-03-19T23:27:09ZPradeep Nayakpradpnayak@gmail.comAutocomplete select list disabled optionsCustom field with type Autocomplete-select lists disabled options.
![Autocomplete-select](/uploads/4255d3183f1e8baf55aee8e4201b95cc/Autocomplete-select.gif)Custom field with type Autocomplete-select lists disabled options.
![Autocomplete-select](/uploads/4255d3183f1e8baf55aee8e4201b95cc/Autocomplete-select.gif)5.13.0https://lab.civicrm.org/dev/core/-/issues/798Prefix/suffix select2 renders oddly on public-facing pages2019-03-14T21:07:10ZJonGoldPrefix/suffix select2 renders oddly on public-facing pagesPrefix and suffix fields in contribution/event profiles render incorrectly on public-facing pages. See screenshot:
![Selection_823](/uploads/5d05559371fa6c062b2dad8ecd8c2901/Selection_823.png)
There are a couple of ways to fix, I'll do...Prefix and suffix fields in contribution/event profiles render incorrectly on public-facing pages. See screenshot:
![Selection_823](/uploads/5d05559371fa6c062b2dad8ecd8c2901/Selection_823.png)
There are a couple of ways to fix, I'll do whatever folks like best.
One is to fix `civicrm.css` here:
```css
.crm-container.crm-public .select2-container .select2-choice {
padding: 5px 5px 5px 8px;
height: auto;
}
```
Changing `height: auto` to `height: 26px` matches the backend `select2.css`. Other select2 widgets are unaffected because they have placeholder text. I could also add placeholder text to the default rendering of this widget, but I think the CSS fix makes more sense.
I'll submit a PR to continue this discussion.5.13.0JonGoldJonGoldhttps://lab.civicrm.org/dev/core/-/issues/795PHP Warning "explode() expects parameter 2 to be string, array given" for mul...2019-03-20T14:59:22ZVirenmagePHP Warning "explode() expects parameter 2 to be string, array given" for multi-value country fieldsI am getting above error while trying to save multiple country for agent profile. And when I search about this error I found that unnecessary use of explode() function on line 127. You can see more about on https://lab.civicrm.org/dev/co...I am getting above error while trying to save multiple country for agent profile. And when I search about this error I found that unnecessary use of explode() function on line 127. You can see more about on https://lab.civicrm.org/dev/core/issues/216 and code file
https://lab.civicrm.org/dev/core/blob/master/CRM/Core/BAO/CustomValueTable.php#L127
So according to me you need to ask to civiCRM team to comment line 127
$mulValues = explode(',', $value);
![error](/uploads/c124cf6618247c06ef570df0639f869c/error.png)5.13.0https://lab.civicrm.org/dev/core/-/issues/789Event reg error when skipping additional contacts2019-03-18T00:07:09ZMartinEvent reg error when skipping additional contactsWe recently encountered a bug under some fairly specific conditions:
* Doing an event registration
* Multiple participants enabled
* User select >1 participant
* On one of the subsequent participants, chooses the "skip" option
* Att...We recently encountered a bug under some fairly specific conditions:
* Doing an event registration
* Multiple participants enabled
* User select >1 participant
* On one of the subsequent participants, chooses the "skip" option
* Attempts to pay using a real credit card on a live payment gateway (in our case using the iATS extension)
This was on Civi 5.9.1 with Drupal 7.63.
In this situation, we found the following error:
> Warning: Invalid argument supplied for foreach() in CRM_Event_Form_Rgistration_Confirm->cleanMoneyFields() (line 1357 of [drupal root]/sites/all/modules/civicrm/CRM/Event/Form/Registration/Confirm.php).
Creating a pull request to fix in progress. I'm confused though, is the codebase here or on github??5.13.0https://lab.civicrm.org/dev/core/-/issues/788Warning: A non-numeric value encountered in ...2019-03-18T05:00:01ZwouterhWarning: A non-numeric value encountered in ...I've encountered warnings on contribution pages & event registrations
- Drupal8
- CiviCRM 5.10.4
- PHP 7.2.12
Warning: A non-numeric value encountered in CRM_Contribute_Form_Contribution_Main::formRule() (line 900 of /var/www/html/vendo...I've encountered warnings on contribution pages & event registrations
- Drupal8
- CiviCRM 5.10.4
- PHP 7.2.12
Warning: A non-numeric value encountered in CRM_Contribute_Form_Contribution_Main::formRule() (line 900 of /var/www/html/vendor/civicrm/civicrm-core/CRM/Contribute/Form/Contribution/Main.php).
Warning: A non-numeric value encountered in CRM_Event_Form_Registration_Register->postProcess() (line 1146 of /var/www/html/vendor/civicrm/civicrm-core/CRM/Event/Form/Registration/Register.php).
```
if ($self->_paymentProcessor &&
$self->_paymentProcessor['billing_mode'] & CRM_Core_Payment::BILLING_MODE_BUTTON
) {
```
```
elseif ($this->_paymentProcessor &&
$this->_paymentProcessor['billing_mode'] & CRM_Core_Payment::BILLING_MODE_NOTIFY
) {
```
![788](/uploads/6ce88a0bf5059e65b381841b42b1fdf2/788.png)5.13.0https://lab.civicrm.org/dev/core/-/issues/784Creating a new relationship type while editing case type definition adds a bl...2019-03-24T20:47:10ZDaveDCreating a new relationship type while editing case type definition adds a blank row in the roles sectionCame across this while working on dev/core#774. Making it a separate child issue (or trying to) since the cause is different and can reproduce separately on the public demo. The cause is that crmCaseType.js accesses data.relationshipType...Came across this while working on dev/core#774. Making it a separate child issue (or trying to) since the cause is different and can reproduce separately on the public demo. The cause is that crmCaseType.js accesses data.relationshipType.label_b_a as if it was an object member but it actually looks like data.relationshipType.19.label_b_a, where 19 is the newly created id.
By "new relationship type" I mean on the case type edit admin screen where you have the dropdown to add a role, if you start typing in the dropdown and it doesn't match an existing relationship type it gives you a "(new)" hint where you can click to create the new relationship type on the fly.5.13.0https://lab.civicrm.org/dev/core/-/issues/771Smart group with uf_group_id does not load contacts with same search profile2019-03-18T02:47:02ZjitendraSmart group with uf_group_id does not load contacts with same search profileSteps to reproduce -
- Create a search profile adding some basic fields `first name`, last name and email.
- Open Advanced Search form, select this profile and add some filters.
- create a smart group of the resulted contacts.
- When yo...Steps to reproduce -
- Create a search profile adding some basic fields `first name`, last name and email.
- Open Advanced Search form, select this profile and add some filters.
- create a smart group of the resulted contacts.
- When you come back from the process after clicking the `Done` button on the last screen, the profile is not pre-selected by default.
- `uf_group_id` is not stored as a formvalue in `civicrm_saved_search` table.5.13.0jitendrajitendra