vb.org Archive - View Single Post - problem when trying to upgrade from vb2 to vb3, quick help needed

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01210 seconds Memory Usage 1,766KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD_SHOWPOST (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_box (1)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit_info (1)postbit (1)postbit_onlinestatus (1)postbit_wrapper (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit reputationlevel showthread	Included Files: ./showpost.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 showpost_start bbcode_fetch_tags bbcode_create postbit_factory showpost_post 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 showpost_complete
Messages: