URL Redirect

[MrPeppah]

So I have a ticket open but figured I'd give it a go here, yes I checked the troubleshooting documentation.

I changed my domain and site URL from http to https. Once I made the change I am stuck in a URL redirection loop. When I tried to go into the database and modify the table back it gives me the following error:

Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available.

 

Any suggestions or help?

[WHMCS ChrisD]

Hey @MrPeppah

Thanks for your post, i'd recommend using the following SQL command replacing the domain with your WHMCS URL then, set your SSL URL via Setup > General Settings

UPDATE `tblconfiguration` SET value ='http://www.yourdomain.com/whmcs/' WHERE setting='SystemURL';
UPDATE `tblconfiguration` SET value = '' WHERE setting = 'SystemSSLURL';
UPDATE `tblconfiguration` SET value = '' WHERE setting = 'AdminForceSSL';

 

[MrPeppah]

Hello Chris,

I actually found this after posting this and the first SQL query fixed it, but the bottom two are irrelevant for the new version as it's supposed to be automatic and not have SSL options. But with that said the "auto" feature doesn't work for me and waiting on a support ticket.

[WHMCS ChrisD]

Hey @MrPeppah ,

You need to manually set the path to https:// in your general settings, if this is looping it could be an issue with your .htaccess file try renaming it as oldhtaccess if that doesnt help, you may need to reinstall your SSL Cert