Kunena 6.3.8 Released

The Kunena team has announce the arrival of Kunena 6.3.8 [K 6.3.8] in stable which is now available for download as a native Joomla extension for J! 4.4.x/5.0.x/5.1.x/5.2.x. This version addresses most of the issues that were discovered in K 6.2 / K 6.3 and issues discovered during the last development stages of K 6.3
Note: Please go to the Kunena Dashboard after an upgrade so that the Kunena database tables are also updated.

Question Rebuild single thread from site backup?

More
1 year 1 week ago #1 by Ratman
Hi all you kunena wizzards. Today I ran the Kunena Diag tool and it found severe inconsistencies in my forum. I let the tool fix them all, everything is green now, but a complete thread is lost. Is it possible to re-create this thread from my daily site backup?

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

More
1 year 1 week ago #2 by Pinkeltje
Maybe but it is tricky. All tables are related by id.

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

More
1 year 1 week ago #3 by rich
As Pinkeltje already wrote, it's a bit difficult. If you open the #__kunena_topics table, you can search for the subject. Then you already have the ID of the topic.
You have to search for these thread IDs in the #__kunena_messages table. They must exist as often as the topic has posts.  
If you have these, you must search for the corresponding IDs in the #__kunena_messages_text table.
And you need the corresponding rows from the table #__kunena_user_topics

You need all these missing rows, and I can't say for sure whether there are any other dependencies. In any case, I do not guarantee database interventions, that is your responsibility.

Important! Always create a backup before you make any changes to your website!
The following user(s) said Thank You: Ratman

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

More
1 year 1 week ago #4 by Ratman
Thank you very much Richard for your explaination. It sounds scary :) I have always a big respect for those guys who speak SQL as any other language
But I think I'll give it a shot, create a duplicate of the database, lock the forum and try to import all those tables. I'll keep you updated :)

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

Time to create page: 0.380 seconds