ERROR: 1030??? What's Wrong?

[ZiRu$]

Warning: mysql_query(): Unable to save result set in /home/virtual/site21/fst/var/www/html/forum/admin/db_mysql.php on line 86


Database error in vBulletin 2.2.8:

Invalid SQL: SELECT count(*) AS posts FROM post WHERE dateline > '1066004683'
mysql error: Got error 127 from table handler

mysql error number: 1030

Date: Sunday 12th of October 2003 08:29:12 PM
Script: http://www.XXXXXXXX.com/forum/forum/index.php?s=
Referer: http://www.XXXXXXXX.com/forum/forumdisplay.php?s=&forumid=18




ANY IDEA WHATS WRONG? I GET THIS WHEN I GO TO MY BOARD

[ZiRu$]

Now I'm getting a DIFFERENT Mysql error error when i go on my board.

It says

Database error in vBulletin 2.2.8:

Invalid SQL: SELECT COUNT(*) AS posts FROM post
mysql error: Can't open file: 'post.MYD'. (errno: 145)

mysql error number: 1016

PLEASE CAN SOMEONE HELP?

[Lesane]

Run this query:


REPAIR TABLE post

[ZiRu$]

God Loves You LESANE!!!!!

Thanks so much bro.....what's up man...long time!

[ZiRu$]

^^^um lesane now when i go to post I get this message

Database error in vBulletin 2.2.8:

Invalid SQL: SELECT wordid,title FROM word WHERE title IN ('color=0a3870','test','/color')
mysql error: Can't open file: 'word.MYD'. (errno: 145)

mysql error number: 1016

[Lesane]

"mysql error: Can't open file: 'word.MYD'. (errno: 145)" indicates that a table is corrupted/damaged.

You can keep fixing them manually by doing the query:


REPAIR TABLE tablename


So when it says word.MYD then the table word is corrupted/damaged so the query would be:


REPAIR TABLE word


But, i suggest you to install this hack from Filburt:
https://vborg.vbsupport.ru/showthread.php?s=&threadid=51560

It mostly fix those errors automaticilly so you don't have to do it manually and your forum keeps being online, but it's not good if you get these errors often. Notice your host about it.

[ZiRu$]

^^^Thanks Lesane.....worked perfect!