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?