Chromaniac Well-known member Jul 16, 2014 #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!
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 Jul 16, 2014 #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. Upvote 0 Downvote
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.
Chromaniac Well-known member Feb 8, 2015 #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? Upvote 0 Downvote
How do I edit the SQL command to run it for all redirections (temporary and permanent). I just need to remove the WHERE part?
Chromaniac Well-known member Mar 16, 2018 #6 Can anyone confirm if the same SQL query would be safe to run for the same purpose on XF2.x? Thanks! Upvote 0 Downvote
Chris D XenForo developer Staff member Mar 16, 2018 #7 Yes, it looks like that would still work. Upvote 0 Downvote