[CMS] Invalid SQL Error: SELECT SQL_CALC_FOUND_ROWS node.nodeid AS itemid

[PolicyWala]

Getting below error on my CMS, Please help what is wrong?

Database error in vBulletin 4.1.5:

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 (1,124,116,123,306,148,126,138,133,125,129) AND node.new != 1 
                
                  ORDER BY CASE WHEN sectionorder.displayorder > 0 THEN sectionorder.displayorder ELSE 9999999 END ASC,
                     node.publishdate DESC;

MySQL Error   : Got error 28 from storage engine
Error Number  : 1030
Request Date  : Wednesday, September 28th 2011 @ 02:07:52 PM
Error Date    : Wednesday, September 28th 2011 @ 02:07:52 PM
Script        : http://www.policywala.com/content.php/289-IndiaFirst-launches-Money-Back-Health-Insurance-Plan
Referrer      : 
IP Address    : 188.223.84.56
Username      : PolicyWala
Classname     : vB_Database
MySQL Version : 5.0.92-community

[PolicyWala]

Searched on Vbulletin and found out -

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.

How to solve the above problem?

[238mph]

Call whoever hosts your forum and tell them the area on their hard drive (where they host your forum) is full... they will need to move it to a larger drive or clean old junk off that drive to free up space.

[Wayne Luke]

Since this is a SELECT query, the most likely problem is that the /tmp partition is out of space but it is an out of space error. Your host would need to correct this issue by resizing the affected partition.