Немного конктретики:
Основная ошибка: Can't create/write to file '/tmp/MYPjwVqn' (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/MYPjwVqn' (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('44', '156', '173', '205', '416', '509', '587', '621', '664', '775', '878', '952', '1104', '1181', '1193', '1248', '1333', '1471', '1483', '1579', '1700', '1729', '2003', '2090', '2287', '2446', '2522', '2625', '2690', '2724', '2745', '2805', '2871', '2902', '2915', '3066', '3789', '4097', '4135', '4529', '4679', '4795', '4822', '4937', '5196', '5657', '5989', '6886', '6891', '6918', '7549', '7612', '7906', '7942', '7947', '9027', '9226', '9253', '9498', '10372', '10630', '10659', '10752', '10896', '10904', '11099', '11137', '11347', '11392', '11559', '12073', '12109', '12259', '13296', '13332', '13370', '13875', '13909', '13917', '14306', '14516', '14559', '14580', '14716', '14788', '14820', '15047', '15070', '15412', '15420', '15421', '15429', '15688', '15725', '16446', '16538', '16783', '16820', '17534', '18007', '18418', '19086', '19733', '20026', '21297', '21677', '23427', '24687', '27267', '29413', '110', '120', '323', '325', '492', '601', '692', '830', '913', '1205', '1300', '1371', '1523', '1593', '1662', '1728', '1842', '1853', '1992', '2056', '2147', '2368', '2531', '2538', '2995', '3103', '3165', '3234', '3453', '3495', '3523', '3783', '3814', '3823', '3954', '4057', '4920', '5018', '5578', '6560', '8012', '8239', '8533', '8580', '9362', '9554', '9909', '10988', '11467', '11509', '12237', '12687', '15480', '16425', '17466', '18292', '18577', '18871', '20113', '20488', '20935', '21261', '21695', '22187', '24209', '24444', '24476', '26066', '26140', '26678', '26829', '27263', '27270', '27295', '27639', '27689', '28104', '29027', '29076', '30508', '30694', '30729', '33974', '33988', '78') AND p.user_id!=78
ORDER BY p.created desc LIMIT 3