Start date set to 0 for new memberships by relation

[civicpixel]

I replicated this behavior on our client install as well as the demo site in 4.0.4 -- it looks like any membership inherited via relationship gets a start date of 0. Here's an example on the demo site.
http://drupal.demo.civicrm.org/civicrm/contact/view?action=browse&selectedChild=rel&reset=1&cid=175

You can replicate it with additional contacts by:
1. Add a new contact
2. Add a relationship of Employee Of to the organization "Widgets and Wodgets"

I didn't have time to get into the code today, but if nobody has a quick fix I'll try to submit a patch this week. I do know this behavior was not a problem in 4.0.0.

[TheZorg]

Have you found a solution for this? I rely heavily on the membership through relationship feature for my project, and would like to find a fix for this.

[civicpixel]

The issue is with the date format being sent to CRM_Member_BAO_Membership::create in /CRM/Contact/BAO/Relationship.php around line #1198. The format that is being set in there is 2010-07-13, but needs to be more like 20100713. I assume this should really be addressed in the chain where the values are loaded via CRM_Member_BAO_Membership::getValues, or modify
CRM_Member_BAO_Membership::create to accept both formats.

Since I haven't had time for a proper fix, what we've done for our client is add these lines before the membership is created in /CRM/Contact/BAO/Relationship.php around line #1198 to adjust the date formats:

Code: [Select]

                        $membershipValues['start_date'] = CRM_Utils_Date::isoToMysql($membershipValues['start_date']);
                        $membershipValues['join_date'] = CRM_Utils_Date::isoToMysql($membershipValues['join_date']);
                        $membershipValues['end_date'] = CRM_Utils_Date::isoToMysql($membershipValues['end_date']);
                        $membershipValues['membership_end_date'] = CRM_Utils_Date::isoToMysql($membershipValues['membership_end_date']);
                        $membershipValues['membership_start_date'] = CRM_Utils_Date::isoToMysql($membershipValues['membership_start_date']);
                        CRM_Member_BAO_Membership::create( $membershipValues, CRM_Core_DAO::$_nullArray );


[Donald Lobo]

Can you please file an issue and link to this forum post

thanx

lobo

[civicpixel]

Done, added the issue here:
http://issues.civicrm.org/jira/browse/CRM-8605