MySQL error in file: /engine/modules/functions.php at line 1523

Error Number: 1114

The Error returned was:
The table '/tmp/#sql_2193_0' is full

SQL query:

SELECT p.id, p.autor, p.date, p.short_story, CHAR_LENGTH(p.full_story) as full_story, p.xfields, p.title, p.category, p.alt_name, p.comm_num, p.allow_comm, p.fixed, p.tags, e.news_read, e.allow_rate, e.rating, e.vote_num, e.votes, e.view_edit, e.editdate, e.editor, e.reason FROM dle_post p LEFT JOIN dle_post_extras e ON (p.id=e.news_id) WHERE category IN ('3001','3003','3004','3005','3007','3008','3009','3012','3013','3014','3015','3016','4001','4002','4003','4005','4006','4007','4008','4009','4010','4011','4012','4013','4014','4015','4016','4017','4018','4019','4020','4021','4022','4023','4024','4025','4026','4027','4028','4029','4030','4031','4032','4033','4035','4036','4037','4038','4039','4040','4041','4042','4043','4044','4045','4046','4047','4048','4049','4050','4051','4052','4053','4054','10001','10002','10003') AND approve=1 ORDER BY news_read DESC LIMIT 0,10