MySQL error 1030 and

[WoodiE]

I'm MySQL database email errors sent to me, below are the two errors:


Database error in vBulletin 2.3.0:
Invalid SQL:
SELECT DISTINCT post.userid, post2.pagetext as pagetext, icon.title as icontitle,icon.iconpath,
thread.threadid,thread.title,lastpost, forumid,pollid,open,replycount,postusername,postuserid,
lastposter,thread.dateline,views,thread.iconid,notes,thread.visible,sticky,votetotal,attac h
FROM thread
LEFT JOIN icon ON (icon.iconid = thread.iconid)
LEFT JOIN post ON (thread.threadid = post.threadid AND post.userid = '2745' AND post.visible = 1) LEFT JOIN post AS post2 ON (thread.firstpostid = post2.postid)
WHERE thread.threadid IN (0,13156,13058,10121,13133,13132,13111,13038,13023,12561,13044,13043,12842,12693,12276,130 11,12622,12960,12464,12922,12968,12870,12175,12961,12920,12341,12497,12717,12573,12738,127 74,8210,12701,12564,149,11579)
ORDER BY sticky DESC, lastpost DESC

mysql error: Got error 28 from table handler

mysql error number: 1030


AND THIS


Database error in vBulletin 2.3.0:

Invalid SQL: SELECT * FROM forum,subscribeforum WHERE subscribeforum.forumid=forum.forumid AND userid=3429 ORDER BY title
mysql error: Got error 28 from table handler

mysql error number: 1030


Can anyone tell me what causes these and how to go about fixing them? I just ran repair.php and that doesn't seem to do anything for the errors.


-Michael

[Steve Machol]

Error code 28: No space left on device

One or more partitions on your server is out of space or doesn't have enough space to complete this operation. Shutdown your forums and contact your host immediately. You or your host will need to find out which partition is low on space and free up some more space.