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

XF 1.5 change http to https in posts (sql?)

#1
hi
i move my site to https

the think is that i have more than 600 url in the posts of my forum that still refer to old url http://

whats is the best method to remplace url in posts that point to my site with http (to https)

can i do sql find and replace url in database? how?

thank you for your help
 

Brogan

XenForo moderator
Staff member
#2
Code:
UPDATE xf_post SET message = REPLACE(message,'current_content','new_content');
Take a backup first in case something goes wrong and you need to restore.
 

MrC

Active member
#4
Code:
UPDATE xf_post SET message = REPLACE(message,'current_content','new_content');
Take a backup first in case something goes wrong and you need to restore.
Hi,

Do I need to rebuild anything? I used that code to change from http to https but only a few links updated. Other links still show http, but when I edited them, they show the correct https links.