asked on

how to remove SSL designation

Ok, i don't really understand how SSL works, so apologies.

I have a website i ported to another hosting environment. It was an SSL site, which i needed because i had online transactions with Stripe.

I don't need the online transactions for the moment. I will later probably.

When i ported the WordPress site over, it works on all pages except the home page, which throws an SSL error, not secure.

It doesn't happen on all browsers, but I don't want anybody getting this.

What do I need to do to make it so this doesn't happen? I want to remove the error and wait until later to get the SSL set up again.

The site is at http://nyackboatcharter.com.

Thanks.

Prasadh Baapaat

1) go to your Cpanel > phpmyadmin and open the database for your WordPress site.
2) open the _options table
3) Find / search for your URL in first 2 rows (siteurl & home) and check if it is "https://nyackboatcharter.com/"

if it is with a "https://" then replace both by "http://"

means REMOVE the s and save.

Doug Foster

ASKER

i did that. i took the s out in both the siteurl and home...

That is all i thought would be needed...

Doug Foster

ASKER

and it seems to only be in Chrome where I get the error. and it works fine on my phone and on another computer in Chrome.

So I'm curious if this is happening anywhere else... but, the weird thing is when i go to "advanced" which allows me to click on a link to go to the home page, it forwards me to https://www.kingwebagency.com/.

That sounds bad.. but this only started when i ported the site and the new hosting site doesn't have ssl set up.

again, for now, i don't want it to be ssl, i don't need it to be since i'm not taking transactions at the moment..

Doug Foster

ASKER

also, i have iThemes security and did a malware check, and it comes up clean..

Domain clean by Google Safe Browsing: nyackboatcharter.com
Domain clean by Norton Safe Web: nyackboatcharter.com
Domain clean on Phish tank: nyackboatcharter.com
Domain clean on the Opera browser: nyackboatcharter.com
Domain clean by SiteAdvisor: nyackboatcharter.com
Domain clean by the Sucuri Malware Labs blacklist: nyackboatcharter.com
Domain clean on SpamHaus DBL: nyackboatcharter.com
Domain clean on Yandex (via Sophos): nyackboatcharter.com
Domain clean by ESET: nyackboatcharter.com

Prasadh Baapaat

one more thing you can do is download your database as a SQL file.

open it in Notepad++ and do a search for https://www.kingwebagency.com/

means at-least you come to know if its there in some entry...

if you find any link replace it with your link and IF YOU WANT then import/replace database.

WARNING:
please do above on your own risk, sometimes the WordPress site might not function properly when you change something and replace the database.

My experience quiet a few times was that I had to reinstall all plugins & feed some data again... so giving a prior warning.

Doug Foster

ASKER

Thanks Prasadh, i did a search on all the places in the DB where this may happen, in post content, options, etc. Nothing.

I think this has to do with the SSL certificate, and that is where my knowledge gets fuzzy (I'm a database guy).

I did leave a message for kingwebagency, to see what is up. i had the SSL set up on HostGator, but they don't seem to know anything about it...

Prasadh Baapaat

well I just hope it isn't a breach...

happy hunting :)

Doug Foster

ASKER

thanks.. and out of curiosity, are you seeing this issue or not? http://nyackboatcharter.com. I only have it on one computer with Chrome.

When i googled, there is a lot of conversation out there about this happening in Chrome...

Prasadh Baapaat

well I checked your link http://nyackboatcharter.com/ in Firefox, Chrome, Iridium & Microsoft Edge...

all working fine, no error message or anything for me.

Doug Foster

ASKER

Thanks. I appreciate your help. I'm not sure about awarding a solution, because we haven't found a solution, but thanks for the help..

Prasadh Baapaat

yes... we did not exactly find a solution here :)

ASKER CERTIFIED SOLUTION

Doug Foster

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Prasadh Baapaat

Thanks for the update.

Doug Foster

ASKER

Sorry for the delay, i took a few days off to find some snow to the north. Now I have to figure out what to do with this question. I'll try to cancel it..

Thanks again Prasadh...

Prasadh Baapaat

yes cancel the question. I second it.

Doug Foster

ASKER

this was what I found out what happened. I thought it was an SSL problem and it was actually a DNS issue.