Charcoal HQ

Mithrandir

2:01 PM

When did Arduino start getting hit badly?

Glorfindel

MS search knows.

It may be a graduation present :P

tripleee

@JF ah, right you are, thanks!

@Mithrandir metasmoke.erwaysoftware.com/…

the graph (rightmost tab) only goes a month back, though ... looks fairly regular

the dip around Jun 26 mirrors a dip across all sites (holiday in India?)

SmokeDetector

[ SmokeDetector | MS ] Bad keyword in answer: Stopping unsolicited emails in particular Viagra & Cialis by Jacqueline Foret on superuser.com

naa- by Glorfindel

Henders

@SmokeDetector Translation: Can you tell the site viagra & cialis to stop sending me emails everyday like that do not interest me at all I start to get fed up with seeing it every day thank you to remove it quickly

What on earth is wrong with the font on arduino? o.O

Can barely read it

J F

Why does SE have a line for mod elections?

> You get to enter the line for a community moderator election. Based on the number of other sites waiting, your election should happen in August.

Mithrandir

2:16 PM

...what?

From?

J F

16

Q: Congratulations, Arduino SE is graduating!

It's been a long road (over 1200 days, and that's just counting this most recent attempt at building an Arduino community), but I have good news: Arduino Stack Exchange is graduating! Congratulations to all who participated, especially the moderators and regular users who gave so much of their ...

tripleee

@Henders looks the same as the other sites here, Chrome on MacOS

Mithrandir

Because elections are manually set up and watched by the team

Henders

@tripleee Derp - sorry I mean Android...

J F

@Mithrandir ah, ok.

@Henders norepro. Got a screenshot?

Henders

2:24 PM

@JF Sorry, I meant android :P

tripleee

@JF it's a bit thinner than e.g. the Arduino site for me, but not illegible

Henders

J F

Henders

Certainly not pleasant to read...

J F

norepro ^^

font-family: Roboto, 'Helvetica Neue', Helvetica, Arial, sans-serif;

tripleee

2:28 PM

not a huge difference for me

Henders

It looks nice for you @JF but not on mine :P

tripleee

I'm guessing your local fonts are screwed somehow

or that particular font

SmokeDetector

[ SmokeDetector | MS ] Bad keyword in answer: Any heath benefits of having butter coffee? by Emmac on coffee.SE

fp- by Glorfindel

[ SmokeDetector | MS ] Manually reported answer: Software patent implementations license by Number 1 Credit Repair Outsour on patents.SE

tpu- by Glorfindel

tripleee

!!/blacklist-keyword credit\W?repair

3/3

SmokeDetector

@tripleee Blacklisted credit\W?repair

tripleee

2:37 PM

hmmm, some legit hits on money

SmokeDetector

CI on b38e050 succeeded. Message contains 'autopull', pulling...

tripleee

though several of those look spammy too

SmokeDetector

[ SmokeDetector ] SmokeDetector started at rev b38e050 (SmokeDetector: Auto blacklist of credit\W?repair by tripleee --autopull) (running on teward/Solar Flare)

Restart: API quota is 13387.

tripleee

only a couple of them are legit i think, most of the other hits are through "related questions"

ArtOfCode

@Undo done

SmokeDetector

3:01 PM

[ charcoal-se.github.io ] continuous-integration/travis-ci/push success on 7fe3157: The Travis CI build passed

tripleee

@SmokeDetector hmmm? Looks like this was belatedly triggered by me editing something in the wiki

SmokeDetector

[ charcoal-se.github.io ] continuous-integration/travis-ci/push success on 7fe3157: The Travis CI build passed

J F

@tripleee Yep, that’s what happens. MS updates the site.

tripleee

@JF but that commit was 4 days old

and I don't see any builds scheduled for the changes I committed just now

J F

@tripleee MS uses the Travis API to restart the most recent build.

It should be all up-to-date. (builds only take ~2 minutes)

tripleee

3:14 PM

@JF so do I need to do something still to have this built? github.com/Charcoal-SE/SmokeDetector/wiki/Home/…

and this github.com/Charcoal-SE/SmokeDetector/wiki/…

SmokeDetector

fp- by Mithrandir on How to solve leverage browser caching? [MS]

tripleee

I don't see how the wiki changes map to any repository, was it wrong to click "Edit on Github"?

J F

@tripleee Nope, that was the right action, and the website is up-to-date.

SmokeDetector

tpu- by Mithrandir on Are there luggage lockers in Athens international airport? [MS]

tripleee

@JF but where are my changes then? or how do I submit them to apply to charcoal-se.org?

Mithrandir

3:17 PM

!!/watch leaveyourluggage\.gr

SmokeDetector

@Mithrandir Added leaveyourluggage\.gr to watchlist

tripleee

or do I just wait?

J F

@tripleee MS watches the wiki and automatically updates charcoal-se.org when it changes.

tripleee

the wiki dropdown on charcoal-se.org/smokey still shows the old content

ArtOfCode

well if you wanna be technical... GitHub tells MS when the wiki updates, and MS kicks off a Travis build to the master branch, which is what gets displayed on MS

tripleee

3:19 PM

or rather, the wiki dropdown on charcoal-se.org links to smokey/ which still contains the old version

SmokeDetector

CI on b884e3d succeeded. Message contains 'autopull', pulling...

[ SmokeDetector ] SmokeDetector started at rev b884e3d (SmokeDetector: Auto watch of leaveyourluggage\.gr by Mithrandir --autopull) (running on teward/Solar Flare)

tripleee

@ArtOfCode so do I just wait, or did it get lost somehow?

SmokeDetector

Restart: API quota is 12845.

J F

@tripleee ⇧⌘R or ctrl+shift+r

ArtOfCode

@tripleee it's there. Look at charcoal-se.org/code

tripleee

3:20 PM

@JF aaaaaahhhhhh of course!!! sorry, stupid me

ArtOfCode

It's on this wiki commit

tripleee

... should I blame caching?

J F

@tripleee don’t worry about it :)

tripleee

thanks for your patience

J F

@tripleee yep.

SmokeDetector

3:21 PM

[ SmokeDetector | MS ] Link at end of answer: Move my Windows 10 installation (Upgraded) to a new hard drive without formatting the destinantion drive by KMKMAHESH on superuser.com

tp- by Mithrandir

pff

naa- by Mithrandir

!!/watch azedo\.com

@Mithrandir That pattern looks like it's already caught by Potentially bad keyword in answer and Potentially bad keyword in body; use !!/watch-force if you really want to do that.

Mithrandir

!!/test applop

SmokeDetector

3:23 PM

> Would not be caught for title, body, and username.

Mithrandir

!!/test com.applop

SmokeDetector

> Potentially bad keyword in body, potentially bad keyword in title, potentially bad keyword in username
----------
Title - Position 1-11: com.applop
Body - Position 1-11: com.applop
Username - Position 1-11: com.applop

Mithrandir

!!/test jamesprada.net

SmokeDetector

> Potentially bad keyword in body, potentially bad keyword in title, potentially bad keyword in username
----------
Title - Position 1-15: jamesprada.net
Body - Position 1-15: jamesprada.net
Username - Position 1-15: jamesprada.net

Mithrandir

Hmm, autoflagged=no is still broken

SmokeDetector

3:27 PM

[ charcoal-se.github.io ] continuous-integration/travis-ci/push success on 7fe3157: The Travis CI build passed

tripleee

@SmokeDetector does it keep on building that particular commit, like, forever?

Mithrandir

@Henders

12

Q: All text on Android.SE and its meta are showing up grayed out

Basically all text on Android.SE and its child meta are showing up as gray when I use Google Chrome, but it appears fine on Firefox. Chrome: An answer: Main page: Meta: Firefox: Main: Meta: I'm using Ubuntu.

bug design

Henders

3:43 PM

@Mithrandir Exactly what's happening! I'll keep an eye on that :O

J F

3:56 PM

Should we enable cgitb for SmokeDetector?

quartata

Doubt it would work since we install our own exception hook

J F

@quartata Replace this line with tr = '\n'.join(cgitb.text((exctype, value, tb)))

Thomas Ward

@tripleee can you re-review the PR?

CI should pass, I just removed the parts you commented on is all. But ultimately there's nothing wrong with ultra nested try/excepts with individual 'raise' functions to make sure those exceptions are actually raised.

ArtOfCode

4:14 PM

There's nothing really wrong with them, but they introduce unnecessary latency. Microseconds, but it's there. If your except block catches the exception, it's already been raised, so you don't need to re-raise it.

SmokeDetector

Merged SmokeDetector #969.

CI on ddf3871 succeeded. Message contains 'autopull', pulling...

[ SmokeDetector ] SmokeDetector started at rev 6c2f430 (metasmoke: Merge pull request #969 from Charcoal-SE/auto-blacklist-1500461259.9744322) (running on teward/Solar Flare)

Restart: API quota is 11971.

Henders

4:30 PM

Only 10 candidates now... :O

quartata

@JF I'll test it in NG

J F

12

A: 2017 Moderator Election Q&A - Questionnaire

Based on the discussions in the comments, I have decided to withdraw from the election this year. While I do feel that I would be a good moderator for Stack Overflow, I have realized that I have not been a major part of the community in recent times. Looking at the facts as they stand, I felt th...

Henders

Wow, the people commenting are not holding back

J F

@Raghav Sood: The point meagar is making is that you have been running in elections for several years now, but your activity has dramatically decreased in the past 2-3 years, and you now only make your presence known whenever there's an election. You've been saying every year that you'll contribute regardless of whether or not you win, but your activity in recent years shows otherwise. What gives? — BoltClock ♦ yesterday

That’s not a good sign for a moderator

M.A.R.

@Henders the comments mostly seem to be from before withdrawal

Nonetheless, this is situation I won't want to be in

Haaaawkward o.o

Henders

4:41 PM

Yeah

This one specifically:

You have a pattern over many years of being almost completely inactive on the site and then appearing around the time of moderator elections to nominate yourself. You're currently doing virtually nothing to help moderate the site with the tools already made available to you. In fact, you've taken only ~30 actions on the site in the last 365 days. While you have a high flag count, you've raised only 11 helpful flags since 2014. Why do you feel access to additional moderation tools should be granted to you, when you have not been using the ones already at your disposal? — meagar ♦ yesterday

Pretty damning

quartata

I swear it seems like just when I thought I knew all the SO mods

SmokeDetector

[ SmokeDetector | MS ] Username similar to website in answer: What significant improvement will I get if I upgrade to Canon EOS 6D from EOS APSC 600D? by Specced on photo.SE

fp- by J F

Thomas Ward

@triplee hint comments? You mean the type hints?

type hint resources are in PEP documentation

483 for theory, 484 for rules.

python.org/dev/peps/pep-0483

python.org/dev/peps/pep-0484

@tripleee ^

SmokeDetector

[ SmokeDetector | MS ] Bad keyword in body, bad keyword in title, blacklisted website in body, link at end of body, pattern-matching website in body, +1 more: CLA Safflower Oil For example last season, by uneebpas on askubuntu.com (@ThomasWard)

NobodyNada

\o

SmokeDetector

4:56 PM

tpu- by Glorfindel

o/

|o

o¡

o̅

Jul 7 at 17:00, by J F

°ᓰ

M.A.R.

5:02 PM

Ö}

J F

5:13 PM

> Police: Murder victims “eerily silent” during hourslong interrogation

ArtOfCode

@Mithrandir I have finally just figured out why it's broken. The bad news is the fix is either slow, complicated, or both.

I will attempt to explain, in case anyone here can figure it out:

We have a posts table and a flag logs table, posts and flag_logs respectively.

If a post has been autoflagged, it has a flag log record with flag_logs.post_id equal to that post's ID.

That's easy: to query for autoflagged posts, we can just select from posts, inner join flag_logs.

However, there are two possible database scenarios for posts that haven't been autoflagged.

Either they haven't been flagged at all, in which case there are no flag_logs; or they've been manually flagged, in which case there's a flag log record with flag_logs.is_auto = 0.

Our original query for "not autoflagged" was SELECT * FROM posts LEFT JOIN flag_logs WHERE flag_logs.id IS NULL OR flag_logs.is_auto = 0.

The theory being that flag_logs.id IS NULL covers the "no flag logs" scenario, and the flag_logs.is_auto = 0 covers the "manually flagged" scenario.

However, the bug is that flag_logs.is_auto = 0 doesn't account for the fact that you can have a flag log with is_auto = 0 and still have autoflag flag logs on the same post.

That's why autoflagged posts were getting included in searches for autoflagged=no

To fix that, I need a query that says WHERE flag_logs.id IS NULL OR (flag_logs.is_auto = 0 AND there are no other flag_logs for this post ID).

If you haven't already figured it out, the "there are no other flag logs for this post ID" is where I'm having trouble.

I suspect it's going to need subqueries. Those are fine in SQL, but a massive PITA with ActiveRecord.

and also probably slow

doppelgreener

5:30 PM

@ArtOfCode Does this query need to return questions or all their logged flags or both?

ArtOfCode

@doppelgreener posts

It's a SELECT posts.*, technically

doppelgreener

So you want all information on questions that either have no connected flag_logs entries, or record flags but none of them have the flag_logs.is_auto property set to 1

ArtOfCode

@doppelgreener correct

doppelgreener

Ok, thanks. I've pinged someone who enjoys puzzling over challenging SQL queries, they might have some perspective in how to achieve this.

SmokeDetector

[ SmokeDetector | MS ] Offensive answer detected: DRAW UML DIAGRAM JAVA by Pedram Haghzaban on stackoverflow.com

tpu- by Glorfindel

ArtOfCode

5:42 PM

@doppelgreener Cheers. I can probably do it in SQL, but the translation to AR could be more of a problem.

SmokeDetector

[ SmokeDetector | MS ] Few unique characters in body, no whitespace in body, repeating characters in body: How to read the .Rpt file and insert the data into MS Access dataBase? by karthik m on stackoverflow.com

Glorfindel

@SmokeDetector v

J F

What happened to the SE 1.0 lit.SE?

ArtOfCode

It died

probably

doppelgreener

it did died

M.A.R.

5:46 PM

It died did

Henders

Died it did

SmokeDetector

[ SmokeDetector | MS ] Blacklisted user: Android card guessing game by Pedram Haghzaban on stackoverflow.com

Glorfindel

It was heated to 451F.

J F

not died didn’t it

SmokeDetector

fp- by Glorfindel

J F

5:48 PM

@Glorfindel Ah, the temperature at which most nations’ legal systems catch fire and burn.

SmokeDetector

[ SmokeDetector | MS ] URL in title, link at end of body: online-tvchannel.org/ by jon son on drupal.SE

tpu- by ArtOfCode

Glorfindel

@JF and most literature.

M.A.R.

This SO election has some great candidates, and I'm optimistic that Andy will finally win this time

ArtOfCode

Andy was the first runner-up last time around, so he should get it

Brock Adams

!!/report stackapps.com/questions/7512/…

SmokeDetector

6:00 PM

[ SmokeDetector | MS ] Manually reported question: How to Challenge Boss in Battleships Blood Sea? by umarmar on stackapps.com

tpu- by J F

J F

This is "name drop" spam and spam seed. See the "answer". — Brock Adams 1 min ago

Brock Adams

:)

J F

@ArtOfCode since, due to an un expected twist of fate, none of the candidates who won last time are up for re-election this year

M.A.R.

@JF aye aye

Umarmar hahaha

SmokeDetector

[ SmokeDetector | MS ] Bad keyword in body: Obtaining the eta2 table provided in the FactoMineR package by bashmike on stackoverflow.com

Sconibulus

6:15 PM

@SmokeDetector fp-

ArtOfCode

6:28 PM

At the expense of my sanity and that of anyone who has to maintain this code in the future... I may have cracked it.

SmokeDetector

6:41 PM

[ SmokeDetector | MS ] Manually reported answer: Internal Server Error 500 when submitting PHP form to email by mcgregor fight on stackoverflow.com

M.A.R.

@SmokeDetector k I guess

SmokeDetector

7:03 PM

[ SmokeDetector | MS ] Offensive answer detected: Grub : linux command not found by Eat this os on superuser.com

tpu- by Henders

SmokeDetector

7:15 PM

Conflicting feedback on Grub : linux command not found.

Henders

@SmokeDetector Doesn't appear to be...

SmokeDetector

[ SmokeDetector | MS ] Username similar to website in answer: copy a linked list with next and random pointer, only read privileges are given on list by traceformula on stackoverflow.com

rene

7:30 PM

@Henders yeah, I screwed up in the Tavern, I already fixed it in MS

Henders

Ah, I thought smokey was losing it!

rene

@DavidPostill will handle it now I guess ...

DavidPostill

@rene Yeah, on it.

The user is toast :)

rene

Sorry if my initial error caused the automatic flagging to stall

ArtOfCode

@rene you'd have to try a lot harder than that to break autoflagging

rene

7:39 PM

goes trying...

ArtOfCode

As in, I'm not even sure I can break it. You'd probably have to be Undo and turn the server off to break it entirely.

rene

turn the server off seems doable, becoming Undo not so much ...

J F

@ArtOfCode There is !!/stopflagging…

SmokeDetector

[ SmokeDetector | MS ] Bad pattern in URL answer: IE8 Object doesn't support property or method 'addEventListener' Jquery 3.1.1 by Andrew Losseff on stackoverflow.com

fp- by Floern

Alexander O'Mara

8:00 PM

@SmokeDetector Not sure it doesn't like like that URL...

DavidPostill

!!/report superuser.com/a/1231417/337631

SmokeDetector

[ SmokeDetector | MS ] Manually reported answer: How to find hyperlinks in Excel 2010 and de-activate them? by Esoft Tool on superuser.com

Alexander O'Mara

I'm guessing /browser-support/ somehow?

J F

lol SE has one review on Yelp, and it’s a one-star.

Floern

@AlexanderO'Mara yep, *-support in an url is a pattern, see github.com/Charcoal-SE/SmokeDetector/blob/…

J F

8:05 PM

I also like how reviews can be useful, funny, or cool, but not useless or unhelpful.

SmokeDetector

8:22 PM

CI on 6628070 failed.

CI on 2e555d2 succeeded.

ArtOfCode

@JF sure, but any of 5 people can just turn it on again

SmokeDetector

8:36 PM

[ SmokeDetector | MS ] Link at end of answer: Sorting table with rowspans by user6740908 on stackoverflow.com

[ SmokeDetector | MS ] Username similar to website in answer: \$1 __webpack_require__(...) is not a function\$1 when using babel 6 by Matthias Sommer on stackoverflow.com

[ SmokeDetector | MS ] Pattern-matching website in answer: php mysql link dynamic category drill down by empati seo on stackoverflow.com

tpu- by Floern

SmokeDetector

8:54 PM

[ SmokeDetector | MS ] Username similar to website in answer: Webpack Externals require not defined with Electron and Angular 4 by Matthias Sommer on stackoverflow.com

[ SmokeDetector | MS ] Bad keyword in answer, bad keyword with email in answer, potentially bad keyword in answer: How might the Chinese government be blocking only specific types of WhatsApp traffic? by caroline hundderson on security.SE

tpu- by Floern

NobodyNada

9:17 PM

Ha, this is a fun audit

We should probably be leaving comments like @Mith's whenever the spam is not obvious -- I would have failed that audit otherwise.

SmokeDetector

[ SmokeDetector | MS ] Link at end of body: Creating Excel Rows Based on Certain Criteria by anonymyous on superuser.com

fp- by NobodyNada

[ SmokeDetector | MS ] Username similar to website in answer: Make two vimeo videos side by side, centered, and responsive by Arcencielstudio on stackoverflow.com

naa- by Floern

SmokeDetector

9:40 PM

[ metasmoke ] ci/circleci failure on ece6de8: Your tests failed on CircleCI

[ SmokeDetector | MS ] Manually reported answer: Creating a 'website builder' - How would I architect it? by Saurav Aggarwal on stackoverflow.com

[ SmokeDetector | MS ] Blacklisted user: website builder web development by Saurav Aggarwal on stackoverflow.com

naa- by ArtOfCode on Creating a 'website builder' - How would I architect it? [MS]

[ metasmoke ] ci/circleci success on 591defc: Your tests passed on CircleCI!

ArtOfCode

@Mithrandir fixed pending deploy.

cc @Undo

J F

10:05 PM

@NobodyNada Does the audit show comments?

NobodyNada

@JF Yep; I saw Mith's comment.

That effectively makes comments a permanent note we can leave for reviewers/10kers, which seems like a good idea for tricky spam

Especially since we've had problems in the past with tricky stuff we flagged getting thrown into LQP and giving people "impossible" audits

SmokeDetector

[ SmokeDetector | MS ] Link at end of answer, potentially bad keyword in answer: filter decimal column in phpGrid by Elman on stackoverflow.com

Undo

@ArtOfCode Done

ArtOfCode

@Undo Ta. I'm already working on a better fix - cache autoflag status on the Post model

SmokeDetector

[ SmokeDetector | MS ] Bad keyword in answer, bad keyword with a link in answer, blacklisted website in answer: Why does blood seep from the eye of Le Chiffre in Casino Royale? by Panharith on movies.SE

naa- by DavidPostill on filter decimal column in phpGrid [MS]

tpu- by DavidPostill

[ SmokeDetector | MS ] Blacklisted user: Is it necessary to watch all the James Bond movies before Casino Royale to understand James Bond movies from 2006 onwards? by Panharith on movies.SE

[ SmokeDetector | MS ] Link at end of answer, potentially bad keyword in answer: Check file exist or not using PHP grid by Elman on stackoverflow.com

naa- by DavidPostill on Is it necessary to watch all the James Bond movies before Casino Royale to understand James Bond movies from 2006 onwards? [MS]

DavidPostill

10:21 PM

@SmokeDetector Hmm. 2 identical posts promoting his framework (with disclosure). Neither really answers the question though ...

SmokeDetector

Restart: API quota is 8357.

Petter Friberg

@DavidPostill They have been spamming with that web site (using multiple accounts, with name of first, second ecc), I think @NobodyNada added it in blacklist, maybe it has not been included yet. If you like to see some link to post I can provided'em

angussidney

@ArtOfCode (only 4 now)

Petter Friberg

@DavidPostill check out this metasmoke.erwaysoftware.com/…, even if not marked as tp, they are bascially all spam and I think SO mods deleted all of them

ArtOfCode

@angussidney yeah that

DavidPostill

10:35 PM

@PetterFriberg Thanks. Noted for future reference.

NobodyNada

Some of those have affiliation disclosed

If not for that, I'd definitely upgrade it to a blacklist

Petter Friberg

Yeah I have always custom mod flagged them, with all reference and I guess SO mods have spam nuked it not only because account named first and second posting same links at same time, they probably also have other info.

NobodyNada

Interestingly, there's a different product at phpgrid.com, but it doesn't look like they're spamming us

Petter Friberg

I have no doubt that they are trying to spam the link on SO

NobodyNada

This is the only one that hasn't been deleted. It discloses affiliation, but all the other ones with affiliation disclosed have been deleted. Should we go ahead and nuke it?

Petter Friberg

10:41 PM

This for example was upvoted and delete by Brad stackoverflow.com/a/45132273/5292302 (probably no flags)

J F

upvoted? :P

Petter Friberg

Just the fact that they are posting same stuff multiple times on same question with different accounts is iffy

NobodyNada

Although the one I linked above is actually an answer to the question. The question's a tool rec though; should we just delete the whole thing? (cc @Petter since you're 10k on SO)

J F

@PetterFriberg Oh, I thought you meant upvoted by Brad.

DavidPostill

@NobodyNada At least that one attempts to answer the question (I've no idea if it is correct or not). Most of them just seem to be a link with no attempt made to explain how to use the product. That to me smells like spam.

Petter Friberg

10:49 PM

baah anyway SO mods currently are considering it spam (the two last post where spam nuked by SO mods not deleted), I'm back to NAA have fun :D

@JF ;), well maybe who knows?

@NobodyNada Need to wait another day, but I will favorite and send a delv-request

NobodyNada

thanks!

SmokeDetector

[ SmokeDetector | MS ] Link at end of answer: Sort a table that is created using document.write() in javascript by user6740908 on stackoverflow.com

NobodyNada

datatables.net seems like a reputable product

SmokeDetector

[ metasmoke ] ci/circleci error on 6a44fb4: Your CircleCI tests were canceled

ArtOfCode

@NobodyNada it is, I've used it a bunch

SmokeDetector

10:57 PM

[ metasmoke ] ci/circleci success on fb35739: Your tests passed on CircleCI!

ArtOfCode

That should be good to deploy and a whole lot faster, @Undo

Miniman

@ArtOfCode If you just need columns from posts, couldn't you do SELECT posts.* FROM posts LEFT JOIN flag_logs GROUP BY posts.* HAVING SUM(flag_logs.is_auto) = 0 ?

ArtOfCode

@Miniman Does HAVING SUM(flag_logs.is_auto) = 0 account for nulls?

Miniman

(You can't actually use * in group by statements, so you'd have to list out the columns manually)

Thomas Ward

stupid question: how's the pickle system working now

!!/location

SmokeDetector

11:03 PM

@ThomasWard teward/Solar Flare

Thomas Ward

!!/rev

SmokeDetector

@ThomasWard 6c2f430 (metasmoke: Merge pull request #969 from Charcoal-SE/auto-blacklist-1500461259.9744322)

ArtOfCode

@ThomasWard no idea if it's even pulled yet

Thomas Ward

!!/gitstatus

SmokeDetector

On branch deploy
Your branch is up-to-date with 'origin/deploy'.
nothing to commit, working directory clean

Miniman

11:03 PM

@ArtOfCode Yep, SUM ignores nulls, so the result will be 0 if all values are null.

Thomas Ward

!!/pull

SmokeDetector

[ SmokeDetector ] SmokeDetector started at rev 2e555d2 (ArtOfCode: Merge pull request #963 from Charcoal-SE/proper_pickle_invalid_encoding_Handling) (running on teward/Solar Flare)

Restart: API quota is 8099.

Thomas Ward

@ArtOfCode it isn't pulled...

but it is now.

ArtOfCode

@Miniman Then yep, I could have done. Cheers :)

Miniman

@ArtOfCode Hope it helps! :)

ArtOfCode

11:05 PM

I've ended up converting it all to a cached attribute on the posts table anyway because performance, but if when we need to build extra stuff on top of that it'll come in handy :)

Thomas Ward

hums to himself

SmokeDetector

[ SmokeDetector | MS ] Few unique characters in body, repeating characters in body, repeating characters in title, title has only one unique char: zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz by WentzWagon on academia.SE

NobodyNada

sd v

Floern

sd v

SmokeDetector

[ SmokeDetector | MS ] Few unique characters in answer, repeating characters in answer: zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz by WentzWagon on academia.SE

[ SmokeDetector | MS ] Manually reported answer: Can you draw Area objects with Graphics g? by Red Hood on stackoverflow.com

Floern

11:13 PM

sd - v

SmokeDetector

naa- by teward on zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz [MS]

[ SmokeDetector | MS ] Blacklisted user: Java - Space complexity with variable by Red Hood on stackoverflow.com

[ SmokeDetector | MS ] Bad keyword in body: Are there more witnesses for aliens or the holocaust? by James on skeptics.SE

fp- by NobodyNada on Java - Space complexity with variable [MS]

NobodyNada

@SmokeDetector why

SmokeDetector