Without activating ssl i changed the base urls setting in magento

Hi I watched your Video in You tube and i did the changes you told me to but i didnt activated the ssl before that i went to my base urls setting and changed the setting to yes . now my site isnt working at all. can you help me please

Hi @Dhananjay_M_Naik and welcome.

That’s actually a really easy mistake to make - and an easy one to fix.

You will have to fix this by editing your database via phpMyAdmin. Open your Magento Database and go into the core_config_data table.

Once you have the table open, click the SQL tab at the top. The box will already have some text in there. Just delete the text and paste the below and press Go. The command will search for any rows relating to your Base URLs:

SELECT * FROM `core_config_data` WHERE `path` LIKE '%base_url%'

When the results load, simply edit your URLs where the Path is web/unsecure/base_url and web/secure/base_url.

Those changes should take immediate effect.

1 Like