Development issueshttps://lab.civicrm.org/groups/dev/-/issues2023-09-05T09:58:20Zhttps://lab.civicrm.org/dev/core/-/issues/3114CiviMail - Error on sending/viewing mail via Mosaico following core update2023-09-05T09:58:20ZsbyrneCiviMail - Error on sending/viewing mail via Mosaico following core updateWe're seeing the error: "DB Error: no such field" when trying to send email from Mosaico. This happens regardless of whether the email is a test, or going out to the intended recipients. The error appears immediately upon submitting the ...We're seeing the error: "DB Error: no such field" when trying to send email from Mosaico. This happens regardless of whether the email is a test, or going out to the intended recipients. The error appears immediately upon submitting the mailing.
We're also unable to view old mailings submitted via Mosico, with the same error appearing but as a webpage rather than a pop-up.
This started happening after we upgraded CiviCRM from 5.39.0 to 5.46.0.
"Traditional" mails are working fine (sending and viewing)
I've done a few basic things to fix the problem with no success:
- Cleaned all caches
- Tricked Civi into thinking it was running an older version of the database and upgraded again to rule out problems with the DB update
- Upgraded Civi to 5.47.0
- Updated Mosaico to 2.9, while also installing Form Core and Seatch kit. Completed additional database updates required by this.
The error that appears while sending the mailing doesn't leave anything in the error log. I do get the following when viewing old mailings though:
```
Mar 11 16:35:20 [error]
$Fatal Error Details = array:3 [
"message" => "DB Error: no such field"
"code" => null
"exception" => CiviCRM_API3_Exception {#3486
-extraParams: array:4 [
"error_code" => "no such field"
"tip" => "add debug=1 to your API call to have more info about the error"
"is_error" => 1
"error_message" => "DB Error: no such field"
]
#message: "DB Error: no such field"
#code: 0
#file: ".../sites/all/modules/civicrm/api/api.php"
#line: 134
trace: {
/.../sites/all/modules/civicrm/api/api.php:134 {
› if (is_array($result) && !empty($result['is_error'])) {
› throw new CiviCRM_API3_Exception($result['error_message'], CRM_Utils_Array::value('error_code', $result, 'undefined'), $result);
› }
}
/.../sites/all/modules/civicrm/CRM/Mailing/Page/View.php:148 { …}
/.../sites/all/modules/civicrm/CRM/Core/Invoke.php:319 { …}
/.../sites/all/modules/civicrm/CRM/Core/Invoke.php:69 { …}
/.../sites/all/modules/civicrm/CRM/Core/Invoke.php:36 { …}
/.../sites/all/modules/civicrm/drupal/civicrm.module:471 { …}
/.../domains/secure/htdocs/includes/menu.inc:527 { …}
/.../domains/secure/htdocs/index.php:21 { …}
}
}
]
Mar 11 16:35:20 [debug] $backTrace = #0 /.../domains/secure/htdocs/sites/all/modules/civicrm/CRM/Core/Error.php(433): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /.../domains/secure/htdocs/sites/all/modules/civicrm/CRM/Core/Invoke.php(39): CRM_Core_Error::handleUnhandledException(Object(CiviCRM_API3_Exception))
#2 /.../domains/secure/htdocs/sites/all/modules/civicrm/drupal/civicrm.module(471): CRM_Core_Invoke::invoke((Array:3))
#3 /.../domains/secure/htdocs/includes/menu.inc(527): civicrm_invoke("mailing", "view")
#4 /.../domains/secure/htdocs/index.php(21): menu_execute_active_handler()
#5 {main}
```
Environment:
- Debian 10 (64 bit)
- MariaDB 10.3
- PHP 7.3
- Drupal 7.88
- CiviCRM 5.47.0
- Mosaico 2.9https://lab.civicrm.org/dev/core/-/issues/3887CiviMail failed with a loose translated message like "Sorry, error happened a...2022-10-20T19:45:37ZSylvain PlanteCiviMail failed with a loose translated message like "Sorry, error happened and your mail has not been record" whenever I tried to use a sample templateOverview
----------------------------------------
When we try to create a mass mailing message and use one of the sample template provided with CiviCRM, I get this message "Désolé, une erreur est survenue et vos informations n'ont pas ét...Overview
----------------------------------------
When we try to create a mass mailing message and use one of the sample template provided with CiviCRM, I get this message "Désolé, une erreur est survenue et vos informations n'ont pas été enregistrées". If I use a simplier template I made, it is working ok.
_If you have already posted on https://civicrm.stackexchange.com or https://chat.civicrm.org, please include the link to that conversation._
Reproduction steps
----------------------------------------
1. Click on **mass mailing**, **new mailing**
2. Fill all fields except **Campaign** and **Template** and then clicked **Save as draft**.
3. Got no error message.
4. Go back, click on **mass mailing**, **draft mailing**, find the draft and click **continue".
5. Choose a template in **template** field.
6. As soon as the template finish loading and autosave try to save it...
7. Got the error message "Désolé, une erreur est survenue et vos informations n'ont pas été enregistrées"
Current behaviour
----------------------------------------
Expected behaviour
----------------------------------------
Should save a draft and let me edit the mail template.
Environment information
----------------------------------------
* __Browser:__ _Chrome Version 106.0.5249.61 | Edge Version 105.0.1343.53
* __CiviCRM:__ _Master/5.50.1
* __PHP:__ _7.4.29
* __CMS:__ _WordPress 6.0.2
* __Database:__ _MariaDB 10.3.34
* __Web Server:__ _Apache 2.4.53
Comments
----------------------------------------
I have tried to reset CiviCRM cache and rebuild path but to no avail. Group are small, 2 or 3 email address. Work with a simple custom template. No recent update of WP or CiviCRM. We are just starting playing with mass mailing, so I can't tell for how long it has not been working. Also tested sending email to a group. Search contact, select a couple of contact, action->send immediate email, choose the sample template, fill the fields, send email, success! No problem. Seem to be related to how CiviMail store a mass mailing in db. Need help to debug further. Thank you.https://lab.civicrm.org/dev/core/-/issues/1034Clearing caches with OPCache enabled results in Fatal error about file not found2022-12-07T05:03:30ZjaapjansmaClearing caches with OPCache enabled results in Fatal error about file not foundI have a server with OPCache enabled and every time I visit the extension page or clear the civicrm cache with civicrm/clearcache?reset=1 civicrm will fail with the following error:
```
PHP Fatal error: require(): Failed opening requir...I have a server with OPCache enabled and every time I visit the extension page or clear the civicrm cache with civicrm/clearcache?reset=1 civicrm will fail with the following error:
```
PHP Fatal error: require(): Failed opening required '/home/civicrm/domains/civicrm.devz.no/private_html/sites/default/files/civicrm/templates_c//CachedExtLoader.46b570d6687674478a30918df6837257.php'
(include_path='.:/home/civicrm/domains/civicrm.devz.no/private_html/sites/all/modules/civicrm:/home/civicrm/domains/civicrm.devz.no/private_html/sites/all/modules/civicrm/packages:.:/home/civicrm/domains/civicrm.devz.no/public_html/sites/all/modules/civicrm:/home/civicrm/domains/civicrm.devz.no/public_html/sites/all/modules/civicrm/packages:/home/civicrm/domains/civicrm.devz.no/public_html/sites/all/modules/civicrm/vendor/tecnickcom:/home/civicrm/domains/civicrm.devz.no/public_html/sites/all/modules/civicrm/vendor/phpseclib/phpseclib/phpseclib:/home/civicrm/domains/civicrm.devz.no/public_html/sites/all/modules/civicrm/vendor/pear/pear_exception:/home/civicrm/domains/civicrm.devz.no/public_html/sites/all/modules/civicrm/vendor/pear/auth_sasl:/home/civicrm/domains/civicrm.devz.no/public_html/sites/all/modules/civicrm/vendor/pear/log
in /home/civicrm/domains/civicrm.devz.no/public_html/sites/all/modules/civicrm/CRM/Extension/ClassLoader.php on line 86\n
```https://lab.civicrm.org/dev/core/-/issues/777Contact ID column is not shown in the report Repeat results2023-02-06T07:53:29ZGhost UserContact ID column is not shown in the report Repeat resultsWhen you select the column 'Contact ID' it doesn't show in the report results.
![Contact_ID_doesn_t_show_on_Repeat](/uploads/457e815634fb568aaf005582ae7c932b/Contact_ID_doesn_t_show_on_Repeat.png)When you select the column 'Contact ID' it doesn't show in the report results.
![Contact_ID_doesn_t_show_on_Repeat](/uploads/457e815634fb568aaf005582ae7c932b/Contact_ID_doesn_t_show_on_Repeat.png)https://lab.civicrm.org/dev/core/-/issues/1504Contribution note removed when edited contribution2023-01-29T05:03:15ZtapashContribution note removed when edited contributionOverview
----------------------------------------
Contribution note does not retrieve when editing a contribution, therefore it gets deleted when saved the contribution.
Reproduction steps
----------------------------------------
1. Cli...Overview
----------------------------------------
Contribution note does not retrieve when editing a contribution, therefore it gets deleted when saved the contribution.
Reproduction steps
----------------------------------------
1. Click on **Edit contribution of any individual**.
1. clicked **Save**.
1. Got a message "Deleted - Selected Note has been deleted successfully."
Current behaviour
----------------------------------------
notes field blank althogh there was a message save in previous edit.
![Screenshot_2020-01-01_at_23.17.57](/uploads/9f9555b85ded80e5f41af0bc7ffcf180/Screenshot_2020-01-01_at_23.17.57.png)
Expected behaviour
----------------------------------------
message should show when editing
Environment information
----------------------------------------
* __CiviCRM:_5.20.3https://lab.civicrm.org/dev/core/-/issues/3200Contributions search result summary not correct2023-12-19T05:03:24ZhfarooqContributions search result summary not correctCMS: Drupal 7.69
CiviCRM: 5.21.3
If contributions with status complete and for "Contributions OR Soft Credits?" field, select "Both" (both contributions and soft credits), in result summary there is a discrepancy seen; Number of total r...CMS: Drupal 7.69
CiviCRM: 5.21.3
If contributions with status complete and for "Contributions OR Soft Credits?" field, select "Both" (both contributions and soft credits), in result summary there is a discrepancy seen; Number of total results does not match with the sum of total contributions and soft credits, please see attached screenshot. I was able to replicate it on [dmaster demo](https://dmaster.demo.civicrm.org/) site at some point back few days but not anymore.
![image](/uploads/655780b5f00f98abf880697baac2aa9c/image.png)https://lab.civicrm.org/dev/core/-/issues/4843CronJob for smart group rebuild / cache purge not working2024-01-15T13:12:26ZTobias Voigttobias.voigt@civiservice.deCronJob for smart group rebuild / cache purge not workingI love the idea of being able to use smart / dynamic groups for our client's projects. In one particular case I'm heavily relying on CiviCRM relationships to mirror the organization's structures. Yet I would like to set up accompanying s...I love the idea of being able to use smart / dynamic groups for our client's projects. In one particular case I'm heavily relying on CiviCRM relationships to mirror the organization's structures. Yet I would like to set up accompanying smart groups, that reflect certain relationships (or combination of relationships) to be able to address those smart groups in mailings or use them in the context of ACLs.
The problem I experienced over and over is that **the rebuild process of the smart group cache doesn't work reliably.**
I tested the two existing cronjobs for the rebuild process **Job.group_rebuild** and **Job.group_cache_flush** - yet they don't actually do what they're supposed to do, independent of the sequence in which I trigger them.
Only when I manually purge the system's cache (after I executed those cronjobs), the rebuilt smart groups are shown in the system. It might be possible that only the "**Job.group_cache_flush**" doesn't work correctly and therefore the smart groups are rebuilt by "**Job.group_rebuild**" but the result isn't shown in the system since the cache doesn't get purged.
I was able to reproduce this behaviour on several systems.https://lab.civicrm.org/dev/core/-/issues/619Custom field of type contact reference stopped working2019-01-03T00:27:11ZPradeep Nayakpradpnayak@gmail.comCustom field of type contact reference stopped workingCustom field of type contact reference stopped working for address field when upgraded to 5.8.1 from 4.7.31
The commit that might have caused this break is https://github.com/civicrm/civicrm-core/pull/12790/files#diff-bdea9a3ec62827e6c9...Custom field of type contact reference stopped working for address field when upgraded to 5.8.1 from 4.7.31
The commit that might have caused this break is https://github.com/civicrm/civicrm-core/pull/12790/files#diff-bdea9a3ec62827e6c90a70202ea9f7ccL1066
![Screen_Shot_2018-12-22_at_23.25.10](/uploads/0b37ef9862869048426f122485447c15/Screen_Shot_2018-12-22_at_23.25.10.png)5.9https://lab.civicrm.org/dev/core/-/issues/1078Customers being charged double randomly2022-11-15T05:03:39ZSohalKhatwaniCustomers being charged double randomlyWe are using Core CiviCRM and the customers are now being charged double for their memberships and 2 payments are being taken. We are on the 5.13.5 and don't see any issues which would cause this. It is a live site with alot of membershi...We are using Core CiviCRM and the customers are now being charged double for their memberships and 2 payments are being taken. We are on the 5.13.5 and don't see any issues which would cause this. It is a live site with alot of memberships coming through. Can anyone help.https://lab.civicrm.org/dev/translation/-/issues/20DB Error: no such table when executing schedule jobs2022-11-07T18:05:35ZYepaDB Error: no such table when executing schedule jobsWe've a single language installation with CiviCRM 5.6.1 & Drupal 7
After we've enabled the "Multiple Language" option under "Multiple Languages Support" section in the config page:
https://www.domain.org/civicrm/admin/setting/localiz...We've a single language installation with CiviCRM 5.6.1 & Drupal 7
After we've enabled the "Multiple Language" option under "Multiple Languages Support" section in the config page:
https://www.domain.org/civicrm/admin/setting/localization?reset=1
If we prepare a mailing with a language different from the language interface, when we execute the schedule jobs, we have the following error:
```
Feb 14 18:17:32 [info] $Fatal Error Details = Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)
[code] => -18
[message] => DB Error: no such table
[mode] => 16
[debug_info] => select id, extends, extends_entity_column_value, style from civicrm_custom_group__en_US where is_active = 1 [nativecode=1146 ** Table 'drupal.civicrm_custom_group__en_US' doesn't exist]
[type] => DB_Error
[user_info] => select id, extends, extends_entity_column_value, style from civicrm_custom_group__en_US where is_active = 1 [nativecode=1146 ** Table 'drupal.civicrm_custom_group__en_US' doesn't exist]
[to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::handle prefix="" info="select id, extends, extends_entity_column_value, style from civicrm_custom_group__en_US where is_activ$
)
Feb 14 18:17:32 [info] $backTrace = #0 /var/www/drupal/public_html/sites/all/modules/civicrm/CRM/Core/Error.php(232): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 /var/www/drupal/public_html/sites/all/modules/civicrm/packages/PEAR.php(921): call_user_func((Array:2), Object(DB_Error))
#3 /var/www/drupal/public_html/sites/all/modules/civicrm/packages/DB.php(985): PEAR_Error->__construct("DB Error: no such table", -18, 16, (Array:2), "select id, extends, extends_entity_column_value, style from civicrm_custom_gr...")
#4 /var/www/drupal/public_html/sites/all/modules/civicrm/packages/PEAR.php(575): DB_Error->__construct(-18, 16, (Array:2), "select id, extends, extends_entity_column_value, style from civicrm_custom_gr...")
#5 [internal function](): PEAR->_raiseError(Object(DB_mysqli), NULL, -18, NULL, NULL, "select id, extends, extends_entity_column_value, style from civicrm_custom_gr...", "DB_Error", TRUE)
#6 /var/www/drupal/public_html/sites/all/modules/civicrm/packages/PEAR.php(224): call_user_func_array((Array:2), (Array:8))
#7 /var/www/drupal/public_html/sites/all/modules/civicrm/packages/DB/common.php(1907): PEAR->__call("raiseError", (Array:7))
#8 /var/www/drupal/public_html/sites/all/modules/civicrm/packages/DB/common.php(1907): PEAR->raiseError(NULL, -18, NULL, NULL, "select id, extends, extends_entity_column_value, style from civicrm_custom_gr...", "DB_Error", TRUE)
#9 /var/www/drupal/public_html/sites/all/modules/civicrm/packages/DB/mysqli.php(933): DB_common->raiseError(-18, NULL, NULL, NULL, "1146 ** Table 'drupal.civicrm_custom_group__en_US' doesn't exist")
#10 /var/www/drupal/public_html/sites/all/modules/civicrm/packages/DB/mysqli.php(403): DB_mysqli->mysqliRaiseError()
#11 /var/www/drupal/public_html/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysqli->simpleQuery("select id, extends, extends_entity_column_value, style from civicrm_custom_gr...")
#12 /var/www/drupal/public_html/sites/all/modules/civicrm/packages/DB/DataObject.php(2415): DB_common->query("select id, extends, extends_entity_column_value, style from civicrm_custom_gr...")
#13 /var/www/drupal/public_html/sites/all/modules/civicrm/packages/DB/DataObject.php(1607): DB_DataObject->_query("select id, extends, extends_entity_column_value, style from civicrm_custom_gr...")
#14 /var/www/drupal/public_html/sites/all/modules/civicrm/CRM/Core/DAO.php(438): DB_DataObject->query("select id, extends, extends_entity_column_value, style from civicrm_custom_gr...")
#15 /var/www/drupal/public_html/sites/all/modules/civicrm/CRM/Core/DAO.php(1411): CRM_Core_DAO->query("select id, extends, extends_entity_column_value, style from civicrm_custom_gr...", TRUE)
#16 /var/www/drupal/public_html/sites/all/modules/civicrm/drupal/modules/views/components/civicrm.core.inc(3119): CRM_Core_DAO::executeQuery("select id, extends, extends_entity_column_value, style from civicrm_custom_gr...")
#17 /var/www/drupal/public_html/sites/all/modules/civicrm/drupal/modules/views/civicrm.views.inc(87): _civicrm_core_data((Array:301), (Array:8))
#18 /var/www/drupal/public_html/sites/all/modules/contrib/views/includes/cache.inc(93): civicrm_views_data_alter((Array:301))
#19 /var/www/drupal/public_html/sites/all/modules/contrib/views/includes/cache.inc(37): _views_fetch_data_build()
#20 /var/www/drupal/public_html/sites/all/modules/contrib/views/views.module(1319): _views_fetch_data("twitter", FALSE, FALSE)
#21 /var/www/drupal/public_html/sites/all/modules/contrib/views/views.module(1655): views_fetch_data("twitter", FALSE)
#22 /var/www/drupal/public_html/sites/all/modules/contrib/views/includes/view.inc(277): views_move_table("twitter")
#23 /var/www/drupal/public_html/sites/all/modules/contrib/views/views.module(1643): view->update()
#24 /var/www/drupal/public_html/sites/all/modules/contrib/views/views.module(762): views_get_view("tweets")
#25 [internal function](): views_block_view("tweets-block")
#26 /var/www/drupal/public_html/includes/module.inc(934): call_user_func_array("views_block_view", (Array:1))
#27 /var/www/drupal/public_html/modules/block/block.module(911): module_invoke("views", "block_view", "tweets-block")
#28 /var/www/drupal/public_html/modules/block/block.module(690): _block_render_blocks((Array:1))
#29 /var/www/drupal/public_html/modules/block/block.module(319): block_list("footer3")
#30 /var/www/drupal/public_html/modules/block/block.module(270): block_get_blocks_by_region("footer3")
#31 /var/www/drupal/public_html/includes/common.inc(5914): block_page_build((Array:11))
#32 /var/www/drupal/public_html/includes/common.inc(2761): drupal_render_page("\n<div id=\"crm-container\" class=\"crm-container\" lang=\"en\" xml:lang=\"en...")
#33 /var/www/drupal/public_html/includes/common.inc(2634): drupal_deliver_html_page("\n<div id=\"crm-container\" class=\"crm-container\" lang=\"en\" xml:lang=\"en...")
#34 /var/www/drupal/public_html/includes/menu.inc(542): drupal_deliver_page("\n<div id=\"crm-container\" class=\"crm-container\" lang=\"en\" xml:lang=\"en...", "")
#35 /var/www/drupal/public_html/index.php(21): menu_execute_active_handler()
#36 {main}
```
The global $dbLocale is equal to '__en_US' because it's not correctly set in the public function setLocale($locale) of i18n.php. The $locale is equal to '_en_US' when the fatal error occurred.
```
/**
* Change the processing language without changing the current user language
*
* @param $locale
* Locale (for example 'en_US', or 'fr_CA').
* True if the domain was changed for an extension.
*/
public function setLocale($locale) {
// Change the language of the CMS as well, for URLs.
CRM_Utils_System::setUFLocale($locale);
// change the gettext ressources
if ($this->_nativegettext) {
$this->setNativeGettextLocale($locale);
}
else {
// phpgettext
$this->setPhpGettextLocale($locale);
}
// for sql queries
global $dbLocale;
$dbLocale = "_{$locale}";
}
```
"inherit locale" option is enabled and no cache error.
Here is the backtrace from setLocale function: [locale_not_well_set_error.txt](/uploads/29d6263e244abc1d0973ff4679463615/locale_not_well_set_error.txt)
I tried without sendgrid extension, the error was the same.https://lab.civicrm.org/dev/drupal/-/issues/60Drupal 8 doesn't see routes for mailchimp extension2019-04-26T20:13:29ZjohnkDrupal 8 doesn't see routes for mailchimp extensionsee also: https://github.com/veda-consulting/uk.co.vedaconsulting.mailchimp/issues/321
I get a 404 for all the pages specific to the mailchimp extension, when running under a D8 site.
I'm unsure whether this is a bug in the extension i...see also: https://github.com/veda-consulting/uk.co.vedaconsulting.mailchimp/issues/321
I get a 404 for all the pages specific to the mailchimp extension, when running under a D8 site.
I'm unsure whether this is a bug in the extension itself, or the civicrm-drupal-8 module, so I thought I'd open an issue here, as well.https://lab.civicrm.org/dev/core/-/issues/458Drupal users are not creating after creation of civicrm profile user.2018-10-22T07:06:23Zrevati_gawasDrupal users are not creating after creation of civicrm profile user.I’am currently using CiviCRM version 4.7.30 with Drupal 8.5.1.
1. Selected drupal `Account creation required` under profile.
2. Added one CiviCRM profile using Contribution page.
3. While making Contribution by anonymous user CiviCRM pro...I’am currently using CiviCRM version 4.7.30 with Drupal 8.5.1.
1. Selected drupal `Account creation required` under profile.
2. Added one CiviCRM profile using Contribution page.
3. While making Contribution by anonymous user CiviCRM profile user is created.
4. But Drupal user is not getting created.https://lab.civicrm.org/dev/drupal/-/issues/84Drupal7: use label instead of name in membership views2023-11-09T23:27:57ZwdecraeneDrupal7: use label instead of name in membership viewsIn `drupal/modules/views/components/civicrm.member.inc` add two times 'pseudo args' so (translated) labels are used instead of machine names.
```php
//Membership Status
$data['civicrm_membership']['status'] = array(
'title' => t...In `drupal/modules/views/components/civicrm.member.inc` add two times 'pseudo args' so (translated) labels are used instead of machine names.
```php
//Membership Status
$data['civicrm_membership']['status'] = array(
'title' => t('Status'),
'real field' => 'status_id',
'help' => t('The Status of the Membership'),
'field' => array(
'handler' => 'civicrm_handler_field_pseudo_constant',
'click sortable' => TRUE,
'pseudo class' => 'CRM_Member_PseudoConstant',
'pseudo method' => 'membershipStatus',
'pseudo args' => array(NULL, NULL, 'label'),
),
'argument' => array(
'handler' => 'views_handler_argument',
),
'filter' => array(
'handler' => 'civicrm_handler_filter_pseudo_constant',
'allow empty' => TRUE,
'pseudo class' => 'CRM_Member_PseudoConstant',
'pseudo method' => 'membershipStatus',
'pseudo args' => array(NULL, NULL, 'label'),
),
'sort' => array(
'handler' => 'views_handler_sort',
),
);
```https://lab.civicrm.org/dev/drupal/-/issues/57Editing contribution recorded as "Deleted Activity" when full log is enabled2021-02-04T19:23:38ZtapashEditing contribution recorded as "Deleted Activity" when full log is enabledIf an existing contribution edited when full log is enabled, it records in chage log as "Deleted Activity". Is this how it should be?If an existing contribution edited when full log is enabled, it records in chage log as "Deleted Activity". Is this how it should be?https://lab.civicrm.org/dev/core/-/issues/807Error in participant counts on events with waitlists2022-10-11T05:03:32ZCharlie DunlaveyError in participant counts on events with waitlistsThere seems to be a participant calculation error at a specific stage in the workflow for events using waitlists, which is making the waitlist feature unuseable.
When a place becomes available on an event with a waitlist, the reminder e...There seems to be a participant calculation error at a specific stage in the workflow for events using waitlists, which is making the waitlist feature unuseable.
When a place becomes available on an event with a waitlist, the reminder email is being sent correctly to the person at the top of the waitlist, but when this user clicks on the registration link in the email, they see the 'Oops, it looks like there are no spaces' message.
At the confirmation page stage, it looks like Civi is counting all participants as opposed to just those with counted set to true. Are you able to take a look?
Thank you,
Charliehttps://lab.civicrm.org/dev/core/-/issues/923Error when creating profile or accessing profile2020-03-25T02:16:30ZtapashError when creating profile or accessing profileNotice: Undefined variable: otherModuleString in CRM_UF_Form_Group->getOtherModuleString() (line 430 of /home/webadmin/public_html/cmm-uat/sites/all/modules/civicrm/CRM/UF/Form/Group.php).Notice: Undefined variable: otherModuleString in CRM_UF_Form_Group->getOtherModuleString() (line 430 of /home/webadmin/public_html/cmm-uat/sites/all/modules/civicrm/CRM/UF/Form/Group.php).5.25.0https://lab.civicrm.org/dev/drupal/-/issues/126Error when merging contacts2020-07-23T16:00:03ZhowardshandError when merging contactsAfter an upgrade to Civi 5.23 on Drupal 7 started experiencing an issue during contact merges:
```
backTrace
#0 sites\all\modules\civicrm\CRM\Core\Error.php(148): CRM_Core_Error::backtrace()
#1 sites\all\modules\civicrm\vendor\pear\pear...After an upgrade to Civi 5.23 on Drupal 7 started experiencing an issue during contact merges:
```
backTrace
#0 sites\all\modules\civicrm\CRM\Core\Error.php(148): CRM_Core_Error::backtrace()
#1 sites\all\modules\civicrm\vendor\pear\pear-core-minimal\src\PEAR.php(922): CRM_Core_Error::handle(Object(DB_Error))
#2 sites\all\modules\civicrm\packages\DB.php(997): PEAR_Error->__construct("DB Error: already exists", -5, 16, (Array:2), "UPDATE civicrm_activity_contact SET contact_id = 150 WHERE contact_id = 54501...")
#3 sites\all\modules\civicrm\vendor\pear\pear-core-minimal\src\PEAR.php(575): DB_Error->__construct(-5, 16, (Array:2), "UPDATE civicrm_activity_contact SET contact_id = 150 WHERE contact_id = 54501...")
#4 sites\all\modules\civicrm\vendor\pear\pear-core-minimal\src\PEAR.php(223): PEAR->_raiseError(Object(DB_mysqli), NULL, -5, 16, (Array:2), "UPDATE civicrm_activity_contact SET contact_id = 150 WHERE contact_id = 54501...", "DB_Error", TRUE)
#5 sites\all\modules\civicrm\packages\DB\common.php(1925): PEAR->__call("raiseError", (Array:7))
#6 sites\all\modules\civicrm\packages\DB\mysqli.php(935): DB_common->raiseError(-5, NULL, NULL, "UPDATE civicrm_activity_contact SET contact_id = 150 WHERE contact_id = 54501...", "1062 ** Duplicate entry '150-7752-3' for key 'UI_activity_contact'")
#7 sites\all\modules\civicrm\packages\DB\mysqli.php(405): DB_mysqli->mysqliRaiseError()
#8 sites\all\modules\civicrm\packages\DB\common.php(1231): DB_mysqli->simpleQuery("UPDATE civicrm_activity_contact SET contact_id = 150 WHERE contact_id = 54501")
#9 sites\all\modules\civicrm\packages\DB\DataObject.php(2696): DB_common->query("UPDATE civicrm_activity_contact SET contact_id = 150 WHERE contact_id = 54501")
#10 sites\all\modules\civicrm\packages\DB\DataObject.php(1829): DB_DataObject->_query("UPDATE civicrm_activity_contact SET contact_id = 150 WHERE contact_id = 54501")
#11 sites\all\modules\civicrm\CRM\Core\DAO.php(421): DB_DataObject->query("UPDATE civicrm_activity_contact SET contact_id = 150 WHERE contact_id = 54501")
#12 sites\all\modules\civicrm\CRM\Core\DAO.php(1473): CRM_Core_DAO->query("UPDATE civicrm_activity_contact SET contact_id = 150 WHERE contact_id = 54501", TRUE)
#13 sites\all\modules\civicrm\CRM\Dedupe\Merger.php(563): CRM_Core_DAO::executeQuery("UPDATE civicrm_activity_contact SET contact_id = 150 WHERE contact_id = 54501", (Array:0), TRUE, NULL, TRUE)
#14 sites\all\modules\civicrm\CRM\Dedupe\Merger.php(1316): CRM_Dedupe_Merger::moveContactBelongings(Object(CRM_Dedupe_MergeHandler), (Array:5), (Array:0))
#15 sites\all\modules\civicrm\CRM\Contact\Form\Merge.php(308): CRM_Dedupe_Merger::moveAllBelongings(150, 54501, (Array:16))
#16 sites\all\modules\civicrm\CRM\Core\Form.php(484): CRM_Contact_Form_Merge->postProcess()
#17 sites\all\modules\civicrm\CRM\Core\QuickForm\Action\Done.php(59): CRM_Core_Form->mainProcess()
#18 sites\all\modules\civicrm\packages\HTML\QuickForm\Controller.php(203): CRM_Core_QuickForm_Action_Done->perform(Object(CRM_Contact_Form_Merge), "done")
#19 sites\all\modules\civicrm\packages\HTML\QuickForm\Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Contact_Form_Merge), "done")
#20 sites\all\modules\civicrm\CRM\Core\Controller.php(335): HTML_QuickForm_Page->handle("done")
#21 sites\all\modules\civicrm\CRM\Utils\Wrapper.php(98): CRM_Core_Controller->run()
#22 sites\all\modules\civicrm\CRM\Core\Invoke.php(285): CRM_Utils_Wrapper->run("CRM_Contact_Form_Merge", "Merge Contact", (Array:0))
#23 sites\all\modules\civicrm\CRM\Core\Invoke.php(68): CRM_Core_Invoke::runItem((Array:13))
#24 sites\all\modules\civicrm\CRM\Core\Invoke.php(36): CRM_Core_Invoke::_invoke((Array:3))
#25 sites\all\modules\civicrm\drupal\civicrm.module(454): CRM_Core_Invoke::invoke((Array:3))
#26 includes\menu.inc(527): civicrm_invoke("contact", "merge")
#27 index.php(21): menu_execute_active_handler()
#28 {main}
Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
DB Error: already exists
Error Details
Database Error Code: Duplicate entry '150-7752-3' for key 'UI_activity_contact', 1062
Additional Details:
Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)
[code] => -5
[message] => DB Error: already exists
[mode] => 16
[debug_info] => UPDATE civicrm_activity_contact SET contact_id = 150 WHERE contact_id = 54501 [nativecode=1062 ** Duplicate entry '150-7752-3' for key 'UI_activity_contact']
[type] => DB_Error
[user_info] => UPDATE civicrm_activity_contact SET contact_id = 150 WHERE contact_id = 54501 [nativecode=1062 ** Duplicate entry '150-7752-3' for key 'UI_activity_contact']
[to_string] => [db_error: message="DB Error: already exists" code=-5 mode=callback callback=CRM_Core_Error::handle prefix="" info="UPDATE civicrm_activity_contact SET contact_id = 150 WHERE contact_id = 54501 [nativecode=1062 ** Duplicate entry '150-7752-3' for key 'UI_activity_contact']"]
)
Return to home page.
Fatal error: Uncaught CRM_Core_Exception: [0: Transaction integrity error: Expected to find active frame thrown in sites\all\modules\civicrm\Civi\Core\Transaction\Manager.php on line 93
```
This seems to be caused by the fact that we record activities for all of our mailings and merging records who were sent the same mailing is causing "Duplicate entry '150-7752-3' for key 'UI_activity_contact'". We have always done this though and have never had the error before.https://lab.civicrm.org/dev/core/-/issues/407Error with currency localization when recording a payment2019-03-07T09:36:01ZjohansError with currency localization when recording a paymentThis has been posted on stackexchange: https://civicrm.stackexchange.com/questions/26612/problem-with-incoerent-local-currency-in-contribution
I am using civicrm 5.4.1 with drupal 7.
My localization is Italian with decimal delimiter , (...This has been posted on stackexchange: https://civicrm.stackexchange.com/questions/26612/problem-with-incoerent-local-currency-in-contribution
I am using civicrm 5.4.1 with drupal 7.
My localization is Italian with decimal delimiter , (comma) in civicrm/admin/setting/localization?reset=1
When I confirm the record of a payment for a contribution the operation goes on forever and I have to exit the page although when I enter the contribution again the payment is registered.
When I look into the ajax requests with the Chrome DevTools I see that when the "record a new payment" popup is loaded it loads this script from the server (extract):
<span id='totalAmount'>
<select class="eight crm-select2 eight crm-form-select required" name="currency" id="currency">↵
<option value="EUR" selected="selected">EUR (€)</option>
</select> <input size="6" maxlength="14" name="total_amount" type="text" value="1.00" id="total_amount" class="eight six crm-form-text required" />
</span>
<span class="status">Balance Owed: € 1,00</span>
Why is the value in total_amount 1.00 and the value showed in the Balance Owed 1,00?
When I confirm and register the payment the loading of the page goes on forever and when I look into the DevTools I see that this happens as the ajax request answers with an error:
> Sorry, due to an error, we are unable to fulfill your request at the
> moment. You may want to contact your administrator or service provider
> with more details about what action you were performing when this
> occurred. amount is not a valid amount: 1.00
If I change the decimal delimiter to . (point) it works fine.
I have checked this on dmaster.demo.civicrm.org it it has the same problem.5.8https://lab.civicrm.org/dev/core/-/issues/789Event reg error when skipping additional contacts2019-03-18T00:07:09ZMartinEvent reg error when skipping additional contactsWe recently encountered a bug under some fairly specific conditions:
* Doing an event registration
* Multiple participants enabled
* User select >1 participant
* On one of the subsequent participants, chooses the "skip" option
* Att...We recently encountered a bug under some fairly specific conditions:
* Doing an event registration
* Multiple participants enabled
* User select >1 participant
* On one of the subsequent participants, chooses the "skip" option
* Attempts to pay using a real credit card on a live payment gateway (in our case using the iATS extension)
This was on Civi 5.9.1 with Drupal 7.63.
In this situation, we found the following error:
> Warning: Invalid argument supplied for foreach() in CRM_Event_Form_Rgistration_Confirm->cleanMoneyFields() (line 1357 of [drupal root]/sites/all/modules/civicrm/CRM/Event/Form/Registration/Confirm.php).
Creating a pull request to fix in progress. I'm confused though, is the codebase here or on github??5.13.0https://lab.civicrm.org/dev/core/-/issues/775Event registration being cancelled when IPN notification received2022-10-30T05:03:27Zvakeesan26Event registration being cancelled when IPN notification receivedWhen we use IPN [eg: Sage-pay] payment processor for event, If user click browser back button after reaching payment website and then confirm again CiviCRM creating new contribution for same participant record.
In this case after user co...When we use IPN [eg: Sage-pay] payment processor for event, If user click browser back button after reaching payment website and then confirm again CiviCRM creating new contribution for same participant record.
In this case after user completing the latest contribution successfully, few minutes later payment processor sending the cancelled notification for previous contribution [The Transaction timed-out.]
now the participant record also being cancelled because of that contribution is updated as cancelled.
![image](/uploads/eb57b13e0fdb5ddfdae39697bdd14895/image.png)
CiviCRM 5.10.4
CMS - Drupal - 7
Steps
1) Configure IPN Payment processor
![image](/uploads/3c103603e49d10001296dbfd2229fadc/image.png)
2) Register the event
![image](/uploads/2ac513a52dcba0dbdf5cd097f7f139c7/image.png)
3) Confirm the registration
![image](/uploads/4f25367935bf0c44972981c10bc0101c/image.png)
4) Click browser back button
![image](/uploads/e7bf60903a6ce91b73500ec4c371726e/image.png)
5) Click Go Back button
![image](/uploads/c42e4286e1078ed17a5ca7d2c315c275/image.png)
6) Again continue & confirm the registration
![image](/uploads/1fb4990faffce58bf0e3d8b79475bfb1/image.png)
7) Now we will have 2 contribution against one participant record [ one completed , one pending incomplete]
![image](/uploads/cb5f1873af5f5b84162ce30a74a556fe/image.png)
8) we will receive the "cancelled" notification from payment processor few minutes later [ The Transaction timed-out.]
To reproduce this step we can manually cancel the Pending incomplete transaction contribution
![image](/uploads/85c7bac67c5d4ee6c39d5d85ff8028a9/image.png)
9) Now event registration will be cancelled
![image](/uploads/7a3a52dfc4b400acf09e1be95b9f8bc1/image.png)