Question HTTP 500 Internal Server Error - out of memory

This is the output from Kunena debug:

500 - JDatabaseMySQLi::query: 5 - Out of memory (Needed 4194276 bytes) SQL=SELECT a.*, j.id AS userid, t.message, l.myfavorite, l.favcount, l.threadhits, l.lasttime, l.threadattachments, COUNT(aa.id) AS attachments, l.msgcount, l.mycount, l.lastid, l.mylastid, l.lastid AS lastread, 0 AS unread, u.avatar, j.username, j.name AS uname, c.name AS catname, c.class_sfx FROM ( SELECT m.thread, MAX(m.hits) AS threadhits, MAX(f.userid IS NOT null AND f.userid='42') AS myfavorite, COUNT(DISTINCT f.userid) AS favcount, COUNT(DISTINCT a.id) AS threadattachments, COUNT(DISTINCT m.id) AS msgcount, COUNT(DISTINCT IF(m.userid='42', m.id, NULL)) AS mycount, MAX(m.id) AS lastid, MAX(IF(m.userid='42', m.id, 0)) AS mylastid, MAX(m.time) AS lasttime FROM egpre_kunena_messages AS m LEFT JOIN egpre_kunena_favorites AS f ON f.thread = m.thread LEFT JOIN egpre_kunena_attachments AS a ON a.mesid = m.id WHERE m.hold IN (0,1,2,3) AND m.moved='0' AND m.thread IN (15,14,13,12,11,10,9,8,7,6) GROUP BY thread ) AS l INNER JOIN egpre_kunena_messages AS a ON a.thread = l.thread INNER JOIN egpre_kunena_messages_text AS t ON a.id = t.mesid LEFT JOIN egpre_users AS j ON j.id = a.userid LEFT JOIN egpre_kunena_users AS u ON u.userid = j.id LEFT JOIN egpre_kunena_categories AS c ON c.id = a.catid LEFT JOIN egpre_kunena_attachments AS aa ON aa.mesid = a.id WHERE (a.parent='0' OR a.id=l.lastid ) GROUP BY a.id ORDER BY lastid DESC

G'day, giovi92, and welcome to Kunena.

See Improving Kunena performance