Profile pages are broken

  • Thom A

    SSC Guru

    Points: 98029

    Mentioned in the large topic in not about SQL forum by other users, but thought should be psoted here. The profile links are no longer working. This is for when you click a user's name (Eirikur Eiriksson), or click the link in the top right to view/edit your own (Profile).

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.

  • Jeff Moden

    SSC Guru

    Points: 993661

    I confirm that.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

    Helpful Links:
    How to post code problems

  • Lynn Pettis

    SSC Guru

    Points: 442094

    Wasn't broken earlier today.  That is how I found that site emails (PM messages) are missing.

     

  • Jeff Moden

    SSC Guru

    Points: 993661

    I agree... it wasn't broken earlier today.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

    Helpful Links:
    How to post code problems

  • Thom A

    SSC Guru

    Points: 98029

    Jeff Moden wrote:

    I agree... it wasn't broken earlier today.

    Was working all day yesterday, as you need that page to upload your avatar again. Wonder if a "fix" and made a breaking change to something else (Profiles). I'd hazard a guess the links to old articles. 🙂

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.

  • Jeff Moden

    SSC Guru

    Points: 993661

    Thom A wrote:

    Jeff Moden wrote:

    I agree... it wasn't broken earlier today.

    Was working all day yesterday, as you need that page to upload your avatar again. Wonder if a "fix" and made a breaking change to something else (Profiles). I'd hazard a guess the links to old articles. 🙂

    Except they lost my avatar file and so did I. 🙁

     

    Anyway, it appears that the Profile pages are working again and the PM messages are available, as well.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

    Helpful Links:
    How to post code problems

  • Thom A

    SSC Guru

    Points: 98029

    Jeff Moden wrote:

    Thom A wrote:

    Jeff Moden wrote:

    I agree... it wasn't broken earlier today.

    Was working all day yesterday, as you need that page to upload your avatar again. Wonder if a "fix" and made a breaking change to something else (Profiles). I'd hazard a guess the links to old articles. 🙂

    Except they lost my avatar file and so did I. 🙁   Anyway, it appears that the Profile pages are working again and the PM messages are available, as well.

    Courtesy of waybackwhen machine:

    Now save it somewhere safe. 🙂

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.

  • Solomon Rutzky

    SSCoach

    Points: 15887

    > Now save it somewhere safe.  🙂

     

    Just to "poke the bear" a little bit (cuz why not), isn't this situation a point in favor for, at least sometimes, storing images in the DB? So that they get backed up with the DB backup, which one typically has at least one, if not several, days / weeks worth of? 😉

    SQL#https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
    Sql Quantum Lifthttps://SqlQuantumLift.com/ ( company )
    Sql Quantum Leaphttps://SqlQuantumLeap.com/ ( blog )
    Info sites — Collations     •     Module Signing     •     SQLCLR

  • Solomon Rutzky

    SSCoach

    Points: 15887

    Also, for some reason I did not need to re-upload my avatar. It was just magically there. I wonder what the difference is.....not terribly important, just curious is all..

     

    SQL#https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
    Sql Quantum Lifthttps://SqlQuantumLift.com/ ( company )
    Sql Quantum Leaphttps://SqlQuantumLeap.com/ ( blog )
    Info sites — Collations     •     Module Signing     •     SQLCLR

  • Jeff Moden

    SSC Guru

    Points: 993661

    Solomon Rutzky wrote:

    > Now save it somewhere safe.  🙂   Just to "poke the bear" a little bit (cuz why not), isn't this situation a point in favor for, at least sometimes, storing images in the DB? So that they get backed up with the DB backup, which one typically has at least one, if not several, days / weeks worth of? 😉

     

    Heh... I thought it was safe. 😉  Hopefully, I have it on my old 32 bit machine, which I've not fired up in years.

     

    The different between your avatar and mine is that mine was an animated GIF.

     

    Anyway, I agree.  There's nothing wrong with storing images, sound files, documents, etc, etc, in a database.  No one will make sure the files are safe like a DBA will.  You just need to be careful how you store the big stuff so that you don't need to backup large binaries that will never change again.  For example, I have almost a decade of call recordings that we're required to keep "online" forever.  They're in a partitioned table where there's one filegroup per month and one NDF file per file group, which have been set to Read Only, live in a different database, and never need to be backed up again.  My only regret is that I should have used a Partitioned View instead of a Partitioned Table so that I could easily use parts of that large table in for smaller test systems.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

    Helpful Links:
    How to post code problems

  • Thom A

    SSC Guru

    Points: 98029

    Looks like it's the editor that "flattens" the image, rather than the upload. I managed to get the animated gif uploaded, but as soon as I select it for use it stopped being animated. ??

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.

  • Solomon Rutzky

    SSCoach

    Points: 15887

    Thom A wrote:

    Looks like it's the editor that "flattens" the image, rather than the upload. I managed to get the animated gif uploaded, but as soon as I select it for use it stopped being animated. ??

     

    Looking at the actual image that is being used here, it is a PNG, which I do believe also supports animations, but is not specifically a GIF, if you were being literal about the type of file you uploaded. And if you did upload a GIF, then I suspect that this system is probably converting all types into a standard format when used as an avatar. Your avatar is:

    https://www.sqlservercentral.com/wp-content/uploads/2019/04/avatar1555597354.png

     

    Jeff's avatar is the same style, just a different number in the filename. On the other hand, my avatar and Steve's are both coming from gravatar.com. Here is mine:

     

    https://secure.gravatar.com/avatar/2097b0c1220de11c10afed989bdfd9f6?s=96&d=mm&r=g

     

    So, perhaps you can try uploading your animated gif to gravatar.com and then referencing that here. Maybe that would work as it wouldn't be something that this system is converting to a standard format, and in the process losing the animation (whether intentional or a poorly done conversion)?

     

    Take care, Solomon..

     

    SQL#https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
    Sql Quantum Lifthttps://SqlQuantumLift.com/ ( company )
    Sql Quantum Leaphttps://SqlQuantumLeap.com/ ( blog )
    Info sites — Collations     •     Module Signing     •     SQLCLR

Viewing 12 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply