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


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!

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.


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?