Announcement

Collapse
No announcement yet.

Database error when not logged in?

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

  • Database error when not logged in?

    When I try viewing any thread as a guest:

    <!-- Database error in vBulletin 2.3.0:
    Invalid SQL:
    SELECT post.postid FROM post
    WHERE post.threadid='57361' AND post.visible=1
    ORDER BY dateline LIMIT 0,20,30,40
    mysql error: You have an error in your SQL syntax near '30,40
    ' at line 4
    mysql error number: 1064

    I know it has something to do with the ACP settings w/ number of posts per page. But I'm not sure how to fix it.
    Matthew Yette
    [email protected]
    antsmarching.org - People in every direction

  • #2
    Please post the complete error message, including the script info.
    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


    • #3
      Originally posted by Steve Machol
      Please post the complete error message, including the script info.
      <html><head><title>antsmarching.org Database Error</title><style>P,BODY{FONT-FAMILY:tahoma,arial,sans-serif;FONT-SIZE:11px;}</style><body>
      <!-- Database error in vBulletin 2.3.0:
      Invalid SQL:
      SELECT post.postid FROM post
      WHERE post.threadid='57552' AND post.visible=1
      ORDER BY dateline LIMIT 0,20,30,40
      mysql error: You have an error in your SQL syntax near '30,40
      ' at line 4
      mysql error number: 1064
      Date: Saturday 12th of April 2003 12:14:56 PM
      Script: http://www.antsmarching.org/forum/fo...threadid=57552
      Referer: http://www.antsmarching.org/forum/fo....php?forumid=3
      -->
      </table></td></tr></table></form>
      <blockquote><p>&nbsp;</p><p><b>There seems to have been a slight problem with the antsmarching.org database.</b><br>
      Please try again by pressing the <a href="javascript:window.location=window.location;">refresh</a> button in your browser.</p>An E-Mail has been dispatched to our <a href="<A href='mailto:[email protected]">Technical'>mailto:[email protected]">Technical Staff</a>, who you can also contact if the problem persists.</p><p>We apologise for any inconvenience.</p></blockquote></body></head></html>
      Matthew Yette
      [email protected]
      antsmarching.org - People in every direction

      Comment


      • #4
        Reupload the original showthread.php file from the 2.3.0 zip file. Make sure you upload in ASCII and overwrite the one on the server.
        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


        • #5
          Originally posted by Steve Machol
          Reupload the original showthread.php file from the 2.3.0 zip file. Make sure you upload in ASCII and overwrite the one on the server.
          Still no good.

          <html><head><title>antsmarching.org Database Error</title><style>P,BODY{FONT-FAMILY:tahoma,arial,sans-serif;FONT-SIZE:11px;}</style><body>
          <!-- Database error in vBulletin 2.3.0:
          Invalid SQL:
          SELECT post.postid FROM post
          WHERE post.threadid='57635' AND post.visible=1
          ORDER BY dateline LIMIT 0,20,30,40
          mysql error: You have an error in your SQL syntax near '30,40
          ' at line 4
          mysql error number: 1064
          Date: Saturday 12th of April 2003 08:37:32 PM
          Script: http://www.antsmarching.org/forum/fo...threadid=57635
          Referer: http://www.antsmarching.org/forum/fo....php?forumid=3
          -->
          </table></td></tr></table></form>
          <blockquote><p>&nbsp;</p><p><b>There seems to have been a slight problem with the antsmarching.org database.</b><br>
          Please try again by pressing the <a href="javascript:window.location=window.location;">refresh</a> button in your browser.</p>An E-Mail has been dispatched to our <a href="<A href='mailto:[email protected]">Technical'>mailto:[email protected]">Technical Staff</a>, who you can also contact if the problem persists.</p><p>We apologise for any inconvenience.</p></blockquote></body></head></html>
          Matthew Yette
          [email protected]arching.org
          antsmarching.org - People in every direction

          Comment


          • #6
            Fill out a support ticket at:

            http://www.vbulletin.com/members/support_form.php

            Be sure to include the login info to your Admin CP, phpMyAdmin and FTP.
            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

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