DB function failed with error number 1 Can't create/write to file '/tmp/#sql_1652_1.MYI' (Errcode: 22) SQL=SELECT a.*, t.message AS messagetext, l.myfavorite, l.favcount, l.attachmesid, l.msgcount, l.lastid, u.avatar, c.id AS catid, c.name AS catname
FROM (
SELECT m.thread, (f.userid='0') AS myfavorite, COUNT(DISTINCT f.userid) AS favcount, COUNT(a.mesid) AS attachmesid,
COUNT(DISTINCT m.id) AS msgcount, MAX(m.id) AS lastid, MAX(m.time) AS lasttime
FROM jos_fb_messages AS m
LEFT JOIN jos_fb_favorites AS f ON f.thread = m.thread
LEFT JOIN jos_fb_attachments AS a ON a.mesid = m.thread
WHERE m.hold='0' AND m.thread IN (66,43,38,39,33,29,13,15,10,3)
GROUP BY thread
) AS l
INNER JOIN jos_fb_messages AS a ON a.thread = l.thread
INNER JOIN jos_fb_messages_text AS t ON a.thread = t.mesid
LEFT JOIN jos_fb_users AS u ON u.userid = a.userid
LEFT JOIN jos_fb_categories AS c ON c.id = a.catid
WHERE (a.parent='0' OR a.id=l.lastid)
ORDER BY o in /home/epicgan1/public_html/epicdesign.com.au/components/com_kunena/lib/kunena.debug.php on line 152
