MyBB Community Forums

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

(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.

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.

so what would the query be then?

Use Yaldaram's suggestion.