View Single Post
  #18  
Old 20 Jul 2019, 16:39
TJF TJF is offline
 
Join Date: Dec 2001
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.
Reply With Quote