MySQL Query Error

Time: 2010-3-11 3:25am
Script: /photo/photo.php

SQL: SELECT p.*,a.id AS albumid,a.privacy,a.type,a.show_time FROM `webshare-photo`.photo p , `webshare-photo`.album a ,`webshare-photo`.member_setting m WHERE p.uploader_mid=m.mid AND m.all_privacy IN (0,2) AND p.album_id=a.id AND p.status='1' AND a.privacy=0 AND a.show_time<=20100311 ORDER BY create_time DESC LIMIT 1200
Error: Incorrect key file for table '/dev/shm/#sql_4029_0.MYI'; try to repair it
Errno.: 126