Previous Thread
Next Thread
Print Thread
Hop To
Board down: Incorrect key file for table error #230272 10/25/2009 5:15 PM
Joined: Nov 2004
Posts: 18
Migstradamus Offline OP
stranger
OP Offline
stranger
Joined: Nov 2004
Posts: 18
Running 7.4.2. Some corruption in the MySQL table I'm not sure how to repair is resulting in this error, preventing posts.

Quote:
Script: /usr/www/users/ninjamig/boards/libs/html.inc.php
Line#: 827
SQL Error: Incorrect key file for table './ninjamig_threads/ubbt_GRAEMLINS.MYI'; try to repair it
SQL Error #: 126
Query: SELECT GRAEMLIN_MARKUP_CODE,GRAEMLIN_SMILEY_CODE,GRAEMLIN_IMAGE,GRAEMLIN_HEIGHT,GRAEMLIN_WIDTH,GRAEMLIN_ORDER FROM ubbt_GRAEMLINS WHERE GRAEMLIN_IS_ACTIVE='1' ORDER BY GRAEMLIN_ORDER ASC


I'm making a backup of the database now. I found that table on the list in the Control Panel and it optimized without an error. Seems like one I should just be able to rebuild without losing anything, no? Thanks.

Seems to have taken out the shoutbox, too. Or unrelated? New shouts just disappear now, but no error appears.

http://www.chessninja.com/boards

Saludos, Mig

Last edited by Migstradamus; 10/25/2009 5:20 PM.
Re: Board down: Incorrect key file for table error [Re: Migstradamus] #230273 10/25/2009 5:27 PM
Joined: Dec 2003
Posts: 5,990
Ruben Offline
Offline
Joined: Dec 2003
Posts: 5,990
Try to repair the table. If you have phpmyadmin
Select the table then select the operations tab.
There should be a table maintenance menu. Select repair table.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Re: Board down: Incorrect key file for table error [Re: Ruben] #230274 10/25/2009 5:44 PM
Joined: Dec 2003
Posts: 5,990
Ruben Offline
Offline
Joined: Dec 2003
Posts: 5,990
HERE is a tutorial for phpmyadmin to repair tables also.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Re: Board down: Incorrect key file for table error [Re: Ruben] #230278 10/25/2009 6:32 PM
Joined: Jun 2006
Posts: 9,243
Rick Offline
Former Developer
Offline
Former Developer
Joined: Jun 2006
Posts: 9,243
Yeah, like Ruben said, a repair of that table should do the trick.

If you don't have phpmyadmin, then you can just run the following query from the control panel:

SQL Query
repair table ubbt_GRAEMLINS

Last edited by Rick; 10/25/2009 6:33 PM.
Re: Board down: Incorrect key file for table error [Re: Rick] #230284 10/25/2009 11:25 PM
Joined: Nov 2004
Posts: 18
Migstradamus Offline OP
stranger
OP Offline
stranger
Joined: Nov 2004
Posts: 18
That did the trick, thanks! Shoutbox is back in action, too. Interesting that went down.


Forum Search
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Followed List v7.7.2 Question
by Ruben - 11/12/2019 12:22 PM
UBB Dev
by JAISP - 11/03/2019 11:01 AM
Exceeded Number of attachments
by rbrtgrmn - 11/02/2019 9:57 PM
Forum New User Registration
by kf6zpl - 10/25/2019 10:45 AM
Having issue with redirects to UBB classic URLs
by amciotola - 10/16/2019 12:11 AM
Who's Online Now
2 registered members (isaac, M4TT), 84 guests, and 442 spiders.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Amusing Terain Scenics
Amusing Terain Scenics
by isaac, August 19
Sky places
Sky places
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Snapshot build 20191023)