1. 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

Discussion in 'XenForo Questions and Support' started by Adam Howard, Sep 12, 2013.

  1. Adam Howard

    Adam Howard Well-Known Member

    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?
     
  2. Adam Howard

    Adam Howard Well-Known Member

    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 :)
     
  3. Adam Howard

    Adam Howard Well-Known Member

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

Share This Page