Simple Machines Community Forum

SMF Support => SMF 1.1.x Support => Topic started by: Swedie on October 30, 2003, 01:30:44 PM

Title: Database Error: Got error 28 from table handler
Post by: Swedie on October 30, 2003, 01:30:44 PM
I am recieving this error, which just all of the sudden started happening:
Database Error: Got error 28 from table handler
File: /export/webroot/www/board/Sources/BoardIndex.php
Line: 151

It's really odd.

It happens when I try to list the board index.

Please help me out!
Title: Re:Database Error: Got error 28 from table handler
Post by: Ben_S on October 30, 2003, 01:37:23 PM
Error 28 is no disk space left. Check your sites not over quota if not contact your host as their disk may be full
Title: Re:Database Error: Got error 28 from table handler
Post by: Swedie on October 30, 2003, 01:49:30 PM
Oh now THAT does ring a bell! Admin kept complaining about the disks running out of space! Thanks ! good call. much likely the problem.
Title: Re: Database Error: Got error 28 from table handler
Post by: roundcrisis on December 12, 2003, 10:10:33 AM
Could something else cause this?

Title: Re: Database Error: Got error 28 from table handler
Post by: Chris Cromer on December 12, 2003, 10:13:04 AM
Nope out of disk space is the only thing that causes this error.
Title: Re: Database Error: Got error 28 from table handler
Post by: [Unknown] on December 12, 2003, 08:57:06 PM
http://www.simplemachines.org/community/index.php?topic=2486 ;).

Yeah, 28 means SPECIFICALLY disk space.  Happens a lot with craptacular linux partitioning.

-[Unknown]
Title: Re: Database Error: Got error 28 from table handler
Post by: dfg on January 24, 2004, 09:53:53 PM
So there is nothing else other than disk space that can cause this error?

What about a corrupt table? is that possible?
Title: Re: Database Error: Got error 28 from table handler
Post by: [Unknown] on January 24, 2004, 09:58:10 PM
QuoteD:\Program Files\MySQL\bin>perror 28
Error code  28:  No space left on device

Nothing else to it.  Probably means your data in on a separate partition, and is full.

-[Unknown]
Title: Re: Database Error: Got error 28 from table handler
Post by: SissysDad on July 25, 2005, 02:23:48 AM
I was getting this error and I know I have plenty of space.  Like 25 Gb's to be exact.  It doesn't happen all the time, but about every 30 posts, it will show up.  It started when I updated the forums four days ago.  So what else besides "out of space" would cause this?

Database Error: Got error 28 from table handler
File: /home/pugstories/public_html/forums/Sources/BoardIndex.php
Line: 82

/var is under 50% so even the partition is okay (for now).
Title: Re: Database Error: Got error 28 from table handler
Post by: Chris Cromer on July 25, 2005, 02:28:16 AM
As was already said, there is no other cause besides being out of space. Just because you have 25GB doesn't mean that 25GB can be used by your partition. Chances are the partition that your mysql data is being stored in is full.
Title: Re: Database Error: Got error 28 from table handler
Post by: yodaofborg on August 19, 2005, 09:03:06 AM
i have had this problem

and if the space is not full
then they have a TEMP folder that should auto empty, but is not that reliable, if this is full, then you need to contact your host and ask them to manually empty the Temp sql temp file

hope this helps someone, (i found out the hard way)

Yoda