×
Kunena 6.0.6 & Kunena 5.2.13 & blue eagle5 1.6.8 released as security release (28 Nov 2022)

The Kunena team has announce the arrival of Kunena 6.0.6 [K 6.0.6] which is now available for download as a native Joomla extension for J! 4.2.x. This is a security release.

× 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

More
10 years 7 months ago - 10 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: 10 years 7 months ago by sozzled.

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

More
10 years 7 months ago #2 by sozzled

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

  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to edit your message.
Time to create page: 0.126 seconds