×
Kunena 5.1.6.1 Released - Security Release (09 Nov 2018)

The Kunena team has announce the arrival of Kunena 5.1.6 [K 5.1.6] which is now available for download as a native Joomla extension for J! 3.9.x. This version addresses most of the issues that were discovered in K 5.1 and issues discovered during the development stages of K 5.1. This is a Security release.

K5.1.6.1 is a install update.

× 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
5 years 9 months 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
5 years 9 months 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
5 years 9 months ago - 5 years 9 months 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: 5 years 9 months ago by Mortti.

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

More
5 years 9 months 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
5 years 9 months 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.

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