vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Member Archives (https://vborg.vbsupport.ru/forumdisplay.php?f=202)
-   -   Sql Prob :( (https://vborg.vbsupport.ru/showthread.php?t=52106)

vB-Host.com 04-25-2003 06:06 AM
Sql Prob :(
 
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

Erwin 04-25-2003 06:17 AM
What exactly was the error message? Don't do anything drastic to your thread table.

vB-Host.com 04-25-2003 06:21 AM
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

Erwin 04-25-2003 06:22 AM
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.

Brad 04-25-2003 06:27 AM
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

vB-Host.com 04-25-2003 06:35 AM
that did the trick! thanks for the fast responce

vB-Host.com 04-25-2003 06:39 AM
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..


All times are GMT. The time now is 07:18 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01622 seconds
  • Memory Usage 1,718KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (7)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete