Help...

Database error in vBulletin 2.2.8:

Invalid SQL: SELECT userid,username
FROM user
WHERE userid<>
AND (usergroupid=5
OR usergroupid=6
OR usergroupid=7
OR usergroupid=2)
ORDER BY RAND()
LIMIT 1
mysql error: You have an error in your SQL syntax near 'AND (usergroupid=5
OR usergroupid=6
' at line 4

mysql error number: 1064

Date: Saturday 05th of October 2002 05:27:03 PM
Referer:

I get this error message, I think it has something to do with the country flag hack, anyone got any ideas what I've done wrong?

[JulianD]

Well, the problem seems to be here:

WHERE userid<>

You need to put something like :

WHERE userid<>'$userid'

Just check what you've installed in the last few days....

[Steve Machol]

Reupload the original user.php file from the 2.2.8 zip file. Make sure you upload in ASCII and overwrite the one on the server.

[FWC]

You overwrote a critical change to user.php when you intsalled the hack. Search for this code in your hacked file:

PHP Code:

$user=$DB_site->query_first("SELECT *,FROM_UNIXTIME(joindate) AS joindate 


and replace it with this code from vB 2.2.8

PHP Code:

$user=$DB_site->query_first("SELECT user.*,FROM_UNIXTIME(joindate) AS joindate