The Arcive of Official vBulletin Modifications Site.

sticky · #1 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 · #2 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

utset 2px">
<tr>
<td width="160"><img src="../cpstyles/vBulletin_3_Default/cp_logo.gif" alt="" title="vBulletin 3 ©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"></style></head>
<body></table></td></tr></table></form>
<blockquote><p class="error"> </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 <> 0
ORDER BY post.attachmentid DESC
LIMIT 0, 500

mysql error: Got error 127 from table handler

mysql error number: 1030

Zachery · #3 11-20-2004, 11:23 AM

Quote:

Originally Posted by sticky

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

utset 2px">
<tr>
<td width="160"><img src="../cpstyles/vBulletin_3_Default/cp_logo.gif" alt="" title="vBulletin 3 ©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"></style></head>
<body></table></td></tr></table></form>
<blockquote><p class="error"> </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 <> 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 · #4 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?

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04588 seconds Memory Usage 2,202KB Queries Executed 13 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (1)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (4)post_thanks_box (4)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (4)post_thanks_postbit_info (4)postbit (4)postbit_onlinestatus (4)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!