Kunena 7.0.4 Released

The Kunena team has announce the arrival of Kunena 7.0.4 [K 7.0.4] in stable which is now available for download as a native Joomla extension for J! 5.4.x/6.0.x. This version addresses most of the issues that were discovered in K 6.2 / K 6.3 / K 6.4 and issues discovered during the last development stages of K 7.0

Question Wrong Database Version but Still Working

More
16 years 11 months ago #14919 by maj
Hi,

I recently installed Kunena on Joomla which is currently using a pre v5 database but with php 5.0 I had the install error warning (about php5 which is strange as well), and have the error:
Code:
Warning: Could not load latest Version record.\nDB function failed with error number 1146 Table 'xxxxx' doesn't exist SQL=SELECT `version`, `versiondate`, `installdate`, `build`, `versionname` FROM `jos_fb_version` ORDER BY `id` DESC LIMIT 1; SQL = SELECT `version`, `versiondate`, `installdate`, `build`, `versionname` FROM `jos_fb_version` ORDER BY `id` DESC LIMIT 1;

However the forum works fine and the error only appears in admin.

Would it be ok to continue to use the forum or is this a serious problem?

Any help appreciated.

Thanks
M

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

More
16 years 11 months ago #15041 by Matias
This is actually a bug which has been fixed.. :)

But seriously: there are two different kind of problem with old MySQL releases:
1) they are really slow on Kunena
2) Many of Kunena SQL queries do not work with MySQL <4.3 and there may be some that do not work well <5.0

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

More
16 years 11 months ago #15140 by maj
Thanks for the information.

The thing is I've been testing the forum and it seems to be pretty quick and works fine; the database info is from an old fireboard installation but apart from the admin error everything is working. I just don't want to put this to production then it breaks. It looks v stable at the moment, I know you said some queries won't work but I have tried everything to break the forum and it is fine.

The reason I want to use Kunena is that it integrates with Jomsocial for the avatar. Updating the database I think will not be possible at the moment any suggestions welcome.

Thanks

Maj

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

More
16 years 11 months ago #15181 by Matias
Many of our queries use subqueries to do the task:

SELECT * FROM (SELECT s1 FROM t1) AS x;

Those are very slow (not optimized) in MySQL <5.0. You cannot see the difference on small forum, but large forums can be really slow.

Actually I cannot find any new feature in MySQL 5.0 that we use. So Kunena may actually work on MySQL 4.3+. Older MySQL versions do not support subqueries and they are used to fetch messages, so.. Don't try Kunena with them.

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

Time to create page: 0.292 seconds