Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
0 registered members (), 92 guests, and 248 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Crasher
Crasher
Midlands, UK
Posts: 137
Joined: July 2005
Show All Member Profiles 
Top Posters(30 Days)
Gizmo 23
Ruben 15
isaac 10
Morgan 8
Alento 4
SteveS 3
Latest Photos
Test
Testing to drag photos
Comfortable Cats
Test
BSA photos
Previous Thread
Next Thread
Print Thread
Transition Your Forum From HTTP to HTTPS #260501
09/23/17 02:14 PM
09/23/17 02:14 PM
isaac  Offline OP
UBB.threads Developer
Joined: Apr 2004
Posts: 1,229
California
Make the transition of an existing UBB.threads forum from http to https.

Summary
1) Obtain a valid security certificate from your webhost or a reputable third-party seller. I've purchased many "PositiveSSL" certs from SSLs.com.
2) Install it using SHA-2 and make sure it is configured properly.
3) Update ALL your URLs in the Control Panel or manually in your config.ini file. This includes the Homepage URLs, Contact pages, Referer Check, any forum headers/footers, etc.
4) Run a SQL query on your posts, private messages, user avatars, profile comments tables to replace "http://www.YOURDOMAIN.COM" with "https://www.YOURDOMAIN.COM"
5) Set up HTTP to HTTPS 301 redirects in your .htaccess file to forward from http:// to https://
6) Update all external plugins to ensure they are HTTPS compliant (sharaholic, twitter, facebook, youtube, ubb custom-tags, and, if your website contains non-UBB.threads content, all those internal site links - trust me you won't find them all in a single pass)
7) Test your website.
BONUS: Update your URLs in google/bing webmaster tools. Update any ads placed on your website, such as Google Adsense. Update any website analytics code.


** MAKE A BACKUP BEFORE YOU BEGIN **


The SQL
** BE VERY CAREFUL OF "POST_DEFAULT_BODY" and "POST_BODY" USAGE - DO NOT INTERCHANGE THEM
• POST_DEFAULT_BODY - [BBcode] This is the original post. CONTENT REBUILDER > REBUILD POSTS takes this and converts it to POST_BODY [HTML]
• POST_BODY - [HTML] This is shown to the user. it is generated from POST_DEFAULT_BODY

To update your POSTS:
* ubbt_POSTS - POST_DEFAULT_BODY
Code
UPDATE ubbt_POSTS
SET POST_DEFAULT_BODY = replace(POST_DEFAULT_BODY, 'http://www.YOURDOMAIN.COM', 'https://www.YOURDOMAIN.COM');

* ubbt_POSTS - POST_BODY
Code
UPDATE ubbt_POSTS
SET POST_BODY = replace(POST_BODY, 'http://www.YOURDOMAIN.COM', 'https://www.YOURDOMAIN.COM');


To update your PRIVATE MESSAGES:
* ubbt_PRIVATE_MESSAGE_POSTS - POST_DEFAULT_BODY
Code
UPDATE ubbt_PRIVATE_MESSAGE_POSTS
SET POST_DEFAULT_BODY = replace(POST_DEFAULT_BODY, 'http://www.YOURDOMAIN.COM', 'https://www.YOURDOMAIN.COM');

* ubbt_PRIVATE_MESSAGE_POSTS - POST_BODY
Code
UPDATE ubbt_PRIVATE_MESSAGE_POSTS
SET POST_BODY = replace(POST_BODY, 'http://www.YOURDOMAIN.COM', 'https://www.YOURDOMAIN.COM');


To update your USER AVATARS and PROFILE COMMENTS:
* ubbt_USER_PROFILE - USER_AVATAR
Code
UPDATE ubbt_USER_PROFILE
SET USER_AVATAR = replace(USER_AVATAR, 'http://www.YOURDOMAIN.COM', 'https://www.YOURDOMAIN.COM');

* ubbt_PROFILE_COMMENTS - COMMENT_BODY
Code
UPDATE ubbt_PROFILE_COMMENTS
SET COMMENT_BODY = replace(COMMENT_BODY, 'http://www.YOURDOMAIN.COM', 'https://www.YOURDOMAIN.COM');


To update your USER SIGNATURES:
* ubbt_USER_PROFILE - USER_DEFAULT_SIGNATURE
Code
UPDATE ubbt_USER_PROFILE
SET USER_DEFAULT_SIGNATURE = replace(USER_DEFAULT_SIGNATURE, 'http://www.YOURDOMAIN.COM', 'https://www.YOURDOMAIN.COM');

* ubbt_USER_PROFILE - USER_SIGNATURE
Code
UPDATE ubbt_USER_PROFILE
SET USER_SIGNATURE= replace(USER_SIGNATURE, 'http://www.YOURDOMAIN.COM', 'https://www.YOURDOMAIN.COM');



HTTP to HTTPS 301 Redirects For Your .htaccess File
Code
RewriteEngine On
RewriteCond %{HTTPS} off
RewriteRule (.*) https://%{HTTP_HOST}%{REQUEST_URI} [R=301,L]




Notes and Further Reading
Full URLs (http:// and https://) vs relative URLs (//):
If you want to correctly FULLY go SSL, use the full protocol name of "http://www.YOURDOMAIN.COM" instead of just "//www.YOURDOMAIN.COM"
The reason to use just double slashes instead of the HTTPS protocol declaration, is if you intend to have your secure urls (https) distribute different content than your open urls (http), since both are seen as separate urls on search engines.

If you are switching to HTTPS, it is advised to fully replace all your http protocol references with https, and forward all calls from http to https. Do not allow the browser/end-user to choose http by leaving your protocol blank with an open "//" url.

If the asset you need is available on SSL, then always use the https:// asset:
http://stackoverflow.com/questions/4831741/can-i-change-all-my-http-links-to-just/27999789#27999789

Why omitting the protocol scheme might not be a good idea:
http://stackoverflow.com/questions/4831741/can-i-change-all-my-http-links-to-just/37654145#37654145

Sometimes IE7 and IE8 do not correctly handle "//" assets. They look at this as being a file transfer, and will attempt to download the page through a download window. Even though the "//" asset is a spec from 1996/1998
https://www.paulirish.com/2010/the-protocol-relative-url/

Google deprecates protocol relative URLs in place of full protocol URLs for the html5 spec:
https://github.com/h5bp/html5-boilerplate/pull/1694/commits/045a1676c4c8cf4bdd23374b5b049507101f5043

Additional discussions:
http://stackoverflow.com/questions/...h-in-a-script-src-http/37609402#37609402


Google SEO HTTPS Migration Checklist (for the ad and SEO focused)
Source: Search Engine Roundtable
• Update all your ad code to support HTTPS
• Ensure your analytics will work on the new HTTPS URLs
• Update your site search (if not using the inbuilt UBB.threads search methods) to support HTTPS and discover new URLs sooner
• Create and submit your new HTTPS XML sitemaps
• Review the Google site move article
• Verify the new HTTPS site with Google Webmaster Tools and track indexation, crawling, search queries, etc.


Final Steps
• Test your site using the Qualys Lab tool
• Followup by searching for, and reading additional articles on "http to https site moves," to know what to expect

and...

[Linked Image]

Attached Files HTTPS SEO Checklist.jpg
Last edited by isaac; 02/11/18 03:30 AM. Reason: added sql for user signatures

isaac @ id242.com // my forum @ CelicaHobby.com
a current developer of UBB.threads php forum software // 7.6.2 Released
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
Re: Transition Your Forum From HTTP to HTTPS [Re: isaac] #260502
09/23/17 02:18 PM
09/23/17 02:18 PM
Gizmo  Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,996
Portland, OR; USA
Be sure to backup your database before preforming any maintenance as preforming any direct maintenance to the system can leave you with a complete mess and a broken forum.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Need to Upgrade?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Transition Your Forum From HTTP to HTTPS [Re: isaac] #260533
10/02/17 04:20 AM
10/02/17 04:20 AM
M4TT  Offline
Journeyman
Joined: Mar 2015
Posts: 59
Canada, SK
Quote
6) Update all external plugins to ensure they are HTTPS compliant (sharaholic, twitter, facebook, youtube, ubb custom-tags, and, if your website contains non-UBB.threads content, all those internal site links - trust me you won't find them all in a single pass)


In layman's terms, how is this achieved? I just noticed I can't see embedded YouTube videos using the Insert Media Tag method... My SSL Report is Grade A.

Re: Transition Your Forum From HTTP to HTTPS [Re: isaac] #260534
10/02/17 03:03 PM
10/02/17 03:03 PM
Gizmo  Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,996
Portland, OR; USA
You'll have to use any 3rd party sites SSL server to provide secure content for your users; in v7.6.0 we included new UBBCodes that support SSL, simply import them (they're in the "install/custom_codes/tags.php" file in the install files you downloaded from this site) via the tag editor in the control panel (CP -> Tools & Information -> Content Rebuilder -> Custom Tag Editor Tab).


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Need to Upgrade?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Transition Your Forum From HTTP to HTTPS [Re: isaac] #260535
10/02/17 04:49 PM
10/02/17 04:49 PM
isaac  Offline OP
UBB.threads Developer
Joined: Apr 2004
Posts: 1,229
California
@M4TT, this is probably what you're looking for. As gizmo pointed out, all of the new codes have also been updated to support https. As usual, after youve updated, run the post/content rebuilder. If you have any third-party software or plugins on your website (not ubb.threads software), you'll need to update those for https per their own instructions.

The following is from the "Special Instructions" section of the v7.6.0 upgrade guide at
https://www.ubbcentral.com/forums/ubbthreads.php/topics/259082/7-6-0-changelog-discussion#Post259088

---

Updated Media Tags
  • Flash Video Embed
  • MySpace Video
  • Vimeo Video
  • Yahoo Video
  • YouTube Video

There are new Media Tags which support displaying videos on mobile devices. You will need to install these manually. After your forum has been upgraded, go to "Control Panel » Content Rebuilder" and select the "Custom Tag Editor" top tab. Next, choose "Import New Tags" from the bottom tab. And finally, browse to your local install/custom_codes/ directory from the "ubbthreads-XXX.zip" archive and select the "tags.php" file.

This will add new set of Media Tags to your existing set. The new items will be prefixed by "[new]". From this screen, you can also disable any tag which you dont want displayed on your forum. You should delete any of your old tags that were upgraded within the new set.


isaac @ id242.com // my forum @ CelicaHobby.com
a current developer of UBB.threads php forum software // 7.6.2 Released
Re: Transition Your Forum From HTTP to HTTPS [Re: isaac] #260536
10/02/17 08:38 PM
10/02/17 08:38 PM
M4TT  Offline
Journeyman
Joined: Mar 2015
Posts: 59
Canada, SK
Okay guys, I just added an s at the end of any http fields in the Content Rebuilder > Custom Tag Editor > Custom Tag List: YouTube Video and ran a rebuild on posts and it's working now!

SSL/HTTPS YouTube Embedded Fix

User Prompt Hint From Text Editor:
Code
YouTube ID; eg: xxxxxxxxxx (or https://www.youtube.com/watch?v=xxxxxxxxxx)



Resulting Markup:
Code
<object width="425" height="350">
 <param name="movie" value="https://www.youtube.com/v/\\2"></param>
 <param name="wmode" value="transparent"></param>
 <embed src="https://www.youtube.com/v/\\2"
  type="application/x-shockwave-flash" wmode="transparent"
  width="425" height="350">
 </embed>
</object>


Thanks for informing of the Custom Tag Editor, very useful!

Thank you smile

Re: Transition Your Forum From HTTP to HTTPS [Re: isaac] #260539
10/03/17 07:21 AM
10/03/17 07:21 AM
isaac  Offline OP
UBB.threads Developer
Joined: Apr 2004
Posts: 1,229
California
@M4TT, thats the old YouTube tag code from version 7.5.x. It is not mobile friendly and detects just 17 of the top 32 most common different YouTube URL variations. Follow the directions to upgrade to the 7.6.x Youtube REGEX strings, which can detect more than 32 of the most common YouTube variations. In addition, it will not break your forums for mobile users.


isaac @ id242.com // my forum @ CelicaHobby.com
a current developer of UBB.threads php forum software // 7.6.2 Released
Re: Transition Your Forum From HTTP to HTTPS [Re: isaac] #261152
02/17/18 11:34 PM
02/17/18 11:34 PM
S
sundance  Offline
member
Joined: Aug 2012
Posts: 115
I totally ran across this thread on accident. But BOY do I NEED it! I have a forum that's probably 20-25 years old and still running strong, and upgraded to SSL (https) last fall...and never did the database on the rest of the site (forum) because I didn't want to crash it. It's so HUGE. so I basically just did the homepage, and some other non-forum pages on the site, but I Really need to do the forum cause it's affecting SEO already having mixed content. Bless you! for writing/starting this thread, and everyone who has contributed to it. I'm a website developer (mostly wordpress) who picked up this client with this old site with this UBBThreads forum on it, and it's been a struggle for me ever since I picked it up, but he really hasn't run across anyone in the area even as knowledgeable as I am, which doesn't say much really.

I'm going to read through this, as I contemplate updating some db tables, gently, one at a time. But if anyone is super-experienced and wants to lend a hand, PLEASE don't hesitate to offer. (LOL)

Anyway, ...GOOD STUFF. :-)

Re: Transition Your Forum From HTTP to HTTPS [Re: isaac] #261153
02/18/18 05:54 AM
02/18/18 05:54 AM
driv  Offline

Joined: Jan 2004
Posts: 2,656
Hi Donna,
I too was nervous about the switch to https, but if you follow Isaac's guide, I'm sure you'll be ok.
It went much more smoothly than I'd anticipated.

Backup first! wink


Using version :: 7.6.2
Re: Transition Your Forum From HTTP to HTTPS [Re: isaac] #261154
02/18/18 12:48 PM
02/18/18 12:48 PM
S
sundance  Offline
member
Joined: Aug 2012
Posts: 115
Did I say I was scared? I guess I revealed that huh...?

Anyway, thanks for the encouragement. It really means a lot.

Last edited by sundance; 02/18/18 12:49 PM.
Re: Transition Your Forum From HTTP to HTTPS [Re: isaac] #261156
02/18/18 12:52 PM
02/18/18 12:52 PM
S
sundance  Offline
member
Joined: Aug 2012
Posts: 115
isaac, can I use this image on how to move... by any chance?

I love it. -Donna

Last edited by sundance; 02/18/18 12:52 PM.
Re: Transition Your Forum From HTTP to HTTPS [Re: isaac] #261157
02/18/18 03:11 PM
02/18/18 03:11 PM
Gizmo  Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,996
Portland, OR; USA
The how to move graphic is from Nimbus Hosting, we have no ownership over it.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Need to Upgrade?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Transition Your Forum From HTTP to HTTPS [Re: isaac] #261608
08/14/18 11:58 AM
08/14/18 11:58 AM
R
Ruben  Offline

Joined: Dec 2003
Posts: 5,948
Lutz,FL
what about urls in custom island code?


Blue Man Group


There is no such thing as stupid questions. Just stupid answers
Re: Transition Your Forum From HTTP to HTTPS [Re: isaac] #261609
08/14/18 12:02 PM
08/14/18 12:02 PM
Gizmo  Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,996
Portland, OR; USA
Everything, your essentially replacing one format for another.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Need to Upgrade?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Transition Your Forum From HTTP to HTTPS [Re: isaac] #261610
08/14/18 02:19 PM
08/14/18 02:19 PM
R
Ruben  Offline

Joined: Dec 2003
Posts: 5,948
Lutz,FL
Thanks.


Blue Man Group


There is no such thing as stupid questions. Just stupid answers

Shout Box
Today's Birthdays
No Birthdays
Recent Topics
Repliers can change thread title
by Baldeagle. 11/12/18 08:49 PM
Tabs In Header
by AstroCat. 11/11/18 08:33 AM
Mindraven
by SteveS. 11/09/18 07:12 PM
Censor List
by Larry Miller. 11/08/18 02:53 PM
The table 'ubbt_topic_views' is full
by Metamatic. 11/01/18 07:12 PM
Forum Statistics
Forums36
Topics35,165
Posts191,596
Members12,112
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.2