×
Kunena 5.2 Beta 1 Released (24 Sep 2020)

The Kunena team is thrilled to announce the first public beta release of Kunena 5.2, a native Joomla extension for Joomla 3.9. This is a development release and should be only be used for testing; this version is not recommended for live websites at this stage.

The purpose of this release is to encourage testing by downloading, installing and identifying any problems or shortcomings that people may discover. K 5.2.0 B1 is stable and we are aware that people will discover defects. We encourage you to use the forum to report defects, as soon as they are discovered, so that the development team can work through the problems before the release of K 5.1 as a stable product. Reporting defects does not mean that the problems can or will be fixed. The Kunena team is looking forward to hearing your feedback on how well we have achieved our design goals.

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

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

More
7 years 7 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
7 years 7 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 edit your message.
Time to create page: 0.110 seconds