UseBB Community

I realise that eventually, most routine tasks will be actioned via the ACP but in the meantime most of these tasks are very difficult except for the most expert amongst us.

Our new forum http://radiochickforum.nzcool.com/ has gained 216 members inside one week but several of these were duplicate or unsuccessful registration attempts. I have managed to delete these from the members table but have no idea how to compact the database so that the membership displays the actual number (re-index?).

Would anyone attempt to explain to me how to do this please?

*bump*

Just hoping that someone will be able to suggest a solution (or point me in the right direction)

Isn't there something like this in phpMyAdmin?

bastya_elvtars:

I get lost in phpMyAdmin and have tried to find a solution myself, that is why I posted my question.

It would have been really helpful had someone posted: "Yes, the solution to your problem is to run this little SQL script [script provided] to re-index and compact your database." Or perhaps, directions to Doc or a menu selection.

Is there anyone who KNOWS the solution please?

OPTIMIZE table usebb_members;

That should do it?

The problem you are having is because you deleted members directly from the DB without updating the stats. See the old docs wiki on how to resync them.

OPTIMIZE does not solve this. You can run this from the ACP too.