Guests - Set To View Forums - Click Thread ERRORS

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Necrosaro420
    Member
    • Jun 2006
    • 79
    #1

    Guests - Set To View Forums - Click Thread ERRORS

    I have my forums set so guests can view the forum, but when they click on one (Off Topic on front page for example) I get a white page that says


    Database error The xxxxxxx.net database has encountered a problem.
    Please try the following:
    • Load the page again by clicking the Refresh button in your web browser.
    • Open the www.xxxxxx.net home page, then try to open another page.
    • Click the Back button to try another link.
    The www.xxxxxxxxx.net forum technical staff have been notified of the error, though you may contact them if the problem persists.
    We apologise for any inconvenience.
    Tags: None
    • RagnarokDensetsu
      Senior Member
      • Nov 2005
      • 390
      • 3.7.x
      #2
      What is the content of the message you recieve in your technical email?

        Comment

        • Steve Machol
          Former Customer Support Manager
          • Jul 2000
          • 154488
          #3
          Also you can right-click on the error page and go to View/Source. Then copy-n-paste the error message here.
          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

            • Necrosaro420
              Member
              • Jun 2006
              • 79
              #4
              Here is the Source of the error page

              <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html><head> <title>NESForums.net Database Error</title> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" /> <style type="text/css"> <!-- body { background-color: white; color: black; } #container { width: 400px; } #message { width: 400px; color: black; background-color: #FFFFCC; } #bodytitle { font: 13pt/15pt verdana, arial, sans-serif; height: 35px; vertical-align: top; } .bodytext { font: 8pt/11pt verdana, arial, sans-serif; } a:link { font: 8pt/11pt verdana, arial, sans-serif; color: red; } a:visited { font: 8pt/11pt verdana, arial, sans-serif; color: #4e4e4e; } --> </style></head><body><table cellpadding="3" cellspacing="5" id="container"><tr> <td><img src="./image.php?type=dberror" alt="Database Error" width="48" height="48" /></td> <td id="bodytitle" width="100%">Database error</td></tr><tr> <td class="bodytext" colspan="2">The NESForums.net database has encountered a problem.</td></tr><tr> <td colspan="2"><hr /></td></tr><tr> <td class="bodytext" colspan="2"> Please try the following: <ul> <li>Load the page again by clicking the <a href="#" onclick="window.location = window.location;">Refresh</a> button in your web browser.</li> <li>Open the <a href="/">www.nesforums.net</a> home page, then try to open another page.</li> <li>Click the <a href="javascript:history.back(1)">Back</a> button to try another link.</li> </ul> </td></tr><tr> <td class="bodytext" colspan="2">The www.nesforums.net forum technical staff have been notified of the error, though you may <a href="mailto:[email protected]">contact them</a> if the problem persists.</td></tr><tr> <td class="bodytext" colspan="2">&nbsp;<br />We apologise for any inconvenience.</td></tr></table><!--Database error in vBulletin 3.6.2:Invalid SQL: SELECT IF(votenum &gt;= 1, votenum, 0) AS votenum, IF(votenum &gt;= 1 AND votenum &gt; 0, votetotal / votenum, 0) AS voteavg, thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid, thread.lastpost, thread.lastposter, thread.lastpostid, thread.dateline, IF(views&lt;=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach, hiddencount, deletedcount ,post.pagetext FROM thread AS thread WHERE thread.threadid IN (0,1278,999,1571,1563,1542,1478,1554,1543,1541,1519,698,1453,1437,1471,1461,1503,1429,1450 ,1440,1383,799,527,1515,1549,320) ORDER BY sticky DESC, lastpost DESC;MySQL Error : Unknown table 'post' in field listError Number : 1109Date : Thursday, November 2nd 2006 @ 03:05:44 PMScript : http://www.nesforums.net/forumdisplay.php?f=2Referrer : http://www.nesforums.net/IP Address : 74.129.123.142Username : UnregisteredClassname : vb_database--></body></html>

                Comment

                • Necrosaro420
                  Member
                  • Jun 2006
                  • 79
                  #5
                  Here is the error email it sends me


                  Database error in vBulletin 3.6.2:Invalid SQL: SELECT IF(votenum >= 1, votenum, 0) AS votenum, IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg, thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid, thread.lastpost, thread.lastposter, thread.lastpostid, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach, hiddencount, deletedcount ,post.pagetext FROM thread AS thread WHERE thread.threadid IN (0,1129,1160,1136,924,871,897,384,742,376,18) ORDER BY sticky DESC, lastpost DESC;MySQL Error : Unknown table 'post' in field listError Number : 1109Date : Thursday, November 2nd 2006 @ 03:08:23 PMScript : http://www.nesforums.net/forumdisplay.php?f=8Referrer : http://www.nesforums.net/IP Address : 74.129.123.142Username : UnregisteredClassname : vb_database

                    Comment

                    • Steve Machol
                      Former Customer Support Manager
                      • Jul 2000
                      • 154488
                      #6
                      Invalid SQL errors are almost always related to modified code. To troubleshoot this, the first thing you need to do is remove any hacks or plugins, then see if you still have this problem.

                      If so, reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.

                      Next, create a new style and choose no parent style. This will force it to use the default templates. Finally empty your browser cache, close all browser windows then try again. Make sure you change to the new style and view your forums with it. Do you have the same problem?
                      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

                        • Necrosaro420
                          Member
                          • Jun 2006
                          • 79
                          #7
                          This would cause me to lose all of my edits though...correct? If so, im not sure if that is the route I want to go lol

                            Comment

                            • Steve Machol
                              Former Customer Support Manager
                              • Jul 2000
                              • 154488
                              #8
                              If you have edited the vB files, yes. Otherwise no.
                              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

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