Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-9368

Membership reminder emails are not being sent

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Major
    • Resolution: Fixed/Completed
    • Affects Version/s: 3.4.7
    • Fix Version/s: 4.1.0
    • Component/s: CiviMember
    • Labels:
      None

      Description

      The membership reminder date field is set to 0000-00-00 during UpdateMembershipRecord.php processing when the record is updated due to a status change. Reminder emails are never sent for these records.

      This problem was introduced for me after updating from CiviCRM 3.3.5 to 3.4.7.

      The problem is due to the civicrm_membership reminder_date field not being formatted properly in the SQL update query. The date field is formatted as YYYY-MM-DD instead of YYYYMMDD. The query results in setting the reminder date field to 0000-00-00.

      The fix is to format the reminder_date field along with the join_date and start_date fields in api/v2/MembershipContact.php in function _civicrm_membership_format_params( ).

      A patch is attached.

        Attachments

          Activity

            People

            • Assignee:
              rajan Rajan P Mayekar
              Reporter:
              marty Marty Wright
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: