PDA

View Full Version : Forum Display Issue

SemperFidelis
06-06-2002, 02:20 AM
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
06-06-2002, 03:54 AM
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
06-06-2002, 11:30 AM
This is an error that I have seen before...

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

Satan
Xenon
06-06-2002, 12:58 PM
i think fireflys hack isn't compatible with php 4.2.x.......
SemperFidelis
06-06-2002, 11:52 PM
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
06-07-2002, 03:51 AM
Originally posted by v-net

WHERE userid<> You are missing a value here. The userid needs to be not equal to something.
SemperFidelis
06-07-2002, 04:36 AM
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
06-07-2002, 04:56 AM
It looks like you are supposed to have the value $daybits[1] there.
SemperFidelis
06-07-2002, 04:59 AM
Thanks FWC
Ill go looking for that now
:)