Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Not Solved [How To?] Delete All Banned Members
#11
Not Solved
Oh! Who said this query? There is no gid in users table. :/

To run User Pruning, follow this: http://community.mybb.com/thread-110102-...#pid801235 and then: http://community.mybb.com/thread-113807-...#pid842305
#12
Not Solved
(2012-11-21, 01:11 PM)Bet-Gangster Wrote: 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'

That is because there is no gid in the users table. The right column name would be usergroup.
#13
Not Solved
http://mods.mybb.com/view/goodbye-spammer for single deletes. But you want to do it for 500 users so this method would take a lot of time.And yes Vernier's query should of used usergroup not gid.
#14
Not Solved
so what would the query be then?
#15
Not Solved
Use Yaldaram's suggestion.


Forum Jump:


Users browsing this thread: 1 Guest(s)