rhocar Posted November 4, 2022 Posted November 4, 2022 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?
Solution Nathan Explosion Posted November 4, 2022 Solution Posted November 4, 2022 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. Daddy, rhocar and Richard Arch 1 2
Richard Arch Posted November 4, 2022 Posted November 4, 2022 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.
Marc Posted November 7, 2022 Posted November 7, 2022 On 11/4/2022 at 7:14 PM, Richard Arch said: Well, I never knew that. Learn something new every day 🙂
rhocar Posted November 7, 2022 Author Posted November 7, 2022 Excellent - many thanks (and I'm glad I asked) 👍
rhocar Posted November 7, 2022 Author Posted November 7, 2022 (edited) 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, 2022 by rhocar
Marc Posted November 7, 2022 Posted November 7, 2022 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 Bionic Rooster 1
Recommended Posts