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

CTXMedia

Formerly CyclingTribe
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]:
Rich (BB code):
... 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 :D
 

CTXMedia

Formerly CyclingTribe
Sorted. (y) Used an SQL replace query:
Code:
UPDATE xengallery_album SET media_cache = replace(media_cache, 'img.cyclechat.co.uk', 'www.cyclechat.net');
 

Mike

XenForo developer
Staff member
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.
 

CTXMedia

Formerly CyclingTribe
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 :eek:
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 !:eek:

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

Formerly CyclingTribe
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

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