Topic: How To Force HTTP to HTTPS

[Mick]

I looked at that setting at the bottom of that page couple of times, and though, no that can't be the upload url, because the avatar is working and the avatars url at the top of the page was https.  Just thought I'd try it and the padlock turned green.   We learn something every day.

By the way, I've managed to change two of my sites to https so far,

https://thegardenmachineryforum.co.uk
https://guitaristguild.com

Had images linked from all over the place in various blocks, so took a while to run around adding s to all the urls lol.. 

[Ken]

shawnb61 posted this as a step by step how to on SMF. 

https://www.simplemachines.org/community/index.php?topic=555034.0

[Skhilled (OP)]

Nice! I planned on making a tutorial myself but have been busy with the vps.

[Skhilled (OP)]

I've just found another way to do this via a mySQL query courtesy of SMFHelper.com. This will change all instances of any posts from HTTP to HTTPS:

https://www.smfhelper.com/index.php?topic=74.0

Code: [Select]

UPDATE smf_messages SET body = REPLACE(body, 'http://yourstite.tld/index.php', 'https://yourstite.tld/index.php');

[Ken]

I've just found another way to do this via a mySQL query courtesy of SMFHelper.com. This will change all instances of any posts from HTTP to HTTPS:

https://www.smfhelper.com/index.php?topic=74.0

Code: [Select]

UPDATE smf_messages SET body = REPLACE(body, 'http://yourstite.tld/index.php', 'https://yourstite.tld/index.php');

Good find Steve. 
Do we need this? We already have that taken care of, yes?  8)

[Skhilled (OP)]

No, remember we manually (did the long way...each one) went through it when we changed the site to https.

[Ken]

Good deal, I thought so but wanted to be sure. 

[Skhilled (OP)]

I was looking for a way like this back then but didn't know how.

[Ken]

Research leads to knowledge, good on you for staying with the task. 

[Skhilled (OP)]

Was luck that someone else posted it and I saw it. LOL

[Ken]

It all counts, you knew a good solution when you saw it.