Cannot see blogs

[ianmac]

Suddenly the blog access has started to fail with a SQL error.
Any clues why this is happening?

Database error in vBulletin 3.7.4:

Invalid SQL:

SELECT blog.blogid, user.username, blogtextid, blog.title, blog_text.dateline, blog_text.pagetext, user.*, blog_user.title AS blogtitle, blog_text.title AS commenttitle,
blog_text.state,
IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid, options_ignore, options_buddy, options_everyone
, ignored.relationid AS ignoreid, buddy.relationid AS buddyid
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
FROM vb3_blog_text AS blog_text
LEFT JOIN vb3_blog AS blog ON (blog.blogid = blog_text.blogid)
LEFT JOIN vb3_user AS user ON (user.userid = blog_text.userid)
LEFT JOIN vb3_blog_user AS blog_user ON (blog_user.bloguserid = blog.userid)
LEFT JOIN vb3_userlist AS buddy ON (buddy.userid = blog.userid AND buddy.relationid = 5 AND buddy.type = 'buddy')
LEFT JOIN vb3_userlist AS ignored ON (ignored.userid = blog.userid AND ignored.relationid = 5 AND ignored.type = 'ignore')
LEFT JOIN vb3_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vb3_customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE blog.state IN('visible', 'moderation')
AND blog.dateline <= 1234411079
AND blog.pending = 0
AND blog_text.state IN('visible', 'moderation')
AND blog.firstblogtextid <> blog_text.blogtextid
AND blog_text.dateline >= 1233201479

ORDER BY blog_text.dateline DESC
LIMIT 10;

MySQL Error : Got error 28 from storage engine
Error Number : 1030

[Steve Machol]

That error means:

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 (if you can) 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.

Here is an explanation of the error on the MySQL site:

http://www.mysql.com/news-and-events/newsletter/2003-10/a0000000249.html

[ianmac]

Thanks. Not knowing what the error meant was my main problem.
The host was having problems and is fixed. :o