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

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

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

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

Satan

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

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 ?

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

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

Thanks FWC
Ill go looking for that now
:)