Skip to main content
2 of 2
added 137 characters in body
user5858
  • 111
  • 1
  • 3

Changing http to https in wp_options

I'm getting many warnings like:

 Mixed Content: The page at 'https://www.example.in/' was loaded over HTTPS, but requested an insecure image 'http://www.example.in/wp-content/uploads/2014/12/logo_250.png'. This content should also be served over HTTPS.

After following SSL breaks customizer: page isn't returned from ajax answer I could fix many warnings.

I've run these commands from mysql:

UPDATE wp_posts SET guid = replace(guid, 'http://www.example.com','https://www.example.com');
UPDATE wp_posts SET post_content = replace(post_content, 'http://www.example.com', 'https://www.example.com');
UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://www.example.com','https://www.example.com');

Now still many images are using http: prefix within the wp_options table in value column.

When I run this the site breaks down though I'm able to get green secured lock in the address bar of browser:

UPDATE wp_options SET option_value = replace(option_value, 'http://www.example.com','https://www.example.com');

Actually in the wp_options there is option_name qode_options_proya which is storing in JSON form. If we change from http to https in this JSON format it is causing some issues. How to resolve it?

user5858
  • 111
  • 1
  • 3