Kunena 6.2.4 Released

The Kunena team has announce the arrival of Kunena 6.2.4 [K 6.2.4] which is now available for download as a native Joomla extension for J! 4.3.x/4.4.x/5.0.x. This version addresses most of the issues that were discovered in K 6.1 / K 6.2 and issues discovered during the last development stages of K 6.2

Question Rebuild single thread from site backup?

More
1 month 4 days 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 month 3 days 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 month 3 days 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.
The following user(s) said Thank You: Ratman

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

More
1 month 3 days 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.425 seconds