SSL deactivation

[slowbroo]

Hello! I have accidentally activated ssl on my shop. Now I can't get into my backoffice to turn it off. Anyone know a way to solve this? I would rather not like to reinstall my shop.
Thanks in advance!

[bonbontamura]

did you find the solution?
I also have the same problem. i thought the ssl certificate is already installed

[AlexSZD]

Hey, the solution is very straightforward, if you can access to the database. Just execute this query:
update ps_configuration set value=0 where name='PS_SSL_ENABLED';

And you'll be able to enter to the admin panel (clear cache first or use another browser)

[RJ Blæk & Toner]

hi

Tried ur solution but get this in phpadmin


Error

SQL query:

UPDATE ps_configuration SET value =0 WHERE name = ‘PS_SSL_ENABLED’

MySQL said:
#1054 - Unknown column '‘PS_SSL_ENABLED’' in 'where clause'
and still cant login???
Rene Johnsen

[AlexSZD]

I cannot try that, but it seems that the query has some syntax errors. I bet that tildes are not correct. Please, re-type the query, don't paste from the browser

hi

Tried ur solution but get this in phpadmin


Error

SQL query:

UPDATE ps_configuration SET value =0 WHERE name = ‘PS_SSL_ENABLED’

MySQL said:
#1054 - Unknown column '‘PS_SSL_ENABLED’' in 'where clause'
and still cant login???
Rene Johnsen

[stevell]

Change the ' to " and it will work.

 

UPDATE ps_configuration SET value =0 WHERE name = "PS_SSL_ENABLED"