« first day (1292 days earlier)      last day (2529 days later) » 
00:00 - 14:0014:00 - 00:00

2:02 PM
@Glorfindel That page 404s for me...
 
@Henders because I just deleted the answer. Quartata checked before I did that.
 
Ah
 
Sorry for the confusion :)
 
Sorry I was a bit late - got my volume off so no pings
 
Never mind, Charcoal HQ is always full of helpful people.
 
2:08 PM
Was that one of your posts @Glorfindel?
 
Yes. Nothing special about it, that's what the sandbox is for.
 
Just wondering if it was "self removed" same as the other one
 
[ SmokeDetector | MS ] Manually reported answer: How to find cities with similar weather conditions by Alex on travel.SE (@JoErNanO)
[ metasmoke ] ci/circleci success on 2549f82: Your tests passed on CircleCI!
fp- by DavidPostill
 
@JoErNanO Why did you report that answer?
 
2:17 PM
@ArtOfCode Looks like it didn't work.
 
[ metasmoke ] ci/circleci success on d489169: Your tests passed on CircleCI!
 
@DavidPostill First post by newly registered user linking an answer saying nothing else.
 
@JoErNanO Hmm. I would have asked them to expand their answer. You can't expect 1st time users to know about link only answers.
And the link did answer the question.
 
2:47 PM
[ SmokeDetector | MS ] Bad keyword in body: Why my sql php is not save in database? by bosnia on stackoverflow.com (@quartata)
fp- by Glorfindel
 
sd - ignore-
 
3:01 PM
GIF of FIRE issue --> i.stack.imgur.com/Iemki.gif
@Cerbrus - I seem to have the chat refreshed when I click the fire icon for the report above...
Only that post seems to do it
 
aww, i was totaly expecting a new icon that actually burned
 
Haha
Sorry, but great idea...
@Henders It happens in SOCVR too
 
@Henders you do realize that you are now talking to yourself in a public chat room right?
 
@Henders What's that caffeine guy on about, eh?
@Henders No idea...
 
3:14 PM
[ SmokeDetector | MS ] Few unique characters in answer, no whitespace in answer, repeating characters in answer: Why are turns banked? by joes mamma on physics.SE
tpu- by Glorfindel
 
3:32 PM
@Henders Think I found a fix
 
What was the issue? Interesting one..
 
The issue what that I whitelisted the <s> tag
but it didn't check if there wasn't cript after the s
 
[ userscripts ] continuous-integration/travis-ci/push failure on 78b9018: The Travis CI build failed
[ userscripts ] continuous-integration/travis-ci/push failure on baea06c: The Travis CI build failed
 
3:48 PM
Yes yes, fixing...
 
Oh shiz, so it actually executed some script?
 
[ userscripts ] continuous-integration/travis-ci/push success on 41c4868: The Travis CI build passed
 
Yea
Which happened to reload the page, @Henders.
 
@QPaysTaxes The question mark at the end was
 
@NobodyNada I think he meant the "this rickroll" link
As in this
 
4:06 PM
o.O
 
4:58 PM
0
Q: I don't have any idea, what to do with this post

peterhIt is about the now probably deleted post here. The post essentially advertises a site where cheap native speakers can be hired for training. The first reaction is that it is obvious spam. There is probably a very big need for similar services, and it is obviously not reachable for free. Thus, ...

 
[ SmokeDetector | MS ] Bad keyword in answer, bad keyword with email in answer, email in answer: Visa requirement for Bahamas Cruise for L1 Visa holder by mercy on travel.SE (@JoErNanO)
 
@SmokeDetector tpu
 
@JoErNanO Blacklisted user.
 
5:03 PM
!!/watch-keyword Dr\.\W?mujahid
 
@JoErNanO You don't have code privileges, but I've created a pull request for you.
 
@JoErNanO BTW you can add a - at the end and Smokey won't reply:
@SmokeDetector tpu-
also, k is a shortcut for tpu-
!!/test preply.com
 
> Url in title, blacklisted website in body, blacklisted website in title
----------
Title - Position 9-19: preply.com
Title - Position 1-19: https://preply.com
Body - Position 9-19: preply.com
 
how'd this not get caught then?
did Cerb ninja Smokey?
reported half an hour after being posted...
!!/test-a Wenn du online Deutsch via Skype lernen willst, check preply.com/de/skype/deutsch-muttersprachler-gesucht. Hier kann man leicht gute Deutschlehrer, auch Deutsche Native Speaker, finden. Die Preise sind sehr attraktiv, es ist möglich, nur 7 Euro für eine Stunde zu zahlen. Es ist auch sehr hilfreich, dass man hier einen Lehrer mit Spezialisierung, z. B Deutsch für Anfänger, Wirtschaftsdeutsch, Internationale Prüfungen, finden kann.
 
> Blacklisted website in answer
----------
Body - Position 63-73: preply.com
 
5:24 PM
By default german.se has a threshold of 2. It's possible that there wasn't another post that triggered the check so that single post sat there and wasn't checked.
 
CI on fb6cebd succeeded.
 
5:46 PM
[ SmokeDetector | MS ] URL-only title, bad keyword in body, link at end of body, pattern-matching website in body, pattern-matching website in title: perfecttips4health.com/anabol-x1/ by ieoidciuefcjh on askubuntu.com (@HenryWHHackv2.0)
[ SmokeDetector | MS ] Link at end of answer: fastest way to Filter, Order and split in pages method by bilal ali on stackoverflow.com (@quartata)
 
5:57 PM
[ SmokeDetector | MS ] Offensive answer detected: How to send an email with Arduino and a WiFi shield? by Chris on arduino.SE
tpu- by Riker
 
@SmokeDetector you sure that one's spam?
 
[ SmokeDetector | MS ] Blacklisted user: SQL update failing to update database by bilal ali on stackoverflow.com (@quartata)
fp- by caffeineaddiction
 
@SmokeDetector Can't decide between NAA and fp...
 
6:00 PM
DataTables is not spam. It's a very useful jQuery plugin: datatables.net
 
...I can't believe I actually forgot to commit a change in Git.
 
lol
 
Recovered from websocket._exceptions.WebSocketConnectionClosedException: Connection is already closed.
[ SmokeDetector | MS ] Username similar to website in answer: How to re-indent Python code after changing indent width in Emacs? by Some on stackoverflow.com (@quartata)
 
!!/alive
 
@NobodyNada Kinda sorta
 
6:10 PM
@SmokeDetector why
 
@NobodyNada Post - Username similar to website
 
yeah, what's the website?
oh...some.py
sd 2- f
 
Restart: API quota is 11124.
[ SmokeDetector | MS ] Username similar to website in answer: Yahoo Finance API / URL not working: Python fix for Pandas DataReader by indexCFD on stackoverflow.com (@quartata)
tpu- by Riker
[ SmokeDetector | MS ] Username similar to website in answer, blacklisted user: Yahoo Finance unable to fetch historic data in ruby after the yahoo API change by indexCFD on stackoverflow.com (@quartata)
[ SmokeDetector | MS ] Username similar to website in answer, blacklisted user: Java read CSV file from the web by indexCFD on stackoverflow.com (@quartata)
 
6:36 PM
[ SmokeDetector | MS ] Bad keyword in body, repeated URL at end of long post: Grown-ups ought to drink 1.5 to 2 liters by foxgreenx on apple.SE (@CalvT)
tpu- by Riker
 
that was really fast
 
3 autoflags
 
7:09 PM
[ SmokeDetector | MS ] Pattern-matching website in answer: Abrir o menu na frente de todo o site by Sulivan Santos on pt.stackoverflow.com
 
sd why
 
@Riker [:37813866] Body - Position 897-924: radiojaboticabal.tk
 
code only
can't tell if spam or not
 
7:30 PM
@SmokeDetector It's got an iframe to a website my anitivirus blocks
 
then imma tpu it
 
The question uses the same URL though
sorry
@SmokeDetector fp
 
@NobodyNada Registered answer as false positive.
Conflicting feedback on Abrir o menu na frente de todo o site.
 
8:16 PM
Restart: API quota is 19926.
 
8:45 PM
!!/location
 
@quartata ArtOfCode/EC2
 
@quartata NobodyNada/Raspberry Pi
 
!!/standby NobodyNada
 
[ SmokeDetector ] SmokeDetector started in standby mode at rev f021a69 (Fernando van Loenhout: Fix typo --autopull) (running on NobodyNada/Raspberry Pi)
 
what the...
 
8:46 PM
Hm?
 
who is the nobodynada bot?
 
yeah, obviously, but why not on the regular smokey account?
 
Because apparently Nobody has an MS token but not chat creds
makes sense
 
interesting.
 
8:49 PM
Oh, sorry
I rebooted my Raspberry Pi, which apparently caused Smokey to come out of standby
 
ActiveRecord::StatementInvalid: Mysql2::Error: Cannot delete or update a parent row: a foreign key constraint fails: DROP TABLE IF EXISTS `api_keys` CASCADE
When I do rails db:schema:load
 
Run db:drop, then db:create and db:schema:load again
 
9:10 PM
Okay, thanks :)
Closer I guess, I'm getting this now, @ArtOfCode
ActiveRecord::StatementInvalid: SQLite3::SQLException: no such collation sequence: utf8_unicode_ci: CREATE TABLE "api_keys" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "key" varchar COLLATE "utf8_unicode_ci", "app_name" varchar COLLATE "utf8_unicode_ci", "user_id" integer, "github_link" varchar COLLATE "utf8_unicode_ci", "is_trusted" boolean) ENGINE=InnoDB DEFAULT CHARSET=utf8
 
J F
Favorite Chrome OS feature:
 
Who's Gary?
 
Normal
 
@Henders you're using SQLite, you need MySQL
 
@Mithrandir The guy from this
 
9:15 PM
Oh wait
I thought you said "Gerry"
kek
 
The picture gave it away ;)
 
@ArtOfCode In the config/database.yml ? I have mysql2 under development
 
might be a stupid question, but is MySQL installed?
 
Paste your database.yml, passwords redacted?
 
# SQLite version 3.x
#   gem install sqlite3
#
#   Ensure the SQLite 3 gem is defined in your Gemfile
#   gem 'sqlite3'
#
default: &default
  adapter: sqlite3
  pool: 5
  timeout: 5000

development:
  <<: *default
  adapter: mysql2
  database: metasmoke
  encoding: utf8
  username: metasmoke
  password: redacted
  host: 127.0.0.1
  port: 3306


# Warning: The database defined as "test" will be erased and
# re-generated from your development database when you run "rake".
# Do not set this db to the same as development or production.
Dec 15 '16 at 23:00, by Undo
development:
  adapter: mysql2
  database: metasmoke
  encoding: utf8
  username: metasmoke
  password: yourpass
  host: 127.0.0.1
  port: 3306
 
9:19 PM
Default adapter is sqlite, and dev inherits from that
 
Ah
Is that what <<: *default means?
 
Yep
 
Why isn't it overridden?
 
Shall I remove development and put it all in default then?
 
because YAML
 
9:20 PM
OHHH
 
you need development defined
 
Just remove <<: * default ?
 
Or that
 
(or just change default to mysql2 instead of sqlite3)
 
Which is better? :P
 
9:21 PM
Since development doesn't have pool and timeout options, I'd change default
 
Prolly doesn't matter to be honest
 
Interestingly, If I remove <<: * default it has the same issue...
 
I blame YAML
just change default then
 
Right I've really cocked it up now :P
andy@ubuntu-box:~/metasmoke$ rails db:create
Created database 'metasmoke'
Mysql2::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.`sqlite3` DEFAULT CHARACTER SET `utf8`' at line 1: CREATE DATABASE `db/test`.`sqlite3` DEFAULT CHARACTER SET `utf8`
Couldn't create database for {"adapter"=>"mysql2", "database"=>"db/test.sqlite3", "encoding"=>"utf8", "username"=>"metasmoke", "password"=>"redacted", "host"=>"127.0.0.1", "port"=>3306, "pool"=>5, "timeout"=>5000}
 
...huh
This is my database.yml, in case it helps at all
# SQLite version 3.x
#   gem install sqlite3
#
#   Ensure the SQLite 3 gem is defined in your Gemfile
#   gem 'sqlite3'
#
default: &default
  adapter: sqlite3
  pool: 5
  timeout: 5000

development:
  adapter: mysql2
  database: metasmoke
  encoding: utf8
  username: metasmoke
  password: password
  host: 127.0.0.1
  port: 3306

# Warning: The database defined as "test" will be erased and
# re-generated from your development database when you run "rake".
# Do not set this db to the same as development or production.
 
9:27 PM
change the database name for test to be metasmoke_test
It's a file name for sqlite3 but a database name for mysql2
 
[ SmokeDetector | MS ] Username similar to website in answer: How to show/draw the spectrum frequency from line into bar shape (android)? by aceh4d on stackoverflow.com (@quartata)
 
so apparently working for 12 hours straight outdoors in 25 degree heat makes you tired
who knew
 
default needs to be the same as development or what?
Yeah i'm tired too and I wasn't really outside today :P
 
Don't put a database name in default
set it individually in each block
 
andy@ubuntu-box:~/metasmoke$ rails db:create
Created database 'metasmoke'
Mysql2::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.`sqlite3` DEFAULT CHARACTER SET `utf8`' at line 1: CREATE DATABASE `db/metasmoke_test`.`sqlite3` DEFAULT CHARACTER SET `utf8`
Couldn't create database for {"adapter"=>"mysql2", "encoding"=>"utf8", "username"=>"metasmoke", "password"=>"metasmokePassword", "host"=>"127.0.0.1", "port"=>3306, "database"=>"db/metasmoke_test.sqlite3"}
Sorry guys, let me know if this is too frustrating :P
 
J F
9:39 PM
I find it kind of interesting that the UK has fairly warm weather, although it’s at the same latitude as southern Canada; while the northern US gets snow each winter most winters, although it’s at the same latitude as the south of France. #oceancurrents
 
my database.yml is here:
# SQLite version 3.x
#   gem install sqlite3
#
#   Ensure the SQLite 3 gem is defined in your Gemfile
#   gem 'sqlite3'
#
default: &default
  adapter: mysql2
  encoding: utf8
  username: metasmoke
  password: redacted
  host: 127.0.0.1
  port: 3306

development:
  adapter: mysql2
  database: metasmoke
  encoding: utf8
  username: metasmoke
  password: redacted
  host: 127.0.0.1
  port: 3306

# Warning: The database defined as "test" will be erased and
# re-generated from your development database when you run "rake".
 
@Henders just metasmoke_test, not metasmoke_test.sqlite3
 
@JF It's never that hot and never that cold. Just boring in the middle :P
@ArtOfCode AHh good, now i've got a Access Denied so that means I'm on the right track... Let me check the privs..
 
J F
It’s also pretty cool that the Appalachians, some of the Atlas Mountains, and some of the mountains in Spain were once the same mountain range.
 
@Henders you'll wanna use the root account for creating the DB, you can switch to the dedicated once it's created
 
9:44 PM
Ah okay
I just did rails db:schema:load and it worked :O Hurray!
What's next? rails db:seed ?
 
Aye
 
:O
HURRAY!
 
:thumbsup:
 
Can you sign into this? Guess I need to create some user account in the DB?
 
Just sign yourself up from localhost
 
9:51 PM
Derp
 
then User.first.add_role(:admin) to get admin, same for developer, the rest you can give yourself from the web UI
 
Where do I do that?
 
in a rails console
rails c to get one
 
Nice thanks :)
Man this is cool. So it ultimately runs inside it's own little folder?
 
yeah
 
9:55 PM
If I created a new project, entered the folder and ran rails c it would run the rails console in that context
 
aye
 
That is neat
Right, I'm off. Thanks so much for your help. Hopefully I can contribute back now too :D
 
10:38 PM
[ SmokeDetector | MS ] Bad keyword in body, bad keyword with email in body, email in body: DO YOU NEED LOAN? by MR HARRY SCOTT on money.SE
 
J F
@SmokeDetector I WANT NOW URGENT LOAN NO COLLATERAL! Do you have 110% guaranteed loans?
 
11:34 PM
[ SmokeDetector | MS ] Offensive answer detected: How do I detect collision detection in flash AS3? by Kinky 420Kitten on stackoverflow.com (@quartata)
tpu- by NobodyNada
 
11:46 PM
[ SmokeDetector | MS ] Bad keyword in link text in body: Motor disturbs Arduino radio control by Simon Lang on electronics.SE
[ SmokeDetector | MS ] Blacklisted username, mostly dots in answer: What range of MAC addresses can I safely use for my virtual machines? by Fuck you on serverfault.com
[ SmokeDetector | MS ] Blacklisted username, mostly dots in answer: What range of MAC addresses can I safely use for my virtual machines? by Fuck you on serverfault.com
 
00:00 - 14:0014:00 - 00:00

« first day (1292 days earlier)      last day (2529 days later) »