« first day (1143 days earlier)      last day (1418 days later) » 

3:54 AM
[ SmokeDetector | MS ] Bad ip for hostname in answer, bad keyword in answer, bad pattern in url answer, link at beginning of answer, potentially bad ns for domain in answer, +1 more (284): Outside of Order 66 - does a blaster ever beat a lightsaber? by moonsoon on scifi.SE
 
4:15 AM
0
Q: Why does the T-1000 kill the trucker?

Ham SandwichToward the end of T2, a trucker checks on the T-1000 after it crashes in its helicopter. On its way to commandeering the truck, the terminator impales the man, unquestionably killing him. I get that the T-1000 is the "bad guy," but what is the in-universe reason for this? The terminator doesn't a...

 
 
4 hours later…
8:16 AM
@Jenayah With only one question on the work that is pretty much correct use of an author tag but I'm not overly fond of that so not gonna roll it back
 
9:07 AM
[ SmokeDetector | MS ] Link at beginning of body (40): How does SCP-173 generate feces? ✏️ by srg forge on scifi.SE
 
SQB
@SmokeDetector false positive
 
@SQB You are not a privileged user. Please see the privileges wiki page for information on what privileges are and what is expected of privileged users.
 
Burn
Cos of my edit to it
 
SQB
Do you need a query for images without alt texts? :)
I saw we're down to just 79 tags without wiki. I assume that's your work for a large part?
That's amazing!
 
70 now, did 9 this morning
Mainly me but I've not been alone in it plus others have been on it with new tags recently so that's good to see
 
SQB
9:12 AM
Wow.
 
I've got the basic no alt text query
 
SQB
You know how I found out? I was tweaking the query to order by oldest tags first. I only got 79 records in return, so I thought I had done something wrong. Then I ran the original...
 
But that's a multi year task
 
May 24-May 31 2020 9770 images SFF
May 31-June 7 2020 9729 images SFF
June 7-June 14 2020 9722 images SFF
June 14-June 21 2020 9681 images SFF
June 21-June 28 2020 9641 images SFF
June 28-July 05 2020 9625 images SFF
 
SQB
Ah, there already is a query?
 
SQB
I would be interested in a list of posts that need Common Mark conversion.
 
That's the one Mith shared
I have no idea how you'd even query that
It might be too complicated to be honest
 
SQB
But I don't know if that's noted somewhere.
I'm still waiting for the new datadump to see if there's anything in there.
Oh wait, this is the new dump.
 
It seems somewhat arbitrary why some posts were missed, I fixed one this morning that I couldn't work out why it wasn't migrated
One potential way to do it would be to check the LastEditDate and LastEditUser on a post but that is going to bring up a lot of false positives
 
SQB
9:29 AM
We could check for old MD constructs in post bodies.
But I don't think we can do regex in SEDE, so that makes it hard.
 
And even if you could that is going to be one complex regex for certain cases
 
SQB
I'm not afraid of that.
I lurv regex.
 
Me too, I have some stupid ones in some projects
We use regex generally for "rules" from OCR we've captured, they can end up quite complicated when you use a validation one
The most complicated would be to find cases of:
> line 1 of quote

> line 2 of quote
Or > line 1 of quote\r\n\r\n> line 2 of quote
I'd imagine
SEDE is T-SQL isn't it?
 
SQB
Yeah.
 
Got a meeting soon but I might try and knock something up at lunch now I've had a few thoughts on how you could do it
Still gonna be awkward and give false positives though I think
 
SQB
9:40 AM
Damn, Posts contains the rendered html, not the MD.
 
Ah okay, might not be able to then haha
 
@TheLethalCarrot I think it's MS SQL
 
SQB
Ah, PostHistory has the MD.
 
10:01 AM
[ SmokeDetector | MS ] Pattern-matching website in body (97): A book about a ordinary guy getting married into a magical family by dorijan5484 on scifi.SE
 
@SmokeDetector false positive
 
@AncientSwordRage Registered question as false positive.
 
@SmokeDetector good bot
 
2
Q: A book about a ordinary guy getting married into a magical family

dorijan5484I'm looking for a book I read 5-6 years ago. I know I found it on top fantasy books at the time. http://bestfantasybooks.com/top25-fantasy-books.php Unfortunately, I couldn't find the book in question during my recent searches. I never finished the whole book, but I do remember the main character...

 
I honestly didn't think smokie would understand that
 
10:12 AM
@SQB Yes, that bit me too when searching for the longest posts.
@SQB even though meta.stackexchange.com/a/2678/222298 clearly says it
and yes, that says T-SQL though I don't know what that is
 
@AncientSwordRage Smokey's relatively smart
 
@SmokeDetector 1 + 1
Let see
 
@AncientSwordRage 3
 
@Mithical grmbl
 
@Jenayah ?
 
10:27 AM
@SmokeDetector false
 
@AncientSwordRage That message is not a report.
 
You're not a report
 
I am not.
 
fess-up time: have I mentioned that I have the credentials to Smokey's account
 
10:31 AM
@Mithical Well played
 
0
Q: Why does Buckbeak's executioner use an axe?

AJFaradayI've only just identified something which has been bugging me for literally years. Why does the executioner Fudge brings to kill Buckbeak use an axe? Seriously, one Avada Kedavra and it's done with zero pain, zero mess and zero effort. Possible arguments and why I think they're wrong. Not every ...

0
Q: Is Grandfather Paradox applicable to DARK ending?

Chloritone_360Can anyone explain if the Grandfather paradox really contradicts to the ending of Dark ?

 
11:12 AM
60
Q: Is the Han/Leia vs Luke/Yoda timeline in The Empire Strikes Back broken?

tonyloSo in The Empire Strikes Back, Luke parts ways with the rest after The Battle of Hoth and trains with Yoda. In the meantime Han and company evade the Imperial fleet, land in a space worm and then end up in Cloud City. Some people think there is a plot hole here, Luke's training would have take...

any Takers?
 
I read it, couldn't be bothered to be honest, just seems to me to be a "we don't see a lot of stuff that happens off screen" sort of thing
 
11:31 AM
@TheLethalCarrot There's a few different insights though, but they're all spread out among the answers
 
0
Q: Who does the snap kill?

MBEllisWe know the snap kills half the population on the planet it's performed, so why for instance does spider-man die? He wasn't on earth when the snap happened. One can argue it's because he was born on earth or lives on earth, but then why did Drax or mantis die? I'm pretty sure they've never even b...

 
@Mithical that goes down too slowly
 
People don't add alt text and some refuse to
 
12:04 PM
@TheLethalCarrot people are silly
 
-1
Q: Could the Avatar theoretically father himself?

PainkillerA thought just crossed my mind after a saw this post on reddit: If I remember correctly the new Avatar is born when the last on dies (I could be wrong it's quite a while ago that I last watched Avatar). So theoretically, if an Avatar impregnates a woman but dies before the baby is born, could tha...

 
12:35 PM
@TheLethalCarrot 10/15? It's the TLC show today!
 
what are you looking at @DavidW? I see 3/15 for TLC
 
Me too
 
Hey, that's weird.
I definitely see 10/15 on my non-logged-in page.
But at lot of those are negative scoring, so why are they showing?
 
Sure you on the homepage?
I've been fixing the posts with no alt text where the question is < -3 just to make some progress and not bump things
But they shouldn't bump
 
12:39 PM
Oh, damn. I opened the questions page, not the homepage.
 
Ah, questions active?
 
Yeah. Holy crap. The homepage looks really weird with only 3 visible questions.
 
Yeah was wondering that myself, got to be a bug
 
@DavidW Wait, what?
 
Well, I think I realized a while back that it grabs the 15 (or whatever it's set for) most recent questions and only shows the ones that are positive.
 
12:42 PM
I see 27 posts on the SFF homepage
 
In a none logged in account
 
Oh... huh
 
I don't know what the bug is
Unless it is getting top 15 active and then filtering score rather than top 15 > -4
But that's got to be a bug
 
I think it always just grabs the number of posts that are supposed to be displayed and then filters. I have ignored, so I can always tell when there are fan-fic questions because I won't see a full set of 30 questions.
 
12:45 PM
Well the ignored filters afterwards yeah
But that's because you can grey out rather than hide
 
I'm guessing the "too low score" filter must do the same. At least that's what the empirical evidence is pointing me towards.
 
Aye it's filtering at the wrong place whereas in this case it shouldn't be
 
12:58 PM
0
Q: How did Shaktimaan lose his abilities?

RusshiroIn the East Indian Super hero TV series Shaktimaan, the titular hero was a normal human who had practiced high level of yoga to develop psychic powers. These included flight, transmutation, and various physical and mental enhancements. I vaguely recall one episode where he lost his powers for som...

 
I think the Retrieve then Filter approach was asked on Meta.Meta at one point, and it was marked as status-by-design
pagination is hard
 
I assumed they grabbed top N most recently active via SQL but I guess maybe not
 
@AncientSwordRage Oh, oops. I didn't find that. (Then again, I occasionally get stuck on the wrong search terms.)
 
1:19 PM
@DavidW I mean, developing a system that paginates is hard, especially if you split the filtering between browser and server
I worked on a system that let you search by ID, but each ID could occasionally correspond to multiple results (e.g. Id=4 could bring back 2 results.) and while the server told me how many ID were returned, I had to keep requesting page n and page n+1 to see if they went over the last expected page
it was real annoying to do
 
1:44 PM
That is a mess; sounds like some part of the system was not designed properly. (Cynically, designed by a web app developer instead of someone with DB experience.)
 
0
Q: What "Wrong path" is Colin referring to?

Jake KrollIn Black Mirror Bandersnatch (2018), Stefan shows his 3D Maze game to Mohan's team. Meanwhile Satpal brought chocolates to Mohan: Satpal: Here you go. Mohan: Happy Birthday to me. (Colin says to Stefan) Colin: Sorry, mate. Wrong path What "Wrong path" is Colin referring to? .

0
Q: Why do Hogwarts owls almost always arrive at breakfast?

J. MiniThey obviously fly at different speeds and to different places, so why do they almost always arrive at breakfast? Several scenes show hundreds of them arriving at the same time, so it's unlikely to be a coincidence.

 
@DavidW the reverse
The DB was designed first with no consideration for how the UI would work
 
0
Q: Why was this question edited after 4 years?

KyloRenWhy was this question edited after nearly 4 years? What was the purpose? It does not seem to serve any purpose what so ever? What was the reason?

 
@TheLethalCarrot ^
 
SQB
@Mithical good answer. I wonder if we should add anything about posts not being one's property, possibly even tying in licensing.
 
1:58 PM
Given the OP it's probably not worth it.
To be frank.
 
SQB
Given the OP is why I wondered.
 
I half-suspect it'll devolve into a rollback war.
 
Greetings, Earthlings.
 
@Mithical lets hope it doesn't need to be locked
@Donald.McLean bleep boop
 
SQB
2:46 PM
 
SQB
3:45 PM
@Marvin they're nocturnal, so they fly at night.
 
 
2 hours later…
SQB
5:16 PM
> Circle the world
And Fly by night
I had a hunch
Why did they try?
 
@AncientSwordRage what Mith said, was ina. A meeting all afternoon, lucky me
And most of the morning
 
1
Q: How come Sam Carter didn't didn't remember which ear?

auburgAt the end of The Thing prequel Kate questions Sam that he's missing his ear ring. Sam points to the wrong ear - but if he's a perfect imitation wouldn't he have known what ear the ear ring was on ? Moreover, when he was assimilated in the spaceship, would he not have remembered to put the ear ri...

 
@TheLethalCarrot Death by meeting
 
Exactly
 
5:31 PM
My employer recently sent out a poll asking folks about creating "meeting free" times. One of the questions asked how much time, on average, we spent in meetings. I was in the lowest category, 0-5 hours/week (yay!!), but one of my co-workers has a meeting average so high that she it put her above the highest category on the survey.
 
@Donald.McLean youch
 
Extremely u lucky for her, luckily I’m on the 0-5 hours a week and near the bottom of that usually. Today was a massive exception which made it worse
 
Yikes. My typical week has about 3-4h of regularly scheduled meetings, but I can often double that with impromptu or last-minute meetings.
 
@DavidW Meh, 2 stars.
 
It's definitely not one of their best; it just fits the theme. It even has an owl for the cover art!
 
5:36 PM
I have a daily 1/2 hour tagup meeting and a bi-weekly 2 hour planning meeting. That puts me above the middle, but I still squeeze in.
 
(meetings) I had a co-worker who had 30h of scheduled meetings a week. In 3 different time zones. I don't care how much more money he was making, it wasn't worth it.
 
I like several Rush songs. I haven't done an exhaustive run-through of their discography - maybe I'll do them next after I finish Huey Lewis.
 
I forget who it was, but I remember someone I know IRL or here, complaining about having too many meetings and not being able to make any progress. How did management respond? Block booked a bunch meetings to discuss what meetings each week they needed to me in that week and which they didn't
 
@AncientSwordRage typical
 
2
Q: Soviet Sci-Fi movie from the '60s(?)/'70s(?)

TriskeleI saw this Soviet sci-fi movie in the '80s, but think it was made earlier, maybe '60s/'70s? A very few aliens come to Earth, to Russia, I guess. One of them, a blonde woman (perhaps after shape-shifting?) falls in love with a local man. But the authorities are on the aliens' tail. In the clima...

 
5:45 PM
yup
 
I have a daily 1/4h to 1/2h scrum meeting, the system folks presenting us use cases two hours a week, and the occasional 1 hour audio metting. Other than that, I'm lucky enough not to have much meetings
Well, junior position helps for that
 
SQB
Same here, although we now instated a second daily meeting, since everyone is working from home.
 
I have <1hr a week
Been at my company for 7+ years (so I wouldn't think of myself as junior)
 
hmm, nope
 
6:09 PM
@SQB Oh, I'm not counting the 3x1h, 5x0.25h "we're all at home, let's stay in touch!" optional meetings.
 
6:20 PM
@Jenayah They're also not bad at cleaning floors. :)
 
7:09 PM
Wow, an entire answer hidden behind spoiler tags.
(Except for the meta part that says "I'm hiding everything.")
 
truly an answer worthy of Puzzling
 
0
Q: Why didn't Sauron realise Frodo was in Mordor despite finding his shirt?

PrometheusIn the Extended Edition of The Return of the King movie, in the scene at the Black Gate, the Mouth of Sauron comes out to parley with the company. Eventually, he presents Frodo's Mithril shirt to Gandalf, and delivers the taunt that eventually leads Aragorn to decapitate him: The Halfling was de...

0
Q: How similar is this scene in The Return of the King to the books?

PrometheusIn the Extended Edition of The Return of the King, at about the 1:15:00 mark, Faramir returns to Denethor to inform him that he let the Frodo and Sam (and the One Ring) go, and the following conversation takes place between them: Faramir: I did what I judged to be right. Denethor: What you judge...

-1
Q: Was Theoden's refusal to help Rohan an allegory for anything?

PrometheusBefore people get their backs up about the word "allegory" because of Tolkien's perceived dislike of it based on that particular quote, feel free to replace the world "allegory" with "applicability". I believe that Tolkien was simply making a semantic distinction in that quote, and there are many...

0
Q: Is Gandalf's rant about Gondor an allegory for anything?

PrometheusPS. Before people get their backs up about the word "allegory" because of Tolkien's perceived dislike of it based on that particular quote, feel free to replace the world "allegory" with "applicability". I believe that Tolkien was simply making a semantic distinction in that quote, and there are ...

 
7:41 PM
scifi.stackexchange.com/a/233647/101407 answer links to question.
 
0
Q: Why didn't the Palantiri reveal the Fellowship's true plan?

PrometheusThroughout the Lord of the Rings, the key tactical advantage that the Fellowship had was that their plan to destroy the One Ring remained secret, to the point that it's even stated that going to war with Mordor was merely a distraction to keep Sauron's Eye away from Frodo (I forget where it is st...

0
Q: Was this line changed for the Extended Edition of The Return of the King?

PrometheusIn the Extended Version of The Return of the King, when Aragorn uses Narsil to defend from the Witch King's sword, the Witch King replies: That line was broken! However, for as long as I can remember watching this scene as a kid (in the theatrical cut), I remember the line being: That blade wa...

0
Q: How did Cochrane obtain dilithium for the first warp flight?

drmanhattanIn the illustrated Handbook (based on the official Star Trek Fact Files 1997 - 2002) I read: "Following the model established by Zefram Cochrane, Federation vessels' warp engines accomplish the transition into subspace by using a matter-antimatter reaction to generate a series of warp fields that...

 
Impressive response time; and it wasn't even the lurking mod who handled it.
 
@DavidW oh, the troll is back
 
Yep, looks like.
 
8:14 PM
It's a good thing that trolls aren't real in this universe, or we would be in so much trouble for all of the speciesist remarks.
 
8:44 PM
@Donald.McLean in a parallel world there's a troll sighing at the sight of fellow trolls humaning his favorite website.
 
8:55 PM
2
Q: Was Fringe the first TV show to use the changing Opening credits?

NJohnnyRecently I started re-watching the TV show Fringe. And noticed that they used different colored opening credits that indicate the universe the majority of the episode takes place in. [I am only up to season 3, but I understand they use 4 different color schemes to indicate the universes. Blue: Or...

 
SQB
9:05 PM
What, no one-box love?
Nope, www makes no difference.
 
Twitter oneboxes have been broken for years
 
SQB
I keep forgetting.
Anyway, an accurate prediction of our future current times. Made shortly after WW2, I think. In French. (cc @Jenayah)
 
1
Q: Why are trains in the Divergent film series are running on two tracks?

hunyadymIn the second Divergent movie, Insurgent, the train is running on 2 tracks (the engine is using the two middle rails, and the wagons are running on the two side rail pairs). See the 9 seconds here from 0:37 and the top view: How can this configuration be better than a regular train with twice th...

 
10:02 PM
 
 
1 hour later…
11:19 PM
1
Q: Looking for a children's scifi/mystery/horror book about a boy who becomes addicted to an arcade game

asiopjdfbgoisdhfbgiosdfbgoiusdIt's about a kid/teen who gets addicted to a VR-like arcade game. Every time he went to the arcade, there was nobody around the game, even though it was really cool/high tech. I can't remember much about it, but it really reminds me of the game Superhot and the Polybius urban legend. It was proba...

 
11:42 PM
0
Q: How many people are killed by the Death Note?

Ryan_LHow many people were killed via Death Note, regardless of who the user was, in the original anime?

 

« first day (1143 days earlier)      last day (1418 days later) »