Delete all users from a certain usergroup?
 

When I try to prune a certain set of users (example: all users awaiting email confirmation who haven't visited the system since May 1, 2003) I get a VB error :(

What SQL query could I run that will delete the users?

To make it easier, I can move the set of users to the POST BAN category and then run a SQL query that deletes all users who are in the POST BAN group.

Can anybody offer some insight? Thanks!

Are you running the latest version of vB? If not, the database error itself would help.

My apologies. VB version 2.2.7 - waiting to upgrade until v3 is released.

The DB error displayed below, pops up AFTER the following information is displayed:

Deleting forum subscriptions .... okay.

Deleting thread subscriptions .... okay.

Deleting calendar events .... okay.

Deleting custom avatars .... okay.

Deleting forum access .... okay.

Deleting moderators .... okay.

Deleting private messages .... okay.

Deleting user sessions .... okay.

Now proceding to update threads & posts ....


DB Error:

Database error in vBulletin Control Panel 2.2.7:

Invalid SQL: SELECT userid,username FROM user WHERE userid IN() LIMIT 0,50
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') LIMIT 0,50' at line 1

mysql error number: 1064

Date: Tuesday 20th of May 2003 02:49:23 PM
Script: http://www.domain.com/forum/forum/ad...osts&startat=0
Referer: http://www.domain.com/forum/admin/user.php

I think this was a bug. Always stay up to date on your vB version for important security reasons. :)

So is there no easy way to run a SQL query to remove all users from the POST BAN usergroup?

Easy, yes. Clean, no. I instead recommend that you upgrade.

I am running 2.3.0 and I get that same error....

if your board is not hacked (particularly file user.php), this might be a bug, report to vb.com. If you hacked user.php, it is the problem of the hack so remove that hack from your file and retry