Development issueshttps://lab.civicrm.org/groups/dev/-/issues2021-02-04T19:23:38Zhttps://lab.civicrm.org/dev/drupal/-/issues/57Editing contribution recorded as "Deleted Activity" when full log is enabled2021-02-04T19:23:38ZtapashEditing contribution recorded as "Deleted Activity" when full log is enabledIf an existing contribution edited when full log is enabled, it records in chage log as "Deleted Activity". Is this how it should be?If an existing contribution edited when full log is enabled, it records in chage log as "Deleted Activity". Is this how it should be?https://lab.civicrm.org/dev/core/-/issues/885Attendee Report: Incorrect filtering by deceased participants2020-12-04T01:44:28ZshaneonabikeAttendee Report: Incorrect filtering by deceased participantsSo today I discovered a pretty strange bug, but I'm open to determine whether this is related to something in the configuration.
**Issue**
When viewing the Attendee List for a new event I noticed that the participant count was lower th...So today I discovered a pretty strange bug, but I'm open to determine whether this is related to something in the configuration.
**Issue**
When viewing the Attendee List for a new event I noticed that the participant count was lower than the Event Participants List. What is narrows down to is that the Attendee List has a *filter for excluding deceased participants*. When I set this to **Any** value it works perfectly.
I traced on so called *deceased* participant and they are not set to deceased. All of these users were imported about 1.5 years ago from an old CiviCRM system and imported here. I don't know if perhaps there an incorrect value is set for the deceased value and therefore is causing certain participants to be considered this way. In total I believe there is about **48** in total :/
**CiviCRM Details**
* Drupal 7
* CiviCRM 5.12.0
* PHP 7.3.4https://lab.civicrm.org/dev/core/-/issues/880utf8mb4 warning keeps coming back up2019-04-24T21:47:11Zjohnkutf8mb4 warning keeps coming back upI run CiviCRM 5.12.0 on Drupal 8.6.14 with PHP 7.2.15 and Apache2. I use postgres for my Drupal database, so the databases are split.
When I upgraded to the recent version that added the Mysql utf8mb4 check (5.12, I think), at the Drupa...I run CiviCRM 5.12.0 on Drupal 8.6.14 with PHP 7.2.15 and Apache2. I use postgres for my Drupal database, so the databases are split.
When I upgraded to the recent version that added the Mysql utf8mb4 check (5.12, I think), at the Drupal status page it began showing the message: "It is recommended, though not yet required, to configure your MySQL server for utf8mb4 support. You will need the following MySQL server configuration: innodb_large_prefix=true innodb_file_format=barracuda innodb_file_per_table=true." I added this configuration to my mysqld.cnf, and then restarted and saw that the message was gone. However, when I restarted my Apache server the next time, the message came back, and I found that the civicrm_utf8mb4_test table was present in the database and needed to be dropped. From code inspection, I concluded this could only come about as a result of a race condition with civicrm-core/Civi/Install/Requirements.php, where the table is created as a non-temporary table. So I changed that code to 'CREATE TEMPORARY TABLE ...' and 'DROP TEMPORARY TABLE ...', which caused the problem to go away.
However, my attempts to capture debug_backtrace() at this point in the code have all failed. I don't understand why that is. I tried printing it to the apache error log, as well as writing it to a file in '/tmp'. I have a dev version of the site, which uses the same CiviCRM database connection, so I also have disabled this site in my Apache configuration, as it seems like it could have been a complicating factor. The bug still occurs, with that original Civi/Install/Requirements.php.5.14.0https://lab.civicrm.org/dev/core/-/issues/871CIVICRM References SF ISSUE2019-04-16T16:29:51ZVirenmageCIVICRM References SF ISSUEI want to display all REFERENCES SF on front-end of login user's dashboard with contact ID in wordpress but I am unable to display REFERENCES SF.
whenever I login with admin and hit below url with php function "file_get_contents" then i...I want to display all REFERENCES SF on front-end of login user's dashboard with contact ID in wordpress but I am unable to display REFERENCES SF.
whenever I login with admin and hit below url with php function "file_get_contents" then it return data in json formate and logout from admin then it does not return any data.I think civicrm check admin login.
url : https://xyz.com/?page=CiviCRM&q=civicrm%2Fajax%2Fmultirecordfieldlist&snippet=4&cid=213&cgid=11&draw=1&columns%5B0%5D%5Bdata%5D=year_26&columns%5B0%5D%5Bname%5D=&columns%5B0%5D%5Bsearchable%5D=true&columns%5B0%5D%5Borderable%5D=true&columns%5B0%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B0%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B1%5D%5Bdata%5D=type_of_provider_27&columns%5B1%5D%5Bname%5D=&columns%5B1%5D%5Bsearchable%5D=true&columns%5B1%5D%5Borderable%5D=true&columns%5B1%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B1%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B2%5D%5Bdata%5D=country_28&columns%5B2%5D%5Bname%5D=&columns%5B2%5D%5Bsearchable%5D=true&columns%5B2%5D%5Borderable%5D=true&columns%5B2%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B2%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B3%5D%5Bdata%5D=action&columns%5B3%5D%5Bname%5D=&columns%5B3%5D%5Bsearchable%5D=true&columns%5B3%5D%5Borderable%5D=false&columns%5B3%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B3%5D%5Bsearch%5D%5Bregex%5D=false&start=0&length=25&search%5Bvalue%5D=&search%5Bregex%5D=false
I have used below code as well but I am unable to get REFERENCES SF. Please check and confirm where I am lacking and which code good to go with. Please guide me as I am stuck in it badly .
$contact_id = get_user_meta($userID, 'contact_id', true);
require_once WP_PLUGIN_DIR . '/civicrm/civicrm/api/class.api.php';
civicrm_initialize();
$result = civicrm_api3(
'Contact',
'get',
[
'sequential' => 1,
'return' => [
"custom_23",
"custom_16",
"organization_name",
"custom_17",
"email",
"phone",
"custom_29",
"custom_25",
"custom_26",
"custom_27",
"custom_24",
"custom_22",
"custom_21",
"custom_20",
"custom_19",
"custom_18",
"custom_28",
"city",
"street_address",
"address_id"
],
'id' => $contact_id,
]
);https://lab.civicrm.org/dev/core/-/issues/861Mail job stuck after contact marked deceased2022-06-11T14:52:12ZyashodhaMail job stuck after contact marked deceasedMail job gets stuck when a contact's email was placed on hold after draft creation - an additional condition needs to be added in order to skip deceased contacts if they are included in the mail group.
This is same for deceased contact,...Mail job gets stuck when a contact's email was placed on hold after draft creation - an additional condition needs to be added in order to skip deceased contacts if they are included in the mail group.
This is same for deceased contact, his preference changes or if contact's email is no longer primary.
Steps to replicate:
* Create a mailing with contacts and schedule it.
* Edit one of the contact to make it deceased.
* Run the scheduled job, it get stuck and no mailing goes out.
![mailing](/uploads/abc02e14a3961d871c196bbdf774023b/mailing.png)
Desired behavior - mailings to all contacts except deceased should go out.
5.19.0yashodhayashodhahttps://lab.civicrm.org/dev/joomla/-/issues/12Actions on Search Results for Contacts is not happening2019-04-10T15:31:12ZchaosbusterActions on Search Results for Contacts is not happeningCiviCRM 5.12.0 on WordPress 5.1.1
After doing any type of search when selecting Contacts in the resulting search (either using the ALL or selected records) then selecting an 'Action' in the dropdown, the page does not go to the next pag...CiviCRM 5.12.0 on WordPress 5.1.1
After doing any type of search when selecting Contacts in the resulting search (either using the ALL or selected records) then selecting an 'Action' in the dropdown, the page does not go to the next page to do the action. For my instance, I was trying to use the 'Group - add contacts' action.https://lab.civicrm.org/dev/core/-/issues/823Value in the "Contact Type" field disappears when the user tries to edit Cont...2019-05-09T21:44:17ZPradeep Nayakpradpnayak@gmail.comValue in the "Contact Type" field disappears when the user tries to edit Contact DetailsContact sub type is not pre-populated when trying to update contact using profile.Contact sub type is not pre-populated when trying to update contact using profile.https://lab.civicrm.org/dev/core/-/issues/813Profile listings don't show some address/phone fields (all but "main"): work,...2022-10-11T05:03:33ZcalbasiProfile listings don't show some address/phone fields (all but "main"): work, home, etc. But I can see/edit it at contact recordAfter upgrade my CiviCRM (from 4.6.x to 5.10) in a Debian 8 server, with php 5.4 (I'm going to migrate to Debian 9/10 later, to meet php new requeriments) I get this error when render listings with phone/address fields:
Notice: Undefine...After upgrade my CiviCRM (from 4.6.x to 5.10) in a Debian 8 server, with php 5.4 (I'm going to migrate to Debian 9/10 later, to meet php new requeriments) I get this error when render listings with phone/address fields:
Notice: Undefined property: CRM_Core_DAO::$Feina-phone-1 en CRM_Profile_Selector_Listings->getRows() (lĂnea 659 de .../sites/all/modules/civicrm/CRM/Profile/Selector/Listings.php).
where "Feina" means "Work" on Catalan.
That is, I can render phone / address field if I choose "main" address/phone at profile builder, but not secondary fields (home/work/work2, etc).
But I can view/edit this info at contact record form, then, it's just a Profile listing error, what I think mean it's a bug/issue, and not just an isolated issue from my install.
I don't know if problem could be related with the use of other language than English or not.
Ps.: I've submitted a question at stackexchange, but not lucky
[there](https://civicrm.stackexchange.com/questions/28755/notice-undefined-property-crm-core-daofeina-phone-2-a-crm-profile-selector)https://lab.civicrm.org/dev/core/-/issues/807Error in participant counts on events with waitlists2022-10-11T05:03:32ZCharlie DunlaveyError in participant counts on events with waitlistsThere seems to be a participant calculation error at a specific stage in the workflow for events using waitlists, which is making the waitlist feature unuseable.
When a place becomes available on an event with a waitlist, the reminder e...There seems to be a participant calculation error at a specific stage in the workflow for events using waitlists, which is making the waitlist feature unuseable.
When a place becomes available on an event with a waitlist, the reminder email is being sent correctly to the person at the top of the waitlist, but when this user clicks on the registration link in the email, they see the 'Oops, it looks like there are no spaces' message.
At the confirmation page stage, it looks like Civi is counting all participants as opposed to just those with counted set to true. Are you able to take a look?
Thank you,
Charliehttps://lab.civicrm.org/dev/core/-/issues/796Updating priceset when selected option is full2022-10-09T05:03:32ZwdecraeneUpdating priceset when selected option is fullYou want to edit as an admin the priceset of an participant, the option the participant selected is full.
![Schermafbeelding_2019-03-12_om_21.21.42](/uploads/4e6f018316f4f102805ad121f83f46d7/Schermafbeelding_2019-03-12_om_21.21.42.png)
...You want to edit as an admin the priceset of an participant, the option the participant selected is full.
![Schermafbeelding_2019-03-12_om_21.21.42](/uploads/4e6f018316f4f102805ad121f83f46d7/Schermafbeelding_2019-03-12_om_21.21.42.png)
You change the value to another option and save it.
![Schermafbeelding_2019-03-12_om_21.24.34](/uploads/cab5f64141209839934a3f517be84095/Schermafbeelding_2019-03-12_om_21.24.34.png)
After saving, the option did not change.
But, when you change the radio after the selected one it does save it.
Reason: behind the option which is selected and full, there is a hidden option field which is selected. When you select the option before this radio and post the form, the browser only post the last one (a radio field can only have one selected value). That is also the reason why the value is changed when you select the radio after the original one.
Solution ? No hidden/disabled options for admins? Should admins be able to override the max possibilities per participant?https://lab.civicrm.org/dev/core/-/issues/791Multiple form submits on contribution pages2022-10-08T05:03:33ZMartinMultiple form submits on contribution pagesThere have been 2 times (and possible more) where contribution pages have submitted more than once when a user filled them out. These have both been (on different pages) for a membership renewal using the "pay later" option. In one case ...There have been 2 times (and possible more) where contribution pages have submitted more than once when a user filled them out. These have both been (on different pages) for a membership renewal using the "pay later" option. In one case there were about 6 contributions created, and 12 in the other.
This is what is showing in the apache log (edited to remove site info / ips, and removing css, etc):
`
[06/Mar/2019:14:37:19 +0000] "GET /civicrm/contribute/transact?reset=1&id=7&cs=114dc355fb504a48dddf1d51450c4a2d_1551882710_168&cid=605 HTTP/1.1" 200 23469 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/64.0.3282.140 Safari/537.36 Edge/18.17763"
[06/Mar/2019:14:37:40 +0000] "GET /civicrm/ajax/l10n-js/en_US?r=0n8f3 HTTP/1.1" 200 2689 "https://mywebsite.com/civicrm/contribute/transact?reset=1&id=7&cs=114dc355fb504a48dddf1d51450c4a2d_1551882710_168&cid=605" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/64.0.3282.140 Safari/537.36 Edge/18.17763"
[06/Mar/2019:14:39:15 +0000] "GET /civicrm/payment/form?formName=Main¤cy=CAD&&is_back_office=&id=7&processor_id=0&cid=605&cs=114dc355fb504a48dddf1d51450c4a2d_1551882710_168&payment_instrument_id=undefined&snippet=json HTTP/1.1" 200 2046 "https://mywebsite.com/civicrm/contribute/transact?reset=1&id=7&cs=114dc355fb504a48dddf1d51450c4a2d_1551882710_168&cid=605" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/64.0.3282.140 Safari/537.36 Edge/18.17763"
[06/Mar/2019:14:39:21 +0000] "POST /civicrm/contribute/transact HTTP/1.1" 302 619 "https://mywebsite.com/civicrm/contribute/transact?reset=1&id=7&cs=114dc355fb504a48dddf1d51450c4a2d_1551882710_168&cid=605" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/64.0.3282.140 Safari/537.36 Edge/18.17763"
[06/Mar/2019:14:39:21 +0000] "POST /civicrm/contribute/transact HTTP/1.1" 302 619 "https://mywebsite.com/civicrm/contribute/transact?reset=1&id=7&cs=114dc355fb504a48dddf1d51450c4a2d_1551882710_168&cid=605" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/64.0.3282.140 Safari/537.36 Edge/18.17763"
[06/Mar/2019:14:39:21 +0000] "POST /civicrm/contribute/transact HTTP/1.1" 302 619 "https://mywebsite.com/civicrm/contribute/transact?reset=1&id=7&cs=114dc355fb504a48dddf1d51450c4a2d_1551882710_168&cid=605" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/64.0.3282.140 Safari/537.36 Edge/18.17763"
[06/Mar/2019:14:39:21 +0000] "POST /civicrm/contribute/transact HTTP/1.1" 302 619 "https://mywebsite.com/civicrm/contribute/transact?reset=1&id=7&cs=114dc355fb504a48dddf1d51450c4a2d_1551882710_168&cid=605" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/64.0.3282.140 Safari/537.36 Edge/18.17763"
[06/Mar/2019:14:39:21 +0000] "POST /civicrm/contribute/transact HTTP/1.1" 302 619 "https://mywebsite.com/civicrm/contribute/transact?reset=1&id=7&cs=114dc355fb504a48dddf1d51450c4a2d_1551882710_168&cid=605" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/64.0.3282.140 Safari/537.36 Edge/18.17763"
[06/Mar/2019:14:39:21 +0000] "POST /civicrm/contribute/transact HTTP/1.1" 500 900 "https://mywebsite.com/civicrm/contribute/transact?reset=1&id=7&cs=114dc355fb504a48dddf1d51450c4a2d_1551882710_168&cid=605" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/64.0.3282.140 Safari/537.36 Edge/18.17763"
`
The following is in the apache error log:
`
[Wed Mar 06 14:40:25.937577 2019] [core:error] End of script output before headers: index.php, referer: https://mywebsite.com/civicrm/contribute/transact?reset=1&id=7&cs=114dc355fb504a48dddf1d51450c4a2d_1551882710_168&cid=605
`
The site has the Stripe and CiviDiscount extensions enabled.
Any help is much appreciated!https://lab.civicrm.org/dev/core/-/issues/780Participant tokens are missing for pdf letters2021-10-12T02:43:07ZwdecraeneParticipant tokens are missing for pdf lettersThis was added before, but in the recent versions (don't know which version), it is not possible to select and use them. Patch attached should solve this.
[add-participant-tokens-to-pdf-letters.patch](/uploads/404f69f9224b70ba7be4bcd1b5...This was added before, but in the recent versions (don't know which version), it is not possible to select and use them. Patch attached should solve this.
[add-participant-tokens-to-pdf-letters.patch](/uploads/404f69f9224b70ba7be4bcd1b529e079/add-participant-tokens-to-pdf-letters.patch)5.43.0https://lab.civicrm.org/dev/core/-/issues/777Contact ID column is not shown in the report Repeat results2023-02-06T07:53:29ZGhost UserContact ID column is not shown in the report Repeat resultsWhen you select the column 'Contact ID' it doesn't show in the report results.
![Contact_ID_doesn_t_show_on_Repeat](/uploads/457e815634fb568aaf005582ae7c932b/Contact_ID_doesn_t_show_on_Repeat.png)When you select the column 'Contact ID' it doesn't show in the report results.
![Contact_ID_doesn_t_show_on_Repeat](/uploads/457e815634fb568aaf005582ae7c932b/Contact_ID_doesn_t_show_on_Repeat.png)https://lab.civicrm.org/dev/core/-/issues/775Event registration being cancelled when IPN notification received2022-10-30T05:03:27Zvakeesan26Event registration being cancelled when IPN notification receivedWhen we use IPN [eg: Sage-pay] payment processor for event, If user click browser back button after reaching payment website and then confirm again CiviCRM creating new contribution for same participant record.
In this case after user co...When we use IPN [eg: Sage-pay] payment processor for event, If user click browser back button after reaching payment website and then confirm again CiviCRM creating new contribution for same participant record.
In this case after user completing the latest contribution successfully, few minutes later payment processor sending the cancelled notification for previous contribution [The Transaction timed-out.]
now the participant record also being cancelled because of that contribution is updated as cancelled.
![image](/uploads/eb57b13e0fdb5ddfdae39697bdd14895/image.png)
CiviCRM 5.10.4
CMS - Drupal - 7
Steps
1) Configure IPN Payment processor
![image](/uploads/3c103603e49d10001296dbfd2229fadc/image.png)
2) Register the event
![image](/uploads/2ac513a52dcba0dbdf5cd097f7f139c7/image.png)
3) Confirm the registration
![image](/uploads/4f25367935bf0c44972981c10bc0101c/image.png)
4) Click browser back button
![image](/uploads/e7bf60903a6ce91b73500ec4c371726e/image.png)
5) Click Go Back button
![image](/uploads/c42e4286e1078ed17a5ca7d2c315c275/image.png)
6) Again continue & confirm the registration
![image](/uploads/1fb4990faffce58bf0e3d8b79475bfb1/image.png)
7) Now we will have 2 contribution against one participant record [ one completed , one pending incomplete]
![image](/uploads/cb5f1873af5f5b84162ce30a74a556fe/image.png)
8) we will receive the "cancelled" notification from payment processor few minutes later [ The Transaction timed-out.]
To reproduce this step we can manually cancel the Pending incomplete transaction contribution
![image](/uploads/85c7bac67c5d4ee6c39d5d85ff8028a9/image.png)
9) Now event registration will be cancelled
![image](/uploads/7a3a52dfc4b400acf09e1be95b9f8bc1/image.png)https://lab.civicrm.org/dev/core/-/issues/759Mail log confusing - looks like emails are being sent with 2 "To" headers2022-10-05T05:03:35ZkenMail log confusing - looks like emails are being sent with 2 "To" headersIn 5.10.4, the mail log is confusing. It makes it look like the email has 2 "To" headers.
Here's a redacted example ...
**To: donor@example.com**
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="=_xxxxxxxxxxxxx"
Fr...In 5.10.4, the mail log is confusing. It makes it look like the email has 2 "To" headers.
Here's a redacted example ...
**To: donor@example.com**
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="=_xxxxxxxxxxxxx"
From: Us <us@example.com>
**To: Donor Name <donor@example.com>**
Subject: Receipt - Donating via credit card
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
Return-Path: us@example.com
Date: Wed, 27 Feb 2019 09:07:39 +1100
Message-ID: <civicrm_xxxxx.xxxx@example.com>https://lab.civicrm.org/dev/core/-/issues/750The following PHP variables are not set: $_SERVER[HTTP_HOST]2023-04-11T05:03:21ZYepaThe following PHP variables are not set: $_SERVER[HTTP_HOST]### The error
```drush updb
[error] The following PHP variables are not set: $_SERVER[HTTP_HOST]
Requirements check reports errors. Do you wish to continue? (yes/no) [yes]:
```
### Steps to reproduce
* Launch the command ```drush u...### The error
```drush updb
[error] The following PHP variables are not set: $_SERVER[HTTP_HOST]
Requirements check reports errors. Do you wish to continue? (yes/no) [yes]:
```
### Steps to reproduce
* Launch the command ```drush updb```
### Versions
* Drupal : 8.6.10
* Drush : 9.5.2
* CiviCRM : 5.10.3
### Related to
* https://github.com/drush-ops/drush/issues/3562https://lab.civicrm.org/dev/core/-/issues/743Case report showing 1 result2019-05-25T06:06:01ZDevAppCase report showing 1 resultAs of 5.10.2 the case summary report joins with relationships.
`
SELECT SQL_CALC_FOUND_ROWS c2_civireport.sort_name as civicrm_c2_client_name, c2_civireport.id as civicrm_c2_id, case_civireport.id as civicrm_case_id, case_civireport.subj...As of 5.10.2 the case summary report joins with relationships.
`
SELECT SQL_CALC_FOUND_ROWS c2_civireport.sort_name as civicrm_c2_client_name, c2_civireport.id as civicrm_c2_id, case_civireport.id as civicrm_case_id, case_civireport.subject as civicrm_case_subject, case_civireport.status_id as civicrm_case_status_id, case_civireport.case_type_id as civicrm_case_case_type_id, case_civireport.start_date as civicrm_case_start_date, case_civireport.end_date as civicrm_case_end_date
FROM civicrm_contact contact_civireport
inner join civicrm_relationship relationship_civireport on contact_civireport.id = relationship_civireport.contact_id_b
inner join civicrm_case case_civireport on case_civireport.id = relationship_civireport.case_id
inner join civicrm_relationship_type relationship_type_civireport on relationship_type_civireport.id=relationship_civireport.relationship_type_id
inner join civicrm_case_contact case_contact_civireport on case_contact_civireport.case_id = case_civireport.id
inner join civicrm_contact c2_civireport on c2_civireport.id=case_contact_civireport.contact_id
WHERE case_civireport.case_type_id REGEXP '[[:cntrl:]]*29[[:cntrl:]]*' AND ( case_civireport.is_deleted = 0 )
ORDER BY c2_civireport.sort_name ASC
LIMIT 0, 50
`
This only returns 1 result on a client's case summary report. Performing a Find Case returns 400+ results.
Reverting to an earlier version of the report fixes the issue:
`
SELECT SQL_CALC_FOUND_ROWS c2_civireport.sort_name as civicrm_c2_client_name, c2_civireport.id as civicrm_c2_id, case_civireport.id as civicrm_case_id, case_civireport.subject as civicrm_case_subject, case_civireport.status_id as civicrm_case_status_id, case_civireport.case_type_id as civicrm_case_case_type_id, case_civireport.start_date as civicrm_case_start_date, case_civireport.end_date as civicrm_case_end_date
FROM civicrm_case case_civireport
inner join civicrm_case_contact case_contact_civireport on case_contact_civireport.case_id = case_civireport.id
inner join civicrm_contact c2_civireport on c2_civireport.id=case_contact_civireport.contact_id
WHERE case_civireport.case_type_id REGEXP '[[:cntrl:]]*29[[:cntrl:]]*' AND ( case_civireport.status_id IN (1) )
LIMIT 0, 50
`
It appears the case summary report has changed to support relationships.
Checking the civicrm_relationship for a case ID that is valid, there isn't a case_id present for that case. Ideally this report should not be dependent (INNER JOIN) for a relationship existing and should begin withh the civicrm_case table.5.15.0https://lab.civicrm.org/dev/core/-/issues/738Adding Sub-Options of Custom Data2019-02-19T10:11:39ZGhost UserAdding Sub-Options of Custom DataHello.
Maybe I didn't know, but I didn't know.
I need to add a sub-option to private recipients. I can explain this with an example.
Suppose you have an option. When I make a choice here, there must be sub-options that are optional in...Hello.
Maybe I didn't know, but I didn't know.
I need to add a sub-option to private recipients. I can explain this with an example.
Suppose you have an option. When I make a choice here, there must be sub-options that are optional in this option.
In the meantime, there is City / County option, but when I choose the province does not come from the county information. (For Turkey)
1. Receiving
a. White Apple
b. Green apple
c. Red Apple
2. Pear
a. White Pear
b. Green Pear
c. Red Pear
Joomla 3.9.3
CiviCRM 5.10.2!
![001275](/uploads/240b66db42d115a9fc5308fd1527bfed/001275.png)https://lab.civicrm.org/dev/core/-/issues/733Validation radio custom fields on civicrm_validateForm hook does not work2022-10-04T05:03:30ZscardiniusValidation radio custom fields on civicrm_validateForm hook does not workI have a custom field to contact in radio type format, not required field.
I'd like to set up custom error on this empty field by using validateForm but `$fields` array doesn't contain a key for this custom field. After setting `$error...I have a custom field to contact in radio type format, not required field.
I'd like to set up custom error on this empty field by using validateForm but `$fields` array doesn't contain a key for this custom field. After setting `$error['custom_xx']` the form is reloaded without displaying the error.
The question is why for Radio type of custom field there is no a key in $fields array?
PS. Related to creating new contact and editing existing contact.https://lab.civicrm.org/dev/translation/-/issues/20DB Error: no such table when executing schedule jobs2022-11-07T18:05:35ZYepaDB Error: no such table when executing schedule jobsWe've a single language installation with CiviCRM 5.6.1 & Drupal 7
After we've enabled the "Multiple Language" option under "Multiple Languages Support" section in the config page:
https://www.domain.org/civicrm/admin/setting/localiz...We've a single language installation with CiviCRM 5.6.1 & Drupal 7
After we've enabled the "Multiple Language" option under "Multiple Languages Support" section in the config page:
https://www.domain.org/civicrm/admin/setting/localization?reset=1
If we prepare a mailing with a language different from the language interface, when we execute the schedule jobs, we have the following error:
```
Feb 14 18:17:32 [info] $Fatal Error Details = Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)
[code] => -18
[message] => DB Error: no such table
[mode] => 16
[debug_info] => select id, extends, extends_entity_column_value, style from civicrm_custom_group__en_US where is_active = 1 [nativecode=1146 ** Table 'drupal.civicrm_custom_group__en_US' doesn't exist]
[type] => DB_Error
[user_info] => select id, extends, extends_entity_column_value, style from civicrm_custom_group__en_US where is_active = 1 [nativecode=1146 ** Table 'drupal.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, extends, extends_entity_column_value, style from civicrm_custom_group__en_US where is_activ$
)
Feb 14 18:17:32 [info] $backTrace = #0 /var/www/drupal/public_html/sites/all/modules/civicrm/CRM/Core/Error.php(232): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 /var/www/drupal/public_html/sites/all/modules/civicrm/packages/PEAR.php(921): call_user_func((Array:2), Object(DB_Error))
#3 /var/www/drupal/public_html/sites/all/modules/civicrm/packages/DB.php(985): PEAR_Error->__construct("DB Error: no such table", -18, 16, (Array:2), "select id, extends, extends_entity_column_value, style from civicrm_custom_gr...")
#4 /var/www/drupal/public_html/sites/all/modules/civicrm/packages/PEAR.php(575): DB_Error->__construct(-18, 16, (Array:2), "select id, extends, extends_entity_column_value, style from civicrm_custom_gr...")
#5 [internal function](): PEAR->_raiseError(Object(DB_mysqli), NULL, -18, NULL, NULL, "select id, extends, extends_entity_column_value, style from civicrm_custom_gr...", "DB_Error", TRUE)
#6 /var/www/drupal/public_html/sites/all/modules/civicrm/packages/PEAR.php(224): call_user_func_array((Array:2), (Array:8))
#7 /var/www/drupal/public_html/sites/all/modules/civicrm/packages/DB/common.php(1907): PEAR->__call("raiseError", (Array:7))
#8 /var/www/drupal/public_html/sites/all/modules/civicrm/packages/DB/common.php(1907): PEAR->raiseError(NULL, -18, NULL, NULL, "select id, extends, extends_entity_column_value, style from civicrm_custom_gr...", "DB_Error", TRUE)
#9 /var/www/drupal/public_html/sites/all/modules/civicrm/packages/DB/mysqli.php(933): DB_common->raiseError(-18, NULL, NULL, NULL, "1146 ** Table 'drupal.civicrm_custom_group__en_US' doesn't exist")
#10 /var/www/drupal/public_html/sites/all/modules/civicrm/packages/DB/mysqli.php(403): DB_mysqli->mysqliRaiseError()
#11 /var/www/drupal/public_html/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysqli->simpleQuery("select id, extends, extends_entity_column_value, style from civicrm_custom_gr...")
#12 /var/www/drupal/public_html/sites/all/modules/civicrm/packages/DB/DataObject.php(2415): DB_common->query("select id, extends, extends_entity_column_value, style from civicrm_custom_gr...")
#13 /var/www/drupal/public_html/sites/all/modules/civicrm/packages/DB/DataObject.php(1607): DB_DataObject->_query("select id, extends, extends_entity_column_value, style from civicrm_custom_gr...")
#14 /var/www/drupal/public_html/sites/all/modules/civicrm/CRM/Core/DAO.php(438): DB_DataObject->query("select id, extends, extends_entity_column_value, style from civicrm_custom_gr...")
#15 /var/www/drupal/public_html/sites/all/modules/civicrm/CRM/Core/DAO.php(1411): CRM_Core_DAO->query("select id, extends, extends_entity_column_value, style from civicrm_custom_gr...", TRUE)
#16 /var/www/drupal/public_html/sites/all/modules/civicrm/drupal/modules/views/components/civicrm.core.inc(3119): CRM_Core_DAO::executeQuery("select id, extends, extends_entity_column_value, style from civicrm_custom_gr...")
#17 /var/www/drupal/public_html/sites/all/modules/civicrm/drupal/modules/views/civicrm.views.inc(87): _civicrm_core_data((Array:301), (Array:8))
#18 /var/www/drupal/public_html/sites/all/modules/contrib/views/includes/cache.inc(93): civicrm_views_data_alter((Array:301))
#19 /var/www/drupal/public_html/sites/all/modules/contrib/views/includes/cache.inc(37): _views_fetch_data_build()
#20 /var/www/drupal/public_html/sites/all/modules/contrib/views/views.module(1319): _views_fetch_data("twitter", FALSE, FALSE)
#21 /var/www/drupal/public_html/sites/all/modules/contrib/views/views.module(1655): views_fetch_data("twitter", FALSE)
#22 /var/www/drupal/public_html/sites/all/modules/contrib/views/includes/view.inc(277): views_move_table("twitter")
#23 /var/www/drupal/public_html/sites/all/modules/contrib/views/views.module(1643): view->update()
#24 /var/www/drupal/public_html/sites/all/modules/contrib/views/views.module(762): views_get_view("tweets")
#25 [internal function](): views_block_view("tweets-block")
#26 /var/www/drupal/public_html/includes/module.inc(934): call_user_func_array("views_block_view", (Array:1))
#27 /var/www/drupal/public_html/modules/block/block.module(911): module_invoke("views", "block_view", "tweets-block")
#28 /var/www/drupal/public_html/modules/block/block.module(690): _block_render_blocks((Array:1))
#29 /var/www/drupal/public_html/modules/block/block.module(319): block_list("footer3")
#30 /var/www/drupal/public_html/modules/block/block.module(270): block_get_blocks_by_region("footer3")
#31 /var/www/drupal/public_html/includes/common.inc(5914): block_page_build((Array:11))
#32 /var/www/drupal/public_html/includes/common.inc(2761): drupal_render_page("\n<div id=\"crm-container\" class=\"crm-container\" lang=\"en\" xml:lang=\"en...")
#33 /var/www/drupal/public_html/includes/common.inc(2634): drupal_deliver_html_page("\n<div id=\"crm-container\" class=\"crm-container\" lang=\"en\" xml:lang=\"en...")
#34 /var/www/drupal/public_html/includes/menu.inc(542): drupal_deliver_page("\n<div id=\"crm-container\" class=\"crm-container\" lang=\"en\" xml:lang=\"en...", "")
#35 /var/www/drupal/public_html/index.php(21): menu_execute_active_handler()
#36 {main}
```
The global $dbLocale is equal to '__en_US' because it's not correctly set in the public function setLocale($locale) of i18n.php. The $locale is equal to '_en_US' when the fatal error occurred.
```
/**
* Change the processing language without changing the current user language
*
* @param $locale
* Locale (for example 'en_US', or 'fr_CA').
* True if the domain was changed for an extension.
*/
public function setLocale($locale) {
// Change the language of the CMS as well, for URLs.
CRM_Utils_System::setUFLocale($locale);
// change the gettext ressources
if ($this->_nativegettext) {
$this->setNativeGettextLocale($locale);
}
else {
// phpgettext
$this->setPhpGettextLocale($locale);
}
// for sql queries
global $dbLocale;
$dbLocale = "_{$locale}";
}
```
"inherit locale" option is enabled and no cache error.
Here is the backtrace from setLocale function: [locale_not_well_set_error.txt](/uploads/29d6263e244abc1d0973ff4679463615/locale_not_well_set_error.txt)
I tried without sendgrid extension, the error was the same.