I disagree, but you may have your own opinion, of course.

So far we have 1 TP and 2 NAA feedbacks.

@ArtOfCode I don't even know what language that is :P

[ SmokeDetector | MS ] URL in title, bad keyword in body, link at end of body, pattern-matching website in body, pattern-matching website in title: healthchatboard.com/zyalix/ by kiyamenjiyos on security.stackexchange.com (@HenryWHHackv2.0 @Oldskool)

[ SmokeDetector | MS ] Blacklisted website in answer, link at end of answer: How to enable the <br /> tag in Wordpress posts and pages by Vijay Singh on wordpress.stackexchange.com

CI on 651f85c succeeded. Message contains 'autopull', pulling...

[ SmokeDetector ] SmokeDetector started at rev 651f85c (Undo1: Let's try this --autopull) (running on Raspberry Pi)

Restart: API quota is 7324.

!!/pending

hmrph

!!/pending 1

Restart: API quota is 7322.

!!

!!/errorlogs 100

  File "/media/sdb1/SmokeDetector/ChatExchange/chatexchange/browser.py", line 107, in post
    return self._request('post', url, data, headers, with_chat_root)

  File "/media/sdb1/SmokeDetector/ChatExchange/chatexchange/browser.py", line 96, in _request
    response.raise_for_status()

  File "/usr/local/lib/python2.7/dist-packages/requests/models.py", line 840, in raise_for_status
    raise HTTPError(http_error_msg, response=self)


ValueError: invalid literal for int() with base 10: 'meta.stackexchange.com'

oh

@Undo C#

Ah right

tpu- by DavidPostill

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

Restart: API quota is 7297.

!!/pending 1

Restart: API quota is 7275.

!!/errorlogs 100

  File "/media/sdb1/SmokeDetector/ChatExchange/chatexchange/browser.py", line 696, in _runner
    self.on_activity(json.loads(a))

  File "/media/sdb1/SmokeDetector/ChatExchange/chatexchange/rooms.py", line 81, in on_activity
    event_callback(event, self._client)

  File "/media/sdb1/SmokeDetector/chatcommunicate.py", line 166, in watcher
    message_id=message_id)

  File "/media/sdb1/SmokeDetector/chatcommunicate.py", line 233, in handle_commands
    return cmds[command](**command_parameters)

dev on prod, yay

um, okay

@Undo it's weekend, and outside the happy hour, nothing to worry about

Why are we calling m.erwaysoftware.com? I think that's what the error is complaining about.

Also, a fine rainy Saturday to you all.

@Andy Shortcut for saving some chars in chat messages (try it), but it doesn't need to be in the code

Not sure why Python complains. Even Chrome doesn't complain, SSL should be set up fine

Oh. I assumed "m" meant "mobile". I suppose I should have tested

Does python support SNI(Server name indication)? If not it will get the default ssl certificate from MS

CI on 8aefcc2 succeeded. Message contains 'autopull', pulling...

[ SmokeDetector ] SmokeDetector started at rev 8aefcc2 (Undo1: This --autopull) (running on Raspberry Pi)

Restart: API quota is 7254.

!!/pending 1

this is taking too long :P

Restart: API quota is 7243.

!!/errorlogs 100

  File "/media/sdb1/SmokeDetector/chatcommands.py", line 708, in command_pending
    message="Expected an integer page number and got '{}' instead (ValueError).".format(page))


ValueError: invalid literal for int() with base 10: 'stackexchange.com'
2016-10-01 14:32:00.750248 UTC
  File "ws.py", line 49, in <module>
    GlobalVars.smokeDetector_user_id[GlobalVars.charcoal_room_id] = str(GlobalVars.wrap.get_me().id)

  File "/media/sdb1/SmokeDetector/ChatExchange/chatexchange/client.py", line 125, in get_me

@Undo Can't you just use the unit tests to quickly test the command? Just mock the MS http(s) requests

@Ferrybig I guess there needs to be some additional packages installed to support SNI: stackoverflow.com/questions/18578439/….

@Ferrybig This time it's an issue in metasmoke, so it'd still break

The API route is returning valid JSON... there's nothing in it, which seems a little odd, but it is valid JSON.

@ArtOfCode yeah, I know what's wrong

what did I do

or not do

github.com/Charcoal-SE/metasmoke/commit/…

Rails doesn't like comparing strings and numbers for whatever reason

@Undo ...huh? None of the others do that, and they've always worked fine...

!!/pending 1

@ArtOfCode shrug I dunno.

Request succeeded this time

!!/errorlogs 100

Old error

So... yeah, I think it works

In that case, why are we getting {"items":[],"has_more":true} out of the API?

there can't be no items and more items available

Backoff received of 10 seconds on request to questions/572544;572539;569983;572546;572546;569983;572536;572548;572536;572508‌​?site=ru at 15:01:38 UTC

@ArtOfCode well that's weird

There should be items there, because I'm sure not every tp post has deletion log records.

Have I got the AR query right?

@posts = Post.includes(:deletion_logs).where(:is_tp => true, :deletion_logs => { :is_deleted => true })

...no, okay

Should work

I want posts where there are no deletion logs

oh right

rather than posts where there are deletion logs that say they're deleted, not sure what I was thinking there

there, that push should fix

!!/pending 1

!!/pending 1

metasmoke is currently crapping itself

6133.4ms load time

yeah, someone's loading the dashboard repeatedly

blah

!!/pending 1

@Undo the API route ain't loading at all

@Undo if the IP begins with an 8 it's probably me

Your query is still running. I think it's borken

@Undo I ran SSL Labs on it but that was 20-30 minutes ago.

!!/pending 1

!!/alive?

@Undo blame this guy :)

reboot the DB server?

[ SmokeDetector ] SmokeDetector started at rev 8aefcc2 (Undo1: This --autopull) (running on Raspberry Pi)

Restart: API quota is 7132.

D, [2016-10-01T15:11:56.564027 #20912] DEBUG -- :    (181648.1ms)  SELECT COUNT(DISTINCT `posts`.`id`) FROM `posts` LEFT OUTER JOIN `deletion_logs` ON `deletion_logs`.`post_id` = `posts`.`id` WHERE `deletion_logs`.`post_id` IS NULL

I'm just gonna say that's not a great query

181648.64ms? O-kay then. It's the right query, though.

hang on MySQL doesn't do left outer joins does it?

or was that full outer joins

well it obviously tried to do something

okay, supposedly explicitly specifying left outer is quicker, so let's try that...

We can do that in Rails 5, stackoverflow.com/a/39410256/1849664

@Undo that's what I was looking at, yeah

pushed

Nope, still terrible apparently

I'm beginning to think a selection loop would actually be more efficient

yuck, but maybe

I've got to run, need to fix a trackhoe. Rolling back MS to a less bad rev, then afk.

cool

[ SmokeDetector | MS ] Link at end of answer: Now I know my ABCs, won't you come and golf with me? by Wall Painting Ideas on codegolf.stackexchange.com

tpu- by Ashish Ahuja

CI on 6d8f54d succeeded.

FYI: SOCVR room meeting on Monday, if you're interested.

!!/pull

[ SmokeDetector ] SmokeDetector started at rev 6d8f54d (ProgramFOX: Merge pull request #230 from Fortunate-MAN/patch-1) (running on Raspberry Pi)

Restart: API quota is 6958.

[ SmokeDetector | MS ] Blacklisted website in answer, link at end of answer: How to quickly determine whether a given natural number is a power of another natural number? by Wall Painting Ideas on mathoverflow.net

@SmokeDetector tpu-

@ArtOfCode last time I looked there wasn't a time announced. Have they announced a time?

@Andy don't think so

they're usually 2000 UTC, IIRC

[ SmokeDetector | MS ] Link at end of answer: can this cashback casino promotion be exploited? by chip on math.stackexchange.com

tpu- by ArtOfCode

[ SmokeDetector | MS ] All-caps answer: How do I get to Rut'Theran village in the Breaking Waves of Change quest: by purpleshep on gaming.stackexchange.com (@angussidney)

Sounds N

Backoff received of 10 seconds on request to questions/127701;127714?site=mathematica at 18:27:59 UTC

Backoff received of 10 seconds on request to questions/572524;572542;572604;572612;572376;572616;572604;572289;572551;572619‌​?site=ru at 18:33:10 UTC

@angussidney I'd have to see the application

[ SmokeDetector | MS ] All-caps answer: Why does my shutter only work in the Scene modes, but not Auto? by ALAN FREEDOM on photo.stackexchange.com

[ SmokeDetector | MS ] All-caps answer: Does over- or underexposed give the most life-like post-edit results? by ALAN FREEDOM on photo.stackexchange.com

[ SmokeDetector | MS ] Offensive answer detected: OS X El Capitan Photos won't let me edit anything by user204179 on apple.stackexchange.com

tpu- by DavidPostill

naa- by DavidPostill on Does over- or underexposed give the most life-like post-edit results?

naa- by DavidPostill on Why does my shutter only work in the Scene modes, but not Auto?

@TinyGiant you might want to check this.

[ SmokeDetector | MS ] Bad keyword with email in body: HACKED BY AN AUDIO N VIDEO BUSINESS-THEY ARE HITTING ME WITH A HIGH PITCHED SOUND by Karin Wrape on ham.stackexchange.com

[ SmokeDetector | MS ] Pattern-matching website in body: Redirect page one to another using .htaccess by Abdul Rehman on stackoverflow.com

[ SmokeDetector | MS ] Bad keyword with email in body: Novice Kid Play and Declaring Winners when Recess is Over by srisley on chess.stackexchange.com

Backoff received of 10 seconds on request to questions/572655;572601;572604;572604;572632;572496;572648;572649;572660;572661‌​?site=ru at 20:42:32 UTC

Backoff received of 10 seconds on request to questions/351329;351201?site=english at 21:06:10 UTC

naa- by ByteCommander on How do I get to Rut'Theran village in the Breaking Waves of Change quest:

@SmokeDetector f

@SmokeDetector I have no idea how to feedback this... raised a custom mod flag

@ByteCommander This is one strange woman posting. For your amusement see her video youtube.com/watch?v=8pLwQYuIhQc

And karinwrapespeaks.wordpress.com :)

Restart: API quota is 5463.

@DavidPostill Wow.

She surely needs to fix her caps lock key.

I hate if people think they know a thing but actually have no idea and are just fantasizing stuff together.

@ByteCommander Apparently she is actually bipolar/depressive. Her writings are everywhere (all caps of course).

Backoff received of 10 seconds on request to questions/127735;127735?site=mathematica at 22:36:14 UTC