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
Message by basse is ignored  [reveal message]  [reveal all messages by basse]  [stop ignoring this user] Go to previous messageGo to next message
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
Message by basse is ignored  [reveal message]  [reveal all messages by basse]  [stop ignoring this user] Go to previous message
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 09:21:14 EDT 2022

Total time taken to generate the page: 0.00785 seconds