XF 1.2 mass restore soft deleted threads and post

[Adam Howard]

OK. So one of my staff members did not have the best password in the world.

And as such we ended up with a lot of soft deleted threads and post. By lots I mean well over 300 - 500 or so.

Is there away to restore all soft deleted content on a mass scale? Perhaps a MySQL command?

 

[Adam Howard]

SOLVED

For threads it is thus

UPDATE xf_thread
SET discussion_state = 'visible'
WHERE discussion_state = 'deleted'

For post it is thus

UPDATE xf_post
SET message_state = 'visible'
WHERE message_state = 'deleted'

Problem solved

 

[Adam Howard]

^ From there it is simple as rebuilding all your cache and search.