vBulletin Database Error!‏

[KimK]

Hello,

Im getting alot of vBulletin Database Error‏ emails, about 60 email daily with the following error:


Database error in vBulletin 4.2.2:


Invalid SQL:

SELECT user.*, discussion.discussionid, discussion.groupid, discussion.lastpostid, discussion.lastpost,
discussion.lastposter, discussion.lastposterid, discussion.visible,
groupmessage.gmid, groupmessage.postuserid, groupmessage.postusername, groupmessage.dateline,
groupmessage.title, groupmessage.pagetext as message,
socialgroup.name as groupname, socialgroup.description as groupdescription
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar,
customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
FROM discussion AS discussion
INNER JOIN socialgroup AS socialgroup ON(discussion.groupid = socialgroup.groupid)
INNER JOIN groupmessage AS groupmessage ON (discussion.firstpostid = groupmessage.gmid)
LEFT JOIN user AS user ON (groupmessage.postuserid = user.userid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid)
LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)

WHERE 1=1


AND ( !(socialgroup.options & 1))
AND discussion.visible > 0
AND groupmessage.state = 'visible'
AND groupmessage.dateline > 130000858

ORDER BY groupmessage.dateline DESC
LIMIT 0,5;

MySQL Error : Got error 28 from storage engine
Error Number : 1030
Referrer :
Classname : vB_Database
MySQL Version :


What should I do to fix this error?? I contact my hosting company and they replied with: "The error in question indeed appears when there is not enough free space in the /tmp partition of the server. We have increased the size of the /tmp/ folder and the issue should not reappear.".

But Im still getting the vBulletin Database Error‏ emails. Can any one help me please.

[ForceHSS]

That error means not enough disk space they need to give you a bigger disk

[Zachery]

MySQL Error : Got error 28 from table handler

Error Code 28 (No space left on device):
Got error 28 from table handler means your server's mysql partition for your mysql database ran out of disk space or that the /tmp directory ( http://www.mysql.com/doc/T/e/Temporary_files.html )on your server doesn't have enough space, you need to

1. close your forum to prevent further posting or writing to the database
2. contact your web host
3. or if your host yourself on a dedicated server, you need to move your mysql partition to a larger disk or change the /tmp directory location via your servers my.cnf file