@Glorfindel :)

@SmokeDetector k

[ SmokeDetector | MS ] URL in title, bad keyword in body, bad keyword in title, bad pattern in URL body, blacklisted website in body, +2 more: supplimenttop.com/core-max-ultra-review/ by atesm milu on workplace.SE

tpu- by Makyen

sd - k

[ SmokeDetector | MS ] Bad keyword in body, blacklisted website in body, link at end of body, pattern-matching website in body: How To Keep Ones Skin Modest And Healthy by oioirexhg on askubuntu.com (@ThomasWard @quartata)

tpu- by Glorfindel

@SmokeDetector are you sure? What am I missing?

@SmokeDetector k

the - is mapped to the Workplace.SE spam post, and the k to this one. Strange ...

@SurajRao Linking to their own blog and posting only in Chinese. I'll stick to my tpu. I flagged it as NAA though.

@JarkoDubbeldam @NisseEngström hmm.. missed the username same as blog link.. was looking at the domain

[ SmokeDetector | MS ] Bad keyword in body, blacklisted website in body, link at end of body, pattern-matching website in body, repeated URL at end of long post: Saving Those Skin Since Naturally by user776191 on askubuntu.com (@ThomasWard @quartata)

tpu- by Glorfindel

[ SmokeDetector | MS ] Potentially bad keyword in answer: Finding local IP addresses using Python's stdlib by snakebarber on stackoverflow.com (@quartata)

fp- by Glorfindel

[ SmokeDetector | MS ] Bad keyword in body, bad keyword in title, repeated URL at end of long post: Reduce Belly Fat With Nutrafy Garcinia by user174501 on webapps.SE

tpu- by paper1111

[ SmokeDetector | MS ] Mostly dots in answer: Identify this movie - A.I System by MâDi Khãñ on movies.SE

naa- by Glorfindel

Flagged amd VTDd.

Also protected the question

[ SmokeDetector | MS ] Blacklisted website in body: How to scrape data from fiverr gig in PHP by Rameez Jawaid on stackoverflow.com (@quartata)

fp- by Glorfindel

@Glorfindel If you can still edit that comment on Movies&TV, remove LoTR part. We don't really answer in comment.

I figured it wouldn't matter as the post will be deleted anyway...

but that part is gone now.

The identification questions are barely tolerable there and answering in the comments just make it worse. I hope you understand. :)

Yeah, no problem. I was just trying to be helpful to the new user.

[ SmokeDetector | MS ] Bad NS for domain in body, bad keyword in body, bad keyword in title, blacklisted website in body: Testro T3 Review: Boost Stamina and Performance| Free Trial In UK by testro3 on askubuntu.com (@ThomasWard @quartata)

tpu- by Glorfindel

:)

Did you watch Star Wars: The Last Jedi?

@AJ Watched yesterday lol

Good

!!/alive

@AJ Kinda sorta

!!/blacklist-keyword primal\W?factor

@Mithrandir Blacklisted primal\W?factor

[ SmokeDetector | MS ] URL in title, bad NS for domain in body, bad NS for domain in title, bad keyword in body, bad keyword in title, +5 more: supplement4help.com/testro-t3/ by user269697 on apple.SE

tpu- by paper1111

CI on 1639cae succeeded. Message contains 'autopull', pulling...

@SmokeDetector k

@SmokeDetector k

[ SmokeDetector ] SmokeDetector started at rev 1639cae (SmokeDetector: Auto blacklist of primal\W?factor by Mithrandir --autopull) (running on teward/Lunar Eclipse)

Restart: API quota is 17379.

[ SmokeDetector | MS ] Blacklisted website in body: How to scrape data from fiverr gig in PHP by Rameez Jawaid on stackoverflow.com (@quartata)

fp- by Glorfindel

[ SmokeDetector | MS ] Potentially bad keyword in answer: Finding local IP addresses using Python's stdlib by snakebarber on stackoverflow.com (@quartata)

@SmokeDetector f

[ SmokeDetector | MS ] Bad keyword in body, bad keyword in title, blacklisted website in body, link at end of body, pattern-matching website in body: Face Creamy For Irritated Skin - 3 Central Ingredients by garetnixon on askubuntu.com (@ThomasWard @quartata)

fp- by Glorfindel on Finding local IP addresses using Python's stdlib [MS]

tpu- by Glorfindel

[ SmokeDetector | MS ] URL in title, bad NS for domain in body, bad NS for domain in title, bad keyword in body, bad keyword in title, +5 more: supplement4help.com/testro-t3/ by myxweajma on apple.SE

[ SmokeDetector | MS ] Few unique characters in answer: can i use boostrap template into my react native project by Jigar on stackoverflow.com (@quartata)

fp- by Glorfindel

tpu- by paper1111 on http://supplement4help.com/testro-t3/ [MS]

@SmokeDetector k

[ SmokeDetector | MS ] Bad keyword in title, phone number detected in body, phone number detected in title: Arlo Tech Support Number +1-800-973-2044 Arlo Camera Customer Service Number by James Paul on photo.SE

tpu- by Glorfindel

[ SmokeDetector | MS ] Bad keyword with a link in answer, link at end of answer: Hierarachy viewer is not working in google LG nexus 4? by Z4Root Software on stackoverflow.com (@quartata)

tpu- by Glorfindel

!!/watch z4rootapk\.co

[ SmokeDetector | MS ] Bad NS for domain in body, bad keyword in body, bad keyword in title, blacklisted website in body, link at end of body: help of a colon cleansing program such by user776203 on askubuntu.com (@ThomasWard @quartata)

@Glorfindel Added z4rootapk\.co to watchlist

tpu- by Glorfindel

CI on 76fb365 succeeded. Message contains 'autopull', pulling...

[ SmokeDetector ] SmokeDetector started at rev 76fb365 (SmokeDetector: Auto watch of z4rootapk\.co by Glorfindel --autopull) (running on teward/Lunar Eclipse)

Restart: API quota is 17289.

[ SmokeDetector | MS ] Bad NS for domain in body, blacklisted website in body, link at end of body, pattern-matching website in body: What's top is perfect doesn't haddest by Himes1961 on askubuntu.com (@ThomasWard @quartata)

tpu- by Glorfindel

[ SmokeDetector | MS ] Blacklisted website in answer: Sending an http request using camel-rx by usanfrancois on stackoverflow.com (@quartata)

tpu- by Glorfindel

@SmokeDetector still up

@SmokeDetector Ouch.

[ SmokeDetector | MS ] Blacklisted website in body: How to scrape data from fiverr gig in PHP by Rameez Jawaid on stackoverflow.com (@quartata)

@SmokeDetector ignore

@Glorfindel Post ignored; alerts about it will no longer be posted.

Conflicting feedback across revisions: current, #1, #2

fp- by rene

[ SmokeDetector | MS ] Blacklisted website in body, link at end of body, pattern-matching website in body: Think of ordering Ptx Pills? by Cassillberg on drupal.SE

tpu- by Glorfindel

[ SmokeDetector | MS ] URL in title, bad NS for domain in body, bad NS for domain in title, bad keyword in body, bad keyword in title, +4 more: supplement4help.com/testro-t3/ by elwyn reilly on astronomy.SE

tpu- by Glorfindel

[ SmokeDetector | MS ] URL in title, bad keyword in body, bad keyword in title, pattern-matching website in body, pattern-matching website in title: wellness4order.com/nutrafy-garcinia/ by KarenMAndersen on apple.SE

tpu- by Glorfindel

[ SmokeDetector | MS ] Pattern-matching website in answer: Do you recommend purchasing devices to strengthen my fingers? by Flint on music.SE

fp- by Glorfindel

[ SmokeDetector | MS ] Bad keyword in body, bad keyword in title, bad keyword in username, blacklisted website in body, link at end of body, +1 more: Virility T3X is scam or not.? by Alpha Max on workplace.SE

tpu- by Glorfindel

[ SmokeDetector | MS ] Link at end of body, repeated URL at end of long post: cinema box apk download for android by regorheets on meta.SE

tpu- by Glorfindel

[ SmokeDetector | MS ] Bad NS for domain in body, bad keyword in body, blacklisted website in body, link at end of body, pattern-matching website in body, +1 more: This element is seen as one of the by Kno ton on drupal.SE

tpu- by Glorfindel

[ SmokeDetector | MS ] Chinese character in title: antd 使用 props.form.getFieldDecorator 触发 componentWillReceiveProps by zhanglu on stackoverflow.com (@quartata)

@SmokeDetector f (but voted to close)

[ SmokeDetector | MS ] URL in title, bad keyword in body, bad keyword in title, pattern-matching website in body, pattern-matching website in title, +1 more: www.strongmuscleshop.com/zyplex/ by timothy jelks on astronomy.SE

tpu- by Glorfindel

[ SmokeDetector | MS ] URL-only title, link at end of body, link following arrow in body, pattern-matching website in body, pattern-matching website in title, +1 more: buyhealthsupplement.com/maxx-boost/ by pierce on askubuntu.com (@ThomasWard @quartata)

tpu- by Glorfindel

[ SmokeDetector | MS ] Bad NS for domain in body, bad keyword in body, bad keyword in title, blacklisted website in body, pattern-matching website in body, +1 more: Titan Blast@Where to Buy? by kaalbera on 3dprinting.SE

sd k

[ SmokeDetector | MS ] URL-only title, bad NS for domain in body, bad NS for domain in title, bad keyword in body, bad keyword in title, +6 more: supplement4help.com/testro-t3/ by barryogorman on askubuntu.com (@ThomasWard @quartata)

tpu- by Glorfindel

[ SmokeDetector | MS ] Potentially bad keyword in answer: How to convert ms-Excel file to pdf in java by Tarun Kumar Nayak on stackoverflow.com (@quartata)

@SmokeDetector q asks for it..

[ SmokeDetector | MS ] Bad keyword in body, blacklisted website in body: Instantly Vivid Immediately Striking by Maryears on graphicdesign.SE (@HenryWHHackv2.1)

tpu- by Glorfindel

@SurajRao q looks like off topic (recommend)

@paper1111 yes.. VTC'ed

@SurajRao Ok nice

@SmokeDetector f

[ SmokeDetector | MS ] URL in title, bad keyword in body, bad keyword in title, link at end of body, pattern-matching website in body, +1 more: wellness4order.com/nutrafy-garcinia/ by EvelWagn on drupal.SE

tpu- by Glorfindel

[ SmokeDetector | MS ] URL-only title, bad NS for domain in body, bad NS for domain in title, bad keyword in body, bad keyword in title, +5 more: www.nutritionfit.org/magnetique-hair-growth/ by Nable1937 on askubuntu.com (@ThomasWard @quartata)

[ SmokeDetector | MS ] Bad keyword with email in body: Read json file in string in c# with header & request by Vikram Rathaur on stackoverflow.com (@quartata)

@SmokeDetector why

@SurajRao Post - Keyword LOAN with email softcell@poc.com

fp- by paper1111

@SmokeDetector f

@SmokeDetector k

[ SmokeDetector | MS ] Bad NS for domain in body, bad keyword in body, bad keyword in title, link at end of body, pattern-matching website in body: EnduraFlex Testo Boost by LouisGary on askubuntu.com (@ThomasWard @quartata)

tpu- by paper1111

[ SmokeDetector | MS ] Few unique characters in answer: Finding dependencies on a SPECIFIC COLUMN (modern way, without using sysdepends) by Yair Maron on dba.SE

[ SmokeDetector | MS ] Bad NS for domain in body, bad keyword in body, bad keyword in title, blacklisted website in body, link at end of body, +1 more: Core Max Ultra An excellent method of getting around muscles by NicholeSteele on security.SE

[ SmokeDetector | MS ] Link at end of body, potentially bad keyword in body, potentially bad keyword in title: Alpha Monster Blast - Includes all-natural constituents by violahadwell on superuser.com

sd 3k

[ SmokeDetector | MS ] Bad NS for domain in body, blacklisted website in body, link at end of body: The sesame extract provides epidermal by tammypages on superuser.com

sd k

[ SmokeDetector | MS ] Bad keyword in body, bad keyword in title, repeated URL at end of long post: Refollium -Increase tha production of collagen by witiarivera on graphicdesign.SE (@HenryWHHackv2.1)

tpu- by Glorfindel

[ SmokeDetector | MS ] Bad NS for domain in body, bad keyword in body, bad keyword in title, blacklisted website in body, link at end of body, +1 more: Magnetique hair growth am within one by Pura ton on drupal.SE

tpu- by Glorfindel

[ SmokeDetector | MS ] Bad keyword in body, bad pattern in URL body, blacklisted username, blacklisted website in body, pattern-matching product name in body: It will permit you to enhance your orgasms by carolyjuriya on apple.SE

tpu- by Glorfindel

[ SmokeDetector | MS ] Bad keyword in body, bad keyword in title: what do you Mean by Testro T3 ? by JenniCor12 on askubuntu.com (@ThomasWard @quartata)

tpu- by Glorfindel

[ SmokeDetector | MS ] URL-only title, bad NS for domain in body, bad NS for domain in title, blacklisted website in body, blacklisted website in title, +4 more: foreverhealthy786.com/instantly-vivid/ by czkpndkrh on askubuntu.com (@ThomasWard @quartata)

tpu- by Glorfindel

!!/report android.stackexchange.com/a/188599/205764

[ SmokeDetector | MS ] Manually reported answer: Are there any Google devices that support capabilities in their default kernel? by Adam Woakes on android.SE

tpu- by Glorfindel

!!/watch paidapps4free\.com

@Glorfindel Added paidapps4free\.com to watchlist

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

[ SmokeDetector ] SmokeDetector started at rev b7dfb16 (SmokeDetector: Auto watch of paidapps4free\.com by Glorfindel --autopull) (running on teward/Lunar Eclipse)

Restart: API quota is 16195.

[ SmokeDetector | MS ] URL in title, bad keyword in body, bad keyword in title, blacklisted website in body, blacklisted website in title, +2 more: trial4supplement.com/virility-t3x-uk/ by RobertRouse on astronomy.SE

tpu- by Glorfindel

[ SmokeDetector | MS ] Link at end of answer, username similar to website in answer: Can I jam on UMTS (WCDMA based) using my USRP 1? by New Age Securities on stackoverflow.com (@quartata)

tpu- by Glorfindel

!!/watch newagesecurities\.com

@paper1111 Added newagesecurities\.com to watchlist

CI on 1241b80 succeeded. Message contains 'autopull', pulling...

[ SmokeDetector ] SmokeDetector started at rev 1241b80 (SmokeDetector: Auto watch of newagesecurities\.com by paper1111 --autopull) (running on teward/Lunar Eclipse)

Restart: API quota is 16023.

[ SmokeDetector | MS ] Repeating characters in title: Unexpected HTTP/1.x request: POST /3/device/XXXXXXXXXXXXXXXXXXXXXXXXXXXX by Waseem Bashir on stackoverflow.com (@quartata)

@SmokeDetector fp-

[ SmokeDetector | MS ] Bad NS for domain in body, bad keyword in body, bad keyword in title, blacklisted website in body: Testro T3 Review: Does this male improvement Really Work? by testro3 on superuser.com

tpu- by paper1111

[ SmokeDetector | MS ] Link at end of body, link following arrow in body: Vastu Tips to Reduce Holiday Stress by marianodcroz on askubuntu.com (@ThomasWard @quartata)

tpu- by Glorfindel

[ SmokeDetector | MS ] URL in title, bad NS for domain in body, bad NS for domain in title, bad keyword in body, blacklisted website in body, +4 more: foreverhealthy786.com/instantly-vivid/ by user269722 on apple.SE

tpu- by Glorfindel

!!/watch vasturemedies\.hatenablog\.com

@paper1111 Added vasturemedies\.hatenablog\.com to watchlist

[ SmokeDetector | MS ] URL in title, bad NS for domain in body, bad NS for domain in title, blacklisted website in body, blacklisted website in title, +3 more: foreverhealthy786.com/instantly-vivid/ by czkpndkrh on apple.SE

CI on 5c59634 succeeded. Message contains 'autopull', pulling...

[ SmokeDetector ] SmokeDetector started at rev 5c59634 (SmokeDetector: Auto watch of vasturemedies\.hatenablog\.com by paper1111 --autopull) (running on teward/Lunar Eclipse)

Restart: API quota is 15741.

[ SmokeDetector | MS ] Link at end of answer, pattern-matching website in answer: Why is Tom Brady's helmet different? by Nick on sports.SE

tpu- by Glorfindel

!!/watch-force bestyouthfootballequipment\.com

@Mithrandir Added bestyouthfootballequipment\.com to watchlist

CI on 9ce7c13 succeeded. Message contains 'autopull', pulling...

[ SmokeDetector ] SmokeDetector started at rev 9ce7c13 (SmokeDetector: Auto watch of bestyouthfootballequipment\.com by Mithrandir --autopull) (running on teward/Lunar Eclipse)

Restart: API quota is 15668.

[ SmokeDetector | MS ] URL in title, bad NS for domain in body, bad NS for domain in title, blacklisted website in body, blacklisted website in title, +3 more: foreverhealthy786.com/instantly-vivid/ by corene larkin on astronomy.SE

@SmokeDetector k

@Glorfindel Really? I thought these were in blacklisted-usernames.txt

That's blacklisting a username. If we ever encounter a troll named 'Andy', blacklisting the username won't help.

[ SmokeDetector | MS ] Blacklisted username: Not able to getting array by parsing its showing as string format in Swift 3.2 by wingding on stackoverflow.com (@quartata)

tpu- by Glorfindel

speaking of ...

...someone deleted them before me...

@SmokeDetector <-- this still needs spam flags

@doppelgreener boom

@Mithrandir \o/!

[ SmokeDetector | MS ] Offensive answer detected: Organic reaction of dry ice and Grignard reagent by aryan on chemistry.SE

tpu- by Glorfindel

[ SmokeDetector | MS ] Bad keyword in body: Please help me fond thiago manga by Kazu -kun on anime.SE

fp- by Glorfindel

@SmokeDetector f

@SmokeDetector k

[ SmokeDetector | MS ] Potentially bad keyword in answer: Refreshing beauty tips by Tapasya Cheulkar on stackoverflow.com (@quartata)

@Undo I figured out that authorization error I was getting last night. If you hit dev/blacklists/ instead of the full endpoint (dev/blacklists/{id}), and it's not the GET endpoint, you get that authorization error. I must have done that and not noticed. (Probably a bad copy/paste of the different deploy locations). I'm sure we can clean that response up some how. I'll make a note in GitHub. In the meantime...that's the reason it happened.

!!/blacklist-website nyassabathandbody\.com

@Glorfindel Blacklisted nyassabathandbody\.com

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

[ SmokeDetector ] SmokeDetector started at rev eb44233 (SmokeDetector: Auto blacklist of nyassabathandbody\.com by Glorfindel --autopull) (running on teward/Lunar Eclipse)

Restart: API quota is 14846.

[ SmokeDetector | MS ] Phone number detected in title: InTer CaStE LoVe MaRrIaGe 91 9828891153 LoVe BaCk SpEcIalIsT MoLvI Ji by user9149773 on stackoverflow.com (@quartata)

tpu- by Glorfindel

[ SmokeDetector | MS ] Repeating characters in answer: error LNK2005, already defined? by Dániel Papp on stackoverflow.com (@quartata)

naa- by Glorfindel

naa by quartata

!!/hats

@quartata Winter Bash won't end for 5 days, 8 hours, 42 minutes, and 43 seconds. GO EARN SOME HATS!

[ SmokeDetector | MS ] Blacklisted website in body: Need Bookkeeping & Accounting Services? by Yasir Haseeb on chemistry.SE

tpu- by Glorfindel

[ SmokeDetector | MS ] Shortened URL in answer: Shortcut Virus: All contents of my USB gets transferred into an unnamed hidden folder by Abdullah sulman on security.SE

fp- by Glorfindel

@Undo Hey, do you know if any of the API routes return how many flags a user has remaining?

I dont see it /options sadly

SE API?

It does not

tpu- by rene

Conflicting feedback on Shortcut Virus: All contents of my USB gets transferred into an unnamed hidden folder.

Conflicting feedback on Shortcut Virus: All contents of my USB gets transferred into an unnamed hidden folder.

@Andy Cool, thanks

Conflicting feedback on Shortcut Virus: All contents of my USB gets transferred into an unnamed hidden folder.

Why is that a TP?

I'm not great with Batch but it looks like it does what it says

Although it does loop forever

@Glorfindel oh, the url

yep

At first, I missed it as well.

That's weird

That'll make a fun review audit for someone

[ SmokeDetector | MS ] Misleading link: Adding support for whitelabeling in angular 2 by FDFDGSFG DJDBM on stackoverflow.com (@quartata)

fp- by Glorfindel

[ SmokeDetector | MS ] Username similar to website in answer: The optimal way to check if a query string is an int? by Tek Grabs on stackoverflow.com (@quartata)

tpu- by Glorfindel

!!/watch tekgrabs\.com

@Glorfindel Added tekgrabs\.com to watchlist

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

[ SmokeDetector ] SmokeDetector started at rev db36961 (SmokeDetector: Auto watch of tekgrabs\.com by Glorfindel --autopull) (running on teward/Lunar Eclipse)

Restart: API quota is 14054.

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

[ SmokeDetector | MS ] Bad keyword in body, link following arrow in body, repeated URL at end of long post: NeuBeauty Cream by neubeauty on graphicdesign.SE (@HenryWHHackv2.1)

metasmoke going down for updates

@SmokeDetector k

Ah. I just wanted to ask whether something is broken again... :P

@Undo k

@Mithrandir This message is not a report.

@SmokeDetector k

@Mithrandir That message is not a report.

@ByteCommander ^ is ---> at ;)

s/This/That/

:P

[ SmokeDetector | MS ] Bad keyword with a link in answer, bad pattern in URL answer: Simple square-wave power inverter circuit question by morning world on electronics.SE

@SmokeDetector k

!!/watch thereviewszone\.com

@Mithrandir Added thereviewszone\.com to watchlist

!!/watch-force click4trial\.com

@Mithrandir Added click4trial\.com to watchlist

CI on 5960d1c succeeded. Message contains 'autopull', pulling...

Restart: API quota is 13523.

!!/rev

@Mithrandir teward/Lunar Eclipse 5960d1c (SmokeDetector: Auto watch of click4trial\.com by Mithrandir --autopull)

@ArtOfCode Fixed

@Undo heh, just as I was about to get rubymine out to do it :)

ta

[ SmokeDetector | MS ] Bad keyword with a link in answer, link at end of answer, pattern-matching website in answer, username similar to website in answer: using seo user friendly in php by seouser on stackoverflow.com (@quartata)

tpu- by ArtOfCode

CI on 014a2aa succeeded.

[ SmokeDetector | MS ] Pattern-matching website in answer: Do we know which mining software Satoshi used? by Allan Lind Jensen on bitcoin.SE

!!/pull

[ SmokeDetector ] SmokeDetector started at rev 014a2aa (quartata: blacklist should come first, then always_silent (style)) (running on teward/Lunar Eclipse)

tpu- by Glorfindel

Restart: API quota is 13152.

[ SmokeDetector | MS ] Bad keyword in answer, bad keyword with email in answer, pattern-matching email in answer, potentially bad keyword in answer, blacklisted user: Famous review site seems to be detecting my posts by Composite_Hacks on tor.SE

[ SmokeDetector | MS ] Bad keyword in answer, bad keyword with email in answer, pattern-matching email in answer, potentially bad keyword in answer, blacklisted user: Using Tor in a python script in Windows by Composite_Hacks on tor.SE

tpu- by Glorfindel on Famous review site seems to be detecting my posts [MS]

tpu- by Glorfindel

wtf mysql

@ArtOfCode I'd say that's more an ActiveRecord flaw

GAH. So I can't create a new model that references a model which was created before we moved to Rails 5, because Rails 4 used INTEGER(11) as the primary key type and Rails 5 uses BIGINT; MySQL won't let me use a BIGINT as a reference to an INTEGER(11). "So change posts.id to a BIGINT, no?" No. I can't change posts.id, because it's used in about a million foreign keys and MySQL won't let me change a column that's part of a foreign key.

@quartata no, it's MySQL that's blocking me here

@ArtOfCode cant you cast it from one to another?

@CaffeineAddiction if I was just doing a query, yes

but I'm trying to alter the database structure, not just manipulate data

why wouldnt it work for data manipulation too?

It would work for data manipulation

not for altering the structure

@ArtOfCode Write down the foreign keys, remove them, change the things, readd them?

very suboptimal, tho

oh, schema change

@Magisch basically this, but in code

so now I get to learn how to list foreign keys

I guess you can automate that

@ArtOfCode should be doable by querying information_schema effectively

well yah, what @Magisch said ... select * from blah and cast all the keys to int?

@Magisch sure is

just rebuild the model

mysql> select table_name, column_name, constraint_name, referenced_table_name, referenced_column_name from information_schema.key_column_usage where referenced_table_name is not null and referenced_column_name is not null and constraint_schema = 'metasmoke_dev';
+--------------------+-------------------+---------------------+-----------------------+------------------------+
| table_name         | column_name       | constraint_name     | referenced_table_name | referenced_column_name |
+--------------------+-------------------+---------------------+-----------------------+------------------…

so not impossible just a pain in the ass and a lot of work

yup

thats why you get payed the big bucks right? ;)

totally

all those big volunteer bucks

I may be about to mangle my database beyond recognition... this'll be fun

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

[ SmokeDetector | MS ] Manually reported answer: "Graphic card error" POST without a graphics card by Victoria the Tech Girl on superuser.com

tpu- by Glorfindel

!!/watch computerrepairnerds\.com

@Glorfindel Added computerrepairnerds\.com to watchlist

wtf

that worked?

CI on 7400aca succeeded. Message contains 'autopull', pulling...

well okay

[ SmokeDetector ] SmokeDetector started at rev 7400aca (SmokeDetector: Auto watch of computerrepairnerds\.com by Glorfindel --autopull) (running on teward/Lunar Eclipse)

Restart: API quota is 12619.

watch-keyword => 2075
blacklist-keyword => 1054
blacklist-website => 1681
blacklist-username => 59

Woohoo! My import script for Helios works

It's slow as...something slow...but it works

@Undo Dev helios should have current blacklists and watchlists as of about two hours ago.

I'm going to do some Smokey testing against that over the next few days. I think the blacklist functionality is decent though.

So, hopefully I won't need to many logs before we get that functionality added. I haven't looked to see what it takes to pull logs from CloudWatch via a lambda yet

> lambda

@Andy Given what little I understand of what you guys are trying to do you might as well write the whole thing in Greek :)

@DavidPostill AWS Lambda is an Amazon cloud service that lets you run a function from a URL.

Another thing to add to the list: Regular backups that can be restored. DDB probably has some kind of solution for that.

@Andy It shouldn't be too hard. May need to be in metasmoke for Access control; turns out I have some pretty sensitive logs in there for other projects outside of SE

[ SmokeDetector | MS ] Pattern-matching email in title: Up to 50% off traveling to Israel or from Israel. dreamliner808@gmail.com by ELI.B on judaism.SE

tpu- by Glorfindel

hahaha

"the best dead"

He has corrected that typo now. The grammar is still off, though.

[ SmokeDetector | MS ] Few unique characters in body: please delete topic by Drekoo on stackoverflow.com (@quartata)

tp- by ArtOfCode

@SmokeDetector v

@Undo the deploy currently pending includes a migration that may have been designed more by righteous anger than logic and skill. You're gonna want to have some spare time when you do that deploy.

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

[ SmokeDetector | MS ] Potentially bad keyword in body: No sound on bluetooth module through aux-in by zksailor534 on electronics.SE

sd f

[ SmokeDetector | MS ] Offensive answer detected: C++ templating primitive types as function arguements by Robert Gray on stackoverflow.com (@quartata)

fp- by ByteCommander

How many feedbacks from different individuals are beneficial? In other words, is it of benefit for there to be more than one feedback provided for each report? If so, is it desirable to have more than 2? 3? Why I'm asking: I'd like modify FIRE to visually indicate in the chat transcript when the SD Report is no longer an issue which the the user needs to act upon (e.g. enough feedbacks and post deleted; user has posted feedback and flagged; etc.).