PDA

View Full Version : another sql error

DarkDraco07
09-08-2002, 02:54 PM
Database error in vBulletin 2.2.7:

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: Sunday 08th of September 2002 09:50:44 AM
Script: http://www.darknemesis.com/forums/forums/
Referer:

i left the forums workong fine, the when i got on this morning this happened
DarkDraco07
09-08-2002, 03:01 PM
and at the obttom where it says script why does it say /forums/forums/ twice?
DarkDraco07
09-09-2002, 01:44 AM
can someone help me, this is kinda important. it wont display none of the forum
g-force2k2
09-09-2002, 01:45 AM
which file is this occuring in? try and replace the file with an unhacked one... regards...

g-force2k2
DarkDraco07
09-09-2002, 01:53 AM
its the index.php
g-force2k2
09-09-2002, 02:00 AM
DD07 did you try replacing it with a fresh index.php yet? see if that fixes the problem... if not it could be because of the php that your host is running (or mysql)

regards...

g-force2k2
DarkDraco07
09-09-2002, 05:39 PM
its was the member of the day hack. i installed it right but when i run the sql error, it wont save. like, i can run it over and over, it says its inserted but its not.
Velocd
09-09-2002, 06:04 PM
WHERE userid<> AND (usergroupid=5 OR usergroupid=6 OR usergroupid=7 OR usergroupid=2


Shouldn't WHERE userid<> have some kind of value after it?

Try replacing that segment with:

WHERE userid<>0