CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMember (Moderator: Deepak Srivastava) »
  • Renewal Reminders won't send, Civi 4.2.14
Pages: [1]

Author Topic: Renewal Reminders won't send, Civi 4.2.14  (Read 911 times)

poorhaus

  • I’m new here
  • *
  • Posts: 29
  • Karma: 0
    • Music Nova Scotia
  • CiviCRM version: 4.4.10
  • CMS version: Drupal 7
  • MySQL version: 5.5.27
  • PHP version: 5.3.17
Renewal Reminders won't send, Civi 4.2.14
January 30, 2014, 12:48:50 pm
I've been tearing my hair out about this one for a while now. Cron and Scheduled Jobs are both running successfully, renewal reminders are set up in Schedule Reminders to be sent out 30, 5, and 0 days before membership expiry, for all membership types. The process_membership job is running and accurately updating membership statuses. Cron and Scheduled Jobs both report that they have completed successfully, but no renewal reminders are ever sent. Indeed, our civicrm_action_log table has 0 rows.

I have tested being able to send mail from Civi ("send email to contacts" from any of the search results) and it works. I've verified that some of our members met the conditions for sending out a reminder when cron last ran. I've attached screencaps of the relevant dialogs from Civi; what might I be missing?

poorhaus

  • I’m new here
  • *
  • Posts: 29
  • Karma: 0
    • Music Nova Scotia
  • CiviCRM version: 4.4.10
  • CMS version: Drupal 7
  • MySQL version: 5.5.27
  • PHP version: 5.3.17
Re: Renewal Reminders won't send, Civi 4.2.14
February 03, 2014, 12:38:43 pm
Just scheduled some Civi upgrades with CiviTeacher; going to 4.3.8 and hoping this resolves itself.  ???

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: Renewal Reminders won't send, Civi 4.2.14
February 03, 2014, 12:52:20 pm
I have done digging a couple of times on scheduled reminders. The most common problem I've found is just timing - because scheduled reminders only run on the exact day - they don't pick any missed & sometimes server times can cause confusion on them. 

However I did observe something in the code that made me think that contacts with non-permissioned relationships of a type which was attached to a membership would not get reminders

http://issues.civicrm.org/jira/browse/CRM-14098
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

poorhaus

  • I’m new here
  • *
  • Posts: 29
  • Karma: 0
    • Music Nova Scotia
  • CiviCRM version: 4.4.10
  • CMS version: Drupal 7
  • MySQL version: 5.5.27
  • PHP version: 5.3.17
Re: Renewal Reminders won't send, Civi 4.2.14
February 04, 2014, 05:45:19 am
Interesting; this may pertain to my use-case. Individual contacts in our system only ever inherit membership from the Organization they belong to; only Organizations can have memberships. These are created as "permissioned" relationships where the Individuals can edit the Organization they are "employed" by, but not vice versa. Does the Schedule Reminders feature attempt to send reminder emails to the email address(es) attached to the Organization contact? This could be the core of my issue if not.

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: Renewal Reminders won't send, Civi 4.2.14
February 04, 2014, 11:50:42 am
Yes, I think the scheduled reminders sends the reminder to either the person with the a permissioned relationship to the org - or just the member if it's not inherited. I guess I would set up a person who should receive a reminder with a 2-way permissioned relationship (& preferably no other relationships) for testing
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

poorhaus

  • I’m new here
  • *
  • Posts: 29
  • Karma: 0
    • Music Nova Scotia
  • CiviCRM version: 4.4.10
  • CMS version: Drupal 7
  • MySQL version: 5.5.27
  • PHP version: 5.3.17
Re: Renewal Reminders won't send, Civi 4.2.14
February 04, 2014, 12:26:32 pm
I'll try anything at this point! By default our Individual contacts only get a one-way permissioned relationship to their org that allows them to edit that org's contact details. We don't assign Drupal user accounts to Organization contacts, so there's no perceived need for the relationship to be 2-way in our use-case since no one can ever log in as an Organization, only as an employee of that org.

I set up a user who expires tomorrow with a 2-way relationship - fingers crossed! Thanks for the tip, Eileen.  ;D

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: Renewal Reminders won't send, Civi 4.2.14
February 04, 2014, 01:33:43 pm
I guess the other thing is that you should see whether you can upgrade - there is always the chance your problem will be fixed in 4.2.14
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

poorhaus

  • I’m new here
  • *
  • Posts: 29
  • Karma: 0
    • Music Nova Scotia
  • CiviCRM version: 4.4.10
  • CMS version: Drupal 7
  • MySQL version: 5.5.27
  • PHP version: 5.3.17
Re: Renewal Reminders won't send, Civi 4.2.14
February 10, 2014, 10:59:00 am
OK, I set up a new reminder (in case the ones I created under 4.2.14 are not valid under 4.3.8) for 0 days before membership end date, gave one of my civi individual contacts a relationship directly (as opposed to a membership inherited from an Org) whose end date is today, and ran the Send Reminders job, and still no reminders were sent.

Which file in the Civi codebase has that code that actually processes the reminders? Especially that code snippet that Eileen posted; I think I need to gain a better understanding of how it actually works.

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: Renewal Reminders won't send, Civi 4.2.14
February 10, 2014, 11:56:47 am
the file is

CRM/Core/BAO/ActionSchedule.php - it starts with the processQueue function
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

poorhaus

  • I’m new here
  • *
  • Posts: 29
  • Karma: 0
    • Music Nova Scotia
  • CiviCRM version: 4.4.10
  • CMS version: Drupal 7
  • MySQL version: 5.5.27
  • PHP version: 5.3.17
Re: Renewal Reminders won't send, Civi 4.2.14
February 11, 2014, 07:05:58 am
Success! I am over the moon.  ;D

The fix was to re-create the renewal reminders after the upgrade to 4.3.8. Thanks for the help, Eileen!
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMember (Moderator: Deepak Srivastava) »
  • Renewal Reminders won't send, Civi 4.2.14

This forum was archived on 2017-11-26.