I hate debugging massive TSQL procedures

I had to write another 250+ line TSQL procedure with some of the most complicated SQL I've done yet and had to debug it

very carefully

[ SmokeDetector ] SmokeDetector started at rev e6b152c (SmokeDetector: Auto watch of clippingimagespecialist\.com by tripleee --autopull) (running on ArtOfCode/EC2)

Restart: API quota is 14580.

Why the restart, @SmokeDetector?

[ SmokeDetector | MS ] Username similar to website in answer: Is it possible to sync MS Outlook with specific Google Calendar? by Syncdroid on webapps.SE

tpu- by CalvT

Anyone know the answer to this:

There was a reboot close to the time that it was reported in SOBotics...

[ SmokeDetector | MS ] Few unique characters in body: Looping through json array in python by schumasc on stackoverflow.com (@quartata)

Wasn't reported here in Charcoal either I don't think

tp- by Henders

@CalvT Yeah, there's no record of that title here in recent history

  File "/home/ubuntu/Smokey/ChatExchange/chatexchange/client.py", line 127, in get_me
    assert self._br.user_id is not None

  File "/home/ubuntu/Smokey/ChatExchange/chatexchange/_utils.py", line 104, in __get__
    method()

  File "/home/ubuntu/Smokey/ChatExchange/chatexchange/browser.py", line 240, in _update_chat_fkey_and_user
    favorite_soup = self.get_soup('chats/join/favorite')

  File "/home/ubuntu/Smokey/ChatExchange/chatexchange/browser.py", line 116, in get_soup
    response = self.get(url, data, headers, with_chat_root)

!!/errorlogs

[ SmokeDetector | MS ] Link at end of answer: How to add related post widget on blogger emporio theme? by Helpful on stackoverflow.com (@quartata)

tpu- by CalvT

[ SmokeDetector | MS ] Few unique characters in body: Performance considerations for calculating vectors in C# by Phil on stackoverflow.com (@quartata)

tp- by Henders

@SmokeDetector I'm guessing this restart did it

@CalvT Not sure about that. Bhargav Rao restarted it because it hadn't reported the post. So that restart at least should have come after the post.

Ah true

[ SmokeDetector | MS ] Manually reported answer (batch report: post 1 out of 5): Can computers cause issues to retina? by seema shah on health.SE

[ SmokeDetector | MS ] Manually reported answer (batch report: post 2 out of 5): Is having to remove glasses to read normal? by seema shah on health.SE

[ SmokeDetector | MS ] Manually reported answer (batch report: post 3 out of 5): Reduce eye-power naturally by seema shah on health.SE

[ SmokeDetector | MS ] Manually reported answer (batch report: post 4 out of 5): Can optic neuritis be recovered 100%? by seema shah on health.SE

[ SmokeDetector | MS ] Manually reported answer (batch report: post 5 out of 5): See better through uncorrected sunglasses by seema shah on health.SE

tpu- by CalvT on Can computers cause issues to retina? [MS]

tpu- by CalvT on Is having to remove glasses to read normal? [MS]

tpu- by CalvT on Reduce eye-power naturally [MS]

tpu- by CalvT on Can optic neuritis be recovered 100%? [MS]

!!test-q www.eye7.in

tpu- by CalvT

!!/test-q www.eye7.in

> Would not be caught as a question.

I'll blacklist that... seems like it's going to keep reoccurring :P

!!/blacklist-website www\.eye7\.in

@Henders You don't have code privileges, but I've created a pull request for you.

Maybe don't bother including the www next time

!!/whois code_admin

@Henders That is not a user level I can check. I know about code_admin, admin

@CalvT good point

@Henders I am aware of 15 code_admin. Currently in this room: Magisch, Andy, Ferrybig, Jan Dvorak, Kyll. Not currently in this room: Thomas Ward, angussidney, tripleee, Mithrandir, ProgramFOX, Ashish Ahuja, ArtOfCode, Gerry, Undo, Glorfindel.

!!/blacklist-website eye7\.in

@Magisch Blacklisted eye7\.in

@Henders No www. Often times spammers omit that

no need to be more specific then full domain name with blacklists

@Magisch Duly noted! Thanks :)

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

[ SmokeDetector ] SmokeDetector started at rev a2d40b2 (SmokeDetector: Auto blacklist of eye7\.in by Magisch --autopull) (running on ArtOfCode/EC2)

Restart: API quota is 14111.

[ SmokeDetector | MS ] Repeating characters in title: Can I configure password for "Arduino Yun-XXXXXXXXXXXX"? by عقبة ز. on arduino.SE

fp- by CalvT

Why are some URLs listed as 'bad keyword' not 'blacklisted website'? Is this because blacklist-website is new?

@Henders Bad keywords are keywords

sometimes people use bad keywords in URLs

So if I blacklist the keyword testoboosteralphax and then a spamming dipshit comes along and spams testoboosteralphaxreviews.in or something like this it'll be caught all the same

[ SmokeDetector | MS ] Bad keyword in body: TableRowSorter shows different result everytime I clicked searchButton by JImmy on stackoverflow.com (@quartata)

sd f

[ SmokeDetector | MS ] Bad keyword in body, pattern-matching website in body, potentially bad keyword in body, repeated URL at end of long post: Components used inElevate igf by shaheerkhan on graphicdesign.SE

tpu- by Cai

!!/test-a bollyquick.blogspot.no

> Would not be caught as an answer.

!!/watch-keyword bollyquick\.blogspot\.\w+

@tripleee Watched bollyquick\.blogspot\.\w+

CI on 2dfdb66 succeeded. Message contains 'autopull', pulling...

[ SmokeDetector ] SmokeDetector started at rev 2dfdb66 (SmokeDetector: Auto watch of bollyquick\.blogspot\.\w+ by tripleee --autopull) (running on ArtOfCode/EC2)

Restart: API quota is 12877.

@Magisch I ask because this one [ MS ] has several keywords listed instead of blacklisting the URL or part of it. I just wondered why you'd go for that instead of the URL.

Is there a schema around for the MetaSmoke DB for the 'feedbacks' table?

github.com/Charcoal-SE/metasmoke/blob/master/db/schema.rb#L78

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

[ SmokeDetector | MS ] Manually reported answer: Can't apply update to Windows 10 - error 0xC1900200 by vishal kumar on superuser.com

@quartata Legend, thanks :)

[ SmokeDetector | MS ] URL in title: DBpedia dump: How to convert from “www.w3.org/2001/XMLSchema#integer” to integer? by Lupanoide on opendata.SE

fp- by DavidPostill

[ SmokeDetector | MS ] No whitespace in answer: What is the condensation point of water? by atwresytdyfguh on chemistry.SE

tpu- by Mego

tpu- by Mego on Can't apply update to Windows 10 - error 0xC1900200 [MS]

[ SmokeDetector | MS ] Link at end of answer: Hacking resources by Nathan on webmasters.SE

fp- by DavidPostill

[ SmokeDetector | MS ] Link at end of answer: Best media player/center that works well with FTP server by Marcin Zubr on superuser.com

fp- by DavidPostill

tp- by tripleee on What is the condensation point of water? [MS]

!!/watch-keyword microsoftofficesupport\.org

@tripleee Watched microsoftofficesupport\.org

CI on 3fc51f1 succeeded. Message contains 'autopull', pulling...

[ SmokeDetector ] SmokeDetector started at rev 3fc51f1 (SmokeDetector: Auto watch of microsoftofficesupport\.org by tripleee --autopull) (running on ArtOfCode/EC2)

Restart: API quota is 11498.

[ SmokeDetector | MS ] Mostly non-Latin body: I want to write a Hindi couplet in .tex file? by Anil chauhan on tex.SE

fp- by DavidPostill

[ SmokeDetector | MS ] URL in title, bad keyword in body, bad keyword in title, link at end of body, pattern-matching website in body, +2 more: worldmuscleking.com/endovex/ by Lore piou on drupal.SE

tpu- by CalvT

[ SmokeDetector | MS ] Repeating words in answer: How to install Windows Phone 7 on a Windows Phone 8 device? by murtaza sheikh on windowsphone.SE

tpu- by CalvT

Hello!

@ArtOfCode I'm trying to make that change to MS I talked about ages ago: adding 'Feedbacks today' metric (My first venture into Ruby on Rails). If I just run the app on localhost, can I use that to check if my change is working before I make a PR? Are there many prerequisites?

@NobodyNada Hello :D

@Henders I bookmarked a conversation when I was setting it up; let me find that

@NobodyNada Legend, thanks so much! Exactly what I needed :P

...I was gonna write an explanation, but that's better :)

@ArtOfCode you (and Undo) already wrote one :D

Yeah DRY man, DRY!

It's so nice to learn a language in an encouraging environment with people who want to help... Makes a real difference :O

@Henders by repeating the word DRY, havnt you gone against the very idea of it? ;)

[ SmokeDetector | MS ] Bad keyword with email in answer, email in answer: How do I permanently opt out of having a credit history? by luke todd on money.SE

tpu- by caffeineaddiction

@CaffeineAddiction Amazing!!! Hahahaha

Oh that got me :P Ha.

[ SmokeDetector | MS ] Bad keyword in body: Imporing a .vcf only imported contact names, not numbers by Barking Dog on apple.SE (@CalvT)

fp- by Mithrandir

[ SmokeDetector | MS ] Bad keyword in body, link at end of body, pattern-matching website in body, repeated URL at end of long post: Month charge and auto shipping. This is the reason numerous by user734018 on superuser.com

tpu- by CalvT

[ SmokeDetector | MS ] Bad keyword in body: Romance/Drama movie from late 80' or early 90's by angelm171 on movies.SE

fp- by Mithrandir

@Henders If you need a hand, I know some Ruby/Rails too.

[ SmokeDetector | MS ] Mostly dots in answer: Cannot run script (is executable, hash bang matches shell) by somedude on askubuntu.com (@HenryWHHackv2.0)

naa- by Riker

@JF Thanks, appreciate that :)

vandalism, though not sure if it's tp-

it's NAA at the start though

!!/blacklist-keyword cyberservices.com

@doppelgreener You don't have code privileges, but I've created a pull request for you.

4/4 TP on spam mentioning that domain: metasmoke.erwaysoftware.com/…

!!/report literature.stackexchange.com/questions/2629/…

[ SmokeDetector | MS ] Manually reported answer: Why is The Hitchhiker's Guide to the Galaxy referred to as H2G2? by user1590 on literature.SE (@Mithrandir)

tpu- by Mithrandir

!!/watch-keyword termsbux\.com

@Mithrandir Watched termsbux\.com

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

[ SmokeDetector ] SmokeDetector started at rev ab1d8f8 (SmokeDetector: Auto watch of termsbux\.com by Mithrandir --autopull) (running on ArtOfCode/EC2)

Restart: API quota is 9486.

I wonder how much spam comes from HNQ questions.

HNQ?

@Mithrandir Most of the spam on SU is spam questions - which of course don't make it to HNQ.

@Henders Hot Network Questions.

Ahhh

@DavidPostill well yes. I meant answers, such as that^ one.

Opinions?

On the MS install: I get

andy@ubuntu-box:~$ bundle install
Could not locate Gemfile

@Mithrandir Looks like it's supposed to be an answer

@Henders You should be in the MS directory

Ah

@NobodyNada It seemed to bundle alright. But when I do this it fails:

andy@ubuntu-box:~/metasmoke$ rails db:create
rails aborted!
Bundler::GemRequireError: There was an error while trying to load the gem 'uglifier'.

...does it say what the error is?

Gem Load Error is: Could not find a JavaScript runtime. See github.com/rails/execjs for a list of available runtimes.

I think :P

Google seems to suggest you can fix it with sudo apt-get install nodejs

Yeah just found that too.. I'll give it a go. Thanks, i'm getting close I hope :P

[ SmokeDetector | MS ] Few unique characters in body, repeating words in body, repeating words in title: test test test test test test test test test test test test test test test test test test test test by jdoe1980 on magento.SE

I get 'You have 135 pending migrations:' now. I think maybe I need to migrate? When I start the rails server and visit the URL it gives me a 'pending migrations error'.

More specifcally:

ActiveRecord::PendingMigrationError

So if I run this:

andy@ubuntu-box:~/metasmoke$ rails db:migrate
rails aborted!
ArgumentError: Unknown migration version "4.1"; expected one of "4.2", "5.0", "5.1"

Close! But no cigar

hmm...what version of Rails are you running?

Rails 5.1.1

Which should mean it's 5.1, right? :P bah

hmm, seems Rails 5 doesn't support migrations from version 4.1

@Undo @Art Should this and this be 4.2 instead of 4.1? Seems rails doesn't like 4.1 as a version

bundle install fetched 5.1.1 so I hope I didn't do anything wrong :P

[ SmokeDetector | MS ] Few unique characters in answer, repeating words in answer: Is there a maximum size an ocean bound creature could grow to? by lmao on worldbuilding.SE

tpu- by Riker

Anyway, I gotta sleep now. Thanks so much @NobodyNada - big help in getting this off the ground and thanks to @Undo and @ArtOfCode for the conversation which helped me to even get to this point :)

np :)

^ That became a bit of an oscar speech :P

@NobodyNada I doubt it, because those were autogenerated at the time. That's what db:schema:load is for, so you don't have to run migrations from zero

5.1.1 is current

@Henders yeah, so you need rails db:schema:load not migrate

followed by rails db:seed

Ah, thanks

[ SmokeDetector | MS ] Offensive body detected: What is the factors of (x-2y+z)^3-(x+2y-z)? by AR Saimoom on math.SE

@NobodyNada You're probably right, actually. Want to throw a GitHub issue for that?

@Undo Sure! If you're sure it should be 4.2, I can make a PR; otherwise I'll do an issue

I had to retroactively put in those version numbers. Bet I did it wrong