Announcement

Collapse
No announcement yet.

Beta 4 to Beta 7 Upgrade Error

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

  • Beta 4 to Beta 7 Upgrade Error

    EDIT :: UPGRADING FROM BETA 5 I made a Mistake :-[



    I start the upgrade process, and get to step one, I click next and get the following error ::

    Step 1) Add Index to Thread table

    Altering Thread Table...
    (this may take a few seconds on a large board)



    There seems to have been a slight problem with the wrestleSpot.com Fan 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.
    Any Ideas Why?
    Last edited by und3rburn; Tue 21 Oct '03, 6:06pm.

  • #2
    My source is the following

    Code:
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html>
    <head>
    	<meta content="text/html; charset=windows-1252" http-equiv="Content-Type" />
    	<title>vBulletin 3 Upgrade System Step 1) Add Index to Thread table</title>
    	<link rel="stylesheet" href="../cpstyles/vBulletin_3_Default/controlpanel.css" />
    	<style type="text/css">
    	#all {
    		margin: 10px;
    	}
    	#all p, #all td, #all li, #all div {
    		font-size: 11px;
    		font-family: verdana, arial, helvetica, sans-serif;
    	}
    	</style>
    </head>
    <body style="margin:0px">
    <table cellpadding="4" cellspacing="0" border="0" width="100%" class="navbody" style="border:outset 2px">
    <tr>
    	<td width="160"><img src="../cpstyles/vBulletin_3_Default/cp_logo.gif" alt="" title="vBulletin 3 &copy;2003 Jelsoft Enterprises Ltd." /></td>
    	<td style="padding-left:100px">
    		<a href="upgrade.php"><b>vBulletin 3 Upgrade System</b><br />
    		(Please be patient as some parts may take some time)</a><br />
    		<br />
    		<b style="font-size:10pt;">Step 1) Add Index to Thread table</b>  (Step 1 of 9)</td>
    </tr>
    </table>
    <div id="all">
    <p style="font-size:10pt;"><b><u>Step 1) Add Index to Thread table</u></b></p>
    <p>Altering Thread Table...<br /><i>(this may take a few seconds on a large board)</i><html><head><title>wrestleSpot.com Fan Forums Database Error</title><style type="text/css"><!--.error { font: 11px tahoma, verdana, arial, sans-serif; }--></style></head>
    <body></table></td></tr></table></form>
    <blockquote><p class="error">&nbsp;</p><p class="error"><b>There seems to have been a slight problem with the wrestleSpot.com Fan Forums database.</b><br />
    Please try again by pressing the <a href="javascript:window.location=window.location;">refresh</a> button in your browser.</p><p class="error">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 class="error">We apologise for any inconvenience.</p></blockquote>
    
    <!--
    Database error in vBulletin 3.0.0 Beta 5:
    
    Invalid SQL: ALTER TABLE thread ADD INDEX (postuserid)
    mysql error: Can't open file: 'thread.MYI'. (errno: 145)
    
    mysql error number: 1016
    
    Date: Wednesday 22nd of October 2003 09:52:43 AM
    Script: [url]http://www.wrestlespot.com/discuss/install/upgrade4.php?step=1[/url]
    Referer: [url]http://www.wrestlespot.com/discuss/install/upgrade4.php?rand=906[/url]
    IP Address: 67.164.8.109
     -->
    
    </body></html>

    Comment


    • #3
      Your thread table crashed. Run this query in phpMyAdmin to fix it:

      REPAIR TABLE thread;
      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
        I try but get the following error >>>

        Can't open file: 'thread.MYI'. (errno: 145)

        Error

        SQL-query :

        SHOW KEYS FROM `thread`

        MySQL said:


        Can't open file: 'thread.MYI'. (errno: 145)

        Comment


        • #5
          You got that when you entered that query in phpMyAdmin?
          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
            Yup.

            Comment


            • #7
              Hmmm...that doesn't make any sense. Can you login with telnet or ssh? If so, login into mysql and type the query directly on the command line.
              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