MySQL broke?

[adameros]

For the last month, other than a small rotate issue, CP1.3.0 has been working great.

The the debugging info says:

While executing query "SELECT DISTINCT a.aid as aid, a.title as title, c.name as cname FROM cpg130_albums as a, cpg130_categories as c WHERE a.category = c.cid AND a.category < '10000' ORDER BY cname,title" on 0

mySQL error: Got error 28 from table handler

I don't see any errors in the mysql error log, and it stops and restarts just fine, so I don't think the DB was corrupted.

Any ideas how to fix this?

[adameros]

Let me add...

OS: Red Hat 9.
Apache: 2.0.40
MySQL: 3.23.58
Browsers: Firefox (Linux and Windows), Safari, IE

[olegario]

I just started seeing the same issue.  It just happened over the last week, and I haven't made any changes to my system.  Any ideas?  My error is a little different.  Here it is:

While executing query "SELECT aid, CONCAT('(', user_name, ') ', title) AS title FROM cpg11d_albums AS a INNER JOIN cpg11d_users AS u ON category = (10000 + user_id) ORDER BY title" on 0

mySQL error: Got error 28 from table handler


TIA!

[kegobeer]

A google search yielded these links for error 28:

http://forums.devshed.com/t49604/s.html
http://www.pmachine.com/forum/threads.php?id=15122_0_16_0_C
http://fudforum.org/forum/index.php?t=msg&th=1983&start=0&
http://www.experts-exchange.com/Databases/Mysql/Q_20810900.html
http://dev.mysql.com/doc/mysql/en/Cannot_create.html

Try the mysql.com link first.  Pay particular attention to the temp directory stuff.

[Nibbler]

You can lookup mysql error codes on your own PC using perror.

Error code  28:  No space left on device