×
Kunena 5.2 RC3 Released (29 Nov 2020)

The Kunena team is thrilled to announce the third public release candidate of Kunena 5.2, a native Joomla extension for Joomla 3.9. This is a development release and should be only be used for testing; this version is not recommended for live websites at this stage.

The purpose of this release is to encourage testing by downloading, installing and identifying any problems or shortcomings that people may discover. K 5.2.0 RC3 is stable and we are aware that people will discover defects. We encourage you to use the forum to report defects, as soon as they are discovered, so that the development team can work through the problems before the release of K 5.1 as a stable product. Reporting defects does not mean that the problems can or will be fixed. The Kunena team is looking forward to hearing your feedback on how well we have achieved our design goals.

× Topics must relate to a currently supported version of Kunena. If you are unsure what is the current supported version of Kunena, please go to the download page.

If you are having problems then, for your own benefit, it would save us all a lot of time if you would kindly post your configuration report when you ask for help from this forum. If you do not post your configuration report we will not ask you for it but you will probably not get your problem solved, either.

Question How to Restore a Permanently Deleted topic? / Easy way through Trashbin ?

More
2 years 11 months ago - 2 years 11 months ago #1 by Kotsolis
One of my moderators (ex-moderator because I removed him) Permanently Deleted 2 very important forum topics.

This is how I found him .

Now how can I put them back in the Forum? Is there a Recycle bin or something in the backend, where we can restore permanently deleted topics? I believe it should be. Because right now I need to:
1)Take the 2 deleted topics from the MySQL database file from the Full Daily backup. I need to open a 79GB tar.gz file through SSH or wait until it is fully downloaded in my hard drive! Any way to do the first option so that we don't lose time? I have 600 people who have voted already and a couple more waiting to vote until 31/12.
2)Then I need to take which mysql tables from the main mysql file? I need to restore them somewhere. In the same server?. Also which mysql tables do I need? I surely need the topic IDs (which I know). Do I need anything else?
3)And finally how am I able to restore those two topics using a MySQL command?

Can you please give me details on that? The contest was up and running, and people were only voting on those two topics.

Update: Also I request that topics should stay in Trashbin even after they are permanently deleted. They should appear at the Backend. One of our moderators completely deleted a topic and we had to restore the whole yesterday's backup including polls to bring it back!
Last edit: 2 years 11 months ago by Kotsolis.

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

More
2 years 11 months ago - 2 years 11 months ago #2 by rich

Can you please give me details on that? The contest was up and running, and people were only voting on those two topics.

That will not be easy. Your topics includes polls. You need at least the infos from this tables.
*_kunena_messages
*_kunena_messages_text
*_kunena_polls
*_kunena_polls_options
*_kunena_polls_users
*_kunena_topics
I give no guarantee for this information! Maybe there are also still other dependencies and if you only make a small mistake, you can destroy your entire page. I don't know which backup software you use, but the best way if you use this possibility.
Last edit: 2 years 11 months ago by rich.
The following user(s) said Thank You: Kotsolis

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

More
2 years 11 months ago - 2 years 11 months ago #3 by Kotsolis
Update: Also I request that topics should stay in Trashbin even after they are permanently deleted. They should appear at the Backend, maybe at a different filder. One of our moderators completely deleted a topic and we had to restore the whole yesterday's backup including polls to bring it back!

Any possibility that you feature this in one of your next patches? We had to bring back the whole yesterday's database with a script to revive the topic.

2nd thing: Disallow moderators from permanently deleting topics .

And after all these changes during 2017 you are perfect to go! :)
Last edit: 2 years 11 months ago by Kotsolis.

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

  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to edit your message.
Time to create page: 0.085 seconds