Kunena 6.2.5 & module Kunena Latest 6.0.7 released

The Kunena team has announce the arrival of Kunena 6.2.5 [K 6.2.5] 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

This is for users to help other users, to discuss topics that are related to forum administration in general or problems in running Joomla. This is not the place to ask for Joomla support. If you want assistance with Joomla please ask at forum.joomla.org

Question too many queries for each user to assets table in joomla

More
11 years 1 month ago #1 by abjocz
My site generate a lot of queries to database, for each user generates 6 queries. I tried to fine the source of that but my knowlagde was not enouch to find. If anyone could help me how to fine the source of that queries?

I used: Joomla 2.5.8 Main Components: CB, Kunena 2.0.3, SH404SEF, K2, Komento, UddeIM PMS Main Modules: Gavick News PRO4 Block spam IP Block bots.

On the other forum some users suggested that could be the Kunena. It is true?


The queries which are generate for each user:
SELECT *
FROM `_users`
WHERE `id` = 15

SELECT `g`.`id`,`g`.`title`
FROM `_usergroups` AS g
INNER JOIN `_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 15

SELECT b.id
FROM _user_usergroup_map AS map
LEFT JOIN _usergroups AS a
ON a.id = map.group_id
LEFT JOIN _usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE map.user_id = 15

SELECT a.rules
FROM _assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft

SELECT id
FROM _assets
WHERE parent_id = 0

SELECT b.rules
FROM _assets AS a
LEFT JOIN _assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.id = 1 OR a.parent_id=0)
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft

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

More
11 years 1 month ago #2 by xillibit
Hello,

I don't know where these queries come from but Kunena doesn't have this kind of queries.

I don't provide support by PM, because this can be useful for someone else.

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

More
11 years 1 month ago - 11 years 1 month ago #3 by Mortti
Check of your "Block spam IP Block bots" modul or something...?

I used: Joomla 2.5.8 Main Components: CB, Kunena 2.0.3, SH404SEF, K2, Komento, UddeIM PMS Main Modules: Gavick News PRO4 Block spam IP Block bots.

Last edit: 11 years 1 month ago by Mortti.

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

More
11 years 1 month ago #4 by abjocz
Block spam IP Block is a script which is actevated manualy and add spam IP to htaccess - i t could be source of these queries?

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

More
11 years 1 month ago #5 by xillibit
Hello,

Try by disabling all modules and plugins and enable them on by one to see which one adds these queries.

I don't provide support by PM, because this can be useful for someone else.

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

Time to create page: 0.470 seconds