Error code 28


#1

I just sent a support mail but didn’t receive the copy of it at the email provided though it does show up in the support history in the panel. Figured I would post it here just to make sure someone sees it as it looks like a fairly serious problem.

I’m getting an error message when trying to use my forum software (phpBB):

[color=#CC0000]
Couldn’t obtain category list.

DEBUG MODE

SQL Error : 1030 Got error 28 from table handler

SELECT c.cat_id, c.cat_title, c.cat_order FROM phpbb_categories c,
phpbb_forums f WHERE f.cat_id = c.cat_id GROUP BY c.cat_id,
c.cat_title, c.cat_order ORDER BY c.cat_order

Line : 106
File : /home/.dacca/user/mydomain.com/forum/includes/functions.php
[/color]

everything I’ve been able to Google up on this points to a space problem with either a tmp directory, SQL server or webserver.

Whatever it is it’s crippled a site that I’m trying to launch this weekend, of course =[

[color=#0000CC]jason[/color]

[color=#00CC00]EDIT: !@#$% :P~ as soon as I submit this it’s back up! THANKS! Anybody wanna say what was the deal here? Surely the server’s not full ;)[/color]


#2

I’m getting this error now (and have in the past… letting it slide, things go back to normal within 24 hours…)
but I’d like to know how it can be avoided and/or fixed on demand!

[quote]Couldn’t obtain category list.

DEBUG MODE

SQL Error : 1030 Got error 28 from table handler

SELECT c.cat_id, c.cat_title, c.cat_order FROM phpbb_categories c, phpbb_forums f WHERE f.cat_id = c.cat_id GROUP BY c.cat_id, c.cat_title, c.cat_order ORDER BY c.cat_order

Line : 119
File : /home/.harmonee/manky/forum.amancay.com/includes/functions.php[/quote]

prrrr…


#3

I got a similar error on my forums (invision)

mySQL query error: SELECT f.*, c.id as cat_id, c.position as cat_position, c.state as cat_state, c.name as cat_name, c.description as cat_desc, c.image, c.url, m.member_name as mod_name, m.member_id as mod_id, m.is_group, m.group_id, m.group_name, m.mid FROM rawk_forums f, rawk_categories c LEFT JOIN rawk_moderators m ON (f.id=m.forum_id) WHERE c.id=f.category ORDER BY c.position, f.position mySQL error: Got error 28 from table handler I put it down to my machine being rebooted as per the email i recieved:-


We’ll be rebooting your hosting machine this afternoon between 2:30 and
4:30pm PST. Web and FTP will be affected, but mail will not. Total
downtime should be no more than 5 minutes.

Happy DreamHost Security Team


Bob

www.rawkstar.net