A site URL changed and now its icon in SEDE is broken

Question

This has happened before, and it's happened again, all because Cognitive Sciences recently was renamed Psychology & Neuroscience, with a change to the URL.

The first thing that needs to be fixed is the name should be changed, as it uses has the old name.

The second problem, due to the URL changing from cogsci.stackexchange.com to psychology.stackexchange.com is that the icons are broken.

These are the right URLs:

https://cdn.sstatic.net/Sites/psychology/img/apple-touch-icon.png

https://cdn.sstatic.net/Sites/psychologymeta/img/apple-touch-icon.png

---

These problems affect both the Psychology & Neuroscience main and meta site listings. And it's not just one page either: the problems are seen in the dropdown, on the main list, and on the compose query page.

It's currently also affecting Writers Writing, which has been renamed more than a year ago.

Answer 1

The issues will be quick hacked (fixed if you wish) running the following SQL update statement on the Data.StackExchange database by someone with full database access.

That sites table does get/should be populated now and then (on changes) from a different source so maybe it is wiser to fix that instead.

I have tested below script here

Use [Data.StackExchange]

-- writing
update Sites 
set BadgeIconUrl = 'https://cdn.sstatic.net/Sites/writing/img/apple-touch-icon.png'
  , ImageUrl = 'https://cdn.sstatic.net/Sites/writing/img/logo.png'
  , IconUrl = 'https://cdn.sstatic.net/Sites/writing/img/icon-16.png'
  , Longname = 'Writing'
where Id = 84 

-- writing Meta
update Sites 
set BadgeIconUrl = 'https://cdn.sstatic.net/Sites/writingmeta/img/apple-touch-icon.png'
  , ImageUrl = 'https://cdn.sstatic.net/Sites/writingmeta/img/logo.png'
  , IconUrl = 'https://cdn.sstatic.net/Sites/writingmeta/img/icon-16.png'
  , Longname = 'Writing Meta'
where Id = 85


-- CosSci
update Sites 
set BadgeIconUrl = 'https://cdn.sstatic.net/Sites/psychology/img/apple-touch-icon.png'
  , ImageUrl = 'https://cdn.sstatic.net/Sites/psychology/img/logo.png'
  , IconUrl = 'https://cdn.sstatic.net/Sites/psychology/img/icon-16.png'
  , Longname = 'Psychology & Neuroscience'
where Id = 146 

-- CogSci Meta
update Sites 
set BadgeIconUrl = 'https://cdn.sstatic.net/Sites/psychologymeta/img/apple-touch-icon.png'
  , ImageUrl = 'https://cdn.sstatic.net/Sites/psychologymeta/img/logo.png'
  , IconUrl = 'https://cdn.sstatic.net/Sites/psychologymeta/img/icon-16.png'
  , Longname = 'Psychology & Neuroscience Meta'
where Id = 147

For reference here is what the icons will look like:

Writing

BadgeIconUrl

ImageUrl

IconUrl

writing Meta

BadgeIconUrl

ImageUrl

IconUrl

CogSci

BadgeIconUrl

ImageUrl

IconUrl

CogSci Meta

BadgeIconUrl

ImageUrl

IconUrl