MySQL Error : Table './xxx/thread' is marked as crashed and last (automatic?) repai

[mezozam]

Hello ,

today i've renew my domain and after that when i open my forum

i face this problem

Database error in vBulletin 3.8.3:

Invalid SQL:

SELECT COUNT(*) AS count
FROM thread
WHERE visible IN (0,1,2)
AND sticky IN (0,1)
AND open <> 10
AND dateline >= 1254628800;

MySQL Error : Table './xxx/thread' is marked as crashed and last (automatic?) repair failed
Error Number : 144
Request Date : Sunday, October 4th 2009 @ 12:26:38 AM
Error Date : Sunday, October 4th 2009 @ 12:26:38 AM
Script : http://www.fallah-street.com/vb/xxx/index.php?do=home
Referrer : http://www.fallah-street.com/vb/xxx/index.php?do=nav
IP Address : 86.134.110.224
Username : Dr.LoVe
Classname : vB_Database
MySQL Version : 5.0.81-community

and i try to

Check Warning: Table is marked as crashed and last repair failed thread Check
Warning: Size of indexfile is: 2603008 Should be: 1996800 thread Check
Warning: Size of datafile is: 2042608 Should be: 2042432 thread Check
Error: Keypointers and record positions doesn't match thread Check
Warning: Found 15684 parts Should be: 15677 parts thread Check
Error: Corrupt thread

and i try to see what's hapening in phpmyadmin

and i looked at thread table and i saw front of this table wrote

thread in use

and the size of this table is ZERO

what does it mean ??

i need sulotion :S

[Steve Machol]

This may be too damaged to fix with the normal methods. Please check out this thread for other ways to repair a db, particularly items #2 and 3:

http://www.vbulletin.com/forum/showthread.php?s=&threadid=44909

You may have to ask your host to try and repair this for you.

[mezozam]

Every thing is ok with liquidweb

they've repaired my database

thank you Steve Machol

[Steve Machol]

Glad to hear it.