Forums » SEPHP Help and Tips

How to Reset Members Count in Admin Dashboard

    • 29 posts
    August 26, 2017 12:02 PM EDT

    Just found something neat out for the stats freaks among us.
    You know, you just open to your Admin Page and you are welcome to your dashboard.

    You see Quick Stats and it gives you a glance run down of your community.

    The member statistics always seem one step ahead of itself though, especially if you have had some test members created during development.

    So, here you are:
    Ready to go live and your View Members link shows (0) while your Total Member stats show (25).

    How do you reset this and start the count from the scratch?

    This is what I found and I hope it helps you too.

    From phpmyadmin, go to your database and click on Search.

    Inside the search box, type: user.creations
    And select just engine4_core_statistics

    The result will be a record of all created account instances.
    This is just a collected stat, so you can delete without any fear.

    Each record shows date and the number of signups for each day.

    Delete as many entry as you like and go back to your admin dashboard...refresh and voila!


    Ask for further clarifications.

    • Moderator
    • 5865 posts
    August 27, 2017 5:12 AM EDT

    Great tips. Thanks :)

    We strongly recommend doing a complete backup of your database before making any changes to it. One wrong move and you could wipe out all of your hard work. 

    • 626 posts
    September 9, 2017 3:19 AM EDT

    Just hit export in chrome once you navigate to the field you want to edit and then do your work. It's the quickest. Nice tip Wale.

    This post was edited by ElsharaSilverheart at September 9, 2017 3:19 AM EDT