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) »
  • Scheduled reminder sent for all members (current and expired)
Pages: [1]

Author Topic: Scheduled reminder sent for all members (current and expired)  (Read 1628 times)

michael23

  • I’m new here
  • *
  • Posts: 24
  • Karma: 2
  • CiviCRM version: 4.6.2
  • CMS version: Joomla 2.5.28
  • MySQL version: 5.6.23
  • PHP version: 5.5.22
Scheduled reminder sent for all members (current and expired)
May 02, 2013, 10:51:51 pm
Hi all,

I recently upgraded our CiviCRM from 4.2.7 to the latest 4.3.1.

Scheduled reminders was already set up under 4.2.7 with emails scheduled to be sent for 30 days prior to the membership end date. However, even with all the scheduled jobs running each night, I don't believe it ever sent anything. So I left it at that.

After the upgrade to 4.3.1, I manually ran the job to send scheduled reminders. To my horror, I found that it sent out membership reminders to all members, past and present. Most emails were sent twice to each recipient, with some receiving many more.

What did I do wrong here? How can I check when the next reminder email is scheduled to send? I can't seem to find any reminder date columns in the database anymore.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Scheduled reminder sent for all members (current and expired)
May 02, 2013, 11:40:57 pm

This was a bug in 4.3.1 which has been fixed in 4.3.2 which was released earlier today

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

michael23

  • I’m new here
  • *
  • Posts: 24
  • Karma: 2
  • CiviCRM version: 4.6.2
  • CMS version: Joomla 2.5.28
  • MySQL version: 5.6.23
  • PHP version: 5.5.22
Re: Scheduled reminder sent for all members (current and expired)
May 03, 2013, 12:25:47 am
Many thanks for the prompt reply and good news. If only I'd waited a few days!

Anyway, will download and install the latest.

michael23

  • I’m new here
  • *
  • Posts: 24
  • Karma: 2
  • CiviCRM version: 4.6.2
  • CMS version: Joomla 2.5.28
  • MySQL version: 5.6.23
  • PHP version: 5.5.22
Re: Scheduled reminder sent for all members (current and expired)
May 03, 2013, 01:37:42 am
I just had a look at the changes made for this issue here:

https://github.com/civicrm/civicrm-core/commit/767910a282392d2393b189507348ab5e77068de4#diff-0

Code: [Select]
$membershipStatus = CRM_Member_PseudoConstant::membershipStatus(NULL, "is_current_member = 1 OR name = 'Expired'", 'id');
Does it mean this will send reminders if the membership is expired?

Yashodha Chaku

  • Forum Godess / God
  • Ask me questions
  • *****
  • Posts: 755
  • Karma: 57
    • CiviCRM
Re: Scheduled reminder sent for all members (current and expired)
May 06, 2013, 12:25:16 pm
We don't send the reminders if membership status is either Pending, Deceased OR Cancelled.

For more details, refer :
http://issues.civicrm.org/jira/browse/CRM-12219

-Yashodha
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

michael23

  • I’m new here
  • *
  • Posts: 24
  • Karma: 2
  • CiviCRM version: 4.6.2
  • CMS version: Joomla 2.5.28
  • MySQL version: 5.6.23
  • PHP version: 5.5.22
Re: Scheduled reminder sent for all members (current and expired)
May 06, 2013, 10:53:07 pm
Thanks Yashodha, but in my case I don't want to send a reminder if the membership status is Expired.

This is because I already have a reminders sent 30 days before the membership end date. If a member does not renew after expiry, we would assume they are no longer interested and I would prefer if they don't get further emails.

Is there anyway to do this?

Yashodha Chaku

  • Forum Godess / God
  • Ask me questions
  • *****
  • Posts: 755
  • Karma: 57
    • CiviCRM
Re: Scheduled reminder sent for all members (current and expired)
May 07, 2013, 11:40:39 am
michael23 :

Folks still might to send the reminders after the members are expired for a particular period (which can be configured).

For your specific case, I would change the membership status criteria to below if you don't want to send the scheduled reminders to 'Expired' members at all.

Code: [Select]
$membershipStatus = CRM_Member_PseudoConstant::membershipStatus(NULL, "is_current_member = 1", 'id');
HTH
-Yashodha
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

michael23

  • I’m new here
  • *
  • Posts: 24
  • Karma: 2
  • CiviCRM version: 4.6.2
  • CMS version: Joomla 2.5.28
  • MySQL version: 5.6.23
  • PHP version: 5.5.22
Re: Scheduled reminder sent for all members (current and expired)
May 07, 2013, 09:10:36 pm
Thanks, I was hoping it would not come to that as it will be a pain to keep the code updated after every update. I think I will just not use the scheduled reminders, but send them out manually.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMember (Moderator: Deepak Srivastava) »
  • Scheduled reminder sent for all members (current and expired)

This forum was archived on 2017-11-26.