Join us on Facebook

# Votes

sql error 6:
Error on delete of '/dh/mysql/tmp/#sql_6f85_8.MYI' (Errcode: 2 - No such file or directory)
in /home/marijn/emofaces.com/inc/emofaces.functions.php on line 539
function getEmofaces of class
sql code:
SELECT SQL_CALC_FOUND_ROWS emofaces.*, emofacesdetails.width, emofacesdetails.height, emofacesdetails.count, emofacesdetails.nrvotes, emofacesdetails.score, emofacesdetails.emotype, emofacesdetails.zazzleid, votes.ipaddress, votes.votedate FROM emofacesdetails LEFT JOIN emofaces USING (id) LEFT JOIN (votes) ON (votes.id = emofaces.id AND votes.emotype = emofacesdetails.emotype AND votes.ipaddress = '54.166.214.107' AND votes.votedate >= DATE_SUB(NOW(), INTERVAL 16 HOUR)) WHERE emofacesdetails.emotype = 3 AND viewdate < NOW() ORDER BY emofacesdetails.nrvotes DESC LIMIT 1625, 25