Development issueshttps://lab.civicrm.org/groups/dev/-/issues2019-09-09T22:30:13Zhttps://lab.civicrm.org/dev/core/-/issues/1190File attachment uploads - pptx issue2019-09-09T22:30:13ZgibsonoliverFile attachment uploads - pptx issueHi
When you upload any .pptx files, say as an Activity attachment, these are saved with file extension .unknown.
This seems to be a file type bug. Files with the .ppt extension are fine.
Tested on 5.13.4Hi
When you upload any .pptx files, say as an Activity attachment, these are saved with file extension .unknown.
This seems to be a file type bug. Files with the .ppt extension are fine.
Tested on 5.13.45.17.1https://lab.civicrm.org/dev/drupal/-/issues/82Event custom fields available in views but do not show2019-09-02T08:47:28Zmagnolia61Event custom fields available in views but do not showUsing drupal 7 and a view with participants.<BR>
I have some custom fields set up on the event<BR>
Using a relation to "CiviCRM Participants: Event ID" I am able to select those as fields in my view.<BR>
So far so good, but their values ...Using drupal 7 and a view with participants.<BR>
I have some custom fields set up on the event<BR>
Using a relation to "CiviCRM Participants: Event ID" I am able to select those as fields in my view.<BR>
So far so good, but their values do not show up.<BR>
<BR>
What could be wrong here? Would this be a bug or isn't this even supposed to work?https://lab.civicrm.org/dev/core/-/issues/1192ENOTICE when creating activity from contact search results / aka Repeat Activ...2019-08-20T01:12:34ZDaveDENOTICE when creating activity from contact search results / aka Repeat Activity accordion section missing when using Add Activity from contact search resultsI'm not sure which one is the actual bug: Is it intentional that you can't create a repeating activity in this situation, in which case the bug is just the ENOTICE, or is it that it was an oversight and you are supposed to be able to cre...I'm not sure which one is the actual bug: Is it intentional that you can't create a repeating activity in this situation, in which case the bug is just the ENOTICE, or is it that it was an oversight and you are supposed to be able to create repeat activities?
The first one is easier/safer to fix, and is just [here](https://github.com/civicrm/civicrm-core/blob/5.16.2/CRM/Core/Form/RecurringEntity.php#L346). The second one seems to be coming from [here](https://github.com/civicrm/civicrm-core/blob/5.16.2/CRM/Activity/Form/Activity.php#L679), because `$this->_action` is actually `CRM_Core_Action::BASIC` in this situation, but might be more complex than just updating that line because recurring activities can be tricky, so might have been left out on purpose.
To clarify what I'm talking about:
1. Do a contact search.
1. Select a couple contacts or all.
1. From the actions dropdown choose "Add Activity".
1. On the resulting activity form there isn't the usual "Repeat Activity" section.
1. If you keep going and save you get the notice `Undefined index: allowRepeatConfigToSubmit in CRM_Core_Form_RecurringEntity::postProcess() (line 346 of /.../web/sites/all/modules/civicrm/CRM/Core/Form/RecurringEntity.php`5.18.0https://lab.civicrm.org/dev/core/-/issues/1193DB Error: no such field when printing event participant name badges from a so...2022-12-08T05:03:18ZjensschuppeDB Error: no such field when printing event participant name badges from a sorted search resultHow to reproduce (on dmaster):
1. Search for event participants
2. Select participants
3. Sort by e.g. participant status, fee level, role
4. Select action "Print name badges"
CiviCRM crashes with "DB Error: no such field", precise...How to reproduce (on dmaster):
1. Search for event participants
2. Select participants
3. Sort by e.g. participant status, fee level, role
4. Select action "Print name badges"
CiviCRM crashes with "DB Error: no such field", precisely `Unknown column 'participant_status' in 'order clause'`.
This may be related to #729.https://lab.civicrm.org/dev/core/-/issues/1194Update civicrm-drupal and civicrm-wordpress tests for PHPUnit 6 compatibility2019-12-25T02:53:33ZtottenUpdate civicrm-drupal and civicrm-wordpress tests for PHPUnit 6 compatibilityThe test suites within civicrm-{drupal,wordpress}.git are not compatible with PHPUnit 6+. This is because they use the base class `\PHPUnit_Framework_TestCase`, which was deprecated phpunit5 and removed in phpunit6.
The equivalent clas...The test suites within civicrm-{drupal,wordpress}.git are not compatible with PHPUnit 6+. This is because they use the base class `\PHPUnit_Framework_TestCase`, which was deprecated phpunit5 and removed in phpunit6.
The equivalent class in phpunit5+ is `\PHPUnit\Framework\TestCase`.5.22.0seamusleeseamusleehttps://lab.civicrm.org/dev/drupal/-/issues/83Drupal8 user creation failed due to CiviCRM qf key validation2020-04-15T06:54:15ZsunilDrupal8 user creation failed due to CiviCRM qf key validationCiviCRM 5.13.6 version breaks the user registration process on Drupal 8.
Error type: Could not find a valid session key.
```
[info] $backTrace = #0 /server_path/vendor/civicrm/civicrm-core/CRM/Core/Error.php(381): CRM_Core_Error::back...CiviCRM 5.13.6 version breaks the user registration process on Drupal 8.
Error type: Could not find a valid session key.
```
[info] $backTrace = #0 /server_path/vendor/civicrm/civicrm-core/CRM/Core/Error.php(381): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /server_path/vendor/civicrm/civicrm-core/CRM/Core/Controller.php(833): CRM_Core_Error::fatal("We can't load the requested web page. This page requires cookies to be enable...")
#2 /server_path/vendor/civicrm/civicrm-core/CRM/Core/Controller.php(828): CRM_Core_Controller->invalidKeyCommon()
#3 /server_path/vendor/civicrm/civicrm-core/CRM/Core/Controller.php(312): CRM_Core_Controller->invalidKey()
#4 /server_path/vendor/civicrm/civicrm-core/CRM/Core/Controller.php(204): CRM_Core_Controller->key("CRM_Profile_Form_Dynamic", TRUE, FALSE)
#5 /server_path/vendor/civicrm/civicrm-core/CRM/Core/Controller/Simple.php(66): CRM_Core_Controller->__construct("Dynamic Form Creator", TRUE, NULL, "CRM_Profile_Form_Dynamic", TRUE, FALSE)
#6 /server_path/vendor/civicrm/civicrm-core/CRM/Core/BAO/UFGroup.php(834): CRM_Core_Controller_Simple->__construct("CRM_Profile_Form_Dynamic", "Dynamic Form Creator", NULL)
#7 /server_path/docroot/modules/contrib/civicrm/civicrm.module(265): CRM_Core_BAO_UFGroup::getEditHTML(NULL, "", NULL, TRUE, TRUE, NULL, FALSE, "Individual")
#8 /server_path/docroot/core/lib/Drupal/Core/Extension/ModuleHandler.php(539): civicrm_form_user_register_form_alter((Array:26), Object(Drupal\Core\Form\FormState), "user_register_form")
#9 /server_path/docroot/core/lib/Drupal/Core/Form/FormBuilder.php(834): Drupal\Core\Extension\ModuleHandler->alter("form", (Array:26), Object(Drupal\Core\Form\FormState), "user_register_form")
#10 /server_path/docroot/core/lib/Drupal/Core/Form/FormBuilder.php(276): Drupal\Core\Form\FormBuilder->prepareForm("user_register_form", (Array:26), Object(Drupal\Core\Form\FormState))
#11 /server_path/docroot/core/lib/Drupal/Core/Controller/FormController.php(93): Drupal\Core\Form\FormBuilder->buildForm("user_register_form", Object(Drupal\Core\Form\FormState))
#12 [internal function](): Drupal\Core\Controller\FormController->getContentResult(Object(Symfony\Component\HttpFoundation\Request), Object(Drupal\Core\Routing\RouteMatch))
#13 /server_path/docroot/core/lib/Drupal/Core/EventSubscriber/EarlyRenderingControllerWrapperSubscriber.php(123): call_user_func_array((Array:2), (Array:2))
#14 /server_path/docroot/core/lib/Drupal/Core/Render/Renderer.php(582): Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}()
#15 /server_path/docroot/core/lib/Drupal/Core/EventSubscriber/EarlyRenderingControllerWrapperSubscriber.php(124): Drupal\Core\Render\Renderer->executeInRenderContext(Object(Drupal\Core\Render\RenderContext), Object(Closure))
#16 /server_path/docroot/core/lib/Drupal/Core/EventSubscriber/EarlyRenderingControllerWrapperSubscriber.php(97): Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->wrapControllerExecutionInRenderContext((Array:2), (Array:2))
#17 /server_path/vendor/symfony/http-kernel/HttpKernel.php(151): Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}()
#18 /server_path/vendor/symfony/http-kernel/HttpKernel.php(68): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(Symfony\Component\HttpFoundation\Request), 1)
#19 /server_path/docroot/core/lib/Drupal/Core/StackMiddleware/Session.php(57): Symfony\Component\HttpKernel\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, TRUE)
#20 /server_path/docroot/core/lib/Drupal/Core/StackMiddleware/KernelPreHandle.php(47): Drupal\Core\StackMiddleware\Session->handle(Object(Symfony\Component\HttpFoundation\Request), 1, TRUE)
#21 /server_path/docroot/core/modules/page_cache/src/StackMiddleware/PageCache.php(99): Drupal\Core\StackMiddleware\KernelPreHandle->handle(Object(Symfony\Component\HttpFoundation\Request), 1, TRUE)
#22 /server_path/docroot/core/modules/page_cache/src/StackMiddleware/PageCache.php(78): Drupal\page_cache\StackMiddleware\PageCache->pass(Object(Symfony\Component\HttpFoundation\Request), 1, TRUE)
#23 /server_path/docroot/core/modules/ban/src/BanMiddleware.php(50): Drupal\page_cache\StackMiddleware\PageCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, TRUE)
#24 /server_path/docroot/core/lib/Drupal/Core/StackMiddleware/ReverseProxyMiddleware.php(47): Drupal\ban\BanMiddleware->handle(Object(Symfony\Component\HttpFoundation\Request), 1, TRUE)
#25 /server_path/docroot/core/lib/Drupal/Core/StackMiddleware/NegotiationMiddleware.php(52): Drupal\Core\StackMiddleware\ReverseProxyMiddleware->handle(Object(Symfony\Component\HttpFoundation\Request), 1, TRUE)
#26 /server_path/vendor/stack/builder/src/Stack/StackedHttpKernel.php(23): Drupal\Core\StackMiddleware\NegotiationMiddleware->handle(Object(Symfony\Component\HttpFoundation\Request), 1, TRUE)
#27 /server_path/docroot/core/lib/Drupal/Core/DrupalKernel.php(693): Stack\StackedHttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, TRUE)
#28 /server_path/docroot/index.php(19): Drupal\Core\DrupalKernel->handle(Object(Symfony\Component\HttpFoundation\Request))
#29 {main}
```
After comparing drupal 7 and drupal 8 module files, i found one the config setting is missing in drupal 8 module.
We need to set keyDisable = TRUE , this will skip Quick form key validation process.
```
--- a/modules/contrib/civicrm/civicrm.module
+++ b/modules/contrib/civicrm/civicrm.module
@@ -251,6 +251,7 @@ function _civicrm_get_profiles($contact_id) {
function civicrm_form_user_register_form_alter(&$form, &$form_state, $form_id) {
$civicrm = \Drupal::service('civicrm');
$civicrm->initialize();
+ CRM_Core_Config::singleton()->keyDisable = TRUE; // to skip quickform key validation
$html = \CRM_Core_BAO_UFGroup::getEditHTML(NULL, '', NULL, TRUE, TRUE, NULL, FALSE, $civicrm->getCtype());
// Need to disable the page cache.
@@ -273,6 +274,7 @@ function civicrm_form_user_register_form_alter(&$form, &$form_state, $form_id) {
*/
function _civicrm_user_register_form_validate(&$form, FormStateInterface $form_state) {
\Drupal::service('civicrm')->initialize();
+ CRM_Core_Config::singleton()->keyDisable = TRUE;
$errors = CRM_Core_BAO_UFGroup::isValid(NULL, '', TRUE);
if (is_array($errors)) {
```
https://github.com/civicrm/civicrm-drupal-8/pull/275.18.0https://lab.civicrm.org/dev/core/-/issues/1196CRM_Utils_Array::crmInArray() should recurse properly2019-08-21T16:39:07ZhaystackCRM_Utils_Array::crmInArray() should recurse properlySeems that there's a minor error in `CRM_Utils_Array::crmInArray()` where the method is [called in global scope](https://lab.civicrm.org/dev/core/blob/master/CRM/Utils/Array.php#L378) instead of with `self::crmInArray()`. PR to follow.Seems that there's a minor error in `CRM_Utils_Array::crmInArray()` where the method is [called in global scope](https://lab.civicrm.org/dev/core/blob/master/CRM/Utils/Array.php#L378) instead of with `self::crmInArray()`. PR to follow.haystackhaystackhttps://lab.civicrm.org/dev/core/-/issues/1198Unable to view completed mailing if mailing hash enabled2019-08-22T01:00:07ZlcdwebUnable to view completed mailing if mailing hash enabledTo reproduce:
1. go to CiviMail > CiviMail Component Settings
2. select option for Hashed Mailing URL's
3. create and send a mailing
4. go to a contact who has received the mailing, click the Mailings tab, and View the mailing
The prev...To reproduce:
1. go to CiviMail > CiviMail Component Settings
2. select option for Hashed Mailing URL's
3. create and send a mailing
4. go to a contact who has received the mailing, click the Mailings tab, and View the mailing
The preview is handled through the API and expects the Mailing ID to be the actual mailing table ID. If hashed ID's is enabled, it fails the variable type validation check.lcdweblcdwebhttps://lab.civicrm.org/dev/core/-/issues/1199No permission to add cases because permission check will always return 0 when...2019-08-25T13:14:48ZErikHommelNo permission to add cases because permission check will always return 0 when I have no casesI have enabled the CiviCase component. When trying to add a case I get the message "You do not have permission to access this case." Correct, I remember....I have to add the Case permissions in my CMS. After doing this, I continue to get...I have enabled the CiviCase component. When trying to add a case I get the message "You do not have permission to access this case." Correct, I remember....I have to add the Case permissions in my CMS. After doing this, I continue to get the message "You do not have permission to access this case." even though I also get the message "Case succesfully added".
Inspecting the code the permission is checked in CRM_Case_Form_CaseView:
```` php
// Access check.
if (!CRM_Case_BAO_Case::accessCase($this->_caseID, FALSE)) {
CRM_Core_Error::statusBounce(ts('You do not have permission to access this case.'));
}
````
The called function CRM_Case_BAO_Case::accessCase will always return 0 (meaning FALSE) whenever I have no cases in my database yet:
```` php
try {
return (bool) civicrm_api3('Case', 'getcount', $params);
}
catch (CiviCRM_API3_Exception $e) {
// Lack of permissions will throw an exception
return FALSE;
}
````
So it seems that I can never add a case if I have no cases yet, or am I missing something?
This is on CiviCRM 5.16.2https://lab.civicrm.org/dev/core/-/issues/1200CiviCRM Dashboard does not respect multiple domains2019-10-09T13:54:34ZhaystackCiviCRM Dashboard does not respect multiple domainsWhen I create a new Domain (conveniently done via the API as provided by the `org.civicrm.multisite` Extension but not limited to that method, the same happens when this is done manually) I have noticed a couple of problems:
1. When I v...When I create a new Domain (conveniently done via the API as provided by the `org.civicrm.multisite` Extension but not limited to that method, the same happens when this is done manually) I have noticed a couple of problems:
1. When I visit the CiviCRM Dashboard, I see duplicate Dashlets (FYI "Call Next" is mine):
![civicrm-duplicate-dashlets](/uploads/b17c00208f74665e341977179938fbf5/civicrm-duplicate-dashlets.png)
2. When I try to create a new Dashlet on the new Domain:
```php
$params = array(
'domain_id' => CRM_Core_Config::domainID(),
'name' => 'blah',
'label' => E::ts( 'Blah' ),
'url' => 'civicrm/blah',
'fullscreen_url' => 'civicrm/blah?context=dashletFullscreen',
'permission' => 'access CiviCRM',
'is_active' => 1,
'cache_minutes' => 1,
);
// Create dashlet.
$dashlet = civicrm_api3( 'Dashboard', 'create', $params );
```
What happens with the above code is that the API updates the existing Dashlet with the new `domain_id` instead of creating a new Dashlet for that Domain.
The result of this is that it's impossible for a Contact to have different Dashlets per Domain.
PR to follow.5.18.0haystackhaystackhttps://lab.civicrm.org/dev/core/-/issues/1201Offline event confirmation email does not respect public flag2023-01-26T05:03:54ZyashodhaOffline event confirmation email does not respect public flagOffline event confirmation email does not contain the ical downloadable file for public event. This works well for online event confirmation email.
*Online event confirmation email*
![online](/uploads/8dddcfa42691c91a5ab91593be7813cf/...Offline event confirmation email does not contain the ical downloadable file for public event. This works well for online event confirmation email.
*Online event confirmation email*
![online](/uploads/8dddcfa42691c91a5ab91593be7813cf/online.png)
*Offline event confirmation email*
![offline](/uploads/f6e0a6146f0d5b073d95c67829b75d4a/offline.png)yashodhayashodhahttps://lab.civicrm.org/dev/core/-/issues/3376Add event with template fails on custom fields2022-04-22T16:22:08ZMartinAdd event with template fails on custom fieldsIssue seen on 5.16.2 (drupal 7) and confirmed on dmaster (5.18.alpha1). Steps to reproduce:
1. Create a custom group for Event with 1 or more fields that are set as required.
1. Create a new event template, including with custom field ...Issue seen on 5.16.2 (drupal 7) and confirmed on dmaster (5.18.alpha1). Steps to reproduce:
1. Create a custom group for Event with 1 or more fields that are set as required.
1. Create a new event template, including with custom field values entered.
1. Go to add a new event, and choose your template, then click "continue". Result: Error message with "Please correct the following errors in the form fields below: [Custom field] is a required field."
When looking at the page source in more detail, you can see the following difference:
* Normal "add event" page uses the following value for the custom field's input element id and name: *[field id]_-1*
* After selecting a template, "add event" page uses the following value for the custom field's input element id and name: *[field id]_[some positive number]*
For example: custom_26_-1 (before), versus custom_26_32 (after).
If I modify the input element id, name, and the class of the parent tr element (maybe that's not needed?) to go back to the original value (like *custom_26_-1*), the form then submits properly.https://lab.civicrm.org/dev/financial/-/issues/66[regression] Thank-you date is lost on editing contributions2019-08-28T05:12:40ZJonGold[regression] Thank-you date is lost on editing contributionsA rather serious regression which IMO merits an out-of-band release.
**To replicate**
* Open a contribution for editing that has a thank-you date.
That's it. The page loads without the contribution date, and so it's lost on save.
Thi...A rather serious regression which IMO merits an out-of-band release.
**To replicate**
* Open a contribution for editing that has a thank-you date.
That's it. The page loads without the contribution date, and so it's lost on save.
This was introduced by https://github.com/civicrm/civicrm-core/commit/b4e8c2b4c3f3730a7193824dfb6452b86d5e31d7 which shipped with 5.16.0.
My quick fix is just to revert it, but others, particularly @pfigel, may want to chime in.5.16.3JonGoldJonGoldhttps://lab.civicrm.org/dev/core/-/issues/1202Network error when paging contacts search pages or modifying rows per page2019-09-09T13:41:18ZalbionbrownNetwork error when paging contacts search pages or modifying rows per pageA network error appears when searching through pages of contacts or changing the amount of rows per page.
To recreate, search for contacts where more than page of results will be returned and click through to subsequent pages. I've foun...A network error appears when searching through pages of contacts or changing the amount of rows per page.
To recreate, search for contacts where more than page of results will be returned and click through to subsequent pages. I've found the same error occurs when I try to change the amount of results to be displayed per page.
I've narrowed the error down to a SQL error that is sourced from the CRM_Contact_Form_Search_Advance::handle().
I've attached a screen grab of the callstack all the way up to where it's about to execute the query.
![Screenshot_2019-08-22_at_18.21.56](/uploads/245ce23ffa0c941de6219aceec6a9218/Screenshot_2019-08-22_at_18.21.56.png)
MySQL returns this error message:
> Expression #37 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'civicrm.civicrm_address.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Here is the generated SQL query which contains the syntax error. It's worth noting that I'm using MySQL Ver 14.14 Distrib 5.7.24.
`SELECT contact_a.id as contact_id, contact_a.contact_type as `contact_type`, contact_a.contact_sub_type as `contact_sub_type`, contact_a.sort_name as `sort_name`, contact_a.display_name as `display_name`, contact_a.do_not_email as `do_not_email`, contact_a.do_not_phone as `do_not_phone`, contact_a.do_not_mail as `do_not_mail`, contact_a.do_not_sms as `do_not_sms`, contact_a.do_not_trade as `do_not_trade`, contact_a.is_opt_out as `is_opt_out`, contact_a.legal_identifier as `legal_identifier`, contact_a.external_identifier as `external_identifier`, contact_a.nick_name as `nick_name`, contact_a.legal_name as `legal_name`, contact_a.image_URL as `image_URL`, contact_a.preferred_communication_method as `preferred_communication_method`, contact_a.preferred_language as `preferred_language`, contact_a.preferred_mail_format as `preferred_mail_format`, contact_a.first_name as `first_name`, contact_a.middle_name as `middle_name`, contact_a.last_name as `last_name`, contact_a.prefix_id as `prefix_id`, contact_a.suffix_id as `suffix_id`, contact_a.formal_title as `formal_title`, contact_a.communication_style_id as `communication_style_id`, contact_a.job_title as `job_title`, contact_a.gender_id as `gender_id`, contact_a.birth_date as `birth_date`, contact_a.is_deceased as `is_deceased`, contact_a.deceased_date as `deceased_date`, contact_a.household_name as `household_name`, IF ( contact_a.contact_type = 'Individual', NULL, contact_a.organization_name ) as organization_name, contact_a.sic_code as `sic_code`, contact_a.is_deleted as `contact_is_deleted`, IF ( contact_a.contact_type = 'Individual', contact_a.organization_name, NULL ) as current_employer, civicrm_address.id as address_id, civicrm_address.street_address as `street_address`, civicrm_address.supplemental_address_1 as `supplemental_address_1`, civicrm_address.supplemental_address_2 as `supplemental_address_2`, civicrm_address.supplemental_address_3 as `supplemental_address_3`, civicrm_address.city as `city`, civicrm_address.postal_code_suffix as `postal_code_suffix`, civicrm_address.postal_code as `postal_code`, civicrm_address.geo_code_1 as `geo_code_1`, civicrm_address.geo_code_2 as `geo_code_2`, civicrm_address.state_province_id as state_province_id, civicrm_address.country_id as country_id, civicrm_phone.id as phone_id, civicrm_phone.phone_type_id as phone_type_id, civicrm_phone.phone as `phone`, civicrm_email.id as email_id, civicrm_email.email as `email`, civicrm_email.on_hold as `on_hold`, civicrm_im.id as im_id, civicrm_im.provider_id as provider_id, civicrm_im.name as `im`, civicrm_worldregion.id as worldregion_id, civicrm_worldregion.name as `world_region`, (CASE
WHEN contact_a.id = 20504 THEN 0
WHEN contact_a.id = 59412 THEN 1
WHEN contact_a.id = 35293 THEN 2
WHEN contact_a.id = 23486 THEN 3
WHEN contact_a.id = 15853 THEN 4
WHEN contact_a.id = 15637 THEN 5
WHEN contact_a.id = 13515 THEN 6
WHEN contact_a.id = 22624 THEN 7
WHEN contact_a.id = 29033 THEN 8
WHEN contact_a.id = 19796 THEN 9
WHEN contact_a.id = 15758 THEN 10
WHEN contact_a.id = 32061 THEN 11
WHEN contact_a.id = 20846 THEN 12
WHEN contact_a.id = 57645 THEN 13
WHEN contact_a.id = 13327 THEN 14
WHEN contact_a.id = 18350 THEN 15
WHEN contact_a.id = 13255 THEN 16
WHEN contact_a.id = 36333 THEN 17
WHEN contact_a.id = 32663 THEN 18
WHEN contact_a.id = 37926 THEN 19
WHEN contact_a.id = 20374 THEN 20
WHEN contact_a.id = 20209 THEN 21
WHEN contact_a.id = 58818 THEN 22
WHEN contact_a.id = 26836 THEN 23
WHEN contact_a.id = 16214 THEN 24
WHEN contact_a.id = 23812 THEN 25
WHEN contact_a.id = 19723 THEN 26
WHEN contact_a.id = 36548 THEN 27
WHEN contact_a.id = 13959 THEN 28
WHEN contact_a.id = 32108 THEN 29
WHEN contact_a.id = 41284 THEN 30
WHEN contact_a.id = 7466 THEN 31
WHEN contact_a.id = 47599 THEN 32
WHEN contact_a.id = 33269 THEN 33
WHEN contact_a.id = 70215 THEN 34
WHEN contact_a.id = 25438 THEN 35
WHEN contact_a.id = 39222 THEN 36
WHEN contact_a.id = 34185 THEN 37
WHEN contact_a.id = 47361 THEN 38
WHEN contact_a.id = 57611 THEN 39
WHEN contact_a.id = 60887 THEN 40
WHEN contact_a.id = 16999 THEN 41
WHEN contact_a.id = 36564 THEN 42
WHEN contact_a.id = 16807 THEN 43
WHEN contact_a.id = 42913 THEN 44
WHEN contact_a.id = 11872 THEN 45
WHEN contact_a.id = 13708 THEN 46
WHEN contact_a.id = 54936 THEN 47
WHEN contact_a.id = 67687 THEN 48
WHEN contact_a.id = 37070 THEN 49
END
) AS _wgt FROM civicrm_contact contact_a LEFT JOIN civicrm_address ON ( contact_a.id = civicrm_address.contact_id AND civicrm_address.is_primary = 1 ) LEFT JOIN civicrm_country ON ( civicrm_address.country_id = civicrm_country.id ) LEFT JOIN civicrm_email ON (contact_a.id = civicrm_email.contact_id AND civicrm_email.is_primary = 1) LEFT JOIN civicrm_phone ON (contact_a.id = civicrm_phone.contact_id AND civicrm_phone.is_primary = 1) LEFT JOIN civicrm_im ON (contact_a.id = civicrm_im.contact_id AND civicrm_im.is_primary = 1) LEFT JOIN civicrm_worldregion ON civicrm_country.region_id = civicrm_worldregion.id WHERE ( ( ( ( contact_a.sort_name LIKE '%george%' ) OR ( contact_a.nick_name LIKE '%george%' ) OR ( civicrm_email.email LIKE '%george%' ) ) ) ) AND (contact_a.is_deleted = 0) AND contact_a.id IN (20504,59412,35293,23486,15853,15637,13515,22624,29033,19796,15758,32061,20846,57645,13327,18350,13255,36333,32663,37926,20374,20209,58818,26836,16214,23812,19723,36548,13959,32108,41284,7466,47599,33269,70215,25438,39222,34185,47361,57611,60887,16999,36564,16807,42913,11872,13708,54936,67687,37070) GROUP BY contact_a.id ORDER BY _wgt`https://lab.civicrm.org/dev/core/-/issues/1203Add `hook_civicrm_pre` and `hook_civicrm_post` to Domain create and edit oper...2019-08-23T01:51:02ZhaystackAdd `hook_civicrm_pre` and `hook_civicrm_post` to Domain create and edit operationsCreating or editing most CiviCRM entities triggers both the `hook_civicrm_pre` and `hook_civicrm_post` hooks. Domains seem to have been overlooked - which means that one cannot detect when a new Domain has been created or when a Domain h...Creating or editing most CiviCRM entities triggers both the `hook_civicrm_pre` and `hook_civicrm_post` hooks. Domains seem to have been overlooked - which means that one cannot detect when a new Domain has been created or when a Domain has been edited. PR to follow.5.18.0haystackhaystackhttps://lab.civicrm.org/dev/core/-/issues/1204Data import for custom membership fields is done as text Instead of value2022-06-04T09:25:32ZyashodhaData import for custom membership fields is done as text Instead of valueData import for custom membership fields is done as text Instead of value. The same works for contact custom data.
Steps to replicate :
---------------------
* Create a custom data used for Membership having *Data Field* with Alphanum...Data import for custom membership fields is done as text Instead of value. The same works for contact custom data.
Steps to replicate :
---------------------
* Create a custom data used for Membership having *Data Field* with Alphanumeric and *Field Type* Autocomplete-Select
* The values in the look up should be numeric.
* Try to update the membership record using import for the custom field with text not the value.
* Check the field in DB, the data is imported but stored as text not value - so this doesn't show up in the UI.
I was able to replicate this on dmaster.
Option value
![optio](/uploads/ec91e4d7ae286a568bd5e6eaab22a26e/optio.png)
Import
![import](/uploads/287886741985da1d224a3c330d6a3f54/import.png)
Final value in database
![mem_Record](/uploads/2efdc86c00dbf49b501cecb4b4141a84/mem_Record.png)5.51.0https://lab.civicrm.org/dev/joomla/-/issues/14[Joomla 4.0] CiviCRM cannot be installed on Joomla 4.0 alpha2021-02-02T00:48:37ZAndrew Thompson[Joomla 4.0] CiviCRM cannot be installed on Joomla 4.0 alphaTested with Joomla 4.0 alpha 11 and CiviCRM 5.16.2.
The installer fails due to several methods that are deprecated in Joomla 4.0 in these files:
- `script.civicrm.php`
- `configure.php`
See [PR #52](https://github.com/civicrm/civicrm...Tested with Joomla 4.0 alpha 11 and CiviCRM 5.16.2.
The installer fails due to several methods that are deprecated in Joomla 4.0 in these files:
- `script.civicrm.php`
- `configure.php`
See [PR #52](https://github.com/civicrm/civicrm-joomla/pull/52) for detail of what is deprecated.
When those are resolved and CiviCRM has been installed then it will not be possible to log in to the Joomla Administrator backend. This is due to the CiviCRM User Management plugin's `admin/plugins/civicrm/civicrm.php`. Again see [PR #52](https://github.com/civicrm/civicrm-joomla/pull/52), which resolves this, for detail.
After the above are resolved, there are some styling issues and the new CiviCRM doesn't get positioned nicely with Joomla 4.0 but those issues are out of scope for this issue.Joomla 4 Integrationhttps://lab.civicrm.org/dev/core/-/issues/1205Attachment API for event custom field gives: Failed to run Permissions checks2020-09-03T13:36:39ZjaapjansmaAttachment API for event custom field gives: Failed to run Permissions checks**Summary**
Retrieving the attachment with an (rest) API of a custom field connected to an event gives: `Failed to run permission check: Unrecognized target entity table (civicrm_event)`. Even when I can retrieve the event with the API....**Summary**
Retrieving the attachment with an (rest) API of a custom field connected to an event gives: `Failed to run permission check: Unrecognized target entity table (civicrm_event)`. Even when I can retrieve the event with the API.
**How to reproduce**
1. Create an custom group for Events.
2. Create a custom field of type File in this custom group.
3. Create an event and upload a file
4. Create an api user, with an api key with permissions to retrieve the attachment
5. Call _Attachment.get_ with the id of the attachment uploaded to the event
**Related issues/fixes**
#690 - Support more entities in Attachment API by short-circuiting permission check which was fixed @pfigel
**The casue of the problem**
This permission error is caused by
Civi\Core\Container.php:
```php
$dispatcher->addSubscriber(new \Civi\API\Subscriber\DynamicFKAuthorization(
$kernel,
'Attachment',
['create', 'get', 'delete'],
// Given a file ID, determine the entity+table it's attached to.
'SELECT if(cf.id,1,0) as is_valid, cef.entity_table, cef.entity_id
FROM civicrm_file cf
LEFT JOIN civicrm_entity_file cef ON cf.id = cef.file_id
WHERE cf.id = %1',
// Get a list of custom fields (field_name,table_name,extends)
'SELECT concat("custom_",fld.id) as field_name,
grp.table_name as table_name,
grp.extends as extends
FROM civicrm_custom_field fld
INNER JOIN civicrm_custom_group grp ON fld.custom_group_id = grp.id
WHERE fld.data_type = "File"
',
['civicrm_activity', 'civicrm_mailing', 'civicrm_contact', 'civicrm_grant']
));
```
See https://github.com/civicrm/civicrm-core/blob/master/Civi/Core/Container.php#L436
**Possible solution**
The sort solution is to add `'civicrm_event'` to this array `['civicrm_activity', 'civicrm_mailing', 'civicrm_contact', 'civicrm_grant']`. But then we have to add all entities which potentially could have a file custom field.
@eileen, @colemanw @pfigel what do you think?5.20.0jaapjansmajaapjansmahttps://lab.civicrm.org/dev/core/-/issues/1206False negative on installer screen for DOES THE SERVER EXIST when installing ...2023-11-07T05:03:22ZDaveDFalse negative on installer screen for DOES THE SERVER EXIST when installing on Azure MySQL(It's not a recent issue.)
Some details at [Stackexchange 1](https://civicrm.stackexchange.com/questions/31794/civicrm-on-azure-not-finding-the-server) and [Stackexchange 2](https://civicrm.stackexchange.com/questions/28884/your-databas...(It's not a recent issue.)
Some details at [Stackexchange 1](https://civicrm.stackexchange.com/questions/31794/civicrm-on-azure-not-finding-the-server) and [Stackexchange 2](https://civicrm.stackexchange.com/questions/28884/your-database-settings-dont-appear-to-be-correct-all-green-but-still-error) but the short version is the DOES THE SERVER EXIST check in the installer is a bit odd - https://github.com/civicrm/civicrm-core/blob/5.16.2/install/index.php#L1038 - it doesn't use the username and password, and then as long as the error is less than code 2000 it says ok that's probably fine. On Azure though the error code is 9002 if you don't provide a properly formatted username and password.
So simple fix is to use the username/password. And it should also use the port for completeness but that's not the problem here.
For reference whether the username/pass is the right combo or not doesn't matter to Azure at this stage, as long as it's the right format it will return the same error code 1045 that the current code receives back from other systems when you pass nulls.
It's not clear if the check even needs to be there when there's similar checks right after - I guess to help narrow down whether the problem is the hostname or something else. But is that really needed.https://lab.civicrm.org/dev/core/-/issues/1207"My Cases" dashlet gives datatables error2021-02-28T23:47:08ZDaveD"My Cases" dashlet gives datatables errorNot sure yet how recent. Reported against 5.14. I'm seeing it in master too.
See https://civicrm.stackexchange.com/a/31810/181
The type url parameter that is expected as either `upcoming, recent, or any`, is getting overwritten by the ...Not sure yet how recent. Reported against 5.14. I'm seeing it in master too.
See https://civicrm.stackexchange.com/a/31810/181
The type url parameter that is expected as either `upcoming, recent, or any`, is getting overwritten by the type parameter from the dashlet that somewhere sets it to `my-cases`, so the db view isn't getting included in the query at https://github.com/civicrm/civicrm-core/blob/5.14.2/CRM/Case/BAO/Case.php#L450.
I'm not seeing the other symptoms reported at stackexchange, at least on master. The case dashboard seems ok, and the datatables error for the my-cases dashlet affects admin users too so isn't related to permissions.5.36.0