An odd error in MySQL.. (thread.MYI?)

[Velocd]

It seems some strange outside interference has caused my forum to temporarily shut down.

I am receiving a strange database error that says:

Database error in vBulletin 2.3.0:

Invalid SQL: 
  SELECT threadid,forumid,title,replycount,postusername,dateline,views,postuserid
  FROM thread
  WHERE visible=1 AND open<>10 
  ORDER BY dateline DESC LIMIT 8

mysql error: Can't open file: 'thread.MYI'. (errno: 145)

mysql error number: 1016

Date: Monday 07th of April 2003 09:22:23 PM
Script: http://www.animesystem.com/forums/
Referer:

I'm not sure what it is referring to when it says "thread.MYI"

Anyone have any ideas? The most recent thing I've done was create a new subdomain on my server, but I hardly see how this could be causing a problem. I was browsing a thread on my site at school today and it loaded just fine, but sometime between 7 hours ago and now this error occurred.

Thanks if you can help.

[Velocd]

Never mind, just noticed a thread that hopefully will solve my problem.

https://vborg.vbsupport.ru/showthrea...ght=thread.myi

Ironic this error just happened with someone recently as well.

I do have one question though, how can a thread table become corrupted by simply viewing threads or regular browsing on the forum?

[Dean C]

I had this problem on localhost yesteday. But it was after hacking a file so i thought nothing of it. How odd :S

- miSt

[Xenon]

well i don't know how these errors can occur, but they can....

just run repair.php

[Steve Machol]

By any chance does your server use CPanel? We have a theory that the latest version of CPanel is updating MySQL on a daily basis. Unfortunately if your database is being written to when this occurs, then you could get database corruption.

Find out if you are using CPanel and if so, what version it is. Also find out what the update schedule is set to.

http://www.vbulletin.com/forum/showt...605#post438605

[Velocd]

Cpanel 6.4.0-EDGE Build 1

MySQL 4.0.12

Webhost Manager Update preferences unknown-- how do I find this info in Cpanel?

I just got this MYI error again yesterday, and a few of my threads were lost as well. Strange error..

[Steve Machol]

Today at 10:12 AM Velocd said this in Post #6
Cpanel 6.4.0-EDGE Build 1

MySQL 4.0.12

Webhost Manager Update preferences unknown-- how do I find this info in Cpanel?

This info is not in CPnael. It's in WebHost Manage which reuires root access to the server. If you are on a shared server you'll need to contact your host about this.

[Kriek]

04-07-03 at 09:33 PM Velocd said this in Post #1
Can't open file: 'thread.MYI'. (errno: 145)

Run this query:

REPAIR TABLE thread

[SysRq]

so has anyone actually found a fix for this that doesnt require doing every night?

[Steve Machol]

1. Read this thread:

http://www.vbulletin.com/forum/showt...threadid=69803

2. Quick fix:

Try using mysqldump to create a sql backup your database - mysqldump guide at http://www.sitepoint.com/article/678

Then create a new empty database name and import the mysql sql backup back into the empty database, and edit config.php to point to the new database

Also take a read of

http://www.mysql.com/doc/en/Corrupte...AM_tables.html

and

http://www.vbulletin.com/forum/showt...threadid=69803
mysql4