- Posts: 225
- Thank you received: 12
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?
1 year 1 week ago #1
by Ratman
Rebuild single thread from site backup? was created 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.
Less
More
- Posts: 660
- Thank you received: 105
1 year 1 week ago #2
by Pinkeltje
Replied by Pinkeltje on topic Rebuild single thread from site backup?
Maybe but it is tricky. All tables are related by id.
Please Log in or Create an account to join the conversation.
1 year 1 week ago #3
by rich
Important! Always create a backup before you make any changes to your website!
Replied by rich on topic Rebuild single thread from site backup?
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.
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.
1 year 1 week ago #4
by Ratman
Replied by Ratman on topic Rebuild single thread from site backup?
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

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