How do I move 6 people out of a usergroup when it errors out?

[Gutspiller]

I'm trying to move some users out of a usergroup and I get this error:

There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.


Database error in vBulletin Control Panel: Invalid SQL: SELECT COUNT(*) AS users FROM user,usergroup WHERE user.usergroupid=usergroup.usergroupid AND usergroup.cancontrolpanel=1 AND user.userid<>
mysql error: You have an error in your SQL syntax near '' at line 1
mysql error number: 1064
Date: Saturday 19th of April 2003 04:40:12 AM
Script: /forumz/blah
Referer: http://www.theforumz.com/forumz/blah

I took somethings out and replaced with "blah" just incase they could be abused.

I have done my research and it looks like this is the infamous php 4.2x (i think that version is right) upgrade problem, where older VBs have problems working with newer versions of PHP. I know I need to update to the latest version of php, but because of all the tweaks on my forum I'm waiting for VB3 to do this. I have work I need to do and am at a stand still.

I was hoping there might be a work around, so I don't have to update my VB code now, only to update it again once VB3 is released. Any query or something I can run manually that will help me get 6 users from one usergroup to another?

I desperately need this, if anybody could help me I would GREATLY appreciate it.

Thanks!

[Xenon]

[SQL]UPDATE user SET usergroupid=x WHERE userid=y[/sql]

but you should really upgrade your board if you want to be save from hackers.....

it doesn't take that long even for real strong hacked boards..

[Gutspiller]

Today at 05:28 AM Xenon said this in Post #2
[SQL]UPDATE user SET usergroupid=x WHERE userid=y[/sql]

but you should really upgrade your board if you want to be save from hackers.....

it doesn't take that long even for real strong hacked boards..

Many thanks!

I'm partily worried about updating my board because of my so many hacks, but I'm also affraid that I will get lost half way through.

If I backup all the php files in my forum directory and then when I upload the new files, if they don't work I can always replace them with my old ones I just backed up right?

How often do hacks stop working after a manual update?

[Xenon]

nope, once you've done the DB changes it's hard to restore the old status, just if you have a complete DB Backup.

Second question: I never lost any hack through updating.
If you are carefully and know what you do you won't loose anything.