Announcement

**und3rburn** · Tue 21 Oct '03, 5:59pm

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>

**Steve Machol** · Tue 21 Oct '03, 7:17pm

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

REPAIR TABLE thread;

**und3rburn** · Tue 21 Oct '03, 7:54pm

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)

**Steve Machol** · Tue 21 Oct '03, 7:57pm

You got that when you entered that query in phpMyAdmin?

**und3rburn** · Tue 21 Oct '03, 8:08pm

Yup.

**Steve Machol** · Tue 21 Oct '03, 9:42pm

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.

Announcement

Beta 4 to Beta 7 Upgrade Error

Beta 4 to Beta 7 Upgrade Error

Comment

Comment

Comment

Comment

Comment

Comment