منتدى استراحات زايد

Hi*

I have encountered numerous database error for vb one morning:

"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 * 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*41*5*7*12*45*46*47*48*14*15*13*16*6*11) AND ((node.permissionsfrom in (1*5*6*11*41) and node.setpublish > 0 and node.publishdate < 1261860337) OR (node.permissionsfrom in (-1) OR node.userid =0 ) )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_fb7_0.MYI' (Errcode: 30)
Error Number : 1"

May I know how to solve it?

Thank you.