- Posts: 5
- Thank you received: 0
Kunena 7.1.1 & Kunena 6.4.17 – Security Updates Released
The Kunena team has announce the arrival of Kunena 7.1.1 [K 7.1.1] in stable which is now available for download as a native Joomla extension for J! 5.4.x/6.0.x./6.1.x./6.2.x This version addresses most of the issues that were discovered in K 6.2 / K 6.3 / K 6.4 / K7.0 and issues discovered during the last development stages of K 7.1
Just a reminder: K6.4.17 receives only securities fixes until end of 2026, so it's advised for users to upgrade to K7.1.
Important Performance Problem
i'm facing a performance issue with Kunena 1.5.4. This is an upgraded Kunena from Fireboard (Joomla 1.0.x) -> Kunena 1.0.11 (Joomla 1.0.x) -> Kunena 1.54 (Joomla 1.5.x). The migration worked fine so far, i have no problems with functionality.
Overall, the Forum is super fast. It's hosted on a dedicated server with enough resources. BUT: if i'm in the categorie overview, and want to switch to a specific categorie (f.e. 400 topics, 9000 replies) it takes foreeeeeeever to finish the load (ok, about 1 minute). CPU load (mysqld) is at 100% in this time...
The strange thing about this: if i switch back to the overview and click again in the same categorie, it goes super fast. Seem's like mysql caches the result for a moment, and therefore gives me the fast response the second time.
Investigating the mysql-slow.log file tells me, that the query in charge is this one:
Time taken:
Am i missing some sort of indexes or so in the database? How else is this arguable? Does anyone have a tip on this one?
P.S.: I posted first in the wrong forum: "Kunena 1.0.11, older Versions and Fireboard" could a moderator delete the post there please?
Best regards,
failbit
Please Log in or Create an account to join the conversation.
I have similar problem as well, haven't got any logs for you just yet,, but we have successfully built a php-fusion to Kunena convertor.. but loading the pages takes ages..
Even using the lastest discussion mod on the home page take for ever just to get 10 results..
the site is here to take look site.aussieslivingsimply.com.au/index.ph...mid=111&func=listcat
I'm hoping it is not because of the size of the forum.. (23000 posts, 60 categories)
I tried changing a few categories to sub- (because we couldn't do this in php-fusion) but it didn't make any difference.
Please Log in or Create an account to join the conversation.
The easiest way to check is to go into the administrator/components/com_kunena/install/kunena.install.upgrade.xml file
and manually check whether your database has the same indexes defined as in the fresh install section of the xml file.
Even with 100,000 of messages this query should be fast.
We love stars on the Joomla Extension Directory .
Please Log in or Create an account to join the conversation.
Please Log in or Create an account to join the conversation.
- made a fresh kunena installation
- in phpmyadmin, exported only the sql-structure from the jos_fb tables
- did the same export for sql on my migrated forum
- made a diff between those two files, and realized there are _many_ differents.
I then decided to just export the DATA (without structure information) from my migrated forum. Then i imported the fresh SQL-STRUCTURE from the new kunena installation. Finally i imported my DATA into this structure -> works like a charm now.
Thanks!
Please Log in or Create an account to join the conversation.
Would it be possible to see the list of differences you ended up with?
The main problem is that prior to FireBoard 1.0.5 all database changes had to be done by hand, which is very error prone.
Thx!
We love stars on the Joomla Extension Directory .
Please Log in or Create an account to join the conversation.