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

giovi92
Topic Author
Offline
New Member

11 years 7 months ago - 11 years 7 months ago #1 by giovi92

HTTP 500 Internal Server Error - out of memory was created 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.