The Official Status Thread
-
@Tsaukpaetra said in The Official Status Thread:
@error said in The Official Status Thread:
@Tsaukpaetra said in The Official Status Thread:
Status: Oops. Ran a query that effectively
UPDATE
d the entire table to have a column set to null, because I was dumb and forgot to join the affected table to the query. Hehe.Always start with ROLLBACK TRAN at the end of your query.
'twas a stored proc being run by the game server. There was no error, so no automatic rollback.
It's whatever, that's why we have a dev database after all. Restore from backup took moments after Azure got off its ass to talk to me.
I meant running an untested sproc/query for the first time. The ROLLBACK stays there until you've observed the effects of the query.
-
@Vixen said in The Official Status Thread:
@Tsaukpaetra said in The Official Status Thread:
@Vixen said in The Official Status Thread:
@error said in The Official Status Thread:
@Vixen said in The Official Status Thread:
@error said in The Official Status Thread:
@Tsaukpaetra said in The Official Status Thread:
Status: Oops. Ran a query that effectively
UPDATE
d the entire table to have a column set to null, because I was dumb and forgot to join the affected table to the query. Hehe.Always start with ROLLBACK TRAN at the end of your query.
uhh..... missing a step there?
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.
I was being because mobile.
i'm on mobile too, and i had no problem with my warthog kneeling.
if your warthog is kneeling you really should have words with your UNSC mechanic.....
I dunno, it looks more like a puma...
blame GIS if it's the wrong image.
Gears of War ain't my favorite franchise so i'm not exactly up on the exploits of Commander Shepard and the vehicles she uses to beat the horde into submission on Azeroth.
Oh damn, you haven't seen The Popular Web-Series: Red Vs. Blue yet? I'm sorry...
-
@error said in The Official Status Thread:
@Tsaukpaetra said in The Official Status Thread:
@error said in The Official Status Thread:
@Tsaukpaetra said in The Official Status Thread:
Status: Oops. Ran a query that effectively
UPDATE
d the entire table to have a column set to null, because I was dumb and forgot to join the affected table to the query. Hehe.Always start with ROLLBACK TRAN at the end of your query.
'twas a stored proc being run by the game server. There was no error, so no automatic rollback.
It's whatever, that's why we have a dev database after all. Restore from backup took moments after Azure got off its ass to talk to me.
I meant running an untested sproc/query for the first time. The ROLLBACK stays there until you've observed the effects of the query.
Meh. I was modifying the query that was working to more accurately reflect the results it was returning with the actual modifications it was performing (Yes, on me. I'll go back and fix it on the original version too at some point) and wasn't paying attention.
Since the results were as expected, nothing appeared amiss until I scanned the rest of the table instead of the target rows....
-
Status:
-
@Tsaukpaetra said in The Official Status Thread:
@Vixen said in The Official Status Thread:
@Tsaukpaetra said in The Official Status Thread:
@Vixen said in The Official Status Thread:
@error said in The Official Status Thread:
@Vixen said in The Official Status Thread:
@error said in The Official Status Thread:
@Tsaukpaetra said in The Official Status Thread:
Status: Oops. Ran a query that effectively
UPDATE
d the entire table to have a column set to null, because I was dumb and forgot to join the affected table to the query. Hehe.Always start with ROLLBACK TRAN at the end of your query.
uhh..... missing a step there?
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.
I was being because mobile.
i'm on mobile too, and i had no problem with my warthog kneeling.
if your warthog is kneeling you really should have words with your UNSC mechanic.....
I dunno, it looks more like a puma...
blame GIS if it's the wrong image.
Gears of War ain't my favorite franchise so i'm not exactly up on the exploits of Commander Shepard and the vehicles she uses to beat the horde into submission on Azeroth.
Oh damn, you haven't seen The Popular Web-Series: Red Vs. Blue yet? I'm sorry...
red versus blue makes purple.
-
@Tsaukpaetra said in The Official Status Thread:
nothing appeared amiss
Ah. Now something is amiss, because since I only restored the one table, the in-flight table self-healed it, and produced this oddity:
Magic. Not sure how Slot 7 turned into slot 89, but that's easily fixed...
-
Status: just got invited to a lifestyle party this weekend
-
@error said in The Official Status Thread:
Status: just got invited to a lifestyle party this weekend
It's a costume party!
-
Status: I have today met a British person who had legitimately never heard of the American Revolution before, nor even knew that we were British colonies in the first place.
-
@pie_flavor History is for chumps! How else can we fulfil the prophecy about repeating it?
-
@Vixen said in The Official Status Thread:
Commander Shepard and the vehicles she uses
Yes yes. That is very exactly correct.
Filed under: Feminism thread is ...
-
@error said in The Official Status Thread:
it sure cuts me a lot.
please keep that sort of thing in your own thread
-
@error said in The Official Status Thread:
ROLLBACK TRAN
how can this stand in 2019? Can't we change these names? To ROLLBACK CIS or something
-
@Vixen said in The Official Status Thread:
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.
not again ...
-
@Luhmann said in The Official Status Thread:
@error said in The Official Status Thread:
ROLLBACK TRAN
how can this stand in 2019? Can't we change these names? To ROLLBACK CIS or something
TRANSACTIONFLUID.
-
THIS MAKES SENSE
-
@Luhmann said in The Official Status Thread:
THIS MAKES SENSE
Totally! You may have more than one trans in your query after all!
-
@Tsaukpaetra
Trouble starts with nested trans
-
status drove behind a car with a number plate 'FIZ'
Conclusion: spend the rest of the journey looking for someone with a 'BUZ' plate
-
Status: dammit, what is it with OSTs not having all the music?
https://www.youtube.com/watch?v=AuEKUtxhP08I'll have to look into extracting these from the files or downloading them from youtube or elsewhere. strongly implies the latter...
fake edit: found a gamerip with 600 tracks. It's mostly to be friendly to transitions etc., but... crap.
-
Status: moderately productive tonight.
-
-
-
@loopback0 said in The Official Status Thread:
@Luhmann said in The Official Status Thread:
@error said in The Official Status Thread:
ROLLBACK TRAN
how can this stand in 2019? Can't we change these names? To ROLLBACK CIS or something
TRANSACTIONFLUID.
..... is this some sort o...
wai....
oh. i see....
yep. i see very much.
/me takes a long sip of tea with half closed eyelids
OUCH! HOT!
-
@Tsaukpaetra said in The Official Status Thread:
@topspin said in The Official Status Thread:
Nearly fifteen milliliters!
Oh boy, I’m not particularly picky, but that sounds sad.
-
Status
-
Status: Sick at home with a cold. Also pretty bored because of this. The night entailed fever dreams filled with Excel. Lamest. Nightmare. Ever!
At least I hope when I go to work next week I can get back to working on things that arenotless retarded.
-
@topspin said in The Official Status Thread:
Lamest. Nightmare. Ever!
i dunno..... i've debugged a VLOOKUP nested in an HLOOKUP nested in a VLOOKUP that populated a table from cells in fourteen different sheets across five different files.......
that would be a pretty bad nightmare if it had happened while I was asleep.
-
@topspin said in The Official Status Thread:
The night entailed fever dreams filled with Excel. Lamest. Nightmare. Ever!
I dunno. Excel looks pretty good, I could totally have some dreams about her... Mm, redheads~
-
@Atazhaia said in The Official Status Thread:
@topspin said in The Official Status Thread:
The night entailed fever dreams filled with Excel. Lamest. Nightmare. Ever!
I dunno. Excel looks pretty good, I could totally have some dreams about her... Mm, redheads~
CUTE! but who's that human under her?
-
-
@topspin said in The Official Status Thread:
@Atazhaia said in The Official Status Thread:
Mm, redheads
Yes, please.
her
Oh. You go ahead.
you prefer the more masculine aesthetic? I can see you are a sapient of good taste!
-
@Vixen Well, I suppose I could have him at the same time as Excel. Double redhead fun~ With me in the middle, obviously.
-
@PleegWat said in The Official Status Thread:
The problem is that doing the research beforehand works out to be more expensive than paying the fines if things go wrong.
The documentation of what's in the ground is often best filed under Fiction.
-
Status: Apparently there will be a fire drill in my (work) building today. The notice reads:
Please note that the bells will sound, and you MUST EVACUATE the building in an orderly calm fashion without any drinks using the stairs.
(emphasis theirs)
I've seen some fire drills over the years of working here, and I don't recall seeing anyone drinking, but I guess it's a big problem.
-
@hungrier Drinks are using your stairs independently of humans?
-
@dkf How else would they get out? The elevators are shut down during a fire alarm/drill
-
@dkf said in The Official Status Thread:
@PleegWat said in The Official Status Thread:
The problem is that doing the research beforehand works out to be more expensive than paying the fines if things go wrong.
The documentation of what's in the ground is often best filed under Fiction.
If it's not on a symbolic empty shelf.
-
@hungrier said in The Official Status Thread:
Status: Apparently there will be a fire drill in my (work) building today. The notice reads:
Please note that the bells will sound, and you MUST EVACUATE the building in an orderly calm fashion without any drinks using the stairs.
(emphasis theirs)
I've seen some fire drills over the years of working here, and I don't recall seeing anyone drinking, but I guess it's a big problem.
I mean, we have fire drills here once every other year, and you bet people will take their cup of fresh coffee/tea with them rather than letting it go cold for such a procedure.
-
@topspin Lucky. We have a (required by law) fire drill every month, and 2 in the first 30 days of school. Always at inconvenient times, too.
-
@topspin said in The Official Status Thread:
I mean, we have fire drills here once every other year, and you bet people will take their cup of fresh coffee/tea with them rather than letting it go cold for such a procedure.
Suppose there's a very very small fire on the way out. "Oh, if I had my cup of coffee/tea now! Woe is me, the building will burn!"
-
@Applied-Mediocrity said in The Official Status Thread:
@topspin said in The Official Status Thread:
I mean, we have fire drills here once every other year, and you bet people will take their cup of fresh coffee/tea with them rather than letting it go cold for such a procedure.
Suppose there's a very very small fire on the way out. "Oh, if I had my cup of coffee/tea now! Woe is me, the building will burn!"
-
-
Status: As far as I know,
document.querySelectorAll
is supposed to work in IE 11. Guess what isn't working and in what browser.e: disregard, I did a dumb
-
@hungrier said in The Official Status Thread:
Status: As far as I know,
document.querySelectorAll
is supposed to work in IE 11. Guess what isn't working and in what browser.e: disregard, I did a dumb
Let me guess, you tried to call
Array.prototype
methods on aNodeList
?Try
[].slice.call( nodeList, 0 );
(Or
Array.from(nodeList)
or[...nodeList]
in a sane browser.)
-
@error No, the code was already
[].slice.call(document.querySelectorAll)
. The problem was that I was looking at the file from a local folder, and IE by default disables scripts with only a notification at the bottom of the screen, and allows you to use the console in devtools but everything just returns undefined.
-
Just caught a bug where multiple (unrelated) properties were sharing the same cache key.
It got caught in code review, but I almost wish I hadn't, because that would have been a really wacky bug to track down.
-
I just realized I'm so bored at work I just wished for a bug to fix.
-
@error said in The Official Status Thread:
I just realized I'm so bored at work I just wished for a bug to fix.
hugs and play time?
-
@error said in The Official Status Thread:
I just realized I'm so bored at work I just wished for a bug to fix.