Answers.Body: <p>There has been a recent JIRA ticket <a href="https://issues.civicrm.org/jira/browse/CRM-18236" rel="nofollow">18326</a></p>
  
  <ul>
  <li>Scheduled reminder set to run one week before membership end date     </li>
  <li>Reminder runs once, then membership end date is changed</li>
  <li>When the next date comes around it correctly sends a reminder but it incorrectly sends a reminder every cron until the next date has ended</li>
  </ul>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-03-17T01:02:03.383Z
Answers.LastActivityDate: 2016-03-17T01:02:03.383Z
Answers.UserDisplayName: petednz - fuzion
Body: <p>We upgraded to 4.6.2 in our test environment and since then our membership renewal reminders are sending emails each time the cron job runs. The reminder is scheduled to send 2 days before membership expiration with no repeats. Our cron job runs every 30 minutes, so the reminder is sent every 30 minutes for the entire 24 hour period. Is there something I need to reset? This only happens with reminders that were set up prior to our 4.6.2 upgrade. All new reminders work properly.</p>
  
  <p>This does seem really similar to issues.civicrm.org/jira/browse/CRM-16514. Could use some help looking into it. I can duplicate the issue.</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-05-22T20:36:43.793Z
Comments.Text: Hi Jane - we got caught out with something a bit like this - everyone got sent Reminders, rather than just the 'targets', and it was prior to 4.6 -  we had set the 'limited to' to be 'additional' (or whatever the corollary is), and having left the next field blank the query incorrectly assumed we meant 'heh let's send it to everyone' (gahh)
  Only mentioning this in case you can spot any other settings on your Scheduled Reminder that might ring alarm bells.
  Other option would be to construct a new Reminder from scratch and see if that behaves? and if so what differences you can spot?
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-05-22T21:11:59.507Z
Comments.Text: This sounds very similar to this reported bug: https://issues.civicrm.org/jira/browse/CRM-16514.  Jane, could you read that over and see if it sounds like the same thing?  If so, it sounds like you have valuable additional information that could be crucial to troubleshooting.
Comments.UserDisplayName: Jon G - Megaphone Tech
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-05-23T22:11:07.867Z
Comments.Text: Hi Jon G - Yes, I think it is the same issue. What information can I provide to help? I can look at whatever you might need, just still getting familiar with CiviCRM so might not be able to debug on my own.
Comments.UserDisplayName: Jane
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-05-24T00:17:21.843Z
Comments.Text: I commented on the issue pointing to this - sounds like the core team couldn't replicate the problem, but now will test upgrading to see if they can replicate the problem.  Meanwhile - do you know how to output SQL?  Try creating a scheduled reminder identical to a broken reminder, then run the SQL statement `select * from civicrm_action_schedule`.  See if there's a difference between the two reminder records that you can identify?
Comments.UserDisplayName: Jon G - Megaphone Tech
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-05-25T00:11:04.943Z
Comments.Text: I took a look at the civicrm_action_schedule and there is nothing different from the scheduled reminders. All columns (except the unique id, name and message) are identical. I also took a look at the civicrm_action_log and nothing stands out there. I can see an entry for each individual email sent. The email definitely should not be repeating every time the Scheduled Jobs task is run, but it is.
Comments.UserDisplayName: Jane
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-05-26T18:13:15.290Z
Comments.Text: @Jane - Have you seen the latest request for info on the ticket? https://issues.civicrm.org/jira/browse/CRM-16514
Comments.UserDisplayName: Jon G - Megaphone Tech
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-08-19T18:28:26.967Z
Comments.Text: We're still seeing this problem. I saw the request for information on that ticket - yes, it seems similar although for events. I will post there as well, but we really could use some help with this. Once the email has been sent once at the correct time, it begins to send every time the cron job runs. There doesn't seem to be anything out of the ordinary with the logs or the scheduled jobs.
Comments.UserDisplayName: Jane
Tags: <civimember><4.6.2><scheduled-reminders>
Title: Membership reminders sending each time scheduled job runs after 4.6.2 upgrade
ThreadText: # Membership reminders sending each time scheduled job runs after 4.6.2 upgrade
  
  (Asked by: username_0 on 2015-05-22)
  
  We upgraded to 4.6.2 in our test environment and since then our membership renewal reminders are sending emails each time the cron job runs. The reminder is scheduled to send 2 days before membership expiration with no repeats. Our cron job runs every 30 minutes, so the reminder is sent every 30 minutes for the entire 24 hour period. Is there something I need to reset? This only happens with reminders that were set up prior to our 4.6.2 upgrade. All new reminders work properly.
  
  This does seem really similar to issues.civicrm.org/jira/browse/CRM-16514. Could use some help looking into it. I can duplicate the issue.
  
  **Tags:** civimember, 4.6.2, scheduled-reminders
  
  > **Comments:**
  > **username_1**: Hi username_0 - we got caught out with something a bit like this - everyone got sent Reminders, rather than just the 'targets', and it was prior to 4.6 -  we had set the 'limited to' to be 'additional' (or whatever the corollary is), and having left the next field blank the query incorrectly assumed we meant 'heh let's send it to everyone' (gahh) Only mentioning this in case you can spot any other settings on your Scheduled Reminder that might ring alarm bells. Other option would be to construct a new Reminder from scratch and see if that behaves? and if so what differences you can spot?  
  > **username_2**: This sounds very similar to this reported bug: https://issues.civicrm.org/jira/browse/CRM-16514.  username_0, could you read that over and see if it sounds like the same thing?  If so, it sounds like you have valuable additional information that could be crucial to troubleshooting.  
  > **username_0**: Hi Jon G - Yes, I think it is the same issue. What information can I provide to help? I can look at whatever you might need, just still getting familiar with CiviCRM so might not be able to debug on my own.  
  > **username_2**: I commented on the issue pointing to this - sounds like the core team couldn't replicate the problem, but now will test upgrading to see if they can replicate the problem.  Meanwhile - do you know how to output SQL?  Try creating a scheduled reminder identical to a broken reminder, then run the SQL statement `select * from civicrm_action_schedule`.  See if there's a difference between the two reminder records that you can identify?  
  > **username_0**: I took a look at the civicrm_action_schedule and there is nothing different from the scheduled reminders. All columns (except the unique id, name and message) are identical. I also took a look at the civicrm_action_log and nothing stands out there. I can see an entry for each individual email sent. The email definitely should not be repeating every time the Scheduled Jobs task is run, but it is.  
  > **username_2**: @username_0 - Have you seen the latest request for info on the ticket? https://issues.civicrm.org/jira/browse/CRM-16514  
  > **username_0**: We're still seeing this problem. I saw the request for information on that ticket - yes, it seems similar although for events. I will post there as well, but we really could use some help with this. Once the email has been sent once at the correct time, it begins to send every time the cron job runs. There doesn't seem to be anything out of the ordinary with the logs or the scheduled jobs.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2016-03-17. Score: 1
  
  There has been a recent JIRA ticket [18326](https://issues.civicrm.org/jira/browse/CRM-18236)
  
  * Scheduled reminder set to run one week before membership end date
  * Reminder runs once, then membership end date is changed
  * When the next date comes around it correctly sends a reminder but it incorrectly sends a reminder every cron until the next date has ended
  
  
  ---
  
  