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: 6,017
Likes: 1
Ruben Offline
Offline
Joined: Dec 2003
Posts: 6,017
Likes: 1
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: 6,017
Likes: 1
Ruben Offline
Offline
Joined: Dec 2003
Posts: 6,017
Likes: 1
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.


Link Copied to Clipboard
Forum Search
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Error Rebuilding Forums 7.7.1
by BellaOnline - 01/22/2020 1:22 PM
Subscriptions Question
by Ruben - 01/14/2020 12:11 PM
Page won't load after 7.7.3 Update
by Jim0421 - 01/08/2020 11:11 AM
Ubb 7.7.3 winkey emoji shortcut issue
by Ruben - 01/07/2020 4:04 PM
testing winkey emoji shortcut
by Ruben - 01/06/2020 2:36 PM
Who's Online Now
1 members (isaac), 97 guests, and 359 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
3D Creations
3D Creations
by JAISP, December 30
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 20200106)