PDA

View Full Version : problem when trying to upgrade from vb2 to vb3, quick help needed


sticky
11-20-2004, 10:25 AM
My problem:

Step 13) Update Attachments #1

Updating Attachments...



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.

What the hell do I do, it won't let me skip this step or continue with the upgrade, what is the problem?

sticky
11-20-2004, 10:36 AM
Here is the source of the error if it helps:

<!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.0 Upgrade System Step 13) Update Attachments #1</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;2000 - 2004, Jelsoft Enterprises Ltd." /></td>
<td style="padding-left:50px">
<a href="upgrade.php"><b>vBulletin 3.0 Upgrade System</b><br />
(Please be patient as some parts may take some time)</a><br />
<br />
<b style="font-size:10pt;">Step 13) Update Attachments #1</b> (Step 13 of 42) </td>
<td nowrap="nowrap" align="right">
<strong>XML File Versions:</strong><br /><br />
vbulletin-style.xml<br />
vbulletin-settings.xml<br />
vbulletin-language.xml
</td>
<td nowrap="nowrap"><br /><br />
3.0.3<br />
3.0.3<br />
3.0.3 </td>
</tr>
</table>
<div id="all">
<p style="font-size:10pt;"><b><u>Step 13) Update Attachments #1</u></b></p>
<p>Updating Attachments...</p><ul>
<html><head><title> 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 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:jwilk@sbcglobal.net">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 :

Invalid SQL:
SELECT post.attachmentid, post.postid, attachment.postid AS attachment_postid

FROM post
LEFT JOIN attachment ON (attachment.attachmentid = post.attachmentid)
WHERE post.attachmentid &lt;&gt; 0
ORDER BY post.attachmentid DESC
LIMIT 0, 500

mysql error: Got error 127 from table handler

mysql error number: 1030

Zachery
11-20-2004, 11:23 AM
Here is the source of the error if it helps:

<!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.0 Upgrade System Step 13) Update Attachments #1</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;2000 - 2004, Jelsoft Enterprises Ltd." /></td>
<td style="padding-left:50px">
<a href="upgrade.php"><b>vBulletin 3.0 Upgrade System</b><br />
(Please be patient as some parts may take some time)</a><br />
<br />
<b style="font-size:10pt;">Step 13) Update Attachments #1</b> (Step 13 of 42) </td>
<td nowrap="nowrap" align="right">
<strong>XML File Versions:</strong><br /><br />
vbulletin-style.xml<br />
vbulletin-settings.xml<br />
vbulletin-language.xml
</td>
<td nowrap="nowrap"><br /><br />
3.0.3<br />
3.0.3<br />
3.0.3 </td>
</tr>
</table>
<div id="all">
<p style="font-size:10pt;"><b><u>Step 13) Update Attachments #1</u></b></p>
<p>Updating Attachments...</p><ul>
<html><head><title> 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 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:jwilk@sbcglobal.net">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 :

Invalid SQL:
SELECT post.attachmentid, post.postid, attachment.postid AS attachment_postid

FROM post
LEFT JOIN attachment ON (attachment.attachmentid = post.attachmentid)
WHERE post.attachmentid &lt;&gt; 0
ORDER BY post.attachmentid DESC
LIMIT 0, 500

mysql error: Got error 127 from table handler

mysql error number: 1030
127 means the table has crashed you should rever tto a backup, repair and optmize all tables, and try the upgrade again.

sticky
11-20-2004, 11:41 AM
I have a backup, this might sound stupid, but how exactly do I revert to it? What steps do I take to install the backup?

How do I repair and optimize tables?

I did a search and repair and optmize tables is supposed to be under import and maintenance in the control panel but it isn't and never has been for me. How else can I do this?