PDA

View Full Version : Error message: what does this mean?


Peter Porker
Sun 7th Jan '01, 7:13am
I continually get the same error message in my email from the server, and have no idea what to do about it. Can anyone give me clear instructions on what to do to fix this?

Here's the error message (same one every time)....

Database error in vBulletin: Invalid SQL: SELECT DISTINCT
threadid,
lastpost
FROM thread
WHERE visible=1 AND () AND thread.lastpost>978860926
ORDER BY lastpost DESC
mysql error: You have an error in your SQL syntax near ') AND thread.lastpost>978860926
ORDER BY lastpost DESC' at line 5
mysql error number: 1064
Date: Sunday 07th of January 2001 02:52:05 AM
Script: //search.php?getdaily=yes&action=dosearch&searchdateline=978860926

Fquist
Tue 9th Jan '01, 8:52am
bump

Mike Sullivan
Tue 9th Jan '01, 12:13pm
version?
hacked?

We need that info.

Peter Porker
Tue 9th Jan '01, 1:03pm
Sorry...it's version 1.1.14 and yes, it's hacked, but only with the latest PM hack.

Mike Sullivan
Tue 9th Jan '01, 1:08pm
Well, that same syntax works here: http://www.vbulletin.com/forum/search.php?getdaily=yes&action=dosearch&searchdateline=979058099 so it leads me to believe that it's something in your search.php. Try replacing it from a newly downloaded zip. :)

And why the double slash in the beginning?

Peter Porker
Tue 9th Jan '01, 3:59pm
Thanks...I'll try that.

...as for the double slash, I have no idea...I'm a newbie at all this, so didn't know that wasn't correct. Just copy&pasted it right from the email.