1

I am on Joomla 3.8.7 and civiCRM 4.7.31. Recently, Two members received the following error message when trying to renew their memberships:

"The membership cannot be saved because the status cannot be calculated for start_date: 20170101 and end_date: 20171231 join_date: 20170306 as at 2018-05-04 22:00:50"

Over 100 members have successfully renewed their memberships this year so I'm not sure why this is happening.

Can someone help?enter image description here

2

Using the CiviCRM menu, if you navigate to Administer > CiviMember > Membership Status Rules (civicrm/admin/member/membershipStatus) you should see a list of membership status rules. These dictate the "workflow" of a membership, and they need to chain together correctly. For example, on the sample site I have handy the rules are:

  • New - ends +3 months from "member since" start date (configuration pictured below).
  • Current (rest of membership - doesn't have start/end config in my sample site, but is the "default" state)
  • Grace - starts end of membership, ends +1 month from that date
  • Expired - starts +1 month from end of membership
  • Pending, Cancelled, Deceased - not part of the automatic process.

Here's what "New" looks like.

configuration for "New" membership status

I suggest you inspect the dates those members are trying to renew and work out where in this workflow they would fall given the rules on your site (expired or grace presumably, since you seem to have a fixed year membership and it's now May in the next year). It may be that a membership state has been removed from the workflow and this leaves a gap, or that the timeline has been adjusted for one but not another.

Just a guess, that's where I'd look first!

  • It's also a bit eye-catching that the error message contains dates in two different formats - probably storage format 20171231 and input format 2018-05-04 22:00:50. If the membership status rules don't solve it, I'd debug the date comparison next. – Chris Burgess May 6 '18 at 2:10
  • github.com/civicrm/civicrm-core/blob/… is where the calculation seems to fail – Chris Burgess May 6 '18 at 2:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.