Previous Thread
Next Thread
Print Thread
Hop To
Joined: Nov 2004
Posts: 18
M
stranger
stranger
M Offline
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 6:20 PM.
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
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
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
HERE is a tutorial for phpmyadmin to repair tables also.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
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 7:33 PM.
Joined: Nov 2004
Posts: 18
M
stranger
stranger
M Offline
Joined: Nov 2004
Posts: 18
That did the trick, thanks! Shoutbox is back in action, too. Interesting that went down.


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
2 members (Havenofsobriety, rootman), 624 guests, and 106 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)