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 :: Polls :: Message Navigator
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 15:23 Go to next message
basse is currently offline  basse   Finland
Messages: 164
Registered: March 2002
Location: Ã…bo, Finland
Karma: 0
Senior Member
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 18: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
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 20: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
Den sön, 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 19: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
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 19:38 Go to previous message
basse is currently offline  basse   Finland
Messages: 164
Registered: March 2002
Location: Ã…bo, Finland
Karma: 0
Senior Member
Some strange voodoo magic occured and the database repaired itself. The board works perfectly now, without any intervention whatsoever from me....
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: evil sql error...
Next Topic: empty private messages
Goto Forum:
  

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

Current Time: Thu Nov 21 22:12:36 GMT 2024

Total time taken to generate the page: 0.02687 seconds