PDA

View Full Version : InvisionBoard/mySQL errors


Gdiguy
04-19-2003, 11:12 AM
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
04-19-2003, 01:35 PM
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
04-19-2003, 10:50 PM
I dunno, I'm pretty much still a newb at php/sql stuff... :( *goes looking*

Jace
04-19-2003, 11:28 PM
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
04-21-2003, 11:57 PM
Ok, I found that... but how do you run that query?

*edit*

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

Jace
04-22-2003, 05:18 PM
Wonderful. Definitely something to keep in your bag of tricks.