UBB.Developers Forums UBB.threads 7 Development How Do I? Repeated SQL error, over and over.

Get this error every couple of weeks, and repairing the table doesnt fix it, only dropping it, and re-adding it does.. but last time I dropped it, apparently I didnt re-add the right things, eventually fixed it (still not quite sure how) but what I want to ask is.. Is there a reason this error keeps coming up? And is there something I can do to fix it on a more permanent basis?

SQL ERROR: Tue, May 25 2004 17:12:00 -0700 Unable to do_query: REPLACE INTO w3t_Online (O_Username,O_Uid,O_Last,O_What,O_Board,O_Extra,O_Read,O_Type) VALUES ('Bryan','2','1085530320','ubbthreads','','','','r')
Can't open file: 'w3t_Online.MYD'. (errno: 145)

If you continually have MySQL table corruption - then I would talk to your host about your MySQL configuration. It's either not configured correctly and optimized or you're not running current versions of MySQL.

Will do,

However, until then, is there a command (or set of them) I can give to my admins to take care of this when Im not around?

ESSENTIALLY:

REPAIR TABLE w3t_Online

You might need to alter that depending on what table is corrupt and what the error code is.

This thread - aobut halfway down has error codes.
http://www.ubbcentral.com/boards/showflat.php?Cat=&Number=35663

Thanks again josh, sorry if I sounded short.. just got a new job and its taking its toll.

Apparently when I tried to repair it before.. it didnt like lower case repair.. when I did it with uppercase, it worked fine..

Go figure.

Thanks again!

-Bry