Tavern on the Meta

Bart

1:24 PM

We have an office puppy

Shadow Wizard

plz-delete Samsung meta.stackexchange.com/questions/307966/… @rene @Bart @Glorfindel @Journeyman

@Bart cute! Is he rechargeable?

Bart

@ShadowWizard let's just say he has enough energy for a lifetime

Shadow Wizard

haha :D

Journeyman Geek

1:50 PM

cv-plz meta.stackexchange.com/questions/307968/…

._. I think I am repcapping today

Mostly cause of what was nearly a oneliner

Princess Luna

@Bart awwwww

Golden retriever?

Magisch

@Bart #1 way to get no work done

Journeyman Geek

was thinking lab, goldies are fluffier ;p

Bart

Golden labrador I think? It's the boss' dog

Taryn

you're not going to "borrow" it?

Derpy

2:02 PM

was checking a bulk data import tool found on git hub to see if I could automate some data migration between access and Sharepoint.

seems somehow... shady.

Journeyman Geek

For a moment I thought @Taryn said that, and nearly had a heart attack.

Cause I think I hate access as much as @Derpy hates sharepoint

Derpy

No source code provided.

The tool uses a free library, spimporthelper.dll.

Journeyman Geek

ugh

Derpy

But the library is obsolete and has never been replaced in the tool.

so the tool creator suggest in one issue to go to the library creator site and download the updated lib from there

Bart

@Magisch yup. Either he wants to play, or decides the plants are food, or finds the cables far too interesting, or needs to pee, or ... But ohmygoshheissocutewhoisagoodboyyesyouare

Journeyman Geek

2:04 PM

Sounds Dog.

Catija

@Bart Probably better that those things happen in the office than unattended at home.

Derpy

the library creator site is a company site that offers this lib (free or with paid support)

Journeyman Geek

heh

SmokeDetector

[ SmokeDetector | MS ] Manually reported answer: True languages that pirates spoke by Ballsy Man on linguistics.SE

Journeyman Geek

Ash was an office dog ;p

It actually works pretty well if everyone is chill, and there's a routine in place

Shadow Wizard

2:07 PM

plz-delete Antenna meta.stackexchange.com/questions/307968/… @Bart @rene @Glorfindel @Journeyman

Derpy

I think I will stop there. The tool could be useful, but it is rapidly looking as an attempt to mine user info /mail accounts.

@ShadowWizard Dead

has to go.

@Bart still cute :D

2:29 PM

hmm

Teams questions go on SO right?

Shadow Wizard

@Catija thanks!

@JourneymanGeek what Teams? First or second?

M.A.R.

@JourneymanGeek like?

@ShadowWizard you're really hung up on the first teams thing

Catija

@JourneymanGeek If you're on a team, and you have a bug report, those go to the Teams team by email. General queries about Teams go on MSO.

Journeyman Geek

1

Q: Stack Overflow for Teams: Question incorrectly not accepted as duplicate, how to overrule?

We are introducing Stack Overflow for Teams in our company. As part of that effort, I'm trying to add FAQ's related to onboarding of new employees in the system. The problem that I'm having is that the Stack Overflow software incorrectly marks questions as duplicate, and does not allow me to eve...

Shadow Wizard

First Teams is SO only, second Teams (previously called Channels) are fitting for MSE, I think.

M.A.R.

2:34 PM

They have a special, private SO, they go there

Just be careful not to post on main

Shadow Wizard

@M.A.R. not really. They call new project with same name as not-so-old, dead, project. It's terrible.

M.A.R.

@ShadowWizard well, I keep forgetting about the first one and only you remind me of it

Catija

From Adam on Charcoal's Team:

> We had some discussions internally on this and (don't quote me on that but) I believe where we landed is that it's fine to use meta SO for discussions and whatnot, but we'd prefer bugs to be reported by email. I think there will be a meta post or an email or something next week to announce whatever our preferred approach is.

Shadow Wizard

It's like someone will create brand new browser, and call it... wait for it... .... .... Netscape Navigator!

Journeyman Geek

@ShadowWizard also, the term's a little overloaded

I guess the new VP of marketing can sort it out ;p

Catija

2:37 PM

Technically, it's "Stack Overflow for Teams"... so...

Shadow Wizard

@Catija oh. so MSO only, yeah.

Journeyman Geek

@ShadowWizard NETSCAPE NAVIGATOR WILL LIVE ON IN OUR HEARTS AND OUR OS/2 VMS!

HTTP

Certainly not stackoverflow-business though

Shadow Wizard

yeah

user315433

Great, schools are closing early today because of the snow. Less pi day nonsense this year than usual.

HTTP

2:45 PM

It's snowing because of White Day...

user315433

New data dump: archive.org/details/stackexchange

user315433

SO is assured of primary round (as always), 11 candidates.

Shadow Wizard

@FTP you made a deal with the weather commander?

M.A.R.

@ShadowWizard I don't think he has a soul to sell

Mathematicians have sold their souls to the devil long ago

rene

@ShadowWizard gone (both)

Shadow Wizard

3:05 PM

@rene yeah, you're late :D

@M.A.R. who? The commander? Or FTP?

rene

@ShadowWizard yeah, I'm slacking

M.A.R.

@ShadowWizard FTP

alexolut

@Ano what's this? I have never use it. Oh ... yes, it's enabled for ruSO as well.

M.A.R.

@alexolut it's a great functionality made available that allows you to . . . Oh, nevermind

alexolut

@Ano you can check here for example.

@M.A.R. it's useless for me and my C++ :)

Shadow Wizard

3:19 PM

@M.A.R. oh he has a Normal Soul

@alexolut convert your C++ to jQuery then. :P

Journeyman Geek

wait what?

alexolut

@ShadowWizard ... and the next step - drop it to the recycle bin.

Feeds

3:51 PM

Podcast #123 – Jon Skeet Wants You To Be a Feminist

Jess Pardue on March 14, 2018

It’s a Stack Overflow Podcast not-so-hostile takeover!

Jon Skeet in the NYC Stack Overflow HQ to celebrate One Million Rep, so we gave him the podcast reins to talk about whatever he wants! And mwhahahaha he wants to talk about… diversity and inclusion in tech and his work educating others on how to be better allies! Wait, that’s not diabolical at all. That’s actually… a really thoughtful and much needed topic to discuss in the tech space… especially now. Is he really that great a guy? Yes. The answer is yes. So, for this episode we’ve invited Casey Ash …

user315433

Roger Waters - What God Wants, Pt. I (2015)

►

Shadow Wizard

hmm... Cassie Montrose... can it be... is she Kevin's wife?

@FTP you usually on top of those things, no? ;)

Derpy

@Feeds and so the Echidnasplaining meme starts once again.

Shadow Wizard

they are both from NY... both work for SO...

Shog9

4:07 PM

@FTP oh man... that's such a "first year in college" album

can't even listen to it now without looking around for a worn out couch to sleep on

Catija

Make sure there aren't any sharpies around, though...

Shog9

Hey Denis! I think you might get faster response by sending an email to the teams contact address. :) In general, Teams is SO-specific, so questions about it go on MSO, not MSE but I think the teams email is the better choice here :) Good luck! — Catija 2 hours ago

eh, @Catija... Please don't do that

Better to have bug reports somewhere

Catija

Adam answered the Charcoal post saying to email them...

Shadow Wizard

@Shog9 even about private ~~channel~~ team?

Catija

If that's wrong, fine... I won't... but it seems like something y'all need to get ironed out? stackoverflow.com/c/charcoal/a/166/2

Shadow Wizard

4:13 PM

@Catija maybe by "them" Adam meant private email to himself only?

Tim Post

The teams team (say that 10 times fast) has been asking folks to email them directly

Shadow Wizard

(think most SE staff got their own email in their profile)

Shog9

@Catija that may be best for Charcoal right at the moment, since y'all were hammering on the mod tools pretty heavily. And I believe that the Teams Team are working directly with a lot of the teams using Teams. BUT...

Catija

@ShadowWizard No, it's about the Teams team... not Adam.

Shog9

...and this bit is important...

Shadow Wizard

4:14 PM

Teams team... hmm... running away from endless loop

Shog9

...it doesn't serve anyone well to shut down bug reports when they do end up in public, unless there's a really good chance that they contain information that's going to hurt someone (vulnerability reports)

Ultimately, email isn't going to scale - in a year's time, this'll likely all be on meta (unless by some miracle we end up with an actual bug tracker after 10 years of using meta for that purpose)

Catija

I didn't even VTC that question... I posted info that I had and that @TimPost just corroborated.

Tim Post

I'm gonna get with team teams and see if we can make the guidance consistent, because I think this is already confusing folks :)

Shadow Wizard

@Shog9 so questions about Teams belong in MSE, not MSO? Or both?

Catija

He migrated it to MSO...

Shadow Wizard

4:20 PM

oh

But question is, should we close it? Or let it be, and let SE staff migrate at will?

e.g. we do close Jobs questions...

Tim Post

I'm working on getting that clarified now. Teams is a little different because it's not the most stable of things currently

NOBODY PANIC OR PUT PINEAPPLE ON PIZZA OR SOMETHING EQUALLY HORRIBLE, I'll get it sorted out.

Félix Gagnon-Grenier

I'll settle for pizza on pineaple. fite me.

Tim Post

Don't you dare set that pizza on ~~fire~~ pineapple.

Shog9

@ShadowWizard the latter

Catija

Can't we all just agree that pineapple is preferable to broccoli on pizza?

Shadow Wizard

4:32 PM

@Shog9 ok then... won't close them. :)

@Catija no no... pineapple is a fruit, it doesn't fit on pizza

Félix Gagnon-Grenier

.... tomatoes..... something something ....

Shadow Wizard

yup

any vegetable can fit

or cheese

Félix Gagnon-Grenier

but but but. tomato is a fruti. frutiIIII!I!

Shadow Wizard

no?

Félix Gagnon-Grenier

en.oxforddictionaries.com/explore/… ?

Shadow Wizard

4:34 PM

> As far as cooking is concerned, some things which are strictly fruits, such as tomatoes or bean pods, may be called 'vegetables' because they are used in savoury rather than sweet cooking

Shog9

@Catija to be clear: email is fine. Email may even be preferable at this point. What I don't want to see is folks taking the time to write up a bug report and getting bounced around because they put it in the wrong place. That's really discouraging; writing bug reports is time consuming and frustrating enough already - the more unnecessary overhead we pile on top of that, the more bugs go unreported.

Félix Gagnon-Grenier

hand waves vaguely

Shadow Wizard

Pizza is about cooking, so vegetable it is! :D

user315433

I used to order pineapple pizza for math club events, and it was well received (better than broccoli on average). But then again, math club,

John Dvorak

Pizza is mostly a vegetable because of US tax agencies

Tim Post

4:35 PM

This one time, at band camp, I ordered pineapple pizza and they disbanded band camp.

Shog9

MSO has the advantage that it's attached to SO. MSE has the advantage of allowing reports from folks with no rep anywhere public. Email has the advantage of... I don't really know what the advantage of email is, but let's assume there is one. Convenience maybe? Anyway, as long as a legit report gets posted somewhere, that's preferable to someone just throwing up their hands and silently cursing us while we sit blissfully assuming that everything is good.

John Dvorak

Email has the advantage of privacy

Shog9

well, the appearance of privacy

Tim Post

^^^^ Has obviously never heard of the NSA

Shog9

but, fair point

Félix Gagnon-Grenier

4:37 PM

some mailling list / bug reports threads are public

John Dvorak

Fewer people will read about SE's vulnerabilities if you send them through email than if you dump them in a MSE post whose rep pins it to the sidebar for weeks

And the only option to avoid NSA is ... sneakernet

Tim Post

We don't have vulnerabilities, we have unintentional features.

2

John Dvorak

maybe a one-time pad with the key exchanged over sneakernet.

Derpy

@TimPost and now we discover that SE is secretly inserting security vulnerabilities and backdoors into users posted code samples on behalf of [insert preferred government here]

E.P.

@JohnDvorak sneakernet is vulnerable to evil-bellhop attacks

Tim Post

4:40 PM

4

Derpy

@MetaEd Will something pop out of that Easter Egg on April, 1?

John Dvorak

MetaEd

@Derpy A bunny, presumably.

Anonymous

4:56 PM

Something I noticed when generating browsable pages from the data dump:

Anonymous

0

Q: Archival annoyance: Amazon URLs in data dump are rewritten to go through Stack

I was recently generating some pages from data dump content, and noticed something problematic: links to Amazon books/products in the data dump HTML are still rewritten to use Stack Overflow's affiliate redirect, instead of the original link the user provided. For example: <p>A bit more speci...

bug markdown data-dump amazon

Anonymous

Though to be fair, Amazon product links are pretty rare on Stack Overflow these days.

Anonymous

Probably more significant for sites like Hardware Recs, I would guess.

Anonymous

re: difficulties of re-rendering posts: If only CommonMark had already taken hold. Or, further back, if only John Gruber had had taken appropriate responsibility for his creation and written a real spec himself.

Anonymous

He got all indignant on his podcast when Jeff launched "Common Markdown".

Anonymous

4:59 PM

but it wouldn't have been necessary if he hadn't been negligent.

Tim Post

Okay! Off to write a flow chart of where teams stuff should to to reach the teams teams! Sorry about the confusion and any hurt feelings folks, we didn't do so well planning this part.

user315433

@JeremyBanks Your query appears to look at 100K oldest posts, was that intended? Doesn't match "these days"

Anonymous

@ftp you're right. that was intended because there were a lot more links back then. If I queried the most recent I had to include more to get equivalent numbers. Maybe not the best choice though.

user315433

5:28 PM

BigQuery can probably return the all-time totals

Tim Post

1

Q: Where Should My Feedback & Bug Reports Related To Stack Overflow For Teams Be Posted?

So, you're a glutton for punishment one of our highly appreciated and eagerly anticipated early users for Stack Overflow For Teams, and you've got some feedback or a bug report for us to see? Here's a quick rundown of the best places to send different kinds of feedback. Most importantly, you're...

support bug-reports stackoverflow-for-teams feature-request-process

user315433

Oh. The most recent SO post in Google BigQuery is from June 2016.

Tim Post

Ugh, I don't even remember who was going to make sure that got updated with new dumps (I believe they were, as they need to run the conversion on their side).

SmokeDetector

[ SmokeDetector | MS ] Bad keyword in body, blacklisted website in body, link at end of body, link following arrow in body, pattern-matching website in body, +1 more: It hides the consequences of ageing due to its pressure relieving qualities by Meacermir 19 on superuser.com

user315433

5:43 PM

Interesting choice of tables: badges, comments, post_history, post_links, posts_answers, posts_moderator_nomination (?!), posts_orphaned_tag_wiki (??), posts_privilege_wiki, posts_questions, posts_tag_wiki, posts_tag_wiki_excerpt, posts_wiki_placeholder, stackoverflow_posts, tags, users, votes.

Taryn

@TimPost that was supposed to be handled on their end

Tim Post

<sigh> If only they had a crawler that could let them know when there was something new on the interne ... oh, wait.

user315433

select id from `bigquery-public-data.stackoverflow.stackoverflow_posts`
order by id desc
limit 10

user315433

> Bytes Processed 237 MB
Bytes Billed 237 MB

user315433

Yeah, why do anything optimized when you are billing by megabytes processed.

SmokeDetector

5:56 PM

[ SmokeDetector | MS ] Manually reported question: Best Mobile Application Development Company Ahmedabad by tec logiq on meta.SE

SmokeDetector

6:09 PM

[ SmokeDetector | MS ] Link at end of answer: Any software to help manage mass combat from Ultimate Campaign? by Dooldarak on rpg.SE

Ano

6:38 PM

2

Q: Banned from asking questions due to connecting a Google account that associated questions with my current account?

A few years ago I was a total programming noob and signed up to StackOverflow in order to get help (more like leeching) with programming issues I was having. My account was quickly blocked from asking questions and I learnt my lesson. Fast forward today and I have a new account I had made early ...

support login user-accounts post-ban merge-accounts

@TimPost How are things going with the survey?

Anonymous

@FTP Good observation!

Anonymous

6:55 PM

@FTP How can you tell without running an expensive query?

Anonymous

Stack Exchange Data Dump
by Stack Exchange, Inc.

Publication date 2018-03-13

Anonymous

Oooo, new release!

SmokeDetector

7:11 PM

[ SmokeDetector | MS ] Pattern-matching website in answer: Question about episode 'The Wedding of River Song' by Adam on scifi.SE

Taryn

@JeremyBanks you're welcome

SmokeDetector

7:29 PM

[ SmokeDetector | MS ] Bad keyword in title, potentially bad keyword in body, blacklisted user: Has no human or animal died of zyklon b? by user29774 on history.SE

user315433

I don't know how these things work, it was just my impression that Id is the primary key of that table, so I was asking for the last ten rows. This was why I didn't query creation date.

rene

delv-pls 20K NSFW meta.stackexchange.com/a/307978/158100 /cc @Bart @Glorfindel @ShadowWizard @TravisJ

Shadow Wizard

@rene delete vote and red flag cast

rene

thanks

needs one more then

Shadow Wizard

But why NSFW?

It's just a face

(flagged as offensive as I don't know what's written)

rene

7:36 PM

Not just a face, those eyes ... they're starring at you

Shadow Wizard

oh it's some date in Arabic

rene

I was going to say your Arabic is better than mine ....

Shadow Wizard

8:11 PM

@rene well, it is... I learned it few years in school. :)

rene

OK

Catija

@Shog9 So... I've been busy since your last messages to me... I intentionally phrased my comment to be open and welcoming and to make the emphasis on them getting attention sooner. I understand what you're saying... the guidance from Tim helps... even your further explanation helps... but "don't do that"... not so much. Maybe I just hit a pet peeve of yours... fine... but there's a lot of shitty stuff people do on MSE and I didn't do that.

Anonymous

8:29 PM

@Taryn FYI FTP was mistaken, the dataset has been updated more recently than that. The ball has not been dropped.

Anonymous

Shadow Wizard

If I can chime in... I think the reasoning behind Shog's pretty "harsh" response is tons of emails he's getting (sent via contact form) with bug reports, which he then refer to MSE, i.e. asking those who sent it to post on MSE (or relevant per-site meta) instead. Just my two cents, and how I see it from my point of view over here. @Catija

oh oops I'm to blame, lol

@JeremyBanks what is this?

user315433

@JeremyBanks The date is "Jul 10, 2017, 10:51:55 PM" for the posts table, bigquery.cloud.google.com/table/…

user315433

That was the one I queried.

Catija

@ShadowWizard Hence the "maybe I just hit a pet peeve of yours"... But to not get any sort of "oh, you may actually have an explanation for this" or "my preferences may not be their preferences" when I responded... and Tim responded. It feels... meh. I try really hard to be respectful of people when I do things. I guess it would have been nice to have been given some benefit of the doubt.

user315433

8:36 PM

Granted, its description also says "Don't use this table - use posts_* instead". Which I didn't read.

Anonymous

@FTP Ah, I understand.

user315433

So the deprecated one was note updated (except perhaps to put that note). The other ones are indeed updated.

Shadow Wizard

@Catija not 100% sure I understand? Shog refered only to your advise to send email instead of posting a question on meta, not to your attitude, which is beyond any doubt good and respectful.

user315433

Which still isn't great if you want to query all posts, but...

Catija

@ShadowWizard Except that I was correct. They do prefer email. And, again... I didn't vote to close it, I gave them additional information on how to get help.

user315433

8:39 PM

Also, it seems Id has no special role in BigQuery, the rows are numbered by something else unrelated to Id. So querying the Id column is indeed scanning all rows.

Shadow Wizard

@Catija oh. Well, Shog jumped the gun then, probably before they had chance to discuss it internally.

Anonymous

@FTP Yeah, I just noticed that when I tried to find max(Id) and I exceeded the free query quota...

user315433

As an employee you should get larger free query quota than that

Shadow Wizard

@FTP umm... he's no longer an employee.

user315433

Although, $5 per TB, with the first TB per month free is not bad.

Shadow Wizard

8:49 PM

oh, in Google. lol

user315433

8:59 PM

A question that should be on the mod questionnaire: what to do about awful tag-based puns in meta titles?

Félix Gagnon-Grenier

awful!!!!????????!!!!!11111111oneoneoneone

you heaten

Shadow Wizard

@FTP example?

Catija

@FTP They're required in burnination/merge requests, last I checked.

Princess Luna

Such [doge]. Much burninate. WOW!

Catija

12

Q: Subtract [calculation]?

I recently encountered the calculation tag. The tag doesn't really add anything meaningful and can't stand on it's own, so I'd like to see it burn. It currently has 301 questions, 11 followers, and no excerpt or wiki. Some uses: Mathematical calculation in code. Should any code that includes ...

discussion burninate-request

Shadow Wizard

9:04 PM

ohhh, those

blech

:D

Catija

Some of them are sort of fun:

4

Q: Let's create a [digital] hell for this tag

The digital tag has 185 questions at the moment, 644 followers and no tag wiki. Does it describe the contents of the questions to which it is applied? and is it unambiguous? No, not at all. It's mostly used instead of (or with) digital-signature, but it gets tagged for questions with entirely ...

discussion burninate-request

Princess Luna

And:

93

Q: such [dogecoin]. much burninate. wow!

I came across the little-used dogecoin, 8 followers, 20 questions, and only one question looks somewhat relevant. So with no further ado: Does it describe the contents of the questions to which it is applied? and is it unambiguous? The questions are more about APIs or apps that use Dogecoin, ...

discussion burninate-request

user315433

@Catija Required in the sense of the experiment with five monkeys, a ladder, a banana and a water spray

Catija

@FTP Eh, it's required enough that a merge/burninate request on IPS received comments from someone saying that it failed to meet the need.

Also, it's bad form to make a burninate request without a pun in the title. — corsiKa Nov 6 '17 at 23:01

Princess Luna

What if there aren't any puns?

Ano

9:17 PM

@Shog9 Why doesn't this post show up on the homepage, between the two that were modified 2 and 4 hours ago?

Shog9

@Catija we're always open to emails. And if folks are asking how to report stuff, we'll occasionally specify email as the best option for various reasons even for the public site.

Catija

@Ano It's at -10...

Shog9

The danger with that as a stock recommendation is that we send folks into sort of a loop where they get repeatedly redirected and just give up.

Ano

@Catija Ah, overlooked that. I forgot what the MSE threshold was for a second

Catija

Questions at -8 or below don't show up on the home page.

Ano

9:19 PM

I thought it was below -10 for a moment

Shog9

Your attitude is fine. I wasn't criticizing that; just... Please try to avoid greeting folks with "try this other venue" whenever possible; a lot of folks will just walk away.

We ran into this problem repeatedly with Jobs -> Careers -> Careers 2.0 -> Jobs

Ano

May I ask, are you drafting an answer to the question of mine you retagged, or do you think the existing ones are sufficient?

Catija

It wasn't a stock recommendation.

Shog9

@Ano the ones there are fine

Ano

Did you see the comments, which say that it's not really possible in SEDE, because the queries also pick up suggested edits from registered users whose accounts were later deleted?

I think you should provide an answer as to what the internal technical details are and why they don't allow for it (if they don't).

Shog9

9:22 PM

if you can't differentiate them in SEDE, I'd say it's unlikely they could be readily differentiated internally

Ano

The question talks about edits, not suggestions, however. So is there no internal flag set on Community edits done by automated scripts?

πάντα ῥεῖ

Hi everybody!

Ano

@πάνταῥεῖ Heh, the original revision's a good way to say both "everybody" and "everyone"

πάντα ῥεῖ

@Ano Hi everyone (Ano)

Ano

@πάνταῥεῖ I'm not everyone

πάντα ῥεῖ

9:26 PM

Guys and gals ...

Ano

Not everyone's the fastest thing in the world

πάντα ῥεῖ

@Ano Sure, I know!

@Ano Being faster looses substance maybe :-P

Ano

The only one who nearly matches my speed is @Shadow the Hedgehog

3 mins ago, by Ano

The question talks about edits, not suggestions, however. So is there no internal flag set on Community edits done by automated scripts?

πάντα ῥεῖ

@Ano I'm in well time scheduled contact with shadowiz, no worries.

Ano

I thought this was fixed? meta.stackexchange.com/questions/307971/…

Shog9

9:31 PM

@Ano ok, what are you trying to do here?

Ano

See my edits and allow others to see them

...without the thousands of pages of automated edits getting in the way

Shog9

@Ano and why can't you do that with SEDE?

Ano

How would you filter out the automated script edits?

I detailed the different scripts at play. The HTTPS links, before that the MSO-MSE links, and before that, adding duplicate links to older duplicate closures.

πάντα ῥεῖ

I had some thoughts:
Some of you may well know, I was banned at SO and I ran a sock puppet that rep raised quickly for about half a year, and was tolerated by the SO mods (though there was even evidence about my identity) until I blew that in an Sylvester Hangover from chat (user0042):
What I'm wondering about is, what would happen if my main SO account is reinstantiated in a few month, and I would ask to merge these. Would the "user0042" ban be inherited?

Shadow Wizard

@πάνταῥεῖ pretty sure merge can't happen when one of the accounts is suspended. @Shog can confirm, right?

πάντα ῥεῖ

9:37 PM

@Ano I'm not such a big fan of "speed", though I liked to drive motorcycles years ago.

Shadow Wizard

@πάνταῥεῖ on second thought, if you merge an account into a suspended account, the result will still be a suspended account. But not the other way around, so... it's quite confusing.

πάντα ῥεῖ

@ShadowWizard Yup! That's exactly what I'm wondering about also. Hence that questions.

Shadow Wizard

@Ano the difference between us is that your speed is natural, inherited... my speed was gained through training and hard work. :D

@πάνταῥεῖ sure! Only SE staff can give real reply though, I was just guessing.

(even moderators can't merge anymore)

Ano

I remember, if, say, you had an account with a remaining suspension term of 3 days, and another with a remaining term of 5 days, and you merged them, the remaining term of the new merged account would be 8 days.

This was why the old "deposit" account on Super User was suspended for a long time.

(Basically, mods would take a spammer and suspend it for one year, and then merge it into the "deposit" account, back when they could merge users.)

It got deleted because I asked a question about it

πάντα ῥεῖ

I'm no longer trying to undergo the ban right now. There were really funny attempts and cool sock puppets. I have no clue how they (mods) had caught me; probably when I exposed these at the SOCVR :-D ...

@Ano Blah, blah!

Ano

9:46 PM

@πάνταῥεῖ What?

πάντα ῥεῖ

@Ano Blah, blah! But very fast ...

Ano

@πάνταῥεῖ What?

Feb 9 at 11:05, by Ano

@Derpy Whenever someone mentions me without asking me an actual question for me to answer, I always respond with "What?".

πάντα ῥεῖ

@Ano To be precise: I'm not interested into your "speedy" non answers about that topic

Ano

@πάνταῥεῖ You can't flag chat messages as NAA.

πάντα ῥεῖ

@Ano Sure, and I won't try to do so.

Ano

9:50 PM

Okay. Discussion closed.

πάντα ῥεῖ

@Ano At least the discussion with you, and TBH your behavior annoys me a bit.

M.A.R.

Whoa what the hell

Oh okay, not that dramaish

When I discuss with myself I get annoyed a bit

πάντα ῥεῖ

Speedy discussions with your _rubber ducky_ ;-) ...
Before attending the next meeting.

Shog9

@ShadowWizard they'd both be suspended

@Ano ok, try this:

select top 100 *
from PostHistory h
where PostHistoryTypeId in (4,5,6)
and UserId=-1
and not exists (select 1 from PostHistory s where h.RevisionGUID=s.RevisionGUID and PostHistoryTypeId=24)
order by CreationDate desc

that should be JUST Community edits - stuff like URL rewriting or that crazy retagging stuff I did a few times

No Community-attributed suggested edits

πάντα ῥεῖ

@Shog9 Thanks, that's what I thought also.

Shog9

9:56 PM

Edits from deleted users have a NULL UserId; they're not actually attributed to Community

πάντα ῥεῖ

@Shog9 Could that be done by mods automatically, after the ban is released from my main SO account?

^ That's one of my major concerns :-/

M.A.R.

If it's done by mods, it's not automatic, is it?

πάντα ῥεῖ

@M.A.R. Well, so if I don't ask for it (merging accounts), they just won't do it?

M.A.R.

@πάνταῥεῖ If your suspension is over, wouldn't it also be for other accounts?

Ano

@Shog9 I want the opposite

M.A.R.

10:08 PM

Or do you mean something else by "ban"?

Ano

I want just those Community edits resulting from approved anonymous edits, without the script edits.

πάντα ῥεῖ

@M.A.R. I don't think so. I'm talking about (tolerated) sock puppet accounts.

Ano

@πάνταῥεῖ Why?

user315433

I would try changing and not exists to and exists

πάντα ῥεῖ

@Ano Too speedy, less thought

M.A.R.

10:11 PM

@πάνταῥεῖ that's how chatting typically works

Ano

@FTP Perfect! Thanks

πάντα ῥεῖ

@M.A.R. Yup. But @Ano also answers too speedy at the Meta Stack Exchange IMO :-P ...

M.A.R.

That's how meta works? shrug

Shog9

@Ano so remove the "not"

πάντα ῥεῖ

@M.A.R. Wrah ... Dad attitude :-P

Ano

10:14 PM

@FTP @Shog9 data.stackexchange.com/meta.stackexchange/revision/821748/…

πάντα ῥεῖ

To be clear what I'm talking about: There's another suspended account of mine user0042, and I'm afraid my main account could be prolonged in suspension because some mod(s) getting the idea of it. @Shog9

Ano

Fixed this.

@πάνταῥεῖ [goes off to let the mods know] :)

(Just kidding)

πάντα ῥεῖ

@Ano I've been asking them primarily, if you didn't notice so far.

Ano

40 secs ago, by Ano

(Just kidding)

a.k.a. it's not relevant

Shog9

@πάνταῥεῖ so what do you want?

πάντα ῥεῖ

10:21 PM

@Shog9 Being sure not to be bitten in the ass :-P

Shog9

well, that's hard to promise

but I'd say if you avoid messing around you're probably fine

πάντα ῥεῖ

@Shog9 That's a statement :-)

Shog9

no one has requested a merge of those accounts just yet

πάντα ῥεῖ

@Shog9 I know a bit about @YvetteColomb's story, and I'm in good private contact with her ;-) ...

Shog9

then you kinda know... The trick with suspensions is to give some indication that you're not just biding your time until you can go back to whatever got you suspended in the first place

user310756

10:26 PM

@πάνταῥεῖ huh? I'm not sure what this has to do with me and yeh we chat privately from time to time

πάντα ῥεῖ

@YvetteColomb Just to cite "The queen of suspensions" :-) No worries!

user310756

@πάνταῥεῖ oh yeh I try to avoid repeating the behaviour that got me suspended in the first place as @Shog9 said, but you know that, I've been frank with you :)

πάντα ῥεῖ

@YvetteColomb I can confirm that you were frank all the time!

user310756

@πάνταῥεῖ :)

Catija

Frank? I thought she was Yvette.

Shog9

10:30 PM

so THAT'S what happened to Frank!

user310756

Nice to see you back on this account @πάνταῥεῖ

Shog9

I've been wondering where he got off to

user310756

@Catija you know what - we had a running joke in our family, my Grandfather was called Frank and my Nanna Mary - when anyone said - "well to be Frank" we'd say "what about Mary?" :D great minds and all that

user310756

@Shog9 we had a horse called Frank! (yes after my grandfather)

Shog9

was he a tree-like Tavern regular for a while?

πάντα ῥεῖ

10:32 PM

@YvetteColomb I'm doing my best, and going to contribute with moderation at sites with lower throughput than Stack Overflow.

user310756

@πάνταῥεῖ yeh - it's a matter of staying off the site when not in the right frame of mind - for me too, for everyone

user310756

@Shog9 huh?

Catija

Frank, Lancaster, Pennsylvania

1.8k 1 12 24

discussion feature-request bug per-site-meta support site-promotion answers

πάντα ῥεῖ

:-P : youtube.com/watch?v=6E2hYDIFDIU

^@Catija

user310756

ah

Anonymous

10:43 PM

4

Q: Indexes on BigQuery Table

I have a use case in which we have a few tables in BigQuery. Now I want to implement an index on one of the columns in the BigQuery table. But I am not finding enough documentation to do that. I found a few blogs and posts mentioning BigQuery doesn't support indexes. Please help me find a blog or...

cloud google-bigquery

Anonymous

no indexes. :P

πάντα ῥεῖ

@Ano No offence. But you're a user for several month, and you don't have all the background and interaction with well known users here. Thus your "speedy responses" just reveal that, and are going useless in vain. That's what I've mentioned, when saying that you're annoying sometimes. I don't want to push you off, but probably slowing down speed and getting experienced in more depth. Just my 2¢!

Ano

No problem

πάντα ῥεῖ

@Ano So you give up that attitude?

Ano

I just said, "no problem".

So, I found 464 anonymous edits made by anyone before my coming out, and after the end of 2013.

@Shog9 Why does this query have duplicate entries?

data.stackexchange.com/meta.stackexchange/revision/821748/…

Shog9

10:53 PM

@Ano title, body, tags - three history types