Development issueshttps://lab.civicrm.org/groups/dev/-/issues2022-06-15T03:08:45Zhttps://lab.civicrm.org/dev/core/-/issues/3496CiviCRM has not bootstrapped sufficiently to fire event "hook_civicrm_entityT...2022-06-15T03:08:45ZjrobensCiviCRM has not bootstrapped sufficiently to fire event "hook_civicrm_entityTypes".Overview
----------------------------------------
Upgrade to 5.50.1 results in
`CiviCRM has not bootstrapped sufficiently to fire event "hook_civicrm_entityTypes".`
I am using civicrm_entity. Mosaico is the 'non-typical' CiviCRM exten...Overview
----------------------------------------
Upgrade to 5.50.1 results in
`CiviCRM has not bootstrapped sufficiently to fire event "hook_civicrm_entityTypes".`
I am using civicrm_entity. Mosaico is the 'non-typical' CiviCRM extension.
https://civicrm.stackexchange.com/questions/42039/installation-of-v5-50-gives-me-an-immediate-bootstrap-exception/42055#42055
Reproduction steps
----------------------------------------
1. Update CiviCRM
1. Attempt top load any page, run CV or drush
1. CiviCRM is not bootstrapped sufficiently!
Current behaviour
----------------------------------------
There is an initialize error. _civicrm_entity_ is in use. I was able to stop this creating an error by refactoring into using drupal events rather than hooks. This just pushed the problem further into civicrm. The drupal _civicrm_ module then caused an error at the initialize() function and after that block. There are reports in stack overflow of this same symptom occurring in Wordpress.
[initialize-error](/uploads/5b96cc9a779774d4fa6db72e453ea280/initialize-error.png)
Expected behaviour
----------------------------------------
Page should load or CV run.
Environment information
----------------------------------------
* __Browser:__ _Firefox Chrome 100+ /Safari
* __CiviCRM:__ From 5.49.3 to _Master/5.50.0 or 5.50.1 _ <!-- If this problem relates to an upgrade, then specify both old and new versions -->
* __PHP:__ /7.4/__
* __CMS:__ _Drupal 9.3.15_
* __Database:__ _MariaDB 10.4_
* __Web Server:__ _Apache 2.4/..._
Comments
----------------------------------------
Commenting out _comonModuleBuildList_ in Container.php as added to git on 21/4/2022 enables the page to load.5.50.2https://lab.civicrm.org/dev/core/-/issues/3495Sorting/paging Advanced Search results corrupts search criteria2022-06-16T05:07:08ZBobSSorting/paging Advanced Search results corrupts search criteriaOverview
----------------------------------------
Certain search criteria fields in Advanced Search which have an implied LIKE operator are corrupted upon sorting by clicking on a column or by advancing to a different page in the results...Overview
----------------------------------------
Certain search criteria fields in Advanced Search which have an implied LIKE operator are corrupted upon sorting by clicking on a column or by advancing to a different page in the results.
Two such fields are:
Contribution Source
Case Subject
Others fields, such as Contact Name, do not exhibit this problem.
Reproduction steps
----------------------------------------
1. Login to https://dmaster.demo.civicrm.org
1. Search | Advanced Search
1. Display results as: Contributions
1. Contribution | Contribution Source = "p"
1. Click Search
1. Note 59 results, displayed search criteria includes "Contribution Source Like %p%"
1. Click the City column heading (or any other column heading), or display page 2 of the results.
Current behaviour
----------------------------------------
There are now 108 results, and the displayed search criteria includes "Contribution Source Like %%"
Expected behaviour
----------------------------------------
The search criteria should not be affected by sorting or paging the results.
Environment information
----------------------------------------
* __Browser:__ _Chrome/102.0.5005.63_
* __CiviCRM:__ _5.50.0_
* __PHP:__ _7.4.29_
* __CMS:__ _Drupal 7.88_
* __Database:__ _MariaDB 10.4.13_
* __Web Server:__ _Apache 2.4.43_
Comments
----------------------------------------
Problem traced to /CRM/Core/Form/Search.php:convertTextStringsToUseLikeOperator() calling trim() on $this->_formValues[$fieldName]. That variable, in the affected cases, is an array rather than a string, e.g. ['LIKE' => 'search_value'].5.52.0https://lab.civicrm.org/dev/core/-/issues/3494ACLs fail with syntax error when using nested API4 smart groups2022-08-09T16:01:32ZAndrew WestACLs fail with syntax error when using nested API4 smart groupsOverview
----------------------------------------
Easiest to explain with specifics:
We have users who should only be able to access contacts in Northern Ireland. So we've got an ACL set up for this.
We have a regular group MembersAll,...Overview
----------------------------------------
Easiest to explain with specifics:
We have users who should only be able to access contacts in Northern Ireland. So we've got an ACL set up for this.
We have a regular group MembersAll, and a smart group MembersNorthernIreland. MembersNorthernIreland is an API4 smart group that finds anyone in the group MembersAll who lives in Northern Ireland.
Then we have a 'Northern Ireland' ACL that allows access to the MembersNorthernIreland smart group.
But the MembersNorthernIreland is throwing syntax errors for ACL users, because a long way down the chain the code finds itself not allowed to access details about MembersAll - because it's not a group the ACL'd user is allowed to access.
Essentially the GroupContactCache wants to build the SQL to generate the people in MembersNorthernIreland. It hands this over to API4, which parses the smart group criteria and finds MembersAll. API4 wants to get the ID for MembersAll and ultimately calls FormattingUtil::getPseudoconstantList() - which tries to return a list of _all_ groups via a getfields call [here](https://github.com/civicrm/civicrm-core/blob/99106f72c566265e5437f1654740f9adc7976956/Civi/Api4/Utils/FormattingUtil.php#L268). But at this point the ACL permissions themselves get in the way, and all it gets is a list of the groups the user is allowed to access.
So the function can't find an ID and returns nothing, ultimately resulting in a DB syntax error where the SQL tries to search an empty list:
```
[message] => DB Error: syntax error
[mode] => 16
[debug_info] => SELECT child_group_id, parent_group_id FROM civicrm_group_nesting WHERE parent_group_id IN () [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1]
```
Backtrace:
```
[...sql then error handling...]
#11 /data/vhosts/humanists.uk/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(476): DB_DataObject->query("SELECT child_group_id, parent_group_id FROM civicrm_group_nesting WHERE paren...")
#12 /data/vhosts/humanists.uk/wp-content/plugins/civicrm/civicrm/CRM/Contact/BAO/GroupNesting.php(201): CRM_Core_DAO->query("SELECT child_group_id, parent_group_id FROM civicrm_group_nesting WHERE paren...")
#13 /data/vhosts/humanists.uk/wp-content/plugins/civicrm/civicrm/CRM/Contact/BAO/GroupContactCache.php(671): CRM_Contact_BAO_GroupNesting::getDescendentGroupIds((Array:0))
#14 /data/vhosts/humanists.uk/wp-content/plugins/civicrm/civicrm/Civi/Api4/Service/Spec/Provider/ContactGetSpecProvider.php(75): CRM_Contact_BAO_GroupContactCache::populateTemporaryTableWithContactsInGroups((Array:0), "civicrm_tmp_e_dflt_a6ffaf8a8a00dea3b83483af9d0b4a95")
#15 /data/vhosts/humanists.uk/wp-content/plugins/civicrm/civicrm/Civi/Api4/Query/Api4SelectQuery.php(554): Civi\Api4\Service\Spec\Provider\ContactGetSpecProvider::getContactGroupSql((Array:32), "`a`.`id`", "IN", (Array:0), Object(Civi\Api4\Query\Api4SelectQuery), 0)
#16 /data/vhosts/humanists.uk/wp-content/plugins/civicrm/civicrm/Civi/Api4/Query/Api4SelectQuery.php(530): Civi\Api4\Query\Api4SelectQuery->createSQLClause("`a`.`id`", "IN", (Array:0), (Array:32), 0)
#17 /data/vhosts/humanists.uk/wp-content/plugins/civicrm/civicrm/Civi/Api4/Query/Api4SelectQuery.php(425): Civi\Api4\Query\Api4SelectQuery->composeClause((Array:3), "WHERE", 0)
#18 /data/vhosts/humanists.uk/wp-content/plugins/civicrm/civicrm/Civi/Api4/Query/Api4SelectQuery.php(298): Civi\Api4\Query\Api4SelectQuery->treeWalkClauses((Array:3), "WHERE")
#19 /data/vhosts/humanists.uk/wp-content/plugins/civicrm/civicrm/Civi/Api4/Query/Api4SelectQuery.php(150): Civi\Api4\Query\Api4SelectQuery->buildWhereClause()
#20 /data/vhosts/humanists.uk/wp-content/plugins/civicrm/civicrm/CRM/Contact/BAO/GroupContactCache.php(529): Civi\Api4\Query\Api4SelectQuery->getSql()
#21 /data/vhosts/humanists.uk/wp-content/plugins/civicrm/civicrm/CRM/Contact/BAO/GroupContactCache.php(808): CRM_Contact_BAO_GroupContactCache::getApiSQL((Array:14), 1177)
#22 /data/vhosts/humanists.uk/wp-content/plugins/civicrm/civicrm/CRM/Contact/BAO/GroupContactCache.php(654): CRM_Contact_BAO_GroupContactCache::insertGroupContactsIntoTempTable("civicrm_tmp_e_gccache_d3d3e139c670a183ea5d7ceab54118b6", 1177, 4808, NULL)
#23 /data/vhosts/humanists.uk/wp-content/plugins/civicrm/civicrm/CRM/Contact/BAO/GroupContactCache.php(360): CRM_Contact_BAO_GroupContactCache::buildGroupContactTempTable((Array:1), Object(CRM_Utils_SQL_TempTable))
#24 /data/vhosts/humanists.uk/wp-content/plugins/civicrm/civicrm/CRM/ACL/BAO/ACL.php(290): CRM_Contact_BAO_GroupContactCache::load(Object(CRM_Core_DAO))
#25 /data/vhosts/humanists.uk/wp-content/plugins/civicrm/civicrm/CRM/ACL/API.php(117): CRM_ACL_BAO_ACL::whereClause(2, (Array:0), (Array:0), 290135)
#26 /data/vhosts/humanists.uk/wp-content/plugins/civicrm/civicrm/CRM/Contact/BAO/Contact/Permission.php(187): CRM_ACL_API::whereClause(2, (Array:0), (Array:0), 290135, FALSE, FALSE, TRUE)
#27 /data/vhosts/humanists.uk/wp-content/plugins/civicrm-wp-profile-sync/includes/civicrm/cwps-civicrm-contact.php(1099): CRM_Contact_BAO_Contact_Permission::allow("290135", 2)
#28 /data/vhosts/humanists.uk/wp-content/plugins/civicrm-wp-profile-sync/includes/civicrm/cwps-civicrm-contact.php(1058): CiviCRM_WP_Profile_Sync_CiviCRM_Contact->user_can_view("290135")
#29 /data/vhosts/humanists.uk/wp-includes/class-wp-hook.php(307): CiviCRM_WP_Profile_Sync_CiviCRM_Contact->menu_link_add(Object(WP_Admin_Bar))
#30 /data/vhosts/humanists.uk/wp-includes/class-wp-hook.php(331): WP_Hook->apply_filters(NULL, (Array:1))
#31 /data/vhosts/humanists.uk/wp-includes/plugin.php(524): WP_Hook->do_action((Array:1))
```
Reproduction steps
----------------------------------------
1. Using search kit, create smart group x based on smart group y
2. Create an ACL that permits users to access smart group x, but not smart group y
3. Login as that user and try to access Civi
Environment information
----------------------------------------
<!-- Some of the items below may not be relevant for every bug - if in doubt please include more information than you think is neccessary. -->
* __Browser:__ _Firefox 59.0.1/Chrome 78.0.3904/Safari 13_
* __CiviCRM:__ _5.50.1_
* __PHP:__ _7.3_
* __CMS:__ _WordPress 6.0_
Comments
----------------------------------------
I've worked around it by removing the nested group. But I'm not sure of the best approach to fix it in the code.https://lab.civicrm.org/dev/core/-/issues/3493Afform: Failed to find key by ID or tag (SIGN)2022-12-19T21:18:09ZandyburnsAfform: Failed to find key by ID or tag (SIGN)I created a simple afform submitting a name and it just spins and shows this console error. On Civi 5.50.0, WP 5.8.4 and multisite. I had this issue on 5.46.3 as well. It does submit the contact even though it appears not to.
![image](/...I created a simple afform submitting a name and it just spins and shows this console error. On Civi 5.50.0, WP 5.8.4 and multisite. I had this issue on 5.46.3 as well. It does submit the contact even though it appears not to.
![image](/uploads/98a9537c12d29cda91345959e268d8a0/image.png)
Sometimes only the angular error:
![image](/uploads/4e77c2cbad1b88909dc62e7b4e3d4500/image.png)
No error reported to civi logs.https://lab.civicrm.org/dev/core/-/issues/3490Upgrader - Apply extension updates after core updates2023-02-08T19:08:30ZtottenUpgrader - Apply extension updates after core updatesOverview
----------------------------------------
Functionality in `civicrm-core` is increasingly organized with internal extensions (`civicrm-core:ext/*`). The main upgrade workflow should incorporate the upgrade-steps for extensions.
...Overview
----------------------------------------
Functionality in `civicrm-core` is increasingly organized with internal extensions (`civicrm-core:ext/*`). The main upgrade workflow should incorporate the upgrade-steps for extensions.
Example use-case
----------------------------------------
1. Extract tarball with a new version of `civicrm-core`, including updated `ext/*`
1. Run the main upgrader (`civicrm/upgrade?reset=1`, `cv core:upgrade`, `drush civicrm-upgrade-db`, or `wp civicrm upgrade-db`)
Current behaviour
----------------------------------------
It updates the schema for things like `civicrm_contact` (eg `CRM/Upgrade/*`) but not things like `civicrm_search_segment` (eg `ext/search_kit/CRM/Search/Upgrader.php`).
As a sysadmin, you must run the upgrades separately.
Most are not habituated to running these together. This leads to confusing user-stories like https://civicrm.stackexchange.com/questions/42094/civimail-issue-db-error-no-such-table-when-sending-mailing (where the first upgrade seemed to work - but you get random errors because the second upgrade hasn't run).
Proposed behaviour
----------------------------------------
Run both.
The core-upgrade should delegate/incorporate the ext-upgrade, and it should preserve essential elements of the ext-upgrade contract. Specifically: ext-upgrades can use features/services/APIs from core. This implies that (1) ext-upgrades run after core-upgrades and (2) when it gets to ext-upgrades, it should follow a normal/open dispatch-policy.
Comments
----------------------------------------
Filing issue after some Mattermost discussion with rudanpal, @colemanw, @bgm, @totten: https://chat.civicrm.org/civicrm/pl/b76y4gy517yxdet331ueqrxgrw
I posted a draft at https://github.com/civicrm/civicrm-core/compare/5.50...totten:run-ext-upgrades?expand=1
As mentioned in PHP comments+Mattermost, there's an issue with the current draft -- when it gets to ext-upgrade tasks, it would (unexpectedly) continue to apply the limited dispatch-policy used for core-upgrades (`upgrade.main` vs `upgrade.finish`). Some ways to address that:
* __Runner state__: While the upgrader goes through phases (*ex: 1-core upgrade, 2-ext upgrade, 3-new exts*), keep a stored value naming the phase. this stored value determines the active dispatch-policy
* ex: `Civi::settings()->set('upgrade_phase', '...')`
* __Task wrapping/task tagging__: When taking ext-upgrade tasks and putting them into the core-upgrade queue, put some wrapper or tag on each one to indicate the phase/policy that it relies on
* wrapper example: `CRM_Upgrade_Form::wrappedTask(string $dispatchPolicy, array $realCallback)
* tag example: `$queue->createItem($task, ['dispatchPolicy' => string])`https://lab.civicrm.org/dev/core/-/issues/3489Increase field size for mailing bounce type2024-01-29T10:07:13ZKurund JalmiIncrease field size for mailing bounce typeThe database fields in civicrm_mailing_bounce_type are too restrictive. The name field is limited to 24 characters and the description is limited to 255 characters. This isn’t long enough for the name and description provided by some ema...The database fields in civicrm_mailing_bounce_type are too restrictive. The name field is limited to 24 characters and the description is limited to 255 characters. This isn’t long enough for the name and description provided by some email service providers - e.g. AWS SES.
I propose that the name field should be increased to 256 characters (`VARCHAR(256)`) and the description field should be increased to 2048 characters (`VARCHAR(2048)`).https://lab.civicrm.org/dev/core/-/issues/3488Minor Search Kit bug: Map Contacts does not update2024-02-03T05:03:23ZAndrew WestMinor Search Kit bug: Map Contacts does not updateOverview
----------------------------------------
If you run Map Contacts in Search Kit, then change the search critiera and run it again, you get the original results.
Reproduction steps
----------------------------------------
1. Sear...Overview
----------------------------------------
If you run Map Contacts in Search Kit, then change the search critiera and run it again, you get the original results.
Reproduction steps
----------------------------------------
1. Search for some contacts
2. Select all, then Map Contacts
3. Close the popup
4. Change the criteria considerably and run the search
5. Select all, then Map Contacts
6. The original results appear
Environment information
----------------------------------------
5.50 with the [proximity patch](https://github.com/civicrm/civicrm-core/pull/23597) applied
Comments
----------------------------------------
The test sites don't have a geocoding provider set up so I can't say for sure it's not something on our setup.https://lab.civicrm.org/dev/core/-/issues/3487CiviCRM Status Page Blank Upon Upgrade to 5.50.02022-06-01T18:20:45ZjohngehrigCiviCRM Status Page Blank Upon Upgrade to 5.50.0Overview
----------------------------------------
Upon upgrade to CiviCRM 5.50.0, the CiviCRM Status page appears blank (i.e. no status information loads on the page). The CiviCRM status information still loads on the CiviCRM Dashboard i...Overview
----------------------------------------
Upon upgrade to CiviCRM 5.50.0, the CiviCRM Status page appears blank (i.e. no status information loads on the page). The CiviCRM status information still loads on the CiviCRM Dashboard in the modal bubble. Otherwise, the upgrade appears successful and everything works properly.
Reproduction steps
----------------------------------------
Run upgrade
Current behaviour
----------------------------------------
CiviCRM System Status page is blank (i.e. no status information loads)
Expected behaviour
----------------------------------------
CiviCRM System Status page loads System Status information
Environment information
----------------------------------------
Browser: Chrome 102.0.5005.63 (Official Build) (64-bit)<br/>
CiviCRM: 5.50.0, upgrading from 5.48.0<br/>
PHP: 7.4<br/>
CMS: WordPress 6.0<br/>
Database: MariaDB 10.3<br/>
Web Server: Apache
Comments
----------------------------------------
I tried to find the problem with the CiviCRM Status page but nothing really stuck out -- I checked the log files, cleared the cache, checked with a different browser, and also checked the cPanel logs but couldn't see anything with errors. Finally, I also checked the Release Notes for releases between 5.48.1 - 5.49.4 to see if any incremental release mentioned this type of error for a possible regression and did not see anything related to it in the Release Notes either.<br/><br/>![6-1-2022_1-01-40_PM](/uploads/98988532824cd2428dfb3f1ebcdaff4f/6-1-2022_1-01-40_PM.png)
![6-1-2022_1-02-08_PM](/uploads/d09873fcb5fa23476536d417a7a40d0e/6-1-2022_1-02-08_PM.png)https://lab.civicrm.org/dev/core/-/issues/3486Merge multiple event participant changes ownership of contribution inappropri...2024-02-04T05:03:27ZStoobMerge multiple event participant changes ownership of contribution inappropriatelyHow to reproduce:
1) Contact A purchases two tickets for self and guest, Contact B, using Multiple Participant registration. As appropriate this creates a contribution for Contact A, and participant for Contact A and Contact B.
2) Cont...How to reproduce:
1) Contact A purchases two tickets for self and guest, Contact B, using Multiple Participant registration. As appropriate this creates a contribution for Contact A, and participant for Contact A and Contact B.
2) Contact B is a duplicate record of pre-existing Contact C. Merge the "new" Contact B into into Contact C on the right.
3) Inappropriate behavior: the contribution record in Contact A record is on Contact C.https://lab.civicrm.org/dev/core/-/issues/3485Installer - CiviGrant option no longer works2022-06-11T15:47:08ZtottenInstaller - CiviGrant option no longer worksOverview
----------------------------------------
When performing a web-based installation on Drupal or WordPress, it presents a list of components that you can toggle. One option no longer works correctly.
Reproduction steps
---------...Overview
----------------------------------------
When performing a web-based installation on Drupal or WordPress, it presents a list of components that you can toggle. One option no longer works correctly.
Reproduction steps
----------------------------------------
1. Create an empty D7/BD/WP site
2. Enable CiviCRM
3. In the status alert, click the link to `civicrm/setup`
4. Enable the CiviGrant option
5. Proceed with install
Current behaviour
----------------------------------------
CiviGrant is not activated
Expected behaviour
----------------------------------------
Activate CiviGrant extension
Or: Don't present the option
Environment information
----------------------------------------
Hydra site for WP: http://site-list.test-1.civicrm.org:8001/?filter=hydra-* (http://hydra-wp.test-1.civicrm.org:8002/)
Comments
----------------------------------------
I noticed this while trying the 5.50 installer, but it probably regressed circa 5.48.
The installer currently presents a list of components (https://github.com/civicrm/civicrm-core/blob/master/setup/plugins/blocks/components.civi-setup.php) and populates `$e->getModel()->components`.
To configurably toggle extensions during install, it needs to update `$e->getModel()->extensions`.
https://github.com/civicrm/civicrm-core/blob/master/setup/src/Setup/Model.php#L42-L455.51.0https://lab.civicrm.org/dev/core/-/issues/3484Comments on notes has a bunch of problems: cannot delete nor update via UI, n...2024-02-05T05:03:29ZherbdoolComments on notes has a bunch of problems: cannot delete nor update via UI, not in API4I only just found out that notes can also have notes (called "comments" in the UI). This functionality is fairly broken. Cannot update nor delete via the UI. And cannot view/update/delete/add via API4.
Tested on CiviCRM 5.49.3 / Drupal 9.I only just found out that notes can also have notes (called "comments" in the UI). This functionality is fairly broken. Cannot update nor delete via the UI. And cannot view/update/delete/add via API4.
Tested on CiviCRM 5.49.3 / Drupal 9.https://lab.civicrm.org/dev/core/-/issues/3483Error when deleting a note: Undefined index: parent_id in CRM_Note_Form_Note-...2024-02-05T05:03:28ZherbdoolError when deleting a note: Undefined index: parent_id in CRM_Note_Form_Note->postProcess()Overview
----------------------------------------
After deleting a note (for instance, on a contact): https://EXAMPLE.org/civicrm/contact/view/note?action=delete&reset=1&cid=314758&id=390738&selectedChild=note.
Results in:
> Notice: U...Overview
----------------------------------------
After deleting a note (for instance, on a contact): https://EXAMPLE.org/civicrm/contact/view/note?action=delete&reset=1&cid=314758&id=390738&selectedChild=note.
Results in:
> Notice: Undefined index: parent_id in CRM_Note_Form_Note->postProcess() (line 169 of /var/www/vhosts/EXAMPLE.org/www/vendor/civicrm/civicrm-core/CRM/Note/Form/Note.php)
Reproduction steps
----------------------------------------
1. Create a note on a contact.
2. Delete that contact.
3. Check error logs.
`postProcess()` is looking for `$params['parent_id']` even though it is not being set when deleting a note.
It appears that `parent_id` is only used for "comments" on notes. This area of the code is a bit funky and doesn't appear to be exposed to API4 (don't see any parent_id there). In `CRM_Note_Form_Note` the `_parentId` is being set based on `$_GET` so I don't think that would be available to the API.
Tested on CiviCRM 5.49.3.https://lab.civicrm.org/dev/core/-/issues/3482mailing workflow: approval doesn't update mailing; creates empty mailing2022-06-01T01:07:07Zlcdwebmailing workflow: approval doesn't update mailing; creates empty mailingTo replicate this issue:
- enable the advanced mailing workflow features (Drupal only)
- create separate users with create/schedule/approve permissions (you must have separate users for schedule/approve at a minimum. if a user has both ...To replicate this issue:
- enable the advanced mailing workflow features (Drupal only)
- create separate users with create/schedule/approve permissions (you must have separate users for schedule/approve at a minimum. if a user has both of those permissions they are handled in a single step and doesn't trigger this error)
- create a mailing
- login as the scheduler user and schedule the mailing
- login as the approver user and approve the mailing
Expected behavior: Mailing is marked approved and queued for delivery.
Actual behavior: Mailing is left in an unapproved state and an empty mailing record is created.
Explanation of problem:
If the advanced workflow functionality is enabled, the approval step is handled with a separate form (CRM_Mailing_Form_Approve). In the postProcess method the function call to update the mailing with the approval status uses now-removed parameters. As a result, the mailing ID is not passed, the existing mailing is not updated, and a new mailing record stub is created.5.50.0lcdweblcdwebhttps://lab.civicrm.org/dev/core/-/issues/3481Primary email is not visually marked as primary2022-06-03T21:55:57Zmagnolia61Primary email is not visually marked as primaryFor phone numbers a visual sign is shown to show which is the primary phone number.
For email addresses this is not the case.
What would be needed to show which email address is the primary one?
Is this a civicrm core thing firstly?
us...For phone numbers a visual sign is shown to show which is the primary phone number.
For email addresses this is not the case.
What would be needed to show which email address is the primary one?
Is this a civicrm core thing firstly?
using contactlayout without shoreditch
![image](https://user-images.githubusercontent.com/2195908/170932708-81876bb9-e1ca-41c3-8c19-9c65ea386503.png)
using contactlayout with shoredich
![image](https://user-images.githubusercontent.com/2195908/170933137-f6aaaa8d-29d7-43f0-8664-3fb8a2c0f47c.png)5.51.0https://lab.civicrm.org/dev/core/-/issues/3480Allow entering website URLs with special characters / IDN in backend2022-05-27T16:42:36ZAndreasandreas.howiller@civiservice.deAllow entering website URLs with special characters / IDN in backendOverview
----------------------------------------
Since a couple of years so called internationalized domain names (IDN) are allowed that contain special characters like German Umlauts, chracters from the Arabic alphabet etc. Modern web ...Overview
----------------------------------------
Since a couple of years so called internationalized domain names (IDN) are allowed that contain special characters like German Umlauts, chracters from the Arabic alphabet etc. Modern web browsers also support them and so it's no surprise that they are more and more in use. That's why for instance http://münchen.de or http://köln.de are registered domains. However CiviCRM won't accept entering these in the contact screen:
![grafik](/uploads/65b49553963fd94ba8e676ad5d0972c6/grafik.png)
In the case of _münchen.de_ which is forwarded to _muenchen.de_ this would be managable, but from real CiviCRM usecases I know dozends of URLs that don't come with alternatives so users won't get them into their Civi (theoretically they could convert them using an IDN converter so that _münchen.de_ becomes _xn--mnchen-3ya.de_ but in practice this is not a real option).
Current behaviour
----------------------------------------
Website URLs containing special characters (valid according to IDN standards) cannot be entered in the backend.
Proposed behaviour
----------------------------------------
Website URLs containing special characters (valid according to IDN standards) can be entered in the backend.https://lab.civicrm.org/dev/core/-/issues/3479make the hook usable by passing the sql2024-02-04T05:03:25Zyashodhamake the hook usable by passing the sqlCurrently, we are not passing the sql in the _alterReportVar_ hook.
`CRM_Utils_Hook::alterReportVar('sql', $this, $this);`
Objective is to make the hook usable by passing the sql instead of redundant params.Currently, we are not passing the sql in the _alterReportVar_ hook.
`CRM_Utils_Hook::alterReportVar('sql', $this, $this);`
Objective is to make the hook usable by passing the sql instead of redundant params.yashodhayashodhahttps://lab.civicrm.org/dev/core/-/issues/3478Afform - email delivery2023-06-29T15:47:01Zaydunsaidan.saunders@squiffle.ukAfform - email deliveryOverview
----------------------------------------
Add an action to enable scheduled Email Delivery of SearchKit results.
Reports provides settings to enable scheduled Email Delivery of reports. The lack of an option to do the same dete...Overview
----------------------------------------
Add an action to enable scheduled Email Delivery of SearchKit results.
Reports provides settings to enable scheduled Email Delivery of reports. The lack of an option to do the same deters some people from using SearchKit - see https://civicrm.stackexchange.com/q/41966/225
Comments
----------------------------------------
Not a high priority item but noting for parity with Reports functionality.https://lab.civicrm.org/dev/core/-/issues/3477SearchKit - dashboard tables2023-12-03T16:32:00Zaydunsaidan.saunders@squiffle.ukSearchKit - dashboard tablesOverview
----------------------------------------
This is about how we can produce dashboard-like summary data with SearchKit to replace existing dashboards and make them more customisable.
For example, consider the Cases dashboard:
...Overview
----------------------------------------
This is about how we can produce dashboard-like summary data with SearchKit to replace existing dashboards and make them more customisable.
For example, consider the Cases dashboard:
- the rows are Case Types
- the columns are the values of Case Status
- the table cells are counts of matching cases, linked to another search
Option 1
--------
SearchKit can produce the counts with eg:
![image](/uploads/16d551f0332f28f4f2a5ef8a6e4a1ff4/image.png)
Maybe a new Display type could restructure the data to produce the desired format.
(Note that is should be based off of CaseType rather than Cases so that types with no cases are shown. But CaseType is not currently available.)
Option 2
--------
See https://gist.github.com/aydun/d49197c81205b463ef5cdef38c97b317
The recently added data segmentation functionality adds 'virtual fields' for group-by purposes. Maybe we could add virtual fields based around the idea of the gist to create virtual fields from an option group so an option group of case_status becomes a set of fields `sum(status_id=1), sum(status_id=2)` etc.
However, I don't think SearchKit/Api4 can produce sql like that - but maybe it can!
Both of these would need to accommodate linking the cells to another parameterized search.
Option 3
----------------------------------------
Something else ...https://lab.civicrm.org/dev/joomla/-/issues/405 broken/dated links in post-install success screen for Joomla2022-10-11T22:50:40Znicol5 broken/dated links in post-install success screen for JoomlaOn successfully installing CiviCRM on Joomla (I'm assuming not on the other CMSs), there's a welcome screen with four links to the old wiki/confluence (ie 'http://wiki.civicrm.org/confluence/display/CRMDOC/Installation+and+Upgrades') whi...On successfully installing CiviCRM on Joomla (I'm assuming not on the other CMSs), there's a welcome screen with four links to the old wiki/confluence (ie 'http://wiki.civicrm.org/confluence/display/CRMDOC/Installation+and+Upgrades') which would better point to new (https) docs pages. The register a site link is also broken.
I'm happy to make a PR for this but not sure where the file is located, I checked in https://github.com/civicrm/civicrm-core/tree/master/install & https://github.com/civicrm/civicrm-joomla but couldn't see it. Maybe it's not an actual smarty template but something that's passed to Joomla's UI as it looks natively styled in J3 and J4?
![image](/uploads/8b0a011ff0531bcfc719e6b4eb5e30b0/image.png)
New links needed for:
- 'Installation Guide' - I guess to this: https://docs.civicrm.org/user/en/latest/initial-set-up/installation-and-basic-set-up/
- Create front-end forms and searchable directories using Profiles - https://docs.civicrm.org/user/en/latest/organising-your-data/profiles/
- Create online contribution pages - https://docs.civicrm.org/user/en/latest/contributions/online-contributions/
- Create events with online event registration - https://docs.civicrm.org/user/en/latest/events/what-is-civievent/
- Register a site - https://civicrm.org/register-a-sitenicolnicolhttps://lab.civicrm.org/dev/core/-/issues/3476API Explorer v4 web page broken2022-05-28T09:41:24ZspalmstromAPI Explorer v4 web page brokenOverview
----------------------------------------
API Explorer v4 gives a broken page when running in an environment that wasn't originally en_US.
Reproduction steps
----------------------------------------
1. Click on **Support -> Deve...Overview
----------------------------------------
API Explorer v4 gives a broken page when running in an environment that wasn't originally en_US.
Reproduction steps
----------------------------------------
1. Click on **Support -> Developer -> API Explorer v4**.
Current behaviour
----------------------------------------
![image](/uploads/afc9e5a33d24a4165dcb7f09424d8c9e/image.png)
Expected behaviour
----------------------------------------
![image](/uploads/23c47fb08a917b0766caf244d0a63d7e/image.png)
as demonstrated by the demo environment.
Environment information
----------------------------------------
<!-- Some of the items below may not be relevant for every bug - if in doubt please include more information than you think is necessary. -->
* __Browser:__ _MS Edge_ but probably irrelevant.
* __CiviCRM:__ _5.49.2/5.51.alpha1_ <!-- If this problem relates to an upgrade, then specify both old and new versions -->
* __PHP:__ _7.4__ but probably irrelevant.
* __CMS:__ _Drupal 9.3.13_ but probably irrelevant.
* __Database:__ _MySQL 8_ but probably irrelevant
* __Web Server:__ _IIS 10_
Comments
----------------------------------------
I am seeing this in two instance, both were set up using en_GB as the language. Reverting to single language didn't help. The page debugger shows four errors along the same lines:
```
https://<web root>/libraries/civicrm/core/bower_components/google-code-prettify/bin/prettify.min.css?r=MYbGEen_GB
```
returns a 404 error.
My theory as to why the local instances aren't working may, of course, be completely wrong, but I look to those more expert in what API Explorer v4 is doing to be able to help. Any suggestions as to a solution would be appreciated.