Forum Previous and Next Thread SQL Error Message when viewing only first thread in forum
 

Hi*
When I go to a forum on my site* I can click the first thread in that forum and then after reading posts* etc. I see the "Previous thread | Next Thread" option after the last post. When I click on the previous thread link it works. But it does not work when I click the next thread link and it gives me the following SQL error message:

Quote:
Database error in vBulletin 4.0.0:

Invalid SQL:

SELECT thread.threadid* thread.title

FROM thread AS thread

WHERE forumid = 7
AND visible = 1
AND open 10


AND lastpost >
ORDER BY lastpost
LIMIT 1;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY lastpost
LIMIT 1' at line 11
Error Number : 1064
Request Date : Tuesday* December 29th 2009 @ 12:50:19 AM
Error Date : Tuesday* December 29th 2009 @ 12:50:20 AM
Script : http://www.raptureforums.com/forum/s...oto=nextnewest
Referrer : http://www.raptureforums.com/forum/p...n-markell.html
IP Address : removed by poster
Username : Chris
Classname : vB_Database
MySQL Version : 5.0.68-log

Any ideas as to why this might happen?