Kunena 7.0.2 Released

The Kunena team has announce the arrival of Kunena 7.0.2 [K 7.0.2] in stable which is now available for download as a native Joomla extension for J! 5.3.x/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 category recount problem, duplicated posts

More
16 years 2 months ago #35686 by Matias
Replied by Matias on topic Re:category recount problem, duplicated posts
I do not see any problem. All the threads have correct number of replies in them.

Did you get this issue fixed and if you did, how?

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

More
16 years 2 months ago #37021 by laoneo1
Replied by laoneo1 on topic Re:category recount problem, duplicated posts
I reverted back to the database state before I run the recount function....since then I haven't recounted the category stats. another problem which appeared with the mogration to 1.5.8 was that when I move a thread the last post field of the old category still shows the moved thread as its last post...
I think something is broken in kunena since version 1.5.7 which was working perfectly....

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

More
16 years 2 months ago - 16 years 2 months ago #37350 by LOK
Replied by LOK on topic Re:category recount problem, duplicated posts
I had the same problem (dublicate Threads)... I was able to fix it
by removing dublicate user entrys from fb_users and running
Code:
ALTER TABLE `jos_fb_announcement` ADD PRIMARY KEY ( `id` ) ; ALTER TABLE `jos_fb_attachments` ADD INDEX `mesid` ( `mesid` ) ; ALTER TABLE `jos_fb_categories` ADD PRIMARY KEY ( `id` ) ; ALTER TABLE `jos_fb_categories` ADD INDEX `parent` ( `parent` ) ; ALTER TABLE `jos_fb_categories` ADD INDEX `published_pubaccess_id` ( `published` , `pub_access` , `id` ) ; ALTER TABLE `jos_fb_categories` ADD INDEX `msg_id` ( `id_last_msg` ) ; ALTER TABLE `jos_fb_favorites` ADD UNIQUE `thread` ( `thread` , `userid` ) ; ALTER TABLE `jos_fb_favorites` ADD INDEX `userid` ( `userid` ) ; ALTER TABLE `jos_fb_messages` ADD PRIMARY KEY ( `id` ) ; ALTER TABLE `jos_fb_messages` ADD INDEX `thread` ( `thread` ) ; ALTER TABLE `jos_fb_messages` ADD INDEX `parent` ( `parent` ) ; ALTER TABLE `jos_fb_messages` ADD INDEX `catid` ( `catid` ) ; ALTER TABLE `jos_fb_messages` ADD INDEX `ip` ( `ip` ) ; ALTER TABLE `jos_fb_messages` ADD INDEX `ip` ( `userid` ) ; ALTER TABLE `jos_fb_messages` ADD INDEX `ip` ( `time` ) ; ALTER TABLE `jos_fb_messages` ADD INDEX `ip` ( `locked` ) ; ALTER TABLE `jos_fb_messages` ADD INDEX `hold_time` ( `hold` , `time` ) ; ALTER TABLE `jos_fb_messages` ADD INDEX `parent_hits` ( `parent` , `hits` ) ; ALTER TABLE `jos_fb_messages_text` ADD PRIMARY KEY ( `mesid` ) ; ALTER TABLE `jos_fb_moderation` ADD PRIMARY KEY ( `catid` , `userid` ) ; ALTER TABLE `jos_fb_ranks` ADD PRIMARY KEY ( `rank_id` ) ; ALTER TABLE `jos_fb_sessions` ADD PRIMARY KEY ( `userid` ) ; ALTER TABLE `jos_fb_smileys` ADD PRIMARY KEY ( `id` ) ; ALTER TABLE `jos_fb_subscriptions` ADD UNIQUE `thread` ( `thread` , `userid` ) ; ALTER TABLE `jos_fb_subscriptions` ADD INDEX `userid` ( `userid` ) ; ALTER TABLE `jos_fb_users` ADD PRIMARY KEY ( `userid` ) ; ALTER TABLE `jos_fb_users` ADD INDEX `group_id` ( `group_id` ) ; ALTER TABLE `jos_fb_users` ADD INDEX `posts` ( `posts` ) ; ALTER TABLE `jos_fb_users` ADD INDEX `uhits` ( `uhits` ) ; ALTER TABLE `jos_fb_version` ADD PRIMARY KEY ( `id` ) ; ALTER TABLE `jos_fb_whoisonline` ADD PRIMARY KEY ( `id` ) ; ALTER TABLE `jos_fb_whoisonline` ADD INDEX `userid` ( `userid` ) ;
row by row (cause some keys already existed) to add missing keys, if you get an error "dublicate entry", you should check if there are dublicats in the table and remove them
Last edit: 16 years 2 months ago by LOK.

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

More
16 years 1 month ago #37873 by PGLion
Replied by PGLion on topic Re:category recount problem, duplicated posts
Today I upgraded to 1.5.8. and did the category recount thing. Now I also have duplicate messages and had to shut down my forum.

I don't have duplicate users, so that seems to be okay. What can I do to remove these double messages? Is it save to run LOK's code?

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

More
16 years 1 month ago - 16 years 1 month ago #37875 by PGLion
Replied by PGLion on topic Re:category recount problem, duplicated posts
Hmm, I tried LOK's code but get this message:

Error

SQL query:

ALTER TABLE `jos_fb_announcement` ADD PRIMARY KEY ( `id` ) ;

MySQL said: Documentation
#1068 - Multiple primary key defined

I must admit I dunno know much about SQL :(
Last edit: 16 years 1 month ago by PGLion.

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

More
16 years 1 month ago #38058 by PGLion
Replied by PGLion on topic Re:category recount problem, duplicated posts
Everything is running smooth again but the problem still remains, I can not run "Recount Category Stats". It results in double entries of all messages in the database. How can I fix this?

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

Time to create page: 0.297 seconds