- Posts: 5
- Thank you received: 0
Kunena 6.3.0 released
The Kunena team has announce the arrival of Kunena 6.3.0 [K 6.3.0] 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 and issues discovered during the last development stages of K 6.3
Topics that are moved into this category are generally considered to be closed. Users may want to add additional information but these topics should not be resurrected in order to discuss new problems or unrelated matters.
Question Update to Kunena 1.6 = Slow
13 years 6 months ago #2
by fxstein
We love stars on the Joomla Extension Directory .
Replied by fxstein on topic Re: Update to Kunena 1.6 = Slow
Hi,
Yes your site is very slow.
Can you please turn on the Joomla debug mode and copy the output into a [ code] [ /code] block in here?
This could be CB or menu related. we have seen some bad bugs in custom menu modules that run way too many queries and a menu alias is being used.
You should see a total of 30-40 queries on the forum page (together with Joomla) - it it is significantly more, we need to look into that.
Hope this helps!
Yes your site is very slow.
Can you please turn on the Joomla debug mode and copy the output into a [ code] [ /code] block in here?
This could be CB or menu related. we have seen some bad bugs in custom menu modules that run way too many queries and a menu alias is being used.
You should see a total of 30-40 queries on the forum page (together with Joomla) - it it is significantly more, we need to look into that.
Hope this helps!
We love stars on the Joomla Extension Directory .
Please Log in or Create an account to join the conversation.
13 years 6 months ago #3
by Stylefr
I don't understand that be write in this code
Thank's you a lot for your help.
Replied by Stylefr on topic Re: Update to Kunena 1.6 = Slow
Code:
Informations
Application afterLoad: 0.004 seconds, 0.23 MB
Application afterInitialise: 0.214 seconds, 2.63 MB
Application afterRoute: 0.329 seconds, 4.36 MB
Application afterDispatch: 1.140 seconds, 14.34 MB
Application afterRender: 1.336 seconds, 14.80 MB
Utilisation de la mémoire
15565836
65 requêtes achevées
SELECT *
FROM jos_session
WHERE session_id = '0cc3e61502148a35e81974be53e408d6'
DELETE
FROM jos_session
WHERE ( time < '1286723777' )
SELECT *
FROM jos_session
WHERE session_id = '0cc3e61502148a35e81974be53e408d6'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '0cc3e61502148a35e81974be53e408d6','1286724677','','0','1','0' )
SELECT *
FROM jos_components
WHERE parent = 0
SELECT folder AS type, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
SELECT `id`, `password`, `gid`
FROM `jos_users`
WHERE username='Stylefr'
SELECT *
FROM jos_users
WHERE id = '62'
SELECT *
FROM jos_session
WHERE session_id = '0cc3e61502148a35e81974be53e408d6'
DELETE
FROM `jos_session`
WHERE session_id = '0cc3e61502148a35e81974be53e408d6'
SELECT *
FROM jos_session
WHERE session_id = 'b78c96361d47eb36abd678840db3ec0c'
SELECT *
FROM jos_session
WHERE session_id = 'b78c96361d47eb36abd678840db3ec0c'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id`,`data` )
VALUES ( 'b78c96361d47eb36abd678840db3ec0c','1286724677','','0','1','0','' )
DELETE
FROM jos_session
WHERE ( time < '1286723777' )
SELECT *
FROM jos_session
WHERE session_id = 'b78c96361d47eb36abd678840db3ec0c'
UPDATE `jos_session`
SET `time`='1286724677',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`=''
WHERE session_id='b78c96361d47eb36abd678840db3ec0c'
SELECT id
FROM jos_users
WHERE username = 'Stylefr'
LIMIT 0, 1
SELECT *
FROM jos_users
WHERE id = '62'
SELECT g.*
FROM jos_core_acl_aro_groups AS g
INNER JOIN jos_core_acl_groups_aro_map AS gm
ON gm.group_id = g.id
INNER JOIN jos_core_acl_aro AS ao
ON ao.id = gm.aro_id
WHERE ao.value='62'
ORDER BY g.id
SELECT COUNT(*)
FROM jos_core_acl_aro_groups AS g1
LEFT JOIN jos_core_acl_aro_groups AS g2
ON (g1.lft > g2.lft
AND g1.lft < g2.rgt)
WHERE g1.name = 'Super Administrator'
AND g2.name = 'USERS'
SELECT COUNT(*)
FROM jos_core_acl_aro_groups AS g1
LEFT JOIN jos_core_acl_aro_groups AS g2
ON (g1.lft > g2.lft
AND g1.lft < g2.rgt)
WHERE g1.name = 'Super Administrator'
AND g2.name = 'Registered'
SELECT COUNT(*)
FROM jos_core_acl_aro_groups AS g1
LEFT JOIN jos_core_acl_aro_groups AS g2
ON (g1.lft > g2.lft
AND g1.lft < g2.rgt)
WHERE g1.name = 'Super Administrator'
AND g2.name = 'Public Backend'
SELECT *
FROM jos_session
WHERE session_id = 'b78c96361d47eb36abd678840db3ec0c'
UPDATE `jos_session`
SET `time`='1286724677',`userid`='62',`usertype`='Super Administrator',`username`='Stylefr',`gid`='25',`guest`='0',`client_id`='0',`data`=''
WHERE session_id='b78c96361d47eb36abd678840db3ec0c'
SELECT *
FROM jos_users
WHERE id = '62'
UPDATE jos_users
SET lastvisitDate = '2010-10-10 15:31:17'
WHERE id = 62
SELECT m.*, c.`option` AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT *
FROM jos_kunena_config
SELECT u.name, u.username, u.block AS blocked, ku.*
FROM jos_users AS u
LEFT JOIN jos_kunena_users AS ku
ON u.id = ku.userid
WHERE u.id = 62
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 262)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT COUNT(*)
FROM jos_kunena_whoisonline
WHERE userip='82.237.35.210'
AND userid='62'
DELETE
FROM jos_kunena_whoisonline
WHERE time < '1286715678'
INSERT INTO jos_kunena_whoisonline (`userid` , `time`, `what`, `task`, `do`, `func`,`link`, `userip`, `user`)
VALUES ('62','1286717478','Consulte la liste des catégories','','','listcat','http://www.bonkersgamers.fr/index.php?option=com_kunena&view=listcat&Itemid=262','82.237.35.210','1')
SELECT *
FROM jos_kunena_sessions
WHERE userid = '62'
SELECT g.*
FROM jos_core_acl_aro_groups AS g
INNER JOIN jos_core_acl_groups_aro_map AS gm
ON gm.group_id = g.id
INNER JOIN jos_core_acl_aro AS ao
ON ao.id = gm.aro_id
WHERE ao.value='62'
ORDER BY g.id
SELECT c.id, c.pub_access, c.pub_recurse, c.admin_access, c.admin_recurse
FROM jos_kunena_categories c
WHERE published='1'
SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name
FROM jos_comprofiler_plugin
WHERE published = 1
AND access <= 2
AND type = 'user'
ORDER BY ordering
UPDATE `jos_kunena_sessions`
SET `allowed`='1,2,3,6,8,15,16,17,18,4,9,10,11,12,13,19',`lasttime`='1286714516',`readtopics`='0',`currvisit`='1286717478'
WHERE userid='62'
SELECT id, title, module, position, content, showtitle, control, params
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 2
AND m.client_id = 0
AND ( mm.menuid = 262 OR mm.menuid = 0 )
ORDER BY position, ordering
SELECT *
FROM jos_users AS u
LEFT JOIN jos_comprofiler AS c
ON c.id = u.id
WHERE u.id = 62
SELECT `gid`
FROM `jos_users`
WHERE `id` = 62
SELECT g1.`id` AS group_id, g1.`name`
FROM `jos_core_acl_aro_groups` AS g1
LEFT JOIN `jos_core_acl_aro_groups` AS g2
ON g2.`lft` >= g1.`lft`
WHERE g2.`id` = 25
ORDER BY g1.`name`
SELECT f.*
FROM jos_comprofiler_fields f
INNER JOIN jos_comprofiler_tabs AS t
ON (f.tabid = t.tabid)
WHERE f.published = 1
AND f.profile != 0
AND t.enabled = 1
AND t.useraccessgroupid IN (24,33,19,31,20,23,30,29,21,18,17,25,28,-2,-1)
ORDER BY t.position, t.ordering, f.ordering
SELECT id
FROM jos_menu
WHERE link = 'index.php?option=com_comprofiler'
AND published=1
AND access <= 2
SELECT *
FROM jos_kunena_categories
WHERE parent='0'
AND published='1'
AND id IN (1,2,3,6,8,15,16,17,18,4,9,10,11,12,13,19)
ORDER BY ordering, name
SELECT *
FROM jos_kunena_announcement
WHERE published='1'
ORDER BY created DESC
LIMIT 0, 1
SELECT w.userid, w.func, u.username AS username, k.showOnline
FROM jos_kunena_whoisonline AS w
LEFT JOIN jos_users AS u
ON u.id=w.userid
LEFT JOIN jos_kunena_users AS k
ON k.userid=w.userid
WHERE w.link LIKE 'http://www.bonkersgamers.fr/index.php?option=com_kunena&view=listcat&Itemid=262%'
AND w.func='listcat'
GROUP BY w.userid
ORDER BY u.username ASC
SELECT c.*, m.id AS mesid, m.thread, m.catid, t.subject AS topicsubject, m.subject, m.name AS mname, u.id AS userid, u.username, u.name AS uname,
(SELECT COUNT(*)
FROM jos_kunena_messages AS mm
WHERE m.thread=mm.thread) AS msgcount, (SELECT COUNT(DISTINCT thread)
FROM jos_kunena_messages AS mmm
WHERE c.id=mmm.catid
AND mmm.hold='0'
AND mmm.time>'1286714516'
AND mmm.thread NOT IN (0)) AS new
FROM jos_kunena_categories AS c
LEFT JOIN jos_kunena_messages AS m
ON c.id_last_msg=m.id
LEFT JOIN jos_kunena_messages AS t
ON m.thread=t.id
LEFT JOIN jos_users AS u
ON u.id=m.userid
WHERE c.parent IN (1,4,17)
AND c.published='1'
AND c.id IN(1,2,3,6,8,15,16,17,18,4,9,10,11,12,13,19)
ORDER BY ordering, name
SELECT c.id, c.name, c.description, c.parent, c.numTopics, c.numPosts, (SELECT COUNT(DISTINCT thread)
FROM jos_kunena_messages AS m
WHERE c.id=m.catid
AND m.hold='0'
AND m.time>'1286714516'
AND m.thread NOT IN (0)) AS new
FROM jos_kunena_categories AS c
WHERE c.parent IN (9,10,11,12,19,13,18,16,8,2,3,6,15)
AND c.published='1'
AND c.id IN(1,2,3,6,8,15,16,17,18,4,9,10,11,12,13,19)
ORDER BY c.ordering, c.name
SELECT *
FROM jos_kunena_moderation AS m
INNER JOIN jos_users AS u
ON u.id=m.userid
WHERE m.catid IN (9,10,11,12,19,13,8,2,3,6,15)
AND u.block=0
SELECT catid, COUNT(*) AS count
FROM jos_kunena_messages
WHERE catid IN (9,10,11,12,19,13,8,2,3,6,15)
AND hold='1'
GROUP BY catid
SELECT s.userid, u.username AS username, u.id, k.moderator, k.showOnline
FROM jos_users AS u
LEFT JOIN jos_kunena_users AS k
ON k.userid=u.id
INNER JOIN jos_session AS s
ON s.client_id=0
AND s.userid=u.id
GROUP BY s.userid
ORDER BY username ASC
SELECT id, username AS username
FROM jos_users
WHERE block='0' OR activation=''
ORDER BY id DESC
LIMIT 0, 1
SELECT u.name, u.username, u.block AS blocked, ku.*
FROM jos_users AS u
LEFT JOIN jos_kunena_users AS ku
ON u.id = ku.userid
WHERE u.id IN (62,66,64,88,68,90)
SELECT code, `location`
FROM jos_kunena_smileys
SELECT u.id
FROM jos_users AS u
WHERE u.block='0'
AND u.usertype IN ('Administrator', 'Super Administrator')
SELECT u.id AS uid, m.catid
FROM jos_users AS u
INNER JOIN jos_kunena_users AS p
ON u.id=p.userid
LEFT JOIN jos_kunena_moderation AS m
ON u.id=m.userid
LEFT JOIN jos_kunena_categories AS c
ON m.catid=c.id
WHERE u.block='0'
AND p.moderator='1'
AND (m.catid IS NULL OR c.moderated='1')
SELECT COUNT(*)
FROM jos_users
WHERE block=0 OR activation=''
SELECT SUM(time >= '1286661600'
AND parent='0') AS todayopen,
SUM(time >= '1286575200'
AND time < '1286661600'
AND parent='0') AS yesterdayopen,
SUM(time >= '1286661600'
AND parent>'0') AS todayanswer,
SUM(time >= '1286575200'
AND time < '1286661600'
AND parent>'0') AS yesterdayanswer
FROM jos_kunena_messages
WHERE time >= '1286575200'
AND hold='0'
SELECT SUM(numTopics) AS titles, SUM(numPosts) AS msgs
FROM jos_kunena_categories
WHERE parent='0'
AND published=1
SELECT SUM(parent='0') AS totalcats, SUM(parent>'0') AS totalsections
FROM jos_kunena_categories
WHERE published=1
SELECT u.name, u.username, u.block AS blocked, ku.*
FROM jos_users AS u
LEFT JOIN jos_kunena_users AS ku
ON u.id = ku.userid
WHERE u.id = 90
SELECT id
FROM jos_menu
WHERE link LIKE 'index.php?option=com_comprofiler&task=registers%'
AND published=1
AND access <= 2
SELECT count(u.id)
FROM jos_uddeim AS u
WHERE u.totrash=0
AND u.toread=0
AND u.toid=62
SELECT id
FROM jos_menu
WHERE published>=0
AND link LIKE '%com_uddeim%'
Fichiers de langue chargés
/homez.59/bonkersg/www/language/fr-FR/fr-FR.ini 1
/homez.59/bonkersg/www/language/fr-FR/fr-FR.plg_system_debug.ini 1
/homez.59/bonkersg/www/language/fr-FR/fr-FR.com_jcomments.ini 1
/homez.59/bonkersg/www/language/fr-FR/fr-FR.com_kunena.ini 1
/homez.59/bonkersg/www/language/fr-FR/fr-FR.mod_mainmenu.ini 1
/homez.59/bonkersg/www/language/fr-FR/fr-FR.tpl_yoo_planet.ini
/homez.59/bonkersg/www/language/en-GB/en-GB.tpl_yoo_planet.ini
/homez.59/bonkersg/www/language/fr-FR/fr-FR.mod_breadcrumbs.ini 1
/homez.59/bonkersg/www/language/fr-FR/fr-FR.mod_cblogin.ini
/homez.59/bonkersg/www/language/en-GB/en-GB.mod_cblogin.ini
/homez.59/bonkersg/www/language/fr-FR/fr-FR.mod_login.ini 1
Diagnostique des textes non traduits
Aucun
Textes non traduits
Aucun
I don't understand that be write in this code
Thank's you a lot for your help.
Please Log in or Create an account to join the conversation.
13 years 6 months ago #5
by fxstein
We love stars on the Joomla Extension Directory .
Replied by fxstein on topic Re: Update to Kunena 1.6 = Slow
Can you also check your appache error log (web hosting).
Could it be that you have lots of warnings and errors in there?
Could it be that you have lots of warnings and errors in there?
We love stars on the Joomla Extension Directory .
Please Log in or Create an account to join the conversation.
13 years 6 months ago #7
by fxstein
We love stars on the Joomla Extension Directory .
Replied by fxstein on topic Re: Update to Kunena 1.6 = Slow
Your hosting company should have some FAQs that explain where to find it. Its a default log on all hosts, just in different locations by hosting company. In many cases you can access it through their control panel (where you setup the domain) - it should be called something like 'Log Manager' - you should find an Access Log and an Error Log - Only the Error Log is of interest for now. Got to the very end of it and see if there are lots of warnings and errors. If so copy some of them here. You can use the
This message contains confidential information
We love stars on the Joomla Extension Directory .
Please Log in or Create an account to join the conversation.
13 years 6 months ago #8
by fxstein
We love stars on the Joomla Extension Directory .
Replied by fxstein on topic Re: Update to Kunena 1.6 = Slow
In addition I would do some testing and turn off CB and UddeIM integration - just to check there are no issues with them.
We love stars on the Joomla Extension Directory .
Please Log in or Create an account to join the conversation.
Time to create page: 0.566 seconds