CiviCRM Community Forums (archive)

The cron job should be clearing the reminder date for those memberships after it sends out the renewal messages, and this "should" prevent further reminders from being sent. Sounds like something in this expected flow is not happening. Please update your forum profile with complete info on version of CiviCRM, your CMS, php and mysql versions so we can investigate.

I ran a quick test with the 2.0 version of UpdateMembershipRecord.php - and it properly cleared the Renewal Reminder record after sending the reminder email out (to a Grace status member). Since I can't recreate this - you'll need to debug it on your side. Assuming that you can browse your DB - you'll want to check whether the reminder_date column in the civicrm_membership table is being set to NULL after each reminder email is set.

You can add some debug / echo statements to the script as follows, which can verify what's happening:

// add next line
                            echo "pre-reminder=" . $dao->reminder_date . "<br />";

                            crm_update_contact_membership( array('id'             => $dao->membership_id,
                                                                 'reminder_date'  => 'null' ) );

// and then these 2 lines
                            $newReminder = CRM_Core_DAO::getFieldValue( 'CRM_Member_DAO_Membership',
                                                                        $dao->membership_id,
                                                                        'reminder_date', 'id' );
                            echo "new reminder=" . $newReminder . "<br />";