Announcement

Collapse
No announcement yet.

Admin Homepage Messed Up

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

  • Admin Homepage Messed Up

    Hi,

    I've just upgraded to vBulletin 7.0 RC 3, and followed all of the steps, etc. I then was taken to the admin homepage, to turn my forums back on, but the admin homepage won't display. I keep getting:

    Database error
    Database error in vBulletin 3.7.0 Release Candidate 3:

    Invalid SQL:

    SELECT COUNT(*) AS count
    FROM moderation AS moderation
    INNER JOIN post AS post USING (postid)
    WHERE moderation.type='reply';

    MySQL Error : Unknown column 'midnigi5_forums.moderation.postid' in 'on clause'
    Error Number : 1054
    Date : Sunday, April 20th 2008 @ 11:10:29 AM
    Script : http://midnightneoforums.com/admincp/index.php?do=home
    Referrer : http://midnightneoforums.com/admincp/index.php?do=nav
    IP Address : ---------
    Username : itsIAN
    Classname : vb_database
    MySQL Version : 4.1.22-standard


    Anyone know why it's doing this?

  • #2
    Follow instruction to the letter...
    http://www.vbulletin.com/forum/showp...37&postcount=2

    Comment


    • #3
      I'm not having trouble connecting to the database, it's just that when I login into my admincp, the front page has a database error.

      Should I still do what you said, or not?

      Comment


      • #4
        You can wait for 'Offical Responce' from the staff here...

        You can just try this to see if you have any files that do not belong or have not been overwritten from an upgrade.
        Admin CP -> Maintenance -> Diagnostics -> Suspect File Versions

        [Note: In some cases you may also need to remove any of the listed .xml files in the includes/xml directory.]

        That error is maybe from a corrupt file on servers host side in folder admincp/

        Comment


        • #5
          I ran the test, and it came up with quite a few files. And yes, it does have the admin one listed. (for it's index)

          index.php File version mismatch: found 3.6.9, expected 3.7.0 Release Candidate 3

          So, what do I do to fix this?

          Comment


          • #6
            That means you did not upload all the 3.7.0 RC3 files. Upload those and overwrite the ones 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


            • #7
              Upload admincp folder files again in ASCII mode to overwrite older version and it should fix this issue of yours.


              I see that 'Official Response' member is now taken this thread.

              Time to slip away.

              Comment


              • #8
                What is ASCII mode, sorry?

                Comment


                • #9
                  Originally posted by Steve Machol View Post
                  That means you did not upload all the 3.7.0 RC3 files. Upload those and overwrite the ones on the server.
                  I'm pretty sure I did, but I'll try again.

                  Comment


                  • #10
                    Originally posted by itsIAN View Post
                    What is ASCII mode, sorry?
                    That is a mode you can select from your FTP client, but auto mode does just fine.

                    http://en.wikipedia.org/wiki/File_Transfer_Protocol

                    Comment


                    • #11
                      kk. I'm reuploading all of the files, besides the images.

                      Comment


                      • #12
                        I was trying to install a modification one day and forgot that I had renamed the admincp to something else. If the admincp has been renamed or it is not reflected in the config.php file would that cause problems?

                        just an idea.
                        www.Copiertalk.com - Everything Copier , Printer, Fax

                        Comment


                        • #13
                          Yeah, I know what you mean, I'd have to change it in the config.php file. But the thing is, is that I can get into the admin CP, just the welcome page has a DB error.

                          Comment


                          • #14
                            We need to see the real error message. 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


                            • #15
                              Originally posted by Steve Machol View Post
                              We need to see the real error message. Right-click on the error page and go to View/Source. Then copy-n-paste the error message here.
                              Sorry for the late response. I just finished reuploading all of the files, except for images and the install.php.

                              Logged in, and yes, still an error page. Here's the source:


                              <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
                              <html dir="ltr" lang="en">
                              <head>
                              <title>Welcome to the vBulletin Admin Control Panel - Midnightneo Forums - vBulletin Admin Control Panel</title>
                              <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
                              <link rel="stylesheet" type="text/css" href="../cpstyles/vBulletin_3_Manual/controlpanel.css" />
                              <style type="text/css">
                              .page { background-color:white; color:black; }
                              .time { color:silver; }
                              </style>
                              <script type="text/javascript">
                              <!--
                              var SESSIONHASH = "";
                              var IMGDIR_MISC = "../cpstyles/vBulletin_3_Manual";
                              var CLEARGIFURL = "./clear.gif";
                              function set_cp_title()
                              {
                              if (typeof(parent.document) != 'undefined' && typeof(parent.document) != 'unknown' && typeof(parent.document.title) == 'string')
                              {
                              parent.document.title = (document.title != '' ? document.title : 'vBulletin');
                              }
                              }
                              //-->
                              </script>
                              <script type="text/javascript" src="../clientscript/yui/yahoo-dom-event.js"></script>
                              <script type="text/javascript" src="../clientscript/yui/connection.js"></script>
                              <script type="text/javascript" src="../clientscript/vbulletin_global.js"></script>
                              </head>
                              <body style="margin:0px" onload="set_cp_title();">
                              <div class="pagetitle">Welcome to the vBulletin Admin Control Panel</div>
                              <div style="margin:10px">
                              <!-- END CONTROL PANEL HEADER -->

                              <div id="admin_news" style="display: none;">
                              <!-- form started:11 queries executed -->
                              <form action="index.php?do=handlemessage" method="post" name="news" id="news">
                              <input type="hidden" name="do" value="handlemessage" />
                              <input type="hidden" name="adminhash" value="e7961759922f60f1b9521d1e9c68faf6" />
                              <br />
                              <table cellpadding="4" cellspacing="0" border="0" align="center" width="90%" class="tborder" id="news_table">
                              </table>
                              </form>
                              <!-- form ended: 11 queries executed -->

                              </div><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
                              <html>
                              <head>
                              <title>Midnightneo Forums Database Error</title>
                              <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
                              <meta name="ROBOTS" content="NOINDEX,NOFOLLOW,NOARCHIVE" />
                              <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="http://www.midnightneoforums.com/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 Midnightneo Forums 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="/">midnightneoforums.com</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 midnightneoforums.com 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>

                              <form><textarea rows="15" cols="70" wrap="off" id="message">Database error in vBulletin 3.7.0 Release Candidate 3:

                              Invalid SQL:

                              SELECT COUNT(*) AS count
                              FROM moderation AS moderation
                              INNER JOIN post AS post USING (postid)
                              WHERE moderation.type='reply';

                              MySQL Error : Unknown column 'midnigi5_forums.moderation.postid' in 'on clause'
                              Error Number : 1054
                              Date : Sunday, April 20th 2008 @ 03:01:25 PM
                              Script : http://midnightneoforums.com/admincp/index.php?do=home
                              Referrer :
                              IP Address :
                              Username : itsIAN
                              Classname : vb_database</textarea></form>
                              </body>
                              </html>

                              Comment

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