XF 1.5 Switched to SSL: smilies causing problems, no joy rebuilding caches

[karll]

I've switched my forum over to use SSL, and this has worked OK for the most part so far, as far as I can tell. However, some of my smilies had the image URL as http rather than https. In fact, there were quite a lot of these (~ 100). (Animated GIFs, so therefore not sprites. (Can animated GIFs be sprites? Probably not ...))

Anyway, so I decided to update these links with a MariaDB regexp_replace rather than manually updating every one of these smilies. In retrospect, I'm not sure whether that may have caused the issue I'm now seeing: Threads are still using http for the img src of the smilies! I've tried rebuilding some of the caches, but no luck so far. I didn't really see a cache that seemed to apply to smilies? I thought maybe it was the Thread Information one, but no joy.

When I run Rebuild Attachments Thumbnails, I get:

ErrorException: Fatal Error: Maximum execution time of 120 seconds exceeded - library/XenForo/Image/ImageMagick/Pecl.php:310

Any ideas for how to solve this?

 

[karll]

Hmm, it seems I wasn't the first person to do this:
https://xenforo.com/community/threads/smilies-and-changing-their-path-ssl-and-mixed-content.120835/

So I really have to manually update my ~100 image URLs?

 

[MattW]

When I did this (updated directly in the db), I just had the edit and save 1 of them in the ACP, and all the rest were updated.

 

[karll]

When I did this (updated directly in the db), I just had the edit and save 1 of them in the ACP, and all the rest were updated.

YES! Thank you, that worked!