Cant remove invalid count for membership subscription levels

Hi @atfpodcast,

I hope you are well today.

I have tested it on my test site but couldn’t reproduce the issue.

Could you please tell me in detail what steps you have implemented by sharing the screenshot of it so that i can reproduce and troubleshoot it?

You can reset it by deleting entries from the table wp_m_membership_relationships in your WordPress database.

Kind Regards,
WPMU DEV

Hi @atfpodcast,

Thank you for your detailed reply.

I just made a test account and I then assigned a subscription / level to the user then I deleted the account from the wordpress users. I did not drop any subscriptions from the members user list. Those stats are still there.

I could reproduce this issue on my test site by adding subscription to the user and deleting the user before dropping the subscription from him.

I have notified the plugin developer about this issue so that it can be fixed.

In the meanwhile before deleting user just drop his subscription first.

To reset existing subscription/access level count to zero by deleting all subscription/access levels from users, try temporary adding the following code in the functions.php file of your theme and remove it after your site reload when the count resets to zero.

global $wpdb;
$wpdb->query("DELETE FROM ".$wpdb->prefix."m_membership_relationships");

Thanks,
WPMU DEV

Hi @atfpodcast,

I have tested and the provided code worked fine for me resetting existing subscription/access level count to zero.

Could you please tell me what is in the table wp_m_membership_relationships in your database?

If contains anything try deleting it manually or executing following SQL query in the SQL query executer.

DELETE FROM wp_m_membership_relationships;

Regards,
WPMU DEV

Hi @atfpodcast,

Awesome, great to see it worked for you and fixed the issue.

I have already notified the plugin developer to fix this issue. The issue will be fixed in the future version of plugin.

Any other issues, we’re here to help 🙂

Cheers,
WPMU DEV