MySQL error 1064

[Erik]

When trying to view a forum (by clicking on it from forum home) I get a technical error which states I have a problem with a divide by zero. One example of such an error is:

Database error in vBulletin 3.0.3:
 
Invalid SQL: 
 
SELECT threadid		
FROM thread AS thread				
 
WHERE forumid = 28			
	 AND sticky = 0			
	 AND visible = 1 
 
	 AND lastpost >= 1088300380								
 
ORDER BY sticky DESC, lastpost DESC		
LIMIT 0, 	
 
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 '' at line 12
 
mysql error number: 1064
 
Date: Monday 26th of July 2004 09:39:40 PM
Script: [url="http://www.***.com/Boards/forumdisplay.php?f=28"][color=#0000ff]http://www.***.com/Boards/forumdisplay.php?f=28[/color][/url]
Referer: 
Username: GM Erik
IP Address: 67.******

There are currently no posts in the forum, but I can't imagine that having so serious an effect on things. Any thoughts as to what might be giving me this error message?

[Zachery]

Try reuploading the original forumdisplay.php file.

[Steve Machol]

Reupload the original forumdisplay.php file.

[Scott MacVicar]

what line number does it show the divide by 0 on?

i think you have set your threads per page to 0 somewhere.

[Erik]

If that isn't a bit of intuitive genius! The error was in line 12, and the error was indeed in the default threads per page before breaking to a new page. That field had been erased, which I assume is interpreted as a zero.

Thanks for the speedy answer.