PDA

View Full Version : MySQL ERROR :(


Lester
3-28-03, 04:30 PM
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
3-28-03, 04:41 PM
You'll need to use your favorite MySQL connection utility to run

REPAIR TABLE tablename

Where tablename is the name of your table :)

Xinil
3-28-03, 05:23 PM
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
3-28-03, 05:26 PM
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
3-28-03, 05:40 PM
Thanks Lex, I sent them an e-mail.