PDA

View Full Version : Sql Errors Out Of No Where....


garoboldy
Sat 18th May '02, 3:32am
Database error in vBulletin 2.2.5:

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 18th of May 2002 12:17:49 AM
Script: http://www.evolutionaryconcepts.com/forum/forum/index.php
Referer:




What in the world happened....everything was fine and now I am getting this when I go to my index.php page.....PLEASE HELP QUICK....Whole thing is down and dont know why....

:confused: :confused: :confused:

Steve Machol
Sat 18th May '02, 3:43am
Did you host just upgrasde to PHP 4.2.0 by any chance? If so, then you should apply the fixes found here:

http://www.vbulletin.com/forum/showthread.php?s=&threadid=44820

Do you have a phpinfo.php file? If not create one with this content:

<?php
phpinfo();
?>Upload it to your forum directory and post the URL here.

garoboldy
Sat 18th May '02, 12:28pm
www.evolutionaryconcepts.com/forum/phpinfo.php

give me a sec while I upload the file...

garoboldy
Sat 18th May '02, 12:32pm
I just applied the changes that were in the .zip file to my 2.2.5 board. I am still getting the error.:confused:

garoboldy
Sat 18th May '02, 12:41pm
in the phpinfo.php I ran it and it says that the php is 4.1.2....

thought I would let ya know on that..

garoboldy
Sat 18th May '02, 12:56pm
NEVERMIND...I cant get to that either......

I am there right now....will be for a few hours...get there if you got info or questions..thanks.:mad: :confused: :mad:

Steve Machol
Sat 18th May '02, 3:18pm
What is the status on this? Your phpinfo.php link is producing a '404 File Not Found' error.