April 2, 2019 at 6:53 pm
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.
Larnu.uk
April 2, 2019 at 6:57 pm
I confirm that.
--Jeff Moden
Change is inevitable... Change for the better is not.
April 2, 2019 at 7:04 pm
Wasn't broken earlier today. That is how I found that site emails (PM messages) are missing.
April 2, 2019 at 7:06 pm
I agree... it wasn't broken earlier today.
--Jeff Moden
Change is inevitable... Change for the better is not.
April 2, 2019 at 7:30 pm
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.
Larnu.uk
April 2, 2019 at 8:29 pm
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
Change is inevitable... Change for the better is not.
April 2, 2019 at 8:38 pm
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.
Larnu.uk
April 2, 2019 at 8:50 pm
> 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 Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR
April 2, 2019 at 8:52 pm
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 Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR
April 2, 2019 at 9:40 pm
> 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
Change is inevitable... Change for the better is not.
April 18, 2019 at 2:24 pm
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.
Larnu.uk
April 18, 2019 at 3:20 pm
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 Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply