How to mass remove/delete [Deleted User] from Dashboard > Users > Users ?
I recently moved a vanilla installation (http://pennlpssa.org/forum) to a new server (http://22.214.171.124/~lpssa/forum/). The export/import went smoothly except for one weird issue. When I visit Dashboard > Users > Users it says there are 18,838 users, instead of 39.
On the original installation, I did have that many users, due to rampant spam. After I installed the Botstop plugin and changed Registration to Confirm Email, I deleted 18,000+ spam users with the Cleanser plugin, whittling it down to a legitimate 39. But now my members list has ballooned back to that absurd number, which includes 18,000+ users with the name [Deleted User]. I compared my original vanilla database to the new one, and they both show the same amount of users under GDN_User, which is to say 18,838. But on the original install, it only recognizes and/or displays 39 as legitimate, i.e. only 39 members actually show up under Dashboard > Users > Users, and on the "Members List" section.
Any ideas how to fix this, without deleting 18,000+ database entries? I already tried that and it's ridiculously slow loading even 1000+ entries at once, let alone deleting them. My database seems to time out after 100 at a time.