• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

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

CTXMedia

Formerly CyclingTribe
#1
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]:
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
#2
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
#3
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
#5
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
#6
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
#7
The URLs are built from the internally stored information in 1.1.6, so it should resolve it automatically (when the sitemap is rebuilt).