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 :)
 
Top