Announcement

Collapse
No announcement yet.

database problem

Collapse
X
Collapse
 
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
Previous template Next
  • #1

    database problem

    I have just had my HOST restore my back up.


    But now I get this

    There seems to have been a slight problem with the GSM Forums database.
    Please try again by pressing the refresh button in your browser.

    An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

    We apologise for any inconvenience


    How can I fix this!!
    Tags: None
  • #2
    Try a view source on that page. it comes up with this
    <html><head><title>GSM Forums Database Error</title><style>P,BODY{FONT-FAMILY:tahoma,arial,sans-serif;FONT-SIZE:11px;}</style><body>

    <!-- Database error in vBulletin 2.2.6:

    Invalid SQL: INSERT INTO session (sessionhash,userid,host,useragent,lastactivity,althash,location) VALUES ('d7f0543df03f7e00d2dfbc15b32c2b57',0,'216.195.17.15','Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1;','1031345192','','/index.php')
    mysql error: Unknown column 'althash' in 'field list'

    mysql error number: 1054

    Date: Friday 06th of September 2002 09:46:32 PM
    Script: http://www.gsmforum.34sp.com/index.php
    Referer:
    -->

    </table></td></tr></table></form>
    <blockquote><p>&nbsp;</p><p><b>There seems to have been a slight problem with the GSM Forums 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="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>
    Thus you have an SQL error. It looks like one of the columns got dropped during the restore. It would make sense to go into PHPMyAdmin and check if the column "althash" is in the table "Field List", if not, it may need to be created. Or maybe another one of the SQL wizzes here has an idea
    -Draco
    The Digital Sector Forums

    Comment

    • #3
      The version of the database backup does not match the version of the vB (2.2.7.) You will need to run the apporiate upgrade scripts to upgrade that database to 2.2.7. What version of vB was this backup from?
      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
        The Back up was

        v 2.2.6 the forum is running on 2.2.7

        Comment

        • #5
          You need to upgrade it by running this script:

          upgrade20.php
          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

          • #6
            This what I get when i run upgrade20.php


            Warning: you are currently running version 2.2.7 and this script upgrades from version 2.2.6. If you are sure you want to continue, please click here otherwise please consult the upgrade instructions.

            when i continue i get this

            Adding new column to session table ...


            There seems to have been a slight problem with the database.
            Please try again by pressing the refresh button in your browser.

            An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

            We apologise for any inconvenience.

            Comment

            • #7
              Right click and view source, then post the complete 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

              • #8
                How do U view source !!


                ok my forum is back online but the back up has not restored all the threads


                should I reinstall vb 2.2.6 and then restore back up

                Comment

                • #9
                  <HTML><HEAD>
                  <META content="text/html; charset=windows-1252" http-equiv=Content-Type>
                  <META content="MSHTML 5.00.3018.900" name=GENERATOR></HEAD>
                  <link rel="stylesheet" href="../cp.css">
                  <title>vBulletin 2.2.6 to 2.2.7 Upgrade script</title>
                  </HEAD>
                  <BODY>
                  <table width="100%" bgcolor="#3F3849" cellpadding="2" cellspacing="0" border="0"><tr><td>
                  <table width="100%" bgcolor="#524A5A" cellpadding="3" cellspacing="0" border="0"><tr>
                  <td><a href="http://vbulletin.com/forum" target="_blank"><img src="cp_logo.gif" width="160" height="49" border="0" alt="Click here to visit the vBulletin support forums"></a></td>
                  <td width="100%" align="center">
                  <p><font size="2" color="#F7DE00"><b>vBulletin 2.2.6 to 2.2.7 Upgrade Script</b></font></p>
                  <p><font size="1" color="#F7DE00"><b>(Note: Please be patient as some parts of this may take some time.)</b></font></p>
                  </td></tr></table></td></tr></table>
                  <br>
                  <b>Adding new column to session table ...</b> <html><head><title> Database Error</title><style>P,BODY{FONT-FAMILY:tahoma,arial,sans-serif;FONT-SIZE:11px;}</style><body>

                  <!-- Database error in vBulletin :

                  Invalid SQL: ALTER TABLE session ADD althash CHAR(32) NOT NULL DEFAULT ''
                  mysql error: Duplicate column name 'althash'

                  mysql error number: 1060

                  Date: Friday 06th of September 2002 10:22:39 PM
                  Script: /admin/upgrade20.php?step=2
                  Referer: http://www.gsmforum.34sp.com/admin/u....php?confirm=1
                  -->

                  </table></td></tr></table></form>
                  <blockquote><p>&nbsp;</p><p><b>There seems to have been a slight problem with the 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="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>

                  Comment

                  • #10
                    That error indicates that you've already run upgrade20.php at least once before. Frankly I'm confused. I don't know what you've done or where you're at right now.
                    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

                    • #11
                      Sorted it mate thanx alot

                      Comment

                      • #12
                        Since I spent so much time on this, would you care to tell me what the fix was?
                        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

                        • #13
                          Originally posted by smachol
                          That error indicates that you've already run upgrade20.php at least once before. Frankly I'm confused. I don't know what you've done or where you're at right now.
                          same here, could you do us a favor, and give us a list, basically and run down of the steps you've done IN ORDER please That will help diagnose the problem
                          -Draco
                          The Digital Sector Forums

                          Comment

                          • #14
                            well basically follewed your steps.


                            I re uploaded vb 2.2.7
                            I then had my HOST restore my back up.

                            I the ran upgrade 20.php


                            All was sorted

                            Comment

                            • #15
                              Originally posted by Gaz.t
                              well basically follewed your steps.


                              I re uploaded vb 2.2.7
                              I then had my HOST restore my back up.

                              I the ran upgrade 20.php


                              All was sorted
                              good to hear, glad it works
                              -Draco
                              The Digital Sector Forums

                              Comment

                              Previous template Next
                              Loading...
                              Working...
                              X