Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Not Solved [How To?] Delete All Banned Members
#1
Not Solved
My forum has over 500 banned spammy members. I need to delete them all is there anyway to do it?
#2
Not Solved
This query will delete all banned accounts:

DELETE FROM `mybb_users` WHERE `gid`='7'

To delete the posts too, read this:

http://community.mybb.com/thread-113807-...#pid842305
[Image: information.gif] MyBB Support Technician
Please do not PM me for support.


MyBBatically - A quick and easy way to update your board!
#3
Not Solved
where do I run it?
#4
Not Solved
You need to run it in PHPMyAdmin (or whatever database manager you use) Smile
[Image: information.gif] MyBB Support Technician
Please do not PM me for support.


MyBBatically - A quick and easy way to update your board!
#5
Not Solved
deleting a user is a bad for seo. Just keep it. It doesent matter if your site has a ban members
#6
Not Solved
Can you give me a quick description where to enter

DELETE FROM mybb_users WHERE gid='7'

in phpmyadmin

thanks
#7
Not Solved
Go to phpmyadmin > select your forums database > click SQL > paste given SQL press go.
.m.  Very helpful staff member, very knowledgeable.
#8
Not Solved
Instead of running a query, you should have to run User Pruning. Because query will delete the users however their traces of posts left behind. So its better to use User Pruning.
#9
Not Solved
(2012-11-20, 08:11 PM)Yaldaram Wrote: Instead of running a query, you should have to run User Pruning. Because query will delete the users however their traces of posts left behind. So its better to use User Pruning.

I second this advice as well. It would be much handier that way rather than deleting them with a query.
#10
Not Solved
How do I run user pruning?

(2012-11-20, 07:11 PM)markwesley Wrote: Go to phpmyadmin > select your forums database > click SQL > paste given SQL press go.

I tried to do it there and got this error

#1054 - Unknown column 'gid' in 'where clause'


Forum Jump:


Users browsing this thread: 1 Guest(s)