Hi there I have version 3.9 I enabled ssl setting after my webhosts said the ssl was set up, but instantly the site went offline and will not load. Is there a way to turn this setting back to off via sql query express? im not really technical and realise that sql query express is a cut down version but its all i have Thanks !!
host reports ssl has been correctly installed so maybe its something i did i checked enable ssl i added the hhtps version of the url in the field below this. any idea why the site now would not load?
1. Go to store table. Remove https url and put back http one in [Url] field. then run below query Update [dbname].[dbo].[Store] set SslEnabled = 0, SecureUrl = NULL
2. Then go to setting table. run below query
Update [dbname].[dbo].[Setting] set Value = 'False' where Name = 'securitysettings.forcesslforallpages'
Hello forefront Thanks for the very fast response and detail. can you tell me which programme i need to connect and i will download it? Im not a techie person but tend to muddle through ! Cheers !
Thanks. I will try and download. as a quick fix if i restore the d/b from a back up (before ssl was enabled) would that remove the ssl setting so i can get it back up quickly?
Thanks. I will try and download. as a quick fix if i restore the d/b from a back up (before ssl was enabled) would that remove the ssl setting so i can get it back up quickly?
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.