FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Bug Reports » SQL Error: "1030: Got error 28 from table handler"
Show: Today's Messages :: Unread Messages :: Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
SQL Error: "1030: Got error 28 from table handler" [message #8809] Sun, 23 February 2003 10:23 Go to next message
basse is currently offline  basse   Finland
Messages: 164
Registered: March 2002
Location: Åbo, Finland
Karma: 0
Senior Member
add to buddy list
stop ignoring messages by this user
My forum has all of a sudden been disabled due to a SQL error. This is what my log contains:

(rid=1&S=67029ec4a0019832d400cd7dd4af5e26) 1030: Got error 28 from table handler
Query: SELECT fud_msg.subject, fud_cat.description, fud_cat.name AS cat_name, fud_cat.default_view, fud_cat.allow_collapse, fud_forum.*, fud_forum_read.last_view, fud_msg.id AS msg_id, fud_msg.post_stamp AS msg_post_stamp, fud_users.id AS user_id, fud_users.alias AS user_login FROM fud_cat INNER JOIN fud_forum ON fud_cat.id=fud_forum.cat_id LEFT JOIN fud_msg ON fud_forum.last_post_id=fud_msg.id LEFT JOIN fud_users ON fud_msg.poster_id=fud_users.id LEFT JOIN fud_forum_read ON fud_forum.id=fud_forum_read.forum_id AND fud_forum_read.user_id=1 ORDER BY fud_cat.view_order, fud_forum.view_order
Server Version: 3.23.49-log
[Referring Page] http://www.furahakoren.org/forum/adm/consist.php


Any ideas?
Re: SQL Error: "1030: Got error 28 from table handler" [message #8811 is a reply to message #8809] Sun, 23 February 2003 13:51 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
remove from buddy list
ignore all messages by this user
You need to repair the table.

FUDforum Core Developer
Re: SQL Error: "1030: Got error 28 from table handler" [message #8816 is a reply to message #8811] Sun, 23 February 2003 15:17 Go to previous messageGo to next message
basse is currently offline  basse   Finland
Messages: 164
Registered: March 2002
Location: Åbo, Finland
Karma: 0
Senior Member
add to buddy list
stop ignoring messages by this user
Den sn, 23 februari 2003 20:51 skrev prottoss:

You need to repair the table.


Sorry for sounding real stupid, but how do I go about doing that? Can it be done inside the admin panel, or do I have to do it some other way?
Re: SQL Error: "1030: Got error 28 from table handler" [message #8834 is a reply to message #8816] Tue, 25 February 2003 14:23 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
remove from buddy list
ignore all messages by this user
You can do this by running REPAIR TABLE table_name; SQL query or use the myisamchk binary (will requite write access to mysql database directory).

FUDforum Core Developer
Re: SQL Error: "1030: Got error 28 from table handler" [message #8840 is a reply to message #8834] Tue, 25 February 2003 14:38 Go to previous message
basse is currently offline  basse   Finland
Messages: 164
Registered: March 2002
Location: Åbo, Finland
Karma: 0
Senior Member
add to buddy list
stop ignoring messages by this user
Some strange voodoo magic occured and the database repaired itself. The board works perfectly now, without any intervention whatsoever from me....
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: evil sql error...
Next Topic: empty private messages
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Sep 26 07:55:23 EDT 2022

Total time taken to generate the page: 0.00765 seconds