hi there,
just discovered that in my wp_registration_log and wp_signup tables there are hundreds of people/email addresses left over from spammers and so on and so forth.
whats the easiest way to clean it up?
would there maybe be a code for the powertools plugin to delete all that don't actually have an active blog/user at the moment?
seahawknationblog
Member
Posted 1 year ago #
This Plugin will take care of everything deleted spam, users deleted, deleted blogs and posts, just about everything you need it to do it can do!!
http://plugins.paidtoblog.com/wpmu-power-tools/
nope it doesn't clean the tables I mentioned, at least not on my installation.
seahawknationblog
Member
Posted 1 year ago #
Just go into database and delete the file on your server if you know how to do this?
well its not a file, its a table, and yes, I can clean it out manually, but I wouldn't want to delete existing and active users, and I don't want to manually check a 400 entries list for 12 active users and delete all others...
that is why I was asking for a code to use powertools and do it automatically?
kunal17
Member
Posted 10 months ago #
Do you mean records for people who register but do not activate? Does WPMU not handle this automatically? i.e. users that do not activate through the email are deleted automatically after 2/3 days?
well, my wp_registration_log is pretty full
Going to make me log into a server. I thought I was going to get away with not doing so this morning.... :)
wp_signups is the one that gets emptied after 48 hours.
I would leave wp_r_log alone to be honest as that is a record of where folks are signing up from. We use it to check against known spammers to see if they;ve signed up any other accounts.
kunal17
Member
Posted 10 months ago #
wp-signups does not seem to clean out activated emails even after I delete the users. Therefore, I am unable to reuse email addresses for test users unless I go in and manually clean them out. What can I do to fix this?