how to change image source to protocol relative

  • Resolved ropezg

    (@ropezg)


    7 years, 10 months ago

    Hello!

    when moving to SSL pages with tablepress tables throw mixed content errors because images saved in tablepress tables are fetched via ‘http’.
    I know that tables are stored in wp_posts but my mysql knowledge is pretty weak so I’m not sure which SQL statement should I use to update all media to protocol relevant version.
    Could you suggest an update which would solve this? I’m pretty sure this would be useful to anyone who is migrating to SSL. I googled but couldn’t find a similar topic
    thanks a lot!

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    thanks for your question, and sorry for the trouble.

    To be honest, I don’t recommend switching to protocol-relative, but instead directly to https://.
    If you don’t want to use a mySQL command (finding one via Google should be easy), you could use a search/replace plugin for WordPress, here you then will just have to pay extra attention to the used search term and replace term: As tables are stored as JSON code, characters like / and " need to be escaped with an extra \. So, in a search/replace plugin, you would search for
    http:\/\/
    and replace it with
    https:\/\/

    Regards,
    Tobias

    Thread Starter ropezg

    (@ropezg)

    ok, will try with that
    thanks for the help!

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    no problem, you are very welcome! ?? Good to hear that this helped!

    Best wishes,
    Tobias

    P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘how to change image source to protocol relative’ is closed to new replies.