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

[ChopSuey]

What's the last Mod you installed?

[goshalim]

Sorry but i do not remember , that was long time ago.