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.