• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.2 mass restore soft deleted threads and post

Adam Howard

Well-known member
#1
OK. So one of my staff members did not have the best password in the world. :rolleyes:

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

Well-known member
#2
SOLVED

For threads it is thus

PHP:
UPDATE xf_thread
SET discussion_state = 'visible'
WHERE discussion_state = 'deleted'
For post it is thus

PHP:
UPDATE xf_post
SET message_state = 'visible'
WHERE message_state = 'deleted'
Problem solved :)