civirules issueshttps://lab.civicrm.org/extensions/civirules/-/issues2023-09-14T23:10:31Zhttps://lab.civicrm.org/extensions/civirules/-/issues/2Multiselect limit = 5 ?2023-09-14T23:10:31Zmagnolia61Multiselect limit = 5 ?I'm trying the recently added conditions:
(added with: https://lab.civicrm.org/extensions/civirules/commit/ed86b82075a4232b39820a366c9c903c89635a2e)
- event type
- participant status
Strangely enough they only show me 5 options to sele...I'm trying the recently added conditions:
(added with: https://lab.civicrm.org/extensions/civirules/commit/ed86b82075a4232b39820a366c9c903c89635a2e)
- event type
- participant status
Strangely enough they only show me 5 options to select, even when there are more to display.
To a programmers ear that hopefully rings a bell immediately. Otherwise it's needle & haystacktime :-)
BTW. shown are the first 5 event type options sorted alphabetically by label...CiviRules Sprint August 2019https://lab.civicrm.org/extensions/civirules/-/issues/7Disabling a rule then shows the search form in the popup2023-03-04T07:29:43ZErikHommelDisabling a rule then shows the search form in the popupCiviRules Sprint August 2019kainukkainukhttps://lab.civicrm.org/extensions/civirules/-/issues/10Error with prev_next_cache2023-03-04T07:29:44ZErikHommelError with prev_next_cacheCheck https://civicrm.stackexchange.com/questions/25677/civirules-issue-with-smart-groupsCheck https://civicrm.stackexchange.com/questions/25677/civirules-issue-with-smart-groupsCiviRules Sprint August 2019jaapjansmajaapjansmahttps://lab.civicrm.org/extensions/civirules/-/issues/18Condition "contact (not) in group" does not respect parent groups2023-03-04T07:29:44ZErikHommelCondition "contact (not) in group" does not respect parent groupsWhen I add a group A and a group B and make both groups children of group Master the following occurs:
* within the CiviCRM UI if I add contact 123 to group A and then check the contacts in the Master group, contact 123 shows up
* if I u...When I add a group A and a group B and make both groups children of group Master the following occurs:
* within the CiviCRM UI if I add contact 123 to group A and then check the contacts in the Master group, contact 123 shows up
* if I use the condition 'contact (not) in group' and set the parameter to group Master the condition will return invalid for contact 123
* if I use the condition 'contact (nto) in group' and set the parameter to group A the condition will return valid for contact 123
Desired behaviour is that the condition is also valid for group Master.CiviRules Sprint August 2019ErikHommelErikHommelhttps://lab.civicrm.org/extensions/civirules/-/issues/19CRM_Core_Error::fatal(" is not of type String") Fatal error when copying a re...2023-03-04T07:29:44ZajfasanoCRM_Core_Error::fatal(" is not of type String") Fatal error when copying a reserved profileWe are at CiviCRM 5.9.0 with CiviRules 2.4. I am not sure if this would have happened prior as I had not previously attempted to copy a profile. I went to copy the On Behalf Of Organization profile and got the error below that seems to ...We are at CiviCRM 5.9.0 with CiviRules 2.4. I am not sure if this would have happened prior as I had not previously attempted to copy a profile. I went to copy the On Behalf Of Organization profile and got the error below that seems to have been generated by the CiviRules extension. I deleted all of my custom rules and disabled the custom extensions that added them and the error persisted. I ran it through the debugger but cant, for the life of me, figure out what the issue is. I think I have either missed something or possibly messed something up.
Any ideas would be greatly appreciated.
Thanks in advance,
A.J.
```
***BACKTRACE***
#0 DRUPAL_ROOT/sites/all/civicrm/ext/ca.bidon.reporterror/CRM/ReportError/Utils.php(31): reporterror_civicrm_generatereport("GLoVA", (Array:2), NULL, (Array:0))
#1 DRUPAL_ROOT/sites/all/civicrm/ext/ca.bidon.reporterror/CRM/ReportError/Handler/FormsNoReferer.php(54): CRM_ReportError_Utils::sendReport((Array:2), (Array:0))
#2 DRUPAL_ROOT/sites/all/civicrm/ext/ca.bidon.reporterror/reporterror.php(168): CRM_ReportError_Handler_FormsNoReferer::handler((Array:2), (Array:0))
#3 DRUPAL_ROOT/sites/all/modules/contrib/civicrm/CRM/Core/Error.php(368): reporterror_civicrm_handler((Array:2))
#4 DRUPAL_ROOT/sites/all/modules/contrib/civicrm/CRM/Core/DAO.php(1550): CRM_Core_Error::fatal(" is not of type String")
#5 DRUPAL_ROOT/sites/all/modules/contrib/civicrm/CRM/Core/DAO.php(1396): CRM_Core_DAO::composeQuery("SELECT r.id AS rule_id, t.id AS trigger_id, t.class_name, r.trigger_params\n FROM `civirule_rule` r\n ...", (Array:2), TRUE)
#6 DRUPAL_ROOT/sites/all/civicrm/ext/org.civicoop.civirules/CRM/Civirules/BAO/Rule.php(221): CRM_Core_DAO::executeQuery("SELECT r.id AS rule_id, t.id AS trigger_id, t.class_name, r.trigger_params\n FROM `civirule_rule` r\n ...", (Array:2))
#7 DRUPAL_ROOT/sites/all/civicrm/ext/org.civicoop.civirules/CRM/Civirules/Trigger/Post.php(72): CRM_Civirules_BAO_Rule::findRulesByObjectNameAndOp(NULL, "create")
#8 DRUPAL_ROOT/sites/all/civicrm/ext/org.civicoop.civirules/civirules.php(266): CRM_Civirules_Trigger_Post::post("create", NULL, 78, Object(CRM_Core_BAO_UFField))
#9 DRUPAL_ROOT/sites/all/modules/contrib/civicrm/CRM/Utils/Hook.php(282): civirules_civicrm_post("create", NULL, 78, Object(CRM_Core_BAO_UFField))
#10 DRUPAL_ROOT/sites/all/modules/contrib/civicrm/CRM/Utils/Hook/DrupalBase.php(84): CRM_Utils_Hook->runHooks((Array:447), "civicrm_post", 4, "create", NULL, 78, Object(CRM_Core_BAO_UFField), NULL, NULL)
#11 DRUPAL_ROOT/sites/all/modules/contrib/civicrm/Civi/Core/CiviEventDispatcher.php(98): CRM_Utils_Hook_DrupalBase->invokeViaUF(4, "create", NULL, 78, Object(CRM_Core_BAO_UFField), NULL, NULL, "civicrm_post")
#12 DRUPAL_ROOT/sites/all/modules/contrib/civicrm/vendor/symfony/event-dispatcher/EventDispatcher.php(184): Civi\Core\CiviEventDispatcher::delegateToUF(Object(Civi\Core\Event\PostEvent), "hook_civicrm_post", Object(Civi\Core\CiviEventDispatcher))
#13 DRUPAL_ROOT/sites/all/modules/contrib/civicrm/vendor/symfony/event-dispatcher/EventDispatcher.php(46): Symfony\Component\EventDispatcher\EventDispatcher->doDispatch((Array:2), "hook_civicrm_post", Object(Civi\Core\Event\PostEvent))
#14 DRUPAL_ROOT/sites/all/modules/contrib/civicrm/Civi/Core/CiviEventDispatcher.php(47): Symfony\Component\EventDispatcher\EventDispatcher->dispatch("hook_civicrm_post", Object(Civi\Core\Event\PostEvent))
#15 DRUPAL_ROOT/sites/all/modules/contrib/civicrm/CRM/Utils/Hook.php(366): Civi\Core\CiviEventDispatcher->dispatch("hook_civicrm_post", Object(Civi\Core\Event\PostEvent))
#16 DRUPAL_ROOT/sites/all/modules/contrib/civicrm/CRM/Core/DAO.php(1674): CRM_Utils_Hook::post("create", NULL, 78, Object(CRM_Core_BAO_UFField))
#17 DRUPAL_ROOT/sites/all/modules/contrib/civicrm/CRM/Core/BAO/UFGroup.php(2714): CRM_Core_DAO::copyGeneric("CRM_Core_BAO_UFField", (Array:1), (Array:1))
#18 DRUPAL_ROOT/sites/all/modules/contrib/civicrm/CRM/UF/Page/Group.php(207): CRM_Core_BAO_UFGroup::copy("9")
#19 DRUPAL_ROOT/sites/all/modules/contrib/civicrm/CRM/UF/Page/Group.php(187): CRM_UF_Page_Group->copy()
#20 DRUPAL_ROOT/sites/all/modules/contrib/civicrm/CRM/Core/Invoke.php(309): CRM_UF_Page_Group->run((Array:4), NULL)
#21 DRUPAL_ROOT/sites/all/modules/contrib/civicrm/CRM/Core/Invoke.php(84): CRM_Core_Invoke::runItem((Array:16))
#22 DRUPAL_ROOT/sites/all/modules/contrib/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:4))
#23 DRUPAL_ROOT/sites/all/modules/contrib/civicrm/drupal/civicrm.module(445): CRM_Core_Invoke::invoke((Array:4))
#24 DRUPAL_ROOT/includes/menu.inc(527): civicrm_invoke("admin", "uf", "group")
#25 DRUPAL_ROOT/index.php(21): menu_execute_active_handler()
#26 {main}
***POST***
```CiviRules Sprint August 2019jaapjansmajaapjansmahttps://lab.civicrm.org/extensions/civirules/-/issues/20Info displayed on the extensions page in CiviCRM is out of date2023-03-04T07:29:45Zfreeform.stephInfo displayed on the extensions page in CiviCRM is out of dateThe link displayed for "Main extension page" is still linking to https://github.com/CiviCooP/org.civicoop.civirules instead of https://lab.civicrm.org/extensions/civirules. I am referring to the extensions page of a CiviCRM installation,...The link displayed for "Main extension page" is still linking to https://github.com/CiviCooP/org.civicoop.civirules instead of https://lab.civicrm.org/extensions/civirules. I am referring to the extensions page of a CiviCRM installation, the info on the CiviCRM website's extensions directory is correct.
Cheers, and thanks for this extension!CiviRules Sprint August 2019jaapjansmajaapjansmahttps://lab.civicrm.org/extensions/civirules/-/issues/21Use the PHASE_POST_COMMIT2023-03-04T07:29:45ZErikHommelUse the PHASE_POST_COMMITPerhaps it would be better to use
```
CRM_Core_Transaction::addCallback(CRM_Core_Transaction::PHASE_POST_COMMIT,
'<class::method>', $callBackParams);
```
instead of running straight of the post hook to make sure the complete transaction...Perhaps it would be better to use
```
CRM_Core_Transaction::addCallback(CRM_Core_Transaction::PHASE_POST_COMMIT,
'<class::method>', $callBackParams);
```
instead of running straight of the post hook to make sure the complete transaction has run before the civirules triggers.CiviRules Sprint August 2019ErikHommelErikHommelhttps://lab.civicrm.org/extensions/civirules/-/issues/24Add only if not exists to sql inserting triggers2023-03-04T07:29:45ZErikHommelAdd only if not exists to sql inserting triggersWhen I re-install CiviRules in an environment where I already have the database tables, the triggers are inserted into the table anyway so I end up with doubles.When I re-install CiviRules in an environment where I already have the database tables, the triggers are inserted into the table anyway so I end up with doubles.CiviRules Sprint August 2019ErikHommelErikHommelhttps://lab.civicrm.org/extensions/civirules/-/issues/26Email template with opt-out URL brings to a blank page with ""2023-03-04T07:29:45ZtapashEmail template with opt-out URL brings to a blank page with ""We have an email template that triggers when a contact is added to a particular group. Email gets sent but the token within the template {action.optOutUrl} doesn't work. How to fix it please? I am using CiviCRM 5.11, Civirules 2.5, and E...We have an email template that triggers when a contact is added to a particular group. Email gets sent but the token within the template {action.optOutUrl} doesn't work. How to fix it please? I am using CiviCRM 5.11, Civirules 2.5, and Email-Api extension 1.19.CiviRules Sprint August 2019kainukkainukhttps://lab.civicrm.org/extensions/civirules/-/issues/28Remove jcalendar2023-03-04T07:29:45ZeileenRemove jcalendarThe jcalendar widget is almost gone from core - it's still used from civirules - search for CRM/common/jcalendar.tpl
It's generally pretty easy - at the tpl level you just need to render the field html like for any other field. You need...The jcalendar widget is almost gone from core - it's still used from civirules - search for CRM/common/jcalendar.tpl
It's generally pretty easy - at the tpl level you just need to render the field html like for any other field. You need to remove any weird date handling like CRM_Utils_Date::processDate because the js standardises the dates with datepicker
eg
https://github.com/civicrm/civicrm-core/pull/13198/filesCiviRules Sprint August 2019kainukkainukhttps://lab.civicrm.org/extensions/civirules/-/issues/29It would be nice to have a "clone" action for a rule so you can copy and cha...2023-03-04T07:29:45ZErikHommelIt would be nice to have a "clone" action for a rule so you can copy and change only what needs changingCiviRules Sprint August 2019kainukkainukhttps://lab.civicrm.org/extensions/civirules/-/issues/30Typo in Contact Removed to Group action (should be Contact Removed From Group)2023-03-04T07:29:45ZErikHommelTypo in Contact Removed to Group action (should be Contact Removed From Group)CiviRules Sprint August 2019ErikHommelErikHommelhttps://lab.civicrm.org/extensions/civirules/-/issues/31Action: Change Participant Status2023-03-04T07:29:45Zmagnolia61Action: Change Participant StatusWould you know of anyone who made a start with this?
Otherwise I will try, though not really a coder myself.
Use case:
1. change participant status to: 'wait on approval' if age does not match the requirements for an event (youthcamp)
...Would you know of anyone who made a start with this?
Otherwise I will try, though not really a coder myself.
Use case:
1. change participant status to: 'wait on approval' if age does not match the requirements for an event (youthcamp)
2. change participant status to: 'pending waitlist' if there was no space for boys on a camp, but still for girls.CiviRules Sprint August 2019alainbalainbhttps://lab.civicrm.org/extensions/civirules/-/issues/33Is it possible to add "NO BULK MAIL" Option in Privacy Preference?2023-03-04T07:29:46ZtapashIs it possible to add "NO BULK MAIL" Option in Privacy Preference?I wanted to trigger NO BULK MAIL but was not able to find it in latest version of civirules. is it possible to add? ThanksI wanted to trigger NO BULK MAIL but was not able to find it in latest version of civirules. is it possible to add? ThanksCiviRules Sprint August 2019alainbalainbhttps://lab.civicrm.org/extensions/civirules/-/issues/34Dropdown list for "Contact Subtypes" for linked condition disabled!2023-03-04T07:29:46ZtapashDropdown list for "Contact Subtypes" for linked condition disabled!![2019-07-14_10-12-57.2019-07-14_10_17_29](/uploads/fe4c86c93afabdc88ad8c383b11f78dc/2019-07-14_10-12-57.2019-07-14_10_17_29.gif)![2019-07-14_10-12-57.2019-07-14_10_17_29](/uploads/fe4c86c93afabdc88ad8c383b11f78dc/2019-07-14_10-12-57.2019-07-14_10_17_29.gif)CiviRules Sprint August 2019alainbalainbhttps://lab.civicrm.org/extensions/civirules/-/issues/38Try some civirules for Stack Exchange question by Josh2023-03-04T07:29:47ZErikHommelTry some civirules for Stack Exchange question by Joshhttps://civicrm.stackexchange.com/questions/31705/civirules-is-not-tagging-users-or-adding-them-to-groups/31707#31707https://civicrm.stackexchange.com/questions/31705/civirules-is-not-tagging-users-or-adding-them-to-groups/31707#31707CiviRules Sprint August 2019ErikHommelErikHommelhttps://lab.civicrm.org/extensions/civirules/-/issues/40DB error when deleting a CiviRule2023-03-04T07:29:47ZErikHommelDB error when deleting a CiviRuleAug 21 15:03:53 [info] $Fatal Error Details = Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)
[code] => -3
[message] => DB Error: constraint violation
[mode] =...Aug 21 15:03:53 [info] $Fatal Error Details = Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)
[code] => -3
[message] => DB Error: constraint violation
[mode] => 16
[debug_info] => DELETE FROM civirule_rule WHERE ( civirule_rule.id = 1 ) [nativecode=1451 ** Cannot delete or update a parent row: a foreign key constraint fails (`civirules_civicrm`.`civirule_rule_action`, CONSTRAINT `fk_ra_rule` FOREIGN KEY (`rule_id`) REFERENCES `civirule_rule` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION)]
[type] => DB_Error
[user_info] => DELETE FROM civirule_rule WHERE ( civirule_rule.id = 1 ) [nativecode=1451 ** Cannot delete or update a parent row: a foreign key constraint fails (`civirules_civicrm`.`civirule_rule_action`, CONSTRAINT `fk_ra_rule` FOREIGN KEY (`rule_id`) REFERENCES `civirule_rule` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION)]
[to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="DELETE FROM civirule_rule WHERE ( civirule_rule.id = 1 ) [nativecode=1451 ** Cannot delete or update a parent row: a foreign key constraint fails (`civirules_civicrm`.`civirule_rule_action`, CONSTRAINT `fk_ra_rule` FOREIGN KEY (`rule_id`) REFERENCES `civirule_rule` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION)]"]
)
Aug 21 15:03:53 [info] $backTrace = #0 /var/www/html/civirulesdev/sites/all/modules/civicrm/CRM/Core/Error.php(236): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /var/www/html/civirulesdev/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(922): CRM_Core_Error::handle(Object(DB_Error))
#2 /var/www/html/civirulesdev/sites/all/modules/civicrm/packages/DB.php(985): PEAR_Error->__construct("DB Error: constraint violation", -3, 16, (Array:2), "DELETE FROM civirule_rule WHERE ( civirule_rule.id = 1 ) [nativecode=1451 ...")
#3 /var/www/html/civirulesdev/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(575): DB_Error->__construct(-3, 16, (Array:2), "DELETE FROM civirule_rule WHERE ( civirule_rule.id = 1 ) [nativecode=1451 ...")
#4 /var/www/html/civirulesdev/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(223): PEAR->_raiseError(Object(DB_mysqli), NULL, -3, 16, (Array:2), "DELETE FROM civirule_rule WHERE ( civirule_rule.id = 1 ) [nativecode=1451 ...", "DB_Error", TRUE)
#5 /var/www/html/civirulesdev/sites/all/modules/civicrm/packages/DB/common.php(1907): PEAR->__call("raiseError", (Array:7))
#6 /var/www/html/civirulesdev/sites/all/modules/civicrm/packages/DB/mysqli.php(933): DB_common->raiseError(-3, NULL, NULL, "DELETE FROM civirule_rule WHERE ( civirule_rule.id = 1 ) [nativecode=1451 ...", "1451 ** Cannot delete or update a parent row: a foreign key constraint fails ...")
#7 /var/www/html/civirulesdev/sites/all/modules/civicrm/packages/DB/mysqli.php(403): DB_mysqli->mysqliRaiseError()
#8 /var/www/html/civirulesdev/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysqli->simpleQuery("DELETE FROM civirule_rule WHERE ( civirule_rule.id = 1 ) ")
#9 /var/www/html/civirulesdev/sites/all/modules/civicrm/packages/DB/DataObject.php(2415): DB_common->query("DELETE FROM civirule_rule WHERE ( civirule_rule.id = 1 ) ")
#10 /var/www/html/civirulesdev/sites/all/modules/civicrm/packages/DB/DataObject.php(1429): DB_DataObject->_query("DELETE FROM civirule_rule WHERE ( civirule_rule.id = 1 ) ")
#11 /var/www/html/civirulesdev/sites/all/modules/civicrm/CRM/Core/DAO.php(617): DB_DataObject->delete(FALSE)
#12 /var/www/html/civirulesdev/sites/default/files/civicrm/ext/civirules/CRM/Civirules/BAO/Rule.php(110): CRM_Core_DAO->delete()
#13 /var/www/html/civirulesdev/sites/default/files/civicrm/ext/civirules/CRM/Civirules/Form/RuleDelete.php(41): CRM_Civirules_BAO_Rule::deleteWithId("1")
#14 /var/www/html/civirulesdev/sites/all/modules/civicrm/CRM/Core/Form.php(495): CRM_Civirules_Form_RuleDelete->postProcess()
#15 /var/www/html/civirulesdev/sites/all/modules/civicrm/CRM/Core/StateMachine.php(160): CRM_Core_Form->mainProcess()
#16 /var/www/html/civirulesdev/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Next.php(61): CRM_Core_StateMachine->perform(Object(CRM_Civirules_Form_RuleDelete), "next", "Next")
#17 /var/www/html/civirulesdev/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Next->perform(Object(CRM_Civirules_Form_RuleDelete), "next")
#18 /var/www/html/civirulesdev/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Civirules_Form_RuleDelete), "next")
#19 /var/www/html/civirulesdev/sites/all/modules/civicrm/CRM/Core/Controller.php(351): HTML_QuickForm_Page->handle("next")
#20 /var/www/html/civirulesdev/sites/all/modules/civicrm/CRM/Utils/Wrapper.php(114): CRM_Core_Controller->run()
#21 /var/www/html/civirulesdev/sites/all/modules/civicrm/CRM/Core/Invoke.php(284): CRM_Utils_Wrapper->run("CRM_Civirules_Form_RuleDelete", "RuleDelete", (Array:0))
#22 /var/www/html/civirulesdev/sites/all/modules/civicrm/CRM/Core/Invoke.php(85): CRM_Core_Invoke::runItem((Array:13))
#23 /var/www/html/civirulesdev/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:4))
#24 /var/www/html/civirulesdev/sites/all/modules/civicrm/drupal/civicrm.module(444): CRM_Core_Invoke::invoke((Array:4))
#25 /var/www/html/civirulesdev/includes/menu.inc(527): civicrm_invoke("civirule", "form", "ruledelete")
#26 /var/www/html/civirulesdev/index.php(21): menu_execute_active_handler()
#27 {main}CiviRules Sprint August 2019ErikHommelErikHommel