MG 1.1 media_cache field contains old URLs - how to edit/change them?

[CTXMedia]

I previously served images through a secondary .co.uk domain (to speed up page loading) but stopped doing this a week ago when I repointed the primary domain at Cloudflare.

I've just discovered that my sitemap.xml still contains reference to the old ".co.uk" domains, specifically in the media_cache blob field in the xengallery_album table [snippet]:

... s:32:"56c36bde1a4e3c5f9da9192bb94f4dd7";s:12:"thumbnailUrl";s:88:"http://img.cyclechat.co.uk/data/xengallery/69/69997-56c36bde1a4e3c5f9da9192bb94f4dd7.jpg";}i:7648;a:10: ...

Is there any way I can update these (without manually re-saving every album)?

Thanks,
Shaun

 

[CTXMedia]

Sorted. Used an SQL replace query:

UPDATE xengallery_album SET media_cache = replace(media_cache, 'img.cyclechat.co.uk', 'www.cyclechat.net');

 

[Mike]

Eek, don't run that query! That will break the field. You're changing the lengths of things so there are knock on effects in that.

 

[Mike]

To follow up though, are you running the latest version of XFMG? I believe this was changed here: https://xenforo.com/community/threads/xenforo-media-gallery-1-1-6-a-released.114610/ (3rd point.)

 

[CTXMedia]

Eek, don't run that query! That will break the field. You're changing the lengths of things so there are knock on effects in that.

So it does ... http://www.cyclechat.net/media/albums?page=2

To follow up though, are you running the latest version of XFMG? I believe this was changed here: https://xenforo.com/community/threads/xenforo-media-gallery-1-1-6-a-released.114610/ (3rd point.)

Erm ... nope - v1.1.5 !

Would simply upgrading to 1.1.6 negate the query/change/need for the cached URL? (I can do this tonight to resolve it if that is the case ).

 

[CTXMedia]

Okay, I've reversed the query and the album covers are all back ... and I'll upgrade XFMG tonight.

Will upgrading remove the album thumbnail URLs from sitemap.xml?

 

[Mike]

The URLs are built from the internally stored information in 1.1.6, so it should resolve it automatically (when the sitemap is rebuilt).

 

[CTXMedia]

The URLs are built from the internally stored information in 1.1.6, so it should resolve it automatically (when the sitemap is rebuilt).

Excellent - thanks Mike.