Database error

[goshalim]

Hi , while trying to open my forum page i received this message.

How can i fix this problem, I need someones help please

Database error in vBulletin 3.7.3:

Invalid SQL:

  SELECT albumpicture.*, album.*, user.username, user.usergroupid,
  IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid 
  FROM fnewalbumpicture AS albumpicture
  LEFT JOIN fnewalbum AS album ON(album.albumid = albumpicture.albumid)
  LEFT JOIN fnewuser AS user ON(user.userid = album.userid)
  WHERE album.state = 'public' 
  ORDER BY dateline DESC LIMIT 0, 5;

MySQL Error   : Out of resources when opening file '/tmp/#sql_3bcc_0.MYD' (Errcode: 24)
Error Number  : 23
Request Date  : Thursday, November 5th 2009 @ 12:56:58 AM
Error Date    : Thursday, November 5th 2009 @ 12:57:25 AM