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

[Chromaniac]

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]

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.

 

[Chromaniac]

Thanks!

 

[Chromaniac]

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

 

[Mike]

Correct.

 

[Chromaniac]

Can anyone confirm if the same SQL query would be safe to run for the same purpose on XF2.x? Thanks!

 

[Chris D]

Yes, it looks like that would still work.