We recently switched our forums to SSL. It was a bit of an ordeal because I don't think our host fully knew what they were doing. I think one tech was able do what we wanted by changing all the http links to https, but then another tech did another restore from a backup and wiped out the changes.
I want to change all references of
http://www.mysite.com to
https://www.mysite.com within on entire vBulletin database.
I know this is the SQL query to change it just in the posts.
UPDATE post SET pagetext = REPLACE(pagetext, 'http://www.mysite.com', 'https://www.mysite.com');
What query would I run to search and replace the entire database? I will, of course, make a backup before running it and check to see the links have been successfully converted.
No members have liked this post.