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

XF 1.3 SQL Query to convert permanent redirects to temporary redirects?

Discussion in 'XenForo Questions and Support' started by OperaManiac, Jul 16, 2014.

  1. OperaManiac

    OperaManiac Well-Known Member

    Just wanted to declutter the forum views by changing permanent redirects to 60 day redirects which should be enough time for search engines to update their databases. Thanks!
  2. Chris D

    Chris D XenForo Developer Staff Member

    UPDATE xf_thread_redirect SET expiry_date = '1410862757' WHERE expiry_date = '0'
    1410862757 is a timestamp that represents 16th September 2014, so roughly 60 days from now.

    That will only change redirects that are currently permanent.
    OperaManiac likes this.
  3. OperaManiac

    OperaManiac Well-Known Member

  4. OperaManiac

    OperaManiac Well-Known Member

    How do I edit the SQL command to run it for all redirections (temporary and permanent). I just need to remove the WHERE part?
  5. Mike

    Mike XenForo Developer Staff Member


Share This Page