Mixed (non-HTTPS) content warnings due to smileys in old comments

[oskarlh]

The smileys in old comments and posts are rendered as
<img class="smiley" src="http://192.241.182.11/images/smilies/smile.png" alt=":)">
Examples: https://twhl.info/news/view/348 https://twhl.info/thread/view/19089 https://twhl.info/journal/view/8895
The http:// part causes browsers to warn about insecure content. Not sure what happens if you want to change the server's IP address. New comments don't have this issue

[LogicAndTrick]

I wonder how that IP address got in there in the first place? That's bizarre...

[oskarlh]

It seems this is causing a bigger issue in Chrome, that the browser refuses to load the images.

[oskarlh]

I suppose something like this should fix it, but with different tables and fields:
UPDATE comments SET content_html=REPLACE(content_html, 'http://192.241.182.11/', 'https://twhl.info/')