1

In Administer > Communication > FROM Email Addresses, I have changed the persons name associated with our [email protected] email. However, receipts still have the old name associated with it. I am using a CiviRule to send a Message Template and the selection FROM Email shows the proper name, but it send the old name. Where in the database do I find this information so I can make sure it is properly cleaned up?

2
  • does changing the civirule to a different From address and then back again help?
    – petednz - fuzion
    Commented Feb 26, 2022 at 21:30
  • otherwise see if you have the old value in the civirule_rule_action table
    – petednz - fuzion
    Commented Feb 26, 2022 at 21:32

1 Answer 1

1

Not sure about how civirules stores it but the From addresses are just option values.

select v.* from civicrm_option_value v inner join civicrm_option_group g on v.option_group_id=g.id and g.name='from_email_address';

8
  • This got me what I needed. It appears that when you edit a FROM email address in the GUI, it changes the table civicrm_options_value > label but it also needs to change the > name column as well.
    – Iowa Boy
    Commented Feb 26, 2022 at 21:52
  • That sounds familiar - there might be an open labs ticket about that.
    – Demerit
    Commented Feb 26, 2022 at 21:53
  • Ah I think this one: lab.civicrm.org/dev/core/-/issues/2995
    – Demerit
    Commented Feb 26, 2022 at 21:55
  • I am guessing tha tin the GUI I could have deleted the old entry and created a new one and solved the problem
    – Iowa Boy
    Commented Feb 26, 2022 at 21:56
  • It sounds like the email api extension used to use the internal machine name instead of label but that's now fixed in its latest code. The GUI should not change the internal machine name once it is set. So yes creating a new one would temporarily fix it, but the extension shouldn't use name for display purposes.
    – Demerit
    Commented Feb 26, 2022 at 22:03

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.