Tavern on the Meta

user315433

12:00 AM

At a glance it looks like something for Information Security more than Super User

Bit of an overlap there

user315433

On one hand, How to force a server to use a specific elliptic curve at the beginning of the handshake via openssl? was migrated from Security to SU, so SU is perhaps better.

Journeyman Geek

;p

I think its on topic on SU, and that matters just a little ;)

user315433

> ▓▓▓▓▓▓░░░░░░░░░ 40% -- Year Progress at 5:00 PM - 26 May 2017

SmokeDetector

12:53 AM

[ SmokeDetector | MS ] Bad keyword with email in answer: Is it possible to see to whom deleted messages were sent from my hacked account? by Robert Perkins on webapps.SE

Jason C

1:18 AM

Any Hibernate peeps in here?

user315433

2:17 AM

Sometimes tour doesn't pick the best example of a comment...

user315433

user315433

A self-referential paradox: a Documentation section called Undocumented Features

user202362

undocumented features sound like bugs

Jon Ericson

The difference? Undocumented features sometimes get fixed.

user202362

2:34 AM

I have an idea! Since SE now has a data team, why doesn't the data team do something useful, like write a search engine for SE?

user202362

A lot of information on Stackoverflow, for example, are obsolete. Google doesn't always return the most relevant. The most relevant, not coincidentall, usually is also the most recent.

Jon Ericson

When they finish that, they can invade Russia.

user202362

I don't think it's that complicated. To make it perfect, yes, it will take A LOT of effort. But there are a few hypothesis: 1) usually there is a life cycle for most maintained software/OS/programming language, and my guess is 2-3 years. 2) answer relevant is highly correlated with those major updates.

SmokeDetector

[ SmokeDetector | MS ] Blacklisted website in body, blacklisted website in title: It some irregular sexual Iron Bull Edge by daatzeen on graphicdesign.SE

user202362

2:54 AM

if link tag with update sites & update triggers questions associated with that tag to be evaluated

user202362

although I have to say, many companies are highly irresponsible with their updates

SmokeDetector

[ SmokeDetector | MS ] Bad keyword in body, bad keyword in title, blacklisted website in body, pattern-matching website in body, potentially bad keyword in body, +2 more: Nayvi Serum skin care by eckr urfey on apple.SE

user202362

they leave to some third party to figure out what exactly need to be updated

user315433

@bjb568 I imagine an argument over the placement of ^2 leading to divorce.

user315433

We actually divorced once over the airplane/treadmill argument. (Preemptive response to the inevitable threads arguing about it: you're all wrong on the internet.)

bjb568

3:02 AM

:3

Journeyman Geek

@Telkitty too broad ;p

SmokeDetector

3:59 AM

[ SmokeDetector | MS ] URL-only title, bad keyword in body, bad keyword in title, blacklisted website in body, blacklisted website in title, +4 more: supplement4help.com/bio-rocket-blast/ by yuossefaljehan on askubuntu.com

user202362

I love big toys

Jason C

4:37 AM

@Shog9 Do you have a way to pull the number of frozen and number of deleted rooms on chat.stackoverflow.com? I'm counting now but it's like 7500 pages at 10 seconds each.

Actually I can't even do it, my cookies keep expiring and I need to keep the 10k privs.

Journeyman Geek

@JasonC there's probably.... lots

user202362

by this time, shog is probably on to his 2nd glass of alcohol

user202362

best time to ask anything other than related to SE really

user202362

that is ... if you could get response to start with

Journeyman Geek

....

@JasonC I can help you with that.

so, there's 2792 pages of rooms....

the last page has 7

the rest have 20

Jason C

4:51 AM

7050 pages and I need the frozen / deleted separately. Although... can you not see deleted because of privs?

Journeyman Geek

oh

Jason C

Because if you can only see frozen, I can subtract.

Journeyman Geek

seperately

wait, which server?

Jason C

Journeyman Geek

I was looking at chat.se

ahh, can't help you there

an SO mod probably could but my chatmoddly powers are only on the 'shared' chat server

Journeyman Geek

5:03 AM

whoo. 14K

Jason C

5:16 AM

Oh yeah I figured it out.

I can view active and active+frozen+deleted page counts when logged in. And in an incognito tab I can view active+frozen. So that's enough to do the math.

1011 active rooms, 63935 frozen, 76037 deleted.

Journeyman Geek

ah

rene

6:32 AM

What the Smoke?

Elephant

Too many charcoal from the smoked spam. Need clean-up.

rene

@JourneymanGeek on this I wondered if I can abuse the linking feature by leaving a comment with links to my own answers and then delete the comment. That will fill the Linked Posts table but only leaves a trace for moderators.

Journeyman Geek

I've never seen anyone do that before

rene

Great let's ~~abuse~~ test that ....

Journeyman Geek

lol.

rene

6:38 AM

> I need to do more testing on it than I can reliably do on a Friday afternoon before a long weekend.

if pre-drunk is a state you shouldn't do coding I better stop altogether ...

Journeyman Geek

lol

Jason C

@rene I got a stumper for you.

This is in progress and heavily mcve'd hence not making sense, but check out this query, where the cte parses close voter ids: data.stackexchange.com/stackoverflow/query/676500

It works.

Now comment out that select and uncomment the last bit that says "this doesn't" and explain what happens.

(You can put a top 50 in that last query I just linked to the wrong version, doesn't matter. The only difference that matters is the u.userid < w.userid)

@TimStone ^ That one's for you too if you need a head-scratcher.

rene

Conversion failed when converting the nvarchar value '{"OriginalQuestionIds":[1867861]' to data type int.

Jason C

Yeah

And that string shouldn't be possible, because and s.value like '%"DisplayName"%'.

All evidence suggests that adding u.userid < w.userid to that join causes the cte to attempt the convert without honoring its where clause.

Any other queries from that same cte succeed, which shouldn't be possible if there's truly a parse error.

So wtf is going on?

I was unable to reproduce that effect with test data. It doesn't make any sense.

Elephant

6:56 AM

there's NAA for that, but sure I can help to get it rid faster

rene

@JasonC but on duplicate votes that is a valid option: data.stackexchange.com/stackoverflow/query/676505 your query works, your assumption about datashape is wrong

Jason C

@rene No. I know that string can exist. But it should not pass the like '%"DisplayName"%' condition in the where clause, so a convert on that string should never even be attempted. Not only that, but if that string was finding its way into the convert, those other two commented out queries should also fail.

Remove the and u.userid < w.userid condition and suddenly it works again.

rene

yeah, that is because the query plan processor will not evaluate that userid column as it is nowhere used then.

need moar coffee

Jason C

@rene Nope. I thought of that. But data.stackexchange.com/stackoverflow/query/676508 works.

Journeyman Geek

sigh

@JasonC heh, one of your example questions makes me wish I had the ability to ~~bitchslap~~ smack someone with a rolled up newspaper over the internet.

Jason C

7:10 AM

@rene And it actually gets weirder: data.stackexchange.com/stackoverflow/query/676509 -- see comments.

This is driving me crazy. And it almost, almost feels like a SQL server bug, but I'm not confident enough to assume that yet.

rene

Must be something caused by the CTE as this simply works as expected: data.stackexchange.com/stackoverflow/query/676505

Jason C

Yeah. It's super weird. I've used that parsing style in the past, it always works. It's something with the cte, its where clause, and something about that join. It's frustrating too because I haven't yet been able to construct any small test tables that make it happen. I can't find a minimal test case that fails in the same way.

(The and charindex(',', s.value) > 1 is unnecessary, really, that was just something I threw in there when trying to fix this current problem, btw.)

@TimStone Prev. ping continued, last example is ^^^ (data.stackexchange.com/stackoverflow/query/676509). Read the above convo, and be mystified.

Anyways

It's way past my bed time

Later

@JourneymanGeek (PS: Like 10 of those questions made me want to slap somebody, lol)

Journeyman Geek

lol

@JasonC I'm a lot more patient

also I find a lot of the MSO meta questions assume context

rene

9:24 AM

@JasonC I played a bit further here. It looks like the query plan optimizer assumes it can safely bring the where clause to the CTE query producing this: Filter(WHERE:([Expr1001]=(100297) AND STRING_SPLIT.[value] like N'%,"DisplayName":%')) Expr1001 is the convert. If that order was reversed it would work, assuming it would short-circuit.

I couldn't find a query hint that tells the optimizer to either do that reversal or don't optimize it like that. Could make a good question on SO I think.

Maybe not optimal but could be a workaround: use try_cast

user202362

12:26 PM

!!/tea

SmokeDetector

@Telkitty brews a cup of green tea for @Telkitty

angussidney

It's fixed now

user202362

！！/tea

user315433

4:15 PM

GD election got enough candidates now (3 for 2 positions)

user315433

Westside looks okay except that the answers to the questionnaire constitute his first post on meta. :-/

Fawad

While writing question,they are not saved when I close browser. And when I open again,all question is gone :( and I need to write again. Any solution?

I remembered it used to save in android buts its not saved in iOS :(

Hi chat

Elephant

I thought iOS has multiple drafts? Not sure though since I don't have iOS

user315433

@Fawad Most desktop text editors have an option to save text. All of them, now that I think of it. And Google Docs.

Fawad

@Elephant correct word draft. There isn't showing "saved as draft" ;(

Jason C

4:46 PM

→ 33 messages moved to Chimney

@rene Whoa. TIL. Also, nice. I'm definitely going to make an SO (or maybe a DBA) question out of this once I get my head around it.

Man I slept in hard. And it was apparently quiet in here last night.

user315433

5:09 PM

!!/report android.stackexchange.com/a/175657/76613

SmokeDetector

[ SmokeDetector | MS ] Manually reported answer: Where is downloaded skype files on android? by james on android.SE

user315433

6:29 PM

What boy scout rank did you reach, @JasonC?

user315433

I'm not sure if it's something for lifetime or just for the duration of membership.

Jason C

I'm an eagle scout

user315433

Cool. Should totally be in your developer story.

Jason C

And oa brotherhood

Lol

user315433

> The induction process, called the Ordeal, is the first step toward full membership in the Order.

user315433

6:38 PM

What a name.

rene

@Gerry Cool! So my veterstrikdiploma can be on there as well?

user315433

We should give those to about a half of our graduates, as an accurate description of the skills acquired.

user315433

Eagle Scout is a serious thing, though.

rene

It is? Never made it to the boy scouts, so I'm unaware of its importance, if any

user315433

Eagle Scout (Boy Scouts of America)

Eagle Scout is the highest achievement or rank attainable in the Boy Scouting program of the Boy Scouts of America (BSA). The designation "Eagle Scout" was founded over one hundred years ago. Only four percent of Boy Scouts are granted this rank after a lengthy review process. The requirements necessary to achieve this rank take years to fulfill. Since its founding, the Eagle Scout rank has been earned by more than two million young men. Requirements include earning at least 21 merit badges. The Eagle Scout must demonstrate Scout Spirit, an ideal attitude based upon the Scout Oath and Law, service...

user315433

6:51 PM

What do we get for collecting 21 badges on SO...?

Ferrybig

7:07 PM

!!/alive

SmokeDetector

@Ferrybig Yup

@Ferrybig Watching this endless list of new questions never gets boring

Elephant

!!/location

Jason C

@Gerry Some unexplained downvotes.

SmokeDetector

@Elephant Undo's RPi 3

Ferrybig

Sorry for the smokey maintenance here, but there are 2 smokey's running at the moment, and 1 of them broke in Charcoal HQ

!!/standby teward/Solar

Jason C

7:10 PM

@Ferrybig Sorry isn't good enough. Unforgivable.

Ferrybig

@JasonC don't let smokey hear that, or he may refuse to work with me

Jason C

7:37 PM

@Jason which is exactly what I meant with "did the site just degrade without a clear reason?". Well, if you got more details there is always chat... — Shadow Wizard 19 secs ago

@ShadowWizard Unexpectedly defensive, but I know you meant to type "Ah, yeah, it's pretty interesting, thanks." :P

Np!

rene

Hey, don't ping @ShadowWizard, he is obviously grumpy

2

Shadow Wizard

@JasonC Ah, yeah, it's pretty interesting, thanks.

:D

@rene I'm the Anti-Shog, I accept pings with open arms. :P

Jason C

@rene I'm half-tempted to bust out the "ping attack shadowizard with star trek tos transcripts" script again.

Shadow Wizard

Go for it!

And hey, any W count, @Jaso!

rene

@JasonC lol

Shadow Wizard

7:42 PM

stealing @Jaso's "n"

rene

@ShadowWizard txt spk

Jason C

What's a W count

Shadow Wizard

@JasonC 2

Jason C

... yes. Makes sense.

Shadow Wizard

in Baker Street, 2 mins ago, by Hexacoordinate-C

"Gaming/The Bridge: minigame Eggs.Asteroids

Send the message insert coin and click on the floating "click me" button that appears to start an Asteroids-esque minigame with user avatars."

Anyone here ever actually tried that? ^

Jason C

7:44 PM

I have, but I don't remember if that was enough on its own or if I had to manually enable the eggs first.

74

Q: What Easter Eggs do the chat sites have?

According to balpha, the SE chat sites may have individual Easter eggs, depending on the site. If you find them, please post. Edit: Because it's so easy to make this stuff up, a screenshot as proof would be nice. (Although Photoshop ain't that hard either...)

Shadow Wizard

@JasonC yeah, I know, that's what I posted too

user315433

@Jason which is exactly what I meant by "did the site just degrade without a clear reason?". Well, if you got more details there is always chat... — Shadow Wizard 8 mins ago

Jason C

@Gerry You're late.

Shadow Wizard

8 mins ago, by Jason C

@Jason which is exactly what I meant with "did the site just degrade without a clear reason?". Well, if you got more details there is always chat... — Shadow Wizard 19 secs ago

user315433

My theory: it is demoralizing to continually fight against the tide of "what's wrong with me?" questions

Jason C

7:45 PM

GO HOME, NOOB

Shadow Wizard

lol

user315433

Which are inevitable considering the name and content of the site + the number of sick people with access to the internet.

Shadow Wizard

It's n00b, not noob!

Jason C

your mom is inevitable considering the name and content of the site

user315433

It's like a retweet but for chat.

user315433

7:47 PM

Rechat

Shadow Wizard

@Gerry that's right, plus tide of questions about sexuality, which IMO makes people uncomfortable there.

Jason C

I think that's called a "twat".

Shadow Wizard

@Gerry that's.. brilliant!

user315433

Stephen Douglas actually died soon after the debates and election, but if you demand historical accuracy in your webcomics you should be reading Hark! A Vagrant.

user315433

s/1860 loss to Lincoln/2015 loss in SO election/

user315433

10:43 PM

Let us continue this discussion in chat

Jason C

HA HA IT'S FUNNY BECAUSE WE'RE ALREADY IN A CHAT ROOM

user315433

> The only dumb questions are the ones unasked. DR means "disaster recovery", e.g. your secondary/backup data center. -- Nick Craver at 1:04 PM - 27 May 2017

user315433

The first sentence proves Nick isn't active on SO anymore.

user315433

3 answers in 2012, 2 in 2013, 2 in 2014, 3 in 2015, none since.

user315433

In 2010 he was #1, ahead of Jon Skeet

SmokeDetector

11:08 PM

[ SmokeDetector | MS ] Pattern-matching website in body: Create ui ux forms in wordpress by Adi Sharabani on wordpress.SE

Journeyman Geek

11:25 PM

ow about health

Jason C

11:53 PM

@JourneymanGeek Yeah they're f'd. That's one of those sites that was kinda doomed to fail from the start.

I feel like pets has been heading a similar direction lately, too, sadly. But maybe not as bad.

Transcript for