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

Home » FUDforum Development » Bug Reports » () 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
() 1030: Got error 28 from table handler [message #9461] Sun, 30 March 2003 09:37 Go to next message
mmcdon23 is currently offline  mmcdon23   Australia
Messages: 1
Registered: March 2003
Karma: 0
Junior Member
I've had the below error logged 3 times over the last 3 days. There is another thread discussing this error and it suggests a TABLE REPAIR. However, as this is only an occasional error and I can't reproduce it, I'm not sure if a TABLE REPAIR is the answer.

Any suggestions?

Error is as follows...
() 1030: Got error 28 from table handler
Query: SELECT fud23_msg.subject, fud23_cat.description, fud23_cat.name AS cat_name, fud23_cat.default_view, fud23_cat.allow_collapse, fud23_forum.*, fud23_msg.id AS msg_id, fud23_msg.post_stamp AS msg_post_stamp, fud23_users.id AS user_id, fud23_users.alias AS user_login FROM fud23_cat INNER JOIN fud23_forum ON fud23_cat.id=fud23_forum.cat_id LEFT JOIN fud23_msg ON fud23_forum.last_post_id=fud23_msg.id LEFT JOIN fud23_users ON fud23_msg.poster_id=fud23_users.id WHERE fud23_forum.id IN (2,3,4,5) ORDER BY fud23_cat.view_order, fud23_forum.view_order
Server Version: 3.23.54-log
[Referring Page] http://www.papercraftsmailbox.com.au/


My system Configuration is as follows:
PHP built On: FreeBSD demon.comcen.com.au 4.8-RC FreeBSD 4.8-RC #0: Tue Mar 11 0 i386 
MySQL Version: 3.23.54-log 
PHP Version: 4.3.1 
Web Server: Apache/1.3.27 (Unix) mod_jk/1.1.0 mod_perl/1.26 PHP/4.3.1 mod_ssl/2.8.12 OpenSSL/0.9.6h 
WebServer to PHP interface: apache 
Forum Version: 2.3.7 
Relavent PHP Settings: Safe Mode: OFF 
Display Errors: ON 
File Uploads: ON 
Magic Quotes: ON 
Register Globals: ON 
Output Buffering: OFF 
Disabled Functions: none 
PSpell Support: Yes 


[Updated on: Sun, 30 March 2003 10:28]

Report message to a moderator

Re: () 1030: Got error 28 from table handler [message #9609 is a reply to message #9461] Sun, 13 April 2003 14:35 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Your MySQL was corrupted, you need to do the following:

REPAIR TABLE [table_name].

Do this for every table with fud23_ prefix.


FUDforum Core Developer
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Russian language mix up
Next Topic: Change Login Name
Goto Forum:
  

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

Current Time: Sun Nov 24 02:37:26 GMT 2024

Total time taken to generate the page: 0.02632 seconds