Problem with mysql06

[dave_childress]

OK having a bit of a problem, and it's gotten quite serious

Could not query forums information

DEBUG MODE

SQL Error : 1016 Can't open file: 'phpbb_posts.MYI' (errno: 145)

SELECT f.*, p.post_time, p.post_username, u.username, u.user_id FROM (( phpbb_forums f LEFT JOIN phpbb_posts p ON p.post_id = f.forum_last_post_id ) LEFT JOIN phpbb_users u ON u.user_id = p.poster_id ) ORDER BY f.cat_id, f.forum_order

Line : 167
File : index.php

and then I fixed it by running this in phpMyAdmin

Code:
REPAIR TABLE phpbb_posts;


But now it keeps coming back every 10-20 minutes.

I'm not sure if I am triggering it off or whats hapenning.

Any help would be appreciated.

[riskynil]

Yep, I'm having the same problem with an allegedly broken table. I'm also located on mysql06.

I dropped the table and readded it. It works for a bit, then it crashes again. It's only the one table (so far!) and it's really starting to tick me off since I haven't changed any code with that uses that table in months.

Now I've even gone so far as to tweak my code so when it tries to insert a row into the problem table, it'll ignore any errors and continue on. At least it doesn't bring my entire site down anymore, but there's still a problem that needs fixing!

-- Ryan