CiviCRM Core issueshttps://lab.civicrm.org/dev/core/-/issues2023-05-03T05:47:11Zhttps://lab.civicrm.org/dev/core/-/issues/2104Add more columns for Activity Report2023-05-03T05:47:11ZyashodhaAdd more columns for Activity ReportAdd more columns for Activity Report e,g target related fields currently it is showing target name and email only.Add more columns for Activity Report e,g target related fields currently it is showing target name and email only.5.62.0yashodhayashodhahttps://lab.civicrm.org/dev/core/-/issues/2103Event location "used by 1 other events"2022-05-13T17:23:04Zaydunsaidan.saunders@squiffle.ukEvent location "used by 1 other events"Overview
----------------------------------------
When viewing event location configuration it displays this:
![image](/uploads/ef57dddf378f249ac33ab7a22e5c1e01/image.png)
Issues
------
1. It is not used by '1 **other** events', it is o...Overview
----------------------------------------
When viewing event location configuration it displays this:
![image](/uploads/ef57dddf378f249ac33ab7a22e5c1e01/image.png)
Issues
------
1. It is not used by '1 **other** events', it is only used here. (You can check by creating an event with a new random address and see that it still shows this.)
1. It always says '1' other location, regardless of how many actually use it. (Check by creating new events and reusing existing locations.
1. It is not easy to see what other events use that location.
Proposed behaviour
----------------------------------------
1. Only show the message if there are other events using this location, excluding this event.
1. Correctly show how many other events are using this location. (Consider whether that is all events, or just active and/or future events) Handle singular/plural correctly.
Bonus:
1. Maybe include a link to search for events using that location. The 'Find Events' on 'Manage Events' could be enhanced to search by location.
Comments
----------------------------------------
Might be suitable for someone looking for a 'getting started' PR5.49.0https://lab.civicrm.org/dev/core/-/issues/2102Changing address on event hangs2020-10-10T19:34:14Zaydunsaidan.saunders@squiffle.ukChanging address on event hangsOverview
----------------------------------------
Changing the address on an event causes hang (spinning logo)
Reproduction steps
----------------------------------------
1. Create an Event with a location & Save.
1. On Event configurat...Overview
----------------------------------------
Changing the address on an event causes hang (spinning logo)
Reproduction steps
----------------------------------------
1. Create an Event with a location & Save.
1. On Event configuration select 'Event Location' tab
1. Click **Create new location** radio
1. Enter address details
1. Click **Save**
Current behaviour
----------------------------------------
Spinning logo. On reloading the page, 'Create new location' is still selected with no address details
Expected behaviour
----------------------------------------
Should save as normal
Environment information
----------------------------------------
* __CiviCRM:__ _Master_
Comments
----------------------------------------
Also tested on test site for https://github.com/civicrm/civicrm-core/pull/18710 (ie not fixed by PR 18710)
Regression since 5.28.25.31.1https://lab.civicrm.org/dev/core/-/issues/2101Add relationship start date logic to the existing Civi scheduled job for rela...2023-05-22T05:03:24ZshitijgAdd relationship start date logic to the existing Civi scheduled job for relationshipsOverview
----------------------------------------
If a user creates a relationships with a future start date:
- The relationship shows in the ‘active’ relationships section
- is_active field of the relationship is set as 1
As CiviCRM t...Overview
----------------------------------------
If a user creates a relationships with a future start date:
- The relationship shows in the ‘active’ relationships section
- is_active field of the relationship is set as 1
As CiviCRM treats this as an ‘active relationship’, so does webform_civicrm, which means users can select a contact with this relationship (through setting the existing contact field show contacts with this relationship) even if the start date is in the future
Example use-case
----------------------------------------
1. Go to a contact
2. Add a relationship with start date in future ie start date > today (and no end date)
3. Save relationship
4. is_active field for the relationship (check civicrm_relationship table) is set to 1
Current behaviour
----------------------------------------
On creation / updating of a relationship with a future start date (start date>today), CiviCRM sets the is_active field = 1
Proposed behaviour
----------------------------------------
On creation / updating of a relationship with a future start date (start date>today):
- SET is_active =0
Add to the logic of the existing relationship expiry scheduled job (Disable expired relationships) which sets the is_active field to 0 for relationships where end date is in the past:
- Update 'Title' to: Enable and Disable relationships
- Help text:
Enables relationships where start date < = today (ie those relationships whose start date is today / in the past)
Disables relationships that have expired (ie. those relationships whose end date is in the past).
- Logic: Along with the existing logic (for disabling expired relationships), we are adding the following logic to the same scheduled job:
Sets the relationship is_active field = 1 for relationships where start date < = today AND end date >today (ie those relationships whose start date is today / in the past)https://lab.civicrm.org/dev/core/-/issues/2100A/B testing report should show unique opens, not total opens2022-09-27T08:37:01ZlarsssandergreenA/B testing report should show unique opens, not total opensThe A/B testing page shows the total number of opens for the A and B emails. The relevant data to make the decision about which subject to use for the remainder of your list is definitely unique opens (sometimes, one or more contacts can...The A/B testing page shows the total number of opens for the A and B emails. The relevant data to make the decision about which subject to use for the remainder of your list is definitely unique opens (sometimes, one or more contacts can have double digit opens reported, which can change the result significantly).
[Brief discussion on Stack Exchange.](https://civicrm.stackexchange.com/questions/3307/how-to-get-a-b-testing-on-the-number-of-unique-open)https://lab.civicrm.org/dev/core/-/issues/2099Advanced Search: Search profiles don't work, they only show FN/LN2023-05-14T05:03:23ZBetty DolfingAdvanced Search: Search profiles don't work, they only show FN/LNChanging the search profile in Advanced Search, does not result in showing the different columns.
Reproduction steps
----------------------------------------
1. Click on **Advanced Search - Search**
I expect to see the list of all cont...Changing the search profile in Advanced Search, does not result in showing the different columns.
Reproduction steps
----------------------------------------
1. Click on **Advanced Search - Search**
I expect to see the list of all contacts in CiviCRM, including address / email info etc in the columns. This is OK.
2. Click on **Advanced Search - change the "Views For Display Contacts"** into a Search profile you have created - **Search**.
I expect to see the list of all contacts in CiviCRM, with the columns shown that I added to my Search Profile.
However, I now only see the LN/FN, but no other data. This is **not OK. **
I tested it in my own environment (5.29.1) but also in dmaster (5.31.alpha1), both with the same result. ![Advanced_Search_-_Search_Profile](/uploads/a06d3f83976ae884199749edcae3151a/Advanced_Search_-_Search_Profile.webm)https://lab.civicrm.org/dev/core/-/issues/2098testMailReportForPrint outputs screeds of stuff into test log - fix2023-05-18T05:03:26ZeileentestMailReportForPrint outputs screeds of stuff into test log - fixhttps://lab.civicrm.org/dev/core/-/issues/2097Remove CIVICRM_FLEXMAILER_HACK_DELIVER2023-05-16T05:03:25ZeileenRemove CIVICRM_FLEXMAILER_HACK_DELIVERI started looking at fixing the memory leaks in MailingJob::runJobs (see #2073) - which is tested via MailingJob:;testMailerSendTest_email but the fact we pass $job out - to use memory & queries efficiently $job should be a CRM_Core_DAO:...I started looking at fixing the memory leaks in MailingJob::runJobs (see #2073) - which is tested via MailingJob:;testMailerSendTest_email but the fact we pass $job out - to use memory & queries efficiently $job should be a CRM_Core_DAO::executeQuery() object but it is a ```CRM_Mailing_BAO_MailingJob``` - there are also a couple of places that call functions on it that could be called statically if it were a $dao
Basically we should clear the mess up - or as a minimum for this ticket remove those weird constants CIVICRM_FLEXMAILER_HACK_DELIVER
@jamie @seamuslee @mattwire @tottenhttps://lab.civicrm.org/dev/core/-/issues/2096Creating new event without email fails2020-10-08T19:41:38Zaydunsaidan.saunders@squiffle.ukCreating new event without email failsOverview
----------------------------------------
Creating a new event without an email produces `Mandatory values missing from Api4 Email::save: email` failure
Reproduction steps
----------------------------------------
1. Click on **E...Overview
----------------------------------------
Creating a new event without an email produces `Mandatory values missing from Api4 Email::save: email` failure
Reproduction steps
----------------------------------------
1. Click on **Events -> New Event**.
1. Enter mandatory fields **Event Type**, **Default Role**, **Event Title** and **Start** and click **Continue**.
1. Observe Email is not required
1. Click **Save and Done**
Current behaviour
----------------------------------------
Error: `Mandatory values missing from Api4 Email::save: email`
Expected behaviour
----------------------------------------
No error!
Environment information
----------------------------------------
* __CiviCRM:__ _Master_
Comments
----------------------------------------
Verified on dmaster5.31.0https://lab.civicrm.org/dev/core/-/issues/2095Switch "Online Pay now" functionality to payment create API2023-05-15T05:03:21Zmagnolia61Switch "Online Pay now" functionality to payment create APIOverview
----------------------------------------
The Online Pay now functionality where a user can pay towards a contribution still used the old way of recording a payment. The new record payment form is currently only a backend form.
...Overview
----------------------------------------
The Online Pay now functionality where a user can pay towards a contribution still used the old way of recording a payment. The new record payment form is currently only a backend form.
It would be very helpful if the Pay Now switches to use that form but in a frontend user exposed way.
This will help customers to pay via the dashboard and checksum link. Also this will enable frontend customer payments towards partial paid contributions.
Example use-case
----------------------------------------
1. Go to user dashboard
2. Pay a contribution with status pending (status partially paid has no Pay button atm)
3. The contribution is handles via a contribution page and not the record payment form
Current behaviour
----------------------------------------
Online Pay now by user dashboard button or checksum link do not user payment create api
Proposed behaviour
----------------------------------------
Let the (frontend) Pay now use the record payment form but in a frontend way with live payment processors.
Comments
----------------------------------------
References to relevant issues and PR's:<br>
https://github.com/civicrm/civicrm-core/pull/12319<br>
https://github.com/civicrm/civicrm-core/pull/14673https://lab.civicrm.org/dev/core/-/issues/2094composer install fails on patch to - Applying patches for adrienrn/php-mimetyper2023-06-11T05:03:26ZHeneryHcomposer install fails on patch to - Applying patches for adrienrn/php-mimetyper
```
- Installing adrienrn/php-mimetyper (0.2.2): Loading from cache
- Applying patches for adrienrn/php-mimetyper
https://patch-diff.githubusercontent.com/raw/adrienrn/php-mimetyper/pull/15.patch (Update gitignore to ensure tha...
```
- Installing adrienrn/php-mimetyper (0.2.2): Loading from cache
- Applying patches for adrienrn/php-mimetyper
https://patch-diff.githubusercontent.com/raw/adrienrn/php-mimetyper/pull/15.patch (Update gitignore to ensure that sites that manage via git don't miss out on the important db.json file)
Could not apply patch! Skipping. The error was: Cannot apply patch https://patch-diff.githubusercontent.com/raw/adrienrn/php-mimetyper/pull/15.patch
Installation failed, reverting ./composer.json to its original content.
[Exception]
Cannot apply patch Update gitignore to ensure that sites that manage via git don't miss out on the important db.jso
n file (https://patch-diff.githubusercontent.com/raw/adrienrn/php-mimetyper/pull/15.patch)!
```https://lab.civicrm.org/dev/core/-/issues/2093Undefined index 'class' on new individual form2020-10-06T23:51:30ZDaveDUndefined index 'class' on new individual formIt's probably not limited to new individual, but [this recent commit](https://github.com/civicrm/civicrm-core/commit/4367e9641356b13764aceb289c46b6023c6c6bb8#diff-bdea9a3ec62827e6c90a70202ea9f7ccR797) added a line that generates the noti...It's probably not limited to new individual, but [this recent commit](https://github.com/civicrm/civicrm-core/commit/4367e9641356b13764aceb289c46b6023c6c6bb8#diff-bdea9a3ec62827e6c90a70202ea9f7ccR797) added a line that generates the notice:
`$fieldAttributes['class'] .= ltrim($fieldAttributes['class'] ?? '' . ' crm-select2');`
You can't use `.=` if the variable isn't set yet, so this gives a red error box on the form. I thought I had written a test to catch generic red boxes on New Individual but maybe it's not a complete test.
Also while it ends up not mattering here, on the right-hand-side personally I think it's best to use brackets to be clear when using `??` and `.` at the same time, since the `.` ends up winning and can sometimes be a sneaky bug.5.31.0https://lab.civicrm.org/dev/core/-/issues/2092Dedupe SUBSTR scalability problems2023-05-13T05:03:22ZJoeMurrayDedupe SUBSTR scalability problemsOverview
----------------------------------------
_When length of field is used in dedupe rules, rules tend not to work even on medium size sites._
Reproduction steps
----------------------------------------
1. On a site with 70k contac...Overview
----------------------------------------
_When length of field is used in dedupe rules, rules tend not to work even on medium size sites._
Reproduction steps
----------------------------------------
1. On a site with 70k contacts, a dudupe rule was defined that included first name (length 1), last name, email, phone, postal code.
1. Check for dedupes times out after 20m. On different runs it also took down MySQL with out of memory, and caused restarts of php-fpm.
1. Changing rule to first name, last name, email, phone, postal code yields 18.5k potential duplicate pairs in 3 minutes.
1. FWIW, using the deduper extension from Eileen didn't help with batch limit of 1000, but did improve things with search limit of 1000.
Current behaviour
----------------------------------------
Timeouts, mysql restarts, php restarts when using length restrictions on fields.
Expected behaviour
----------------------------------------
No timeouts or process restarts on medium sized databases even when using length restrictions on fields.
Implementation Alternative
----------------------------------------
The problem seems to stem from subquery join on substring function, which is well known to be not optimizable by MySQL: ON (SUBSTR(t1.first_name, 1, 1) = SUBSTR(t2.first_name, 1, 1)). Instead of this approach, one can imagine using Temporary tables that include SUBSTR(t.first_name, 1, 1) as a field that has index, and then the join would be optimized. While we use temp tables in reports, they do have the potential of causing their own issues, but I believe they are much reduced from the current situation here.
We don't currently have funding to work on this. Nonetheless, I thought it would be useful to report the problem and ask if there is approval for the concept of using temp tables with indexed fields for dedupe search criteria based on substrings?
I've labelled this as both improvement and bug since it seems to straddle the divide.https://lab.civicrm.org/dev/core/-/issues/2091Participant join not working in search2020-12-17T20:00:42ZeileenParticipant join not working in searchURL
https://dmaster.demo.civicrm.org/civicrm/search#/create/Contact/?join=%5B%5B%22Participant%20AS%20participants%22,true%5D%5D
![Screen_Shot_2020-10-05_at_3.16.38_PM](/uploads/aaa16d483d6acf36f733d2335c608a26/Screen_Shot_2020-10-05_a...URL
https://dmaster.demo.civicrm.org/civicrm/search#/create/Contact/?join=%5B%5B%22Participant%20AS%20participants%22,true%5D%5D
![Screen_Shot_2020-10-05_at_3.16.38_PM](/uploads/aaa16d483d6acf36f733d2335c608a26/Screen_Shot_2020-10-05_at_3.16.38_PM.png)
@colemanw - reported by @JonGold on chathttps://lab.civicrm.org/dev/core/-/issues/2090Undefined index on contact's activity tab when there's an activity that has n...2020-10-03T23:07:08ZDaveDUndefined index on contact's activity tab when there's an activity that has no With ContactYou can't see the error because ajax swallows it, but you can:
1. Install the [loudnotices](https://lab.civicrm.org/extensions/loudnotices) extension.
2. Create an activity and leave the With Contact blank.
3. Visit the contact's activi...You can't see the error because ajax swallows it, but you can:
1. Install the [loudnotices](https://lab.civicrm.org/extensions/loudnotices) extension.
2. Create an activity and leave the With Contact blank.
3. Visit the contact's activity tab. It will hang.
4. Look in ConfigAndLog and you'll see the error/backtrace.
PR coming.5.31.0https://lab.civicrm.org/dev/core/-/issues/2089Error when trying to register a participant to an event2020-10-08T19:31:46ZSemperFiError when trying to register a participant to an eventHello
Registering event no longer works and I cannot find an explanation to this error.
<br>Based on user feedback, it has suddenly started to bug, without any specific actions from them before.
<br>Configuration is : civicrm 5.29.1 on w...Hello
Registering event no longer works and I cannot find an explanation to this error.
<br>Based on user feedback, it has suddenly started to bug, without any specific actions from them before.
<br>Configuration is : civicrm 5.29.1 on wordpress 5.5.1 / PHP 7.2.33-1+ubuntu20.04.1
<br>Cache have been cleaned using the civicrm admin. interface
<br>Log are below. Could you please help/advise
<br>Thanks in advance for your time
oct. 03 16:43:51 [error] $Fatal Error Details = Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)
[code] => -5
[message] => DB Error: already exists
[mode] => 16
[debug_info] => INSERT INTO `civicrm_activity` (`source_record_id` , `activity_type_id` , `subject` , `activity_date_time` , `status_id` , `priority_id` ) VALUES ( 10277 , 5 , 'Test - 1 oct. 2020 0:00 - Auditeur - Registered' , 20201003164351 , 2 , 2 ) [nativecode=1062 ** Duplicate entry '7555' for key 'PRIMARY']
[type] => DB_Error
[user_info] => INSERT INTO `civicrm_activity` (`source_record_id` , `activity_type_id` , `subject` , `activity_date_time` , `status_id` , `priority_id` ) VALUES ( 10277 , 5 , 'Test - 1 oct. 2020 0:00 - Auditeur - Registered' , 20201003164351 , 2 , 2 ) [nativecode=1062 ** Duplicate entry '7555' for key 'PRIMARY']
[to_string] => [db_error: message="DB Error: already exists" code=-5 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO `civicrm_activity` (`source_record_id` , `activity_type_id` , `subject` , `activity_date_time` , `status_id` , `priority_id` ) VALUES ( 10277 , 5 , 'Test - 1 oct. 2020 0:00 - Auditeur - Registered' , 20201003164351 , 2 , 2 ) [nativecode=1062 ** Duplicate entry '7555' for key 'PRIMARY']"]
)
oct. 03 16:43:51 [debug] $backTrace = #0 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(205): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(922): CRM_Core_Error::handle(Object(DB_Error))
#2 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/packages/DB.php(998): PEAR_Error->__construct("DB Error: already exists", -5, 16, (Array:2), "INSERT INTO `civicrm_activity` (`source_record_id` , `activity_type_id` , `su...")
#3 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(575): DB_Error->__construct(-5, 16, (Array:2), "INSERT INTO `civicrm_activity` (`source_record_id` , `activity_type_id` , `su...")
#4 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(223): PEAR->_raiseError(Object(DB_mysqli), NULL, -5, 16, (Array:2), "INSERT INTO `civicrm_activity` (`source_record_id` , `activity_type_id` , `su...", "DB_Error", TRUE)
#5 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1925): PEAR->__call("raiseError", (Array:7))
#6 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/packages/DB/mysqli.php(936): DB_common->raiseError(-5, NULL, NULL, "INSERT INTO `civicrm_activity` (`source_record_id` , `activity_type_id` , `su...", "1062 ** Duplicate entry '7555' for key 'PRIMARY'")
#7 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/packages/DB/mysqli.php(406): DB_mysqli->mysqliRaiseError()
#8 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1231): DB_mysqli->simpleQuery("INSERT INTO `civicrm_activity` (`source_record_id` , `activity_type_id` , `su...")
#9 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(2696): DB_common->query("INSERT INTO `civicrm_activity` (`source_record_id` , `activity_type_id` , `su...")
#10 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(1245): DB_DataObject->_query("INSERT INTO `civicrm_activity` (`source_record_id` , `activity_type_id` , `su...")
#11 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(625): DB_DataObject->insert()
#12 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Activity/BAO/Activity.php(339): CRM_Core_DAO->save()
#13 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Activity/BAO/Activity.php(1774): CRM_Activity_BAO_Activity::create((Array:11))
#14 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Event/BAO/Participant.php(194): CRM_Activity_BAO_Activity::addActivity(Object(CRM_Event_BAO_Participant))
#15 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Event/Form/Participant.php(1272): CRM_Event_BAO_Participant::create((Array:29))
#16 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Event/Form/Participant.php(988): CRM_Event_Form_Participant->submit((Array:29))
#17 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Core/Form.php(507): CRM_Event_Form_Participant->postProcess()
#18 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Core/QuickForm/Action/Upload.php(152): CRM_Core_Form->mainProcess()
#19 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Core/QuickForm/Action/Upload.php(119): CRM_Core_QuickForm_Action_Upload->realPerform(Object(CRM_Event_Form_Participant), "upload")
#20 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Upload->perform(Object(CRM_Event_Form_Participant), "upload")
#21 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Event_Form_Participant), "upload")
#22 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php(347): HTML_QuickForm_Page->handle("upload")
#23 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Event/Page/Tab.php(100): CRM_Core_Controller->run()
#24 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Event/Page/Tab.php(166): CRM_Event_Page_Tab->edit()
#25 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(312): CRM_Event_Page_Tab->run((Array:4), NULL)
#26 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(68): CRM_Core_Invoke::runItem((Array:12))
#27 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(36): CRM_Core_Invoke::_invoke((Array:4))
#28 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm.php(1654): CRM_Core_Invoke::invoke((Array:4))
#29 /var/www/html/civicrm/wp-includes/class-wp-hook.php(287): CiviCRM_For_WordPress->invoke("")
#30 /var/www/html/civicrm/wp-includes/class-wp-hook.php(311): WP_Hook->apply_filters("", (Array:1))
#31 /var/www/html/civicrm/wp-includes/plugin.php(478): WP_Hook->do_action((Array:1))
#32 /var/www/html/civicrm/wp-admin/admin.php(259): do_action("toplevel_page_CiviCRM")
#33 {main}https://lab.civicrm.org/dev/core/-/issues/2088Maximum Participant Count for Event not enforced in some situation (Wordpress...2023-05-23T05:03:28ZclementMaximum Participant Count for Event not enforced in some situation (Wordpress 5.0.8, CIVICRM 5.12.0, also observed on WP 5.4.2/CIVICRM 5.21.2))We saw recently that 2 event registration that were set to have a maximum number of participants. Event A has set to a maximum number of 29 but allowed 30, and Event B has set to a maximum number of 17 but allowed 19. Until these 2 event...We saw recently that 2 event registration that were set to have a maximum number of participants. Event A has set to a maximum number of 29 but allowed 30, and Event B has set to a maximum number of 17 but allowed 19. Until these 2 events, the maximum number has been enforced well on the events.
When I looked at the last few registrations (all frontend) for these 2 events, for Event A, the last registration registered 1min after the prior 2 registrations which registered at the same time to the minute. For Event B, the last 3 registrations where all registered at the same time to the minute. I tried to register for these events and the Event is full message is correctly shown.
Would this anomaly be due to how the registrations take place particularly when they are in close succession? Any advice and what can be done ? I researched on the net and it seems there was a issue about max participant enforcement (CRM5039), but that was more than ten years ago, that woulnd't be the issue by know i suppose. Any advise? Thanks.
After some fiddling around, I managed to get 2 participants into a event with a 1 participant limit using the following method:
- Participant A typing in his details to register for event
- Participant B registered later but completed his registration and pressed "Continue"
- Participant A pressed "Continue"
- Both participants pressed "Continue" together at the "Confirm Your Registration Information" page
This looks like a bug to me, any views ? Thanks.https://lab.civicrm.org/dev/core/-/issues/2087Remove extraneous UF match queries2020-10-07T19:48:51ZeileenRemove extraneous UF match queries
When calling contact.create the sequence is
1) create/ edit the contact
2) do any email adds / deletes requested - this requires
- if a primary email is added/ altered update the uf_name
3) update the the uf name
Within update the ...
When calling contact.create the sequence is
1) create/ edit the contact
2) do any email adds / deletes requested - this requires
- if a primary email is added/ altered update the uf_name
3) update the the uf name
Within update the uf name there are 2 queries to see if the update is needed
1) check if they have a primary address
2) check if they have a uf match
**Proposal**
1) Remove the update from Contact.create since it is done in Email.create
2) Add the update into Email.delete when promoting another email
3) check for uf_match before has primary when doing uf match
Sub-pr of #20335.31.0https://lab.civicrm.org/dev/core/-/issues/2086Editing an activity always logs a backtrace about duplicate key if you don't ...2023-07-11T05:03:30ZDaveDEditing an activity always logs a backtrace about duplicate key if you don't change the With Contacts@eileen One thing I'm seeing as a result of https://github.com/civicrm/civicrm-core/pull/18566 is that every time you edit an activity and save it it silently logs a backtrace for the PEAR error since the target contact always already ex...@eileen One thing I'm seeing as a result of https://github.com/civicrm/civicrm-core/pull/18566 is that every time you edit an activity and save it it silently logs a backtrace for the PEAR error since the target contact always already exists if you haven't changed it. I suppose edits are less common than new activities, so maybe it's still a net win, but logging a backtrace maybe is worse than an extra query.
To think about...
I haven't marked it regression since it's not a bug exactly.https://lab.civicrm.org/dev/core/-/issues/2085Word Replacements accessing legacy field that has no UI2023-05-15T05:03:22ZAlanDixonWord Replacements accessing legacy field that has no UIAs per https://civicrm.stackexchange.com/questions/37832/why-is-civicrm-mistranslating-my-string/37833#37833
When an older install has translations in the field civicrm_domain.locale_custom_strings, it can really confuse.
Based on the ...As per https://civicrm.stackexchange.com/questions/37832/why-is-civicrm-mistranslating-my-string/37833#37833
When an older install has translations in the field civicrm_domain.locale_custom_strings, it can really confuse.
Based on the last time this code was touched (https://github.com/civicrm/civicrm-core/commit/234d8f09414678e7b8e94cada91637de1f89e582) I'd think it's high time to get rid of that field?