MySQL error in file: /components/modules/top_users.php at line 217

Error Number: 1

The Error returned was:
Can't create/write to file '/tmp/#sql-temptable-3d94e2-76b48-34840.MAI' (Errcode: 28 "No space left on device")

SQL query:

SELECT COUNT(*) as count, MAX(t.date_open) as last_date, m.`name`, m.`member_group`, m.`avatar`, m.`posts_num`, m.`banned`, m.`topics_num`, m.`member_id`, m.`lastdate`, m.`reputation`, s.`text`, s.`date`, mo.`mo_id`, mo.`mo_date`, mo.`mo_hide` FROM `LB_topics` t LEFT JOIN `LB_members` m ON t.member_id_open=m.member_id LEFT JOIN `LB_members_status` s ON m.member_id = s.member_id LEFT JOIN `LB_members_online` mo ON m.member_id = mo.mo_member_id WHERE t.`member_id_open` > '0' AND t.`date_open` >= '1770144233' GROUP BY t.member_id_open ORDER BY `count` DESC LIMIT 10