Over the past several months we have been experiencing very sporadic complaints from current members about not being able to renew and/or being redirected to the new registration screen when they try to renew. Upon investigation, we've discovered that the renewal button is missing from their renewal screen and that they may not have a membership plan to renew, although their membership is still present and active (or expired) in the database
cbsubs_subscriptions table.
This occurs about 4 to 8 times a month and doesn't seem to follow any pattern or time span. Most of these are long term members (several years or more). The only way to correct is to edit the database
cbsubs_subscriptions table and clear the
status and
plan_id fields to allow re-importation of their CVS membership record. After import, go back to the database and set status field to "X" if their original plan had expired or "A" if still active. After doing this, the renewal button and membership plan and upgrade path are present again.
I am aware of the fact that if a plan is changed, then any prior membership of that plan will not reflect the change and must be re-imported. There have been no changes to any of our plans since the site went live 15 months ago. Coincidentally, this seems to have started about the same time as the issues on another post I made:
211938-last-visit-date-is-not-updating
I'm wondering if these issues might be related, but they haven't affected the same members.
Any ideas?
Thank you.