Database problem
 

When trying to change a user's status, i get this error:
-----
There seems to have been a slight problem with the Awesome Forums 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 2.2.5:

Invalid SQL: SELECT userid
FROM user
WHERE username='ChRiS'
AND userid <>
mysql error: You have an error in your SQL syntax near '' at line 4

mysql error number: 1064

Date: Monday 24th of March 2003 04:43:14 PM
------

Can anyone tell me what to do to solve this problem or point me in the right direction ? :(

Update:
I *think* the problem began when running this query in the database for the shoutbox:

CREATE TABLE `shoutbox` (
`shoutid` int(11) NOT NULL auto_increment,
`userid` int(11) NOT NULL default '0',
`shout_text` text NOT NULL,
`timestamp` int(11) NOT NULL default '0',
PRIMARY KEY (`shoutid`)
) TYPE=MyISAM;

Since then my 'active users today' doesn't seem to be working either :(

Anyone able to help please?

I think that this is a bug in 2.2.5 (<> empty), i recommend upgrading to a new version.

Lesane is right, it's a bug with vb versions below 2.2.6 and php versions over 4.2.x

Hmmm i never updated before...
Any tutorials for it or is it too easy?

look at my sig, there is a lint to a tutorial :)

another question: can i update directly from 2.2.5 to 2.2.9?

yes, just follow the instructions in the tutorial for the files and then run the right upgrade srcipt (you can see which one to run after runnen any one of them ;))

Ok, thank u for the help...
I'm upgrading now...
Fingers crossed :(

I edited all the code with the program the way u described in your tutorial.
Do i need to install upgrade scripts too?
Just go to /admin/upgrade20.php for example and run it?
What if anything goes wrong with that? Can it be put back? or only by replacing db with an earlier one?