3

We recently upgraded from Civi 4.6.23 to 5.3.2. The upgrade has gone fairly smoothly, but today we discovered a problem where the Member Since and Start Dates are not being set for any new memberships started since the day we upgraded. Though these members are being giving the status of "Current", they are not being given correct access to our site.

I've checked our error logs, and there are no errors. I also checked the database, and the database does not have a Member Since or Start Date, and has no record of a membership in the member_log table.

In this picture, you can see that there is no date set for Member Since or Start Date:

If we got to edit the member, though, it does have a Member Since date. But, still not Start Date. enter image description here

  • That looks like a serious data loss. If you have logging enabled, you can update member_since and start_date columns in civicrm_membership table looking at the last (not empty) value in log_civicrm_membership. – jitendra - fuzion Oct 30 '18 at 3:05
  • Do you have any extensions installed which deal with dates and/or Membership? What about custom override files? – Jon G - Megaphone Tech Oct 30 '18 at 3:55
  • Hi, sorry an important detail I guess I left off, this is only affecting new memberships since the upgrade. All memberships from before are working fine. We do not have any extensions or custom overrides that would be affecting this. – Kimberlie Davis Oct 31 '18 at 4:42
  • I have looked through the error logs, and there doesn't seem to be any errors causing this. There was a Geocoder error being thrown when a membership is created, but I resolved that error and it did not resolve the membership date issue. I went back to an older version of our site, and was able to create a membership without issue. I also updated to the latest version, and still ran into this issue. – Kimberlie Davis Nov 26 '18 at 23:17
1

I never found the cause to this, but ended up using a Rule in Drupal to set the member_since and join_date variables when a new membership is created.

  • good to know you found that as a workaround but somewhat worrying that something on your system is affecting this core feature – petednz - fuzion Dec 11 '18 at 5:22

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.