Forum Display Issue

Error Displaying Forum Homepage
This has only started occuring this morning.
Last night all was working fine.

1. Address of Forums -http://kb.vianet.net.au
2. PHP Version - 4.1.2
3. MySQL version - v3.23.49-log
4. Apache/webserver version - apache
5. Server operating system - Red Hat
6. Any error message you are getting - see below
7. Whether or not you have edited any files -no (see below)

PHP info : http://kb.vianet.net.au/phpinfo.php


Now im getting this error :

Database error in vBulletin 2.2.6:

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: Thursday 06th of June 2002 09:34:43 AM
Script: http://kb.vianet.net.au/index.php?s=
Referer:


This is only occuring when trying to access /index.php (forums homepage)
All other pages display fine

Has anyone got any idea what may be causing this and how to fix it ?
Thankyou

[SemperFidelis]

Was getting caused by the changes made to index.php in Fireflys "Member of the Day" hack

Still, its rather odd that this wasnt a problem for the last week since I installed it

[Chris M]

This is an error that I have seen before...

It requires some sort of update from vB.com...

Satan

[Xenon]

i think fireflys hack isn't compatible with php 4.2.x.......

[SemperFidelis]

Im running vb 2.2.6 at th moment (have been since the rc came out)
Im also still running PHP 4.1.2

Hellsatan - any ideas what that update is ?

[FWC]

Originally posted by v-net

WHERE userid<>

You are missing a value here. The userid needs to be not equal to something.

[SemperFidelis]

Originally posted by FWC
You are missing a value here. The userid needs to be not equal to something.

Thats rather odd as thats exactly how it is in the member of the day hack

[FWC]

It looks like you are supposed to have the value $daybits[1] there.

[SemperFidelis]

Thanks FWC
Ill go looking for that now