How do I delete SSL (https) in database?

General General Questions
1

I have already to activate SSL in Administration Panel:



"Enable secure connection at checkout (SSL certificate is required to be installed on your server) "

"Enable secure connection in the administration panel (SSL certificate is required to be installed on your server) "

"Enable secure connection for authentication, profile and orders pages (SSL certificate is required to be installed on your server) "

and

“Keep HTTPS connection once a secure page is visited”



But,



I deleted my host’s SSL certificate, Now I can not log in my Administration panel.

How do I delete SSL (https) in database?

Which table or field need to change in database?

so I can log in my admin panel.

Help!! Help!!!

2

Do you have access to your database?



If so, check these tables



secure_admin

secure_auth

secure_checkout



change value from Y to N

3

[quote name=‘D-Litz’]Do you have access to your database?



If so, check these tables



secure_admin

secure_auth

secure_checkout



change value from Y to N[/QUOTE]



Thank you D-Litz, I check these in table: cscart_settings, The value of these fields are “N”, But I still do not log in Admin panel.

Please see Screenshots:



[ATTACH]2282[/ATTACH]

1.jpg

4

Try to delete ‘var/cache/’ and ‘var/compiled/’ directories.

5

[quote name=‘indy0077’]Try to delete ‘var/cache/’ and ‘var/compiled/’ directories.[/QUOTE]



Thanks Indy0077.



Great, Love you so much.:wink:

6 
SELECT * FROM csc_settings_objects WHERE object_id IN (55,56)


UPDATE csc_settings_objects SET value = ‘N’ WHERE csc_settings_objects.object_id = 55;

UPDATE csc_settings_objects SET value = ‘N’ WHERE csc_settings_objects.object_id = 56;