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

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 User statistics broken in K1.6

More
15 years 6 months ago #64060 by thujahekk
Replied by thujahekk on topic Re: User statistics broken in K1.6
OK, thanks.. appreciate it.
Forum is now offline.. awaiting your feedback.

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

More
15 years 6 months ago - 15 years 6 months ago #64062 by Matias
Replied by Matias on topic Re: User statistics broken in K1.6
WARNING: THIS MESSAGE IS MENT ONLY TO FIX ISSUES FOR thujahekk. USING THESE QUERIES MAY BREAK YOUR FORUM FOR GOOD.

In Kunena 1.5:

1) Take backup from jos_kunena_* tables (you may want to leave those 3 broken tables out:)

NOTE: If your forum has been online for a while and users have been using it, you can restore everything else but changes in user data or sessions (read topics).

2) Install Kunena 1.6, but choose to restore backup from K1.5.

3) Run SQL queries:
Code:
ALTER TABLE `jos_fb_moderation` DROP PRIMARY KEY ; ALTER TABLE `jos_fb_sessions` DROP PRIMARY KEY ; ALTER TABLE `jos_fb_users` DROP PRIMARY KEY ; ALTER TABLE `jos_kunena_moderation` ADD PRIMARY KEY ( `catid,userid` ) ; ALTER TABLE `jos_kunena_sessions` ADD PRIMARY KEY ( `userid` ) ; ALTER TABLE `jos_kunena_users` ADD PRIMARY KEY ( `userid` )

4) Install Kunena 1.6 and import data again

5) Restore other tables to keep new data (optional)


You can also try to fix the tables without previous steps:

In Kunena 1.6 (uses first item for every key -- may cause some data to be lost, most likely changed profile info + session information):
Code:
ALTER IGNORE TABLE `jos_kunena_moderation` ADD PRIMARY KEY ( `catid,userid` ) ; ALTER IGNORE TABLE `jos_kunena_sessions` ADD PRIMARY KEY ( `userid` ) ; ALTER IGNORE TABLE `jos_kunena_users` ADD PRIMARY KEY ( `userid` ) ;

I hope that this works for you.
Last edit: 15 years 6 months ago by Matias.

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

More
15 years 6 months ago - 15 years 6 months ago #64068 by Matias
Replied by Matias on topic Re: User statistics broken in K1.6
Hmm.. there seems to be missing some other fields and keys as well.
Code:
ALTER TABLE `jos_kunena_announcement` MODIFY `title` tinytext NOT NULL AFTER `id`; ALTER TABLE `jos_kunena_categories` MODIFY `moderated` tinyint(4) NOT NULL default '1' AFTER `alert_admin`; ALTER IGNORE TABLE `jos_kunena_messages` ADD KEY `ip` (ip), ADD KEY `userid` (userid); ALTER TABLE `jos_kunena_ranks` MODIFY `rank_title` varchar(255) NOT NULL default '' AFTER `rank_id`, MODIFY `rank_image` varchar(255) NOT NULL default '' AFTER `rank_special`; ALTER IGNORE TABLE `jos_kunena_subscriptions` ADD UNIQUE KEY `thread` (thread,userid), ADD KEY `userid` (userid); ALTER TABLE `jos_kunena_users` MODIFY `birthdate` date NOT NULL default '0001-01-01' AFTER `gender`;

That should be it..
Last edit: 15 years 6 months ago by Matias.

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

More
15 years 6 months ago #64078 by thujahekk
Replied by thujahekk on topic Re: User statistics broken in K1.6
Not fully tested yet, but so far so good... seems to be working :)
Thanks so much for your help!

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

More
15 years 6 months ago #64080 by Matias
Replied by Matias on topic Re: User statistics broken in K1.6
Cool. I need to think a way to detect this issue and fix it automatically.

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

More
15 years 3 months ago #80774 by thujahekk
Replied by thujahekk on topic Re: User statistics broken in K1.6
Hi Matias,
Just installed Kunena 1.6.2 and the errors are back. User records are duplicated in the database in "jos_kunena_users".

Any advice as to how I can fix? Any help to solve this issue will be greatly appreciated.

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

Time to create page: 0.228 seconds