Notifications
Clear all

Limited Support

Our team is currently on holiday, so support will be limited during this period. Response times may be slower than usual, and some inquiries may be delayed.
We appreciate your patience and understanding, and we’ll resume our usual support by the end of August.

 

How do I delete 32,000 inactive users (UI can do only handful at a time)?

2 Posts
2 Users
1 Reactions
394 Views
Posts: 127
Topic starter
(@mplusplus)
Reputable Member
Joined: 6 years ago

Hi there,

My WPForo has over 32,000 inactive users (bot attack) and I need to delete them all. (Admin UI allows only a handful at a time, so I need a better way). 

Is there a MariaDB SQL Query that I can run or do something else to delete all inactive users in one go? I have attached the list of table names in my database.

Thanks.

 

PS: I found some SQL queries but they did not work for my case.

1 Reply
Sofy
Posts: 5483
 Sofy
Admin
(@sofy)
Support Team
Joined: 8 years ago

Hi,

You can use the code provided here: https://wpforo.com/community/how-to-and-troubleshooting-2/delete-inactive-users/#post-77189.

Just change the prefix according to your website.

Reply