• 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?

OperaManiac

Well-known member
#1
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!
 

Chris D

XenForo developer
Staff member
#2
Code:
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

Well-known member
#4
How do I edit the SQL command to run it for all redirections (temporary and permanent). I just need to remove the WHERE part?