Go Back   vb.org Archive > Community Central > Community Lounge

Reply
 
Thread Tools Display Modes
  #1  
Old 04-06-2003, 08:22 PM
Jucin Jucin is offline
 
Join Date: Oct 2002
Posts: 11
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Holy Errors what the hell is going on?

<a href="http://www.f-bodytech.com/forum/" target="_blank">http://www.f-bodytech.com/forum/</a>
Reply With Quote
  #2  
Old 04-06-2003, 08:32 PM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Code:
Invalid SQL: SELECT COUNT(*) AS threads FROM thread
mysql error: Can't open file: 'thread.MYI'. (errno: 145)

mysql error number: 1016

Date: Sunday 06th of April 2003 02:25:56 PM
Script: http://www.f-bodytech.com/forum/forum/
Referer: https://vborg.vbsupport.ru/showthrea...threadid=51275
threadtable is corrupt, you have to run repair.php from the extras folder
Reply With Quote
  #3  
Old 04-06-2003, 08:34 PM
Jucin Jucin is offline
 
Join Date: Oct 2002
Posts: 11
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

where would this file be located?
Reply With Quote
  #4  
Old 04-06-2003, 08:37 PM
Jucin Jucin is offline
 
Join Date: Oct 2002
Posts: 11
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I also just did a backup and this is the message I received through a email.

Database error in vBulletin Control Panel 2.2.8:

Invalid SQL: SHOW FIELDS FROM thread
mysql error: Can't open file: 'thread.MYI'. (errno: 145)

mysql error number: 1016

Date: Sunday 06th of April 2003 02:26:56 PM
Script: http://www.f-bodytech.com/forum/forum/admin/backup.php
Referer: http://www.f-bodytech.com/forum/admi...action=choose&
Reply With Quote
  #5  
Old 04-06-2003, 08:39 PM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

the file is in your vb.zip archive

as said your thread table is corupt, you cant do anything with threads anymore until you repair it.
Reply With Quote
  #6  
Old 04-06-2003, 09:05 PM
Jucin Jucin is offline
 
Join Date: Oct 2002
Posts: 11
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

We do the repair.php and heres what we get

http://www.f-bodytech.com/forum/extr...html=1&check=1 check it out for yourself
Reply With Quote
  #7  
Old 04-06-2003, 09:41 PM
filburt1 filburt1 is offline
 
Join Date: Feb 2002
Location: Maryland, US
Posts: 6,144
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

IIRC you need to upload it to the admin directory.
Reply With Quote
  #8  
Old 04-07-2003, 02:54 AM
Link14716's Avatar
Link14716 Link14716 is offline
 
Join Date: Jun 2002
Location: Georgia, USA
Posts: 2,519
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Do not upload the entire extras folder, upload repair.php to the admin directory.
Reply With Quote
  #9  
Old 04-07-2003, 03:01 AM
Jalrock Jalrock is offline
 
Join Date: Dec 2001
Posts: 57
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I had the same eror. Hummmmmmmmm.Repair seemed to have fixed it but now mu querys are double on each page????
Reply With Quote
  #10  
Old 04-08-2003, 01:47 AM
JulianD's Avatar
JulianD JulianD is offline
 
Join Date: Jan 2002
Posts: 455
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hey what's going on with this problem... I had the same problem yesterday, and a few people on other forums are reporting the same problem on thread.MYI.

Are you guys running MySQL 4.x? My host upgraded to MySQL 4.x and PHP 4.3.1, that's the only changes on my server.
Reply With Quote
Reply

Thread Tools
Display Modes

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 08:19 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.04034 seconds
  • Memory Usage 2,239KB
  • 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_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)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
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete