Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > General > Member Archives
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Sql Prob :( Details »»
Sql Prob :(
Version: , by vB-Host.com vB-Host.com is offline
Developer Last Online: Sep 2003 Show Printable Version Email this Page

Version: Unknown Rating:
Released: 04-25-2003 Last Update: Never Installs: 0
 
No support by the author.

Ok I just got alerted of sql errors.. so went into phpmyadmin... thread is locked up on in use...

_thread__ Browse Select Insert Properties Drop Empty in use

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 04-25-2003, 07:17 AM
Erwin's Avatar
Erwin Erwin is offline
 
Join Date: Jan 2002
Posts: 7,604
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

What exactly was the error message? Don't do anything drastic to your thread table.
Reply With Quote
  #3  
Old 04-25-2003, 07:21 AM
vB-Host.com's Avatar
vB-Host.com vB-Host.com is offline
 
Join Date: Apr 2003
Posts: 162
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

i tried rebooting the box... but still no change..

Database error in vBulletin 2.2.9:

Invalid SQL: SELECT count(*) AS count FROM thread WHERE dateline>='1051254000'
mysql error: Can't open file: 'thread.MYI'. (errno: 145)

mysql error number: 1016

Date: Friday 25th of April 2003 01:17:12 AM
Reply With Quote
  #4  
Old 04-25-2003, 07:22 AM
Erwin's Avatar
Erwin Erwin is offline
 
Join Date: Jan 2002
Posts: 7,604
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Okay, the thread table is corrupted.

You need to "repair" it. You can do so via phpmyadmin, or by uploading and running repair.php from your uploads directory of your vB ZIP file.
Reply With Quote
  #5  
Old 04-25-2003, 07:27 AM
Brad Brad is offline
 
Join Date: Nov 2001
Posts: 4,765
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Today at 03:21 AM vB-Host.com said this in Post #3
i tried rebooting the box... but still no change..

Database error in vBulletin 2.2.9:

Invalid SQL: SELECT count(*) AS count FROM thread WHERE dateline>='1051254000'
mysql error: Can't open file: 'thread.MYI'. (errno: 145)

mysql error number: 1016

Date: Friday 25th of April 2003 01:17:12 AM

Common problem, did you just upgrade to mySQL 4 be chance?

Refer to this thread at vB.com, its basicly repeat of erwins post, but its more of a 'step by step' post

http://www.vbulletin.com/forum/showt...threadid=69171
Reply With Quote
  #6  
Old 04-25-2003, 07:35 AM
vB-Host.com's Avatar
vB-Host.com vB-Host.com is offline
 
Join Date: Apr 2003
Posts: 162
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

that did the trick! thanks for the fast responce
Reply With Quote
  #7  
Old 04-25-2003, 07:39 AM
vB-Host.com's Avatar
vB-Host.com vB-Host.com is offline
 
Join Date: Apr 2003
Posts: 162
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Today at 12:27 AM Anime-loo said this in Post #5
Common problem, did you just upgrade to mySQL 4 be chance?

yeap did the upgrade to it all Apache, PHP and SQL... now running Apache 1.3.27, PHP 4.3.1 and MySQL 4.0.12... but this customer's vB has been stable the whole while since the upgrade almost 2 weeks ago... so not sure really if SQL 4 is the problem..
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 06:16 AM.


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.04217 seconds
  • Memory Usage 2,260KB
  • Queries Executed 22 (?)
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
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (7)post_thanks_box
  • (7)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (7)post_thanks_postbit_info
  • (6)postbit
  • (7)postbit_onlinestatus
  • (7)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