XF 1.1 Someone has soft deleted most of the threads, how to retian it? :(

[rdn]

Some of my mods, abuse their permissions.
A lot of threads where deleted, but just soft deleted.
How to un-delete all soft deleted threads?

 

[Chris D]

Select the deleted thread or threads by clicking the checkbox next to each one in the thread list.

In the inline moderation drop down there is an undelete option.

 

[rdn]

I have a lot of forum nodes, they deleted not just one forum section.Most of forum sections.

 

[Chris D]

Before they deleted the threads, did you have many soft deleted threads already?

If not, I can suggest a database query that will undelete them automatically - but there will be no way to distinguish between threads that are supposed to be deleted vs the threads they deleted maliciously.

So we either do that and risk undeleting some stuff that was supposed to be deleted or you are just going to have to use the inline moderation tools (there is a Select All button).

 

[rdn]

I can use sql query if theirs an available.
I don't have any soft deleted threads previously.

 

[rdn]

I have learned, to disable hard delete permission for moderator.
Yes, it help for me a little bit.
But for now, I want to un-delete all of the threads that where soft deleted.

 

[Chris D]

UPDATE xf_thread
SET discussion_state = 'visible'
WHERE discussion_state = 'deleted'
AND node_id IN (2,3,4)

That query should do it......

Notice this will only run on threads in forums "2,3,4" - you can change that accordingly to the forums you want to run it on, or just delete that entire last line to make it run on all forums.

 

[rdn]

UPDATE xf_thread
SET discussion_state = 'visible'
WHERE discussion_state = 'deleted'
AND node_id IN (2,3,4)

That query should do it......

Notice this will only run on threads in forums "2,3,4" - you can change that accordingly to the forums you want to run it on, or just delete that entire last line to make it run on all forums.

Awesome, everything works fine now.
How about restoring soft deleted post?

 

[Chris D]

Same thing, really. Remove the last line and change "xf_thread" to "xf_post" and change "discussion_state" to "message_state".

There's one last step that bobster kindly reminded me of.

Once you've finished undeleting stuff, you will probably want to rebuild your various caches... Admin CP > Tools > Rebuild Caches.

Rebuild thread information (with post counters), poll information, forum information and then finally rebuild the search index.

The rebuilding of the search index may take a long time... but without doing that, you might find that threads are missing when you search.

 

[rdn]

After doing this, threads/post got recovered and open.

But then, User Post Count, Likes do not update.
How can I fix this?
I already did rebuild caches.

Thread Information, Forum Information, User Caches, Daily Statistics and Search Index, still user's stats not updating.

 

[rdn]

How to rebuild user's stats?
-Post Count
-Likes Recieved

 

[The Dark Wizard]

How to rebuild user's stats?
-Post Count
-Likes Recieved

Hmmm there is a query some where on the site for it that I have used in the past, I can't find it for you right now because I'm on the go but hopefully someone will.

 

[rdn]

This now fixed. Thanks !

 

[upnet]

UPDATE xf_thread
SET discussion_state = 'visible'
WHERE discussion_state = 'deleted'
AND node_id IN (2,3,4)

That query should do it......

Notice this will only run on threads in forums "2,3,4" - you can change that accordingly to the forums you want to run it on, or just delete that entire last line to make it run on all forums.

Is it possible to specify the query to a certain user who deleted and time frame that they did so?

 

[Chris D]

Not really no. What happened?