- Posts: 2
- Thank you received: 0
Kunena 6.3.4 released
The Kunena team has announce the arrival of Kunena 6.3.4 [K 6.3.4] in stable which is now available for download as a native Joomla extension for J! 4.4.x/5.0.x/5.1.x. This version addresses most of the issues that were discovered in K 6.2 / K 6.3 and issues discovered during the last development stages of K 6.3
Note: Please go to the Kunena Dashboard after an upgrade so that the Kunena database tables are also updated.
Question too many queries for each user to assets table in joomla
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.
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.
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.
Please Log in or Create an account to join the conversation.
Please Log in or Create an account to join the conversation.
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.