12

I visited the main page of SEDE and noticed that most of the images return a 404:

broken images

This looks like a similar problem as reported earlier in Missing images in SEDE but that covered the site-switch drop down which is working in this case.

I suppose this is related to the content move on the CDN earlier this week.

I repro-ed this in Chrome, FF and Edge, so it is not browser dependent. I'm in Western Europe, probably routing over the AMS-IX, in case CloudFlare is involved.

Notice that following apple-touch-icons.png do load, they are all for the meta sites of: Stats , Academia , Islam , Japanse , Pets , Quantative Finance , Productivity , Lego , Portugese , Elementary-OS

Can either the paths on SEDE be fixed or the images on the CDN be restored?

Inspired on this migration I would start with this sql query on the SEDE database to stay inline with the intent:

UPDATE dbo.[Sites]
 SET BadgeIconUrl = ''//cdn.sstatic.net/Sites/'' 
                 + (CASE WHEN CHARINDEX(''meta.'', TinyName) = 1 
                         THEN SUBSTRING(TinyName, 6, LEN(TinyName) - 5) + ''meta'' 
                         ELSE TinyName END) + ''/img/apple-touch-icon.png''
WHERE Id IN( 
  SELECT Id
    FROM dbo.[Sites]
   WHERE CHARINDEX(''stackexchange.com'', Url) != 0
      OR CHARINDEX(''stackoverflow.com'', Url) != 0
      OR CHARINDEX(''serverfault.com'', Url) != 0
      OR CHARINDEX(''superuser.com'', Url) != 0
      OR CHARINDEX(''stackapps.com'', Url) != 0
      OR CHARINDEX(''askubuntu.com'', Url) != 0
      OR CHARINDEX(''mathoverflow.net'', Url) != 0
)
2
  • 1
    I can only partially reproduce this - I get some of the images (the top 4 of SO, Math, SU, AU load) and some don't.
    – ArtOfCode
    Commented Apr 2, 2016 at 17:45
  • 1
    Looks like they still move cheese around, and SEDE is left behind. Commented Apr 2, 2016 at 17:50

1 Answer 1

4

Looks like we didn't update the import properly, so it kept updating to the wrong images.

We put in an immediate fix for the images and will fix the import at a later time (likely today).

4
  • Just so I understand: you fix this in your private import scripts, not in the public github repro of the DataExplorer, right?
    – rene
    Commented Apr 4, 2016 at 13:09
  • @rene - the image URLs are in the DB, not in code.
    – Oded
    Commented Apr 4, 2016 at 13:14
  • That is true but I did point out this migration that is the initial creation and seed of that field. I'm only trying to prevent the situation where you re-run all migrations later on for what ever reason to find that stuff is broken again .... been there, done that ;)
    – rene
    Commented Apr 4, 2016 at 13:17
  • The migration was already run - it won't run again (given that the column... exists).
    – Oded
    Commented Apr 4, 2016 at 13:43

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .