Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 11-20-2004, 10:25 AM
sticky sticky is offline
 
Join Date: Sep 2003
Posts: 934
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default problem when trying to upgrade from vb2 to vb3, quick help needed

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?
Reply With Quote
  #2  
Old 11-20-2004, 10:36 AM
sticky sticky is offline
 
Join Date: Sep 2003
Posts: 934
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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="borderutset 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
Reply With Quote
  #3  
Old 11-20-2004, 11:23 AM
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Location: Ontario, Canada
Posts: 11,440
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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="borderutset 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.
Reply With Quote
  #4  
Old 11-20-2004, 11:41 AM
sticky sticky is offline
 
Join Date: Sep 2003
Posts: 934
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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?
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 04:17 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03751 seconds
  • Memory Usage 2,198KB
  • Queries Executed 11 (?)
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_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