Important K 1.5 latest posts module - no longer supported or maintained. Do NOT use this with K 1.6!

Hi everybody,

I've investigated lockups and slowdowns on my site running Kunena forum and Kunena Latest Posts module.
I've found that one of the sql queries in the modules/mod_kunenalatest/helper.php is too complex for poor mysql:

SELECT q.maxid AS id, m.time, m.thread, n.hits, q.countid AS `count` , m.subject, m.userid, m.name, m.catid, q.catname, t.message, 0 AS unread
FROM (
SELECT max( m.id ) AS maxid, count( m.id ) AS countid, c.name AS catname
FROM jos_fb_messages AS m
JOIN jos_fb_categories AS c ON m.catid = c.id
WHERE c.published =1
AND m.hold =0
AND m.moved =0
AND c.pub_access
IN ( 0, 1 , -1, 18 )
GROUP BY m.thread
ORDER BY maxid DESC
LIMIT 14
) AS q
JOIN jos_fb_messages AS m ON q.maxid = m.id
JOIN jos_fb_messages AS n ON m.thread = n.id
JOIN jos_fb_messages_text AS t ON q.maxid = t.mesid

This query takes 1.5 secs running on my configuration - and almost all the time used for the creating tmp table inside mysql.

Other queries in this module are also look quite complex. Compare to the fireboard good old last posts module - no such complex queries were there.
Unfortunately I am not SQL-guru and I am not able to fix this by myself.

Currently I've just disabled this queries (displaying first post in the thread instead of the last one) but displaying last post in the thread is essential for this module.

Did anyone hear about similar troubles with such sql queries?

-- Dam

Not sure that this is the right place, but I have some question to the module developers...
Please have a look at this thread, thanks:
www.kunena.com/forum/112-modules/33001-k...plicated-sql-queries

I've also found strange issue on one of my configurations.
Using the module wastes extra 10Mb of RAM.
Investigating the culprit I've found that the reason is in loading Community Builder object. Removed the line - got minus 10Mbs of RAM.

I've also found that actually module uses the 5% of the huge Community Builder functionality. I've made special CB class without extra functionality - and this helped me - module was completely function but I've saved 10 Mb.

This was made by the very dirty hack (I am not a developer) so I am just pointing at this trouble - may be this will help someone.

I've done this with CB 1.2.1 and Kunena Latest Module 1.0.45

-- Dam

Not sure who the author is of that module, but I would recommend to at least limit the amount of data processed by the query.

I would at least limit to the latest 10-30 days. That WHERE criteria will limit the amount of processing significantly.

Hope this helps!

fxstein

This is the error I'm getting:

Fatal error: Cannot redeclare class smile in /home/content/w/o/o/woozabee/html/components/com_kunena/template/default/smile.class.php on line 31

I am using a custom template with Kunena 1.5.6 and installed the latest version of this mod. Not sure if my custom template is causing this or what...

jpc0480 wrote:

This is the error I'm getting:

Fatal error: Cannot redeclare class smile in /home/content/w/o/o/woozabee/html/components/com_kunena/template/default/smile.class.php on line 31

I am using a custom template with Kunena 1.5.6 and installed the latest version of this mod. Not sure if my custom template is causing this or what...

well could be, youst send us template, we will see if we can help or not.