Download wpForo 3.0

AI Search
Classic Search
 Search Phrase:
 Search Type:
Advanced search options
 Search in Forums:
 Search in date period:

 Sort Search Results by:

AI Assistant
Forums
wpForo Support Foru...
How-to and Troubles...
How do I delete 32,...
 
Notifications
Clear all

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

    Summarize Topic
How-to and Troubleshooting - wpForo 2.0
Last Post by Sofy 1 year ago
2 Posts
2 Users
1 Reactions
1,003 Views
RSS
Posts: 127
 mplusplus
Topic starter
Translate ▼
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
Mar 23, 2025 1:14 am
(@mplusplus)
Reputable Member
Joined: 6 years ago
[#62284]

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.


Topic Tags
inactive users delete users SQL
1 Reply
Sofy
Posts: 5774
 Sofy
Admin
Translate ▼
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
Mar 26, 2025 3:39 pm
(@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.


In case you want to say thank you 😊

We'd really appreciate and be thankful if you leave a good review on plugin page. This is the best way to say thank you to this project and support team.

Reply
mplusplus reacted
Forum Jump:
  Previous Topic
Next Topic  
Related Topics
Topic Tags:  inactive users (11) , delete (8) , users (15) , SQL (5) ,
Share: