MySQL ERROR :(

[Lester]

Can someone please help me??

this is the error that I get:

mySQL query error: SELECT COUNT(tid) as max FROM rvtopics WHERE forum_id='2' and approved='1' and (last_post > 1046291355 or pinned=1)

mySQL error: Can't open file: 'rvtopics.MYI'. (errno: 145)
mySQL error code: 1016
Date: Friday 28th of March 2003 12:29:15 PM


http://www.reginemultimedia.com/forums/index.php?act=SF&f=2

PLS HELP! it's driving me nuts :( :(

[LexF]

You'll need to use your favorite MySQL connection utility to run

REPAIR TABLE tablename

Where tablename is the name of your table :)

[Xinil]

Hey Lex, I've had to repair one of my tables three times in the past two days. What's up? Is there something wrong with my code?

[LexF]

Tables can get corrupted when they're being written to (INSERT/REPLACE/UPDATE), if the operation is stopped before it can complete.

Please email support@powweb.com with your domain name, MySQL server, and your MySQL username/password for us to investigate this further -- along with a description fo the problem, of course.

[Xinil]

Thanks Lex, I sent them an e-mail.