Thread

The site is getting frequent database errors that clear up upon a page refresh, but they are getting more frequent.

MySQL ERROR:

Error Number: 126

Description: Incorrect key file for table ‘/ramdisk/mysql/tmp/#sql_10ac_1.MYI’; try to repair it

Query: SELECT t.title, t.body, t.topic_id, t.thread_total, t.thread_views, t.author_id, t.last_post_author_id, t.forum_id, f.forum_status, f.forum_permissions, m.screen_name, m2.screen_name as last_poster, f.forum_name FROM exp_forum_topics t, exp_forums f, exp_members m, exp_members m2 WHERE t.forum_id = f.forum_id AND t.author_id = m.member_id AND t.last_post_author_id = m2.member_id AND f.forum_is_cat = ‘n’ AND t.board_id = ‘1’ ORDER BY topic_date DESC LIMIT 30

and

MySQL ERROR:

Error Number: 1030

Description: Got error -1 from storage engine

Query: SELECT t.title, t.body, t.topic_id, t.thread_total, t.thread_views, t.author_id, t.last_post_author_id, t.forum_id, f.forum_status, f.forum_permissions, m.screen_name, m2.screen_name as last_poster, f.forum_name FROM exp_forum_topics t, exp_forums f, exp_members m, exp_members m2 WHERE t.forum_id = f.forum_id AND t.author_id = m.member_id AND t.last_post_author_id = m2.member_id AND f.forum_is_cat = ‘n’ AND t.board_id = ‘1’ ORDER BY thread_total DESC LIMIT 30

I have repaired and optimized the tables multiple times (via the CP) to no avail.

My question is, what’s the best way to fix this?  If I use backed up data on a clean install, will I be bringing the problem along with me?

If you go into the database via PHPMyAdmin, you should find an option to repair/optimize the table.  Can you give that a go?  If you don’t have access, open a support ticket with your host and ask them to try to repair the table.

-greg

Greg,

I stated in my OP that I have tried optimizing and repairing the tables several times.  The errors continue.

ETA:  Let me try it again, via the server CP, which is what I think you meant, as opposed to the EE Admin.

Okay, I’ve done that with no errors, so now I’ll have to wait and see if the SQL errors pop up again 😊

Cool.  Run it through the ringer, and let us know if errors pop up.

-greg

Greg,

Why would running an optimize/repair via the EE admin panel be different than using the PHPMyAdmin?  Just curious.

Still getting the errors :/

PHPMyAdmin is more robust than the EE database utility.  At this point, I’d suggest putting in a support ticket with your host, give them the exact error you are receiving, and tell them the steps you have gone through to do the repair.  Let us know what your host says.

-greg