Announcement

Collapse
No announcement yet.

MySQL error 1064

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • MySQL error 1064

    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:

    Code:
    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: http://www.***.com/Boards/forumdisplay.php?f=28
    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?
    http://wyrldscape.com
    Free Form Gaming with style and dedication.

  • #2
    Try reuploading the original forumdisplay.php file.

    Comment


    • #3
      Reupload the original forumdisplay.php file.
      Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
      Change CKEditor Colors to Match Style (for 4.1.4 and above)

      Steve Machol Photography


      Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


      Comment


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

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

        My Blog | Twitter

        Comment


        • #5
          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.
          http://wyrldscape.com
          Free Form Gaming with style and dedication.

          Comment

          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
          Working...
          X