Немного конктретики:
Основная ошибка: Can't create/write to file '/tmp/MYVJmrUc' (Errcode: 28) at /var/www/cafemam/data/www/cafemam.ru/htdocs/_modules/nblog/nblog.module.php line 422
Где: /var/www/cafemam/data/www/cafemam.ru/htdocs/_modules/nblog/nblog.module.php line 422
Что: Can't create/write to file '/tmp/MYVJmrUc' (Errcode: 28)
В чем: SELECT p.id, p.blog_id, p.post_title, p.user_id, p.created, u.first_name, u.last_name
FROM core_nblog_post AS p
JOIN core_users_extended AS u USING(user_id)
WHERE p.type="1" AND p.user_id IN('120', '322', '692', '1031', '2147', '2871', '3495', '4057', '5018', '5112', '7942', '8341', '10372', '11467', '13182', '14788', '15047', '15367', '16409', '17446', '17506', '18577', '65', '78', '353', '1193', '1309', '1523', '1700', '1853', '2516', '2531', '3165', '3234', '4574', '5560', '9362', '13917', '14589', '15398', '18871', '19368', '19972', '20572', '21677', '25053', '26066', '26140', '26700', '27174', '28665', '29279', '29413', '31059', '32546', '20935', '21297', '22187', '25719', '26131', '26473', '27243', '27270', '27295', '27639', '28478', '28502', '29076', '30146', '30508', '30545', '30794', '31545', '31703', '31816', '32549', '33256', '33296', '34006', '20113') AND p.user_id!=20113
ORDER BY p.created desc LIMIT 3