Database error - Help if you can :)

[UrGonnaDie]

Hello everyone im getting like 30 emails with errors like this below. I recently moved my site from one hosting company to another i think that is the cause but even though im getting db errors its not affecting my site from working.
-------------------------------------------------
Database error in vBulletin 4.0.8:

Invalid SQL:
SELECT SQL_CALC_FOUND_ROWS node.nodeid AS itemid ,(node.nodeleft = 1) AS isroot, node.nodeid, node.contenttypeid, node.contentid, node.url, node.parentnode, node.styleid, node.userid,
node.layoutid, node.publishdate, node.setpublish, node.issection, parent.permissionsfrom as parentpermissions,
node.showrating,
node.permissionsfrom, node.publicpreview, node.shownav, node.hidden, node.nosearch , info.description, info.title, info.viewcount, info.creationdate, info.workflowdate,
info.workflowstatus, info.workflowcheckedout, info.workflowlevelid, info.associatedthreadid,
user.username, sectionorder.displayorder


FROM cms_node AS node
INNER JOIN cms_nodeinfo AS info ON info.nodeid = node.nodeid
LEFT JOIN user AS user ON user.userid = node.userid
LEFT JOIN cms_sectionorder AS sectionorder ON sectionorder.sectionid = node.parentnode
AND sectionorder.nodeid = node.nodeid
LEFT JOIN cms_node AS parent ON parent.nodeid = node.parentnode

WHERE node.new != 1 AND node.nodeid IN (45,5,11,2,3,1) AND ( (node.permissionsfrom IN (1)) OR (node.userid =1) OR ( node.permissionsfrom in (1,5) AND (node.parentnode IN (1) OR node.nodeid = 1) AND
node.setpublish > 0 AND node.publishdate < 1297602378 ))AND node.new != 1

ORDER BY CASE WHEN sectionorder.displayorder > 0 THEN sectionorder.displayorder ELSE 9999999 END ASC,
node.publishdate DESC;

MySQL Error : Can't create/write to file '/tmp/#sql_6760_0.MYI' (Errcode: 28)
Error Number : 1
Request Date : Sunday, February 13th 2011 @ 07:06:18 AM
Error Date : Sunday, February 13th 2011 @ 07:06:18 AM
Script : http://www.justpurefun.com/
Referrer :
IP Address : 208.54.161.219
Username : UrGonnaDie
Classname : vB_Database
MySQL Version : 5.0.91-community

[Lynne]

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

[UrGonnaDie]

What makes you say that? originally i thought it was my /tmp folder i changed the permissions from 755 to 777 had no luck.

[Lynne]

<a href="http://rackerhacker.com/2007/08/09/mysql-error-codes/" target="_blank">http://rackerhacker.com/2007/08/09/mysql-error-codes/</a>

[UrGonnaDie]

That works thanks so much Lynne.