mysql error: Got error 28 from table handler

[cf-soul]

1. Www.clanforen.de
2. PHP version 4.1.2
3. MySQL version 3.23.53
4. Apache/webserver version - newest
5. Server operating system - Linux

http://www.clanforen.de/phpinfo.php


My problem:
if I click on thread, then I get the following error:
-----------------------------------------------------

Database error in vBulletin 2.2.5:
Invalid SQL:
SELECT
post.*,SUM(bookmarks.public) AS bmcount,SUM(bookmarks.counter) AS allhits,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath,
attachment.attachmentid,attachment.filename,attachment.visible AS attachmentvisible,attachment.counter
,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline
FROM post
LEFT JOIN icon ON icon.iconid=post.iconid
LEFT JOIN user ON user.userid=post.userid
LEFT JOIN userfield ON userfield.userid=user.userid
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
LEFT JOIN bookmarks ON bookmarks.userid=user.userid AND bookmarks.public='1'
WHERE post.postid IN (0,652519,652904,652910)
GROUP BY post.postid
ORDER BY dateline
mysql error: Got error 28 from table handler
mysql error number: 1030
Date: Tuesday 04th of February 2003 02:42:44 PM


Ok. I have try to use repair.php - all table are OK
I have empty the searchindex table (130MB)

But i don´t know, how can i clear space via ssh?

thx 4 any help

[Cary]

Error code 28 means there's no space left on your device.

Close your forums immediately. Next, send a letter to your webhost informing them that the MySQL patition ran out of space... they should be able to help you.