Can I mass delete my inactive users? - How-to and Troubleshooting - wpForo 2.0

RE: Can I mass delete my inactive users?

Robert — Mon, 25 Sep 2023 10:52:10 +0000

Hi @aar,

Use PhpMyAdmin plugin or the same tool in your hosting cPanel, go to the SQL tab and execute the following SQL. Make sure you have a backup of your database. Also, please make sure your table prefix is wp_, if it isn't, change all red marked wp_ prefixes to yours.

DELETE u, um, p FROM ***wp_***users u
   INNER JOIN ***wp_***wpforo_profiles p ON p.`userid`   = u.`ID`
       LEFT JOIN ***wp_***usermeta    um ON um.`user_id` = u.`ID`
WHERE p.`posts` = 0
AND u.`ID` NOT IN( SELECT DISTINCT `post_author` FROM ***wp_***posts )
AND p.status = 'inactive'

RE: Can I mass delete my inactive users?

dimalifragis — Sun, 24 Sep 2023 16:31:08 +0000

Hi,

What "crashes" exactly means? What is the error?

Also this should be removed from wpForo pages.

Can I mass delete my inactive users?

AAR — Sun, 24 Sep 2023 16:20:28 +0000

When I try and mass delete my inactive users, the forum software crashes. I'd like to delete 25K inactive users. Is there a way to do this?

Thanks.