A Database Error Occurred

Error Number: 1

Can't create/write to file '/tmp/#sql_57a_0.MAI' (Errcode: 28 "No space left on device")

SELECT * FROM (`tmgallery`) JOIN `tmalbum` ON `tmalbum`.`albumid` = `tmgallery`.`albumid` ORDER BY RAND() LIMIT 8