Kunena 6.2.2 Released with module Latest 6.0.5, module Kunena Stats 6.0.5, Kunena Discuss 6.0.5 and Kunena Search module 6.0.5

The Kunena team has announce the arrival of Kunena 6.2.2 [K 6.2.2] which is now available for download as a native Joomla extension for J! 4.3.x/4.4.x/5.0.x. This version addresses most of the issues that were discovered in K 6.1 / K 6.2 and issues discovered during the last development stages of K 6.2

The error code HTTP 500 Internal Server Error is a general-purpose message this indicates a general error in a web application. Please note that there is no general solution for this general error. You should first read HTTP 500 Internal Server Error before posting in this category.

Question HTTP 500 Internal Server Error - out of memory

11 years 7 months ago - 11 years 7 months ago #1 by giovi92
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
Last edit: 11 years 7 months ago by sozzled.

Please Log in or Create an account to join the conversation.

11 years 7 months ago #2 by sozzled

Please Log in or Create an account to join the conversation.

Time to create page: 0.262 seconds