I am new to this community and setup, so bear with me...I do work in IT for a day job, which is probably a bad thing because I think I know what I'm doing but... 🙂

We have a self-hosted forum which has a lot of old users setup. We would like to tidy it up but the member screen in the portal doesn't show the last_activity field which I can see exists in the database.

Now, I can easily write an SQL query that will remove the members directly from the 'ibf_core_members' table but I don't want to break the forum because I am guessing that the 'delete' option in the portal may do more than just remove that table entry?,

I was going to test this on just 1 member first but I thought I'd check on here first...any suggestions?

Use the search functionality in the Members listing:

And when you get the results then you will see a "Prune Members Found" link that will allow you to mass delete.

Well, I never knew that.  I've added some screenshots, not only can you delete members but you can move them to a different group too.

Thanks Nathen.

 

Well, I never knew that.

Learn something new every day 🙂 

Excellent - many thanks (and I'm glad I asked) 👍

Me again - I clicked on the prune and just as the screen was refreshing, I noticed the message recommending a database backup 🤦‍♂️

Can that be done via the portal or do we have to do that manually on our server?

The prune function said the action was queued and has not yet been done so I'm assuming it might happen overnight (?) which means I may have time to do a backup before that?

EDIT: ah, forget it, I see the pruning has started in the background...

Edited November 7, 20222 yr by rhocar

That is something you would need to do on your server. You would need to backup database and files. Its something you should have a regular backup of in any case, if you are self hosting