InvisionBoard/mySQL errors

[Gdiguy]

I've had a forum working fine for like 6 months, but for the last day or so it's been having an error anytime you click on any of the sub-forums...

www.ebgalaxy.com/forums


The error message:

mySQL query error: SELECT COUNT(tid) as max FROM ibf_topics WHERE forum_id='3' and approved='1' and (last_post > 1048187463 or pinned=1)

mySQL error: Can't open file: 'ibf_topics.MYI'. (errno: 145)
mySQL error code: 1016
Date: Saturday 19th of April 2003 12:11:03 PM


Any ideas? :(

[Steven]

That sounds like you might have some database corruption. Does invisionboard have a repair.php file or anything of this nature like vbulletin has?

-Steven

[Gdiguy]

I dunno, I'm pretty much still a newb at php/sql stuff... :( *goes looking*

[Jace]

In your Control Panel (cPanel) under one of the MySQL links you'll see a link to phpMyAdmin somewhere towards the bottom of the page. Load this then navigate on over to your Invision database. Run the following SQL query:

REPAIR TABLE ibf_topics;

I've had the same thing happen to my BB before and this has fixed it right up. Good luck.

[Gdiguy]

Ok, I found that... but how do you run that query?

*edit*

haha, found it... worked perfectly, thanks a ton! :)

[Jace]

Wonderful. Definitely something to keep in your bag of tricks.