- Posts: 2
- Thank you received: 0
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
16 years 11 months ago #14919
by maj
Wrong Database Version but Still Working was created 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:
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
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.
16 years 11 months ago #15041
by Matias
Replied by Matias on topic Re:Wrong Database Version but Still Working
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
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.
16 years 11 months ago #15140
by maj
Replied by maj on topic Re:Wrong Database Version but Still Working
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
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.
16 years 11 months ago #15181
by Matias
Replied by Matias on topic Re:Wrong Database Version but Still Working
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.
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