« first day (1268 days earlier)      last day (3752 days later) » 

8:03 PM
Why not this?
select body, count(*)
from Posts
where posttypeid = 1
group by body
having count(*)>1
 
Because I don't know that much SQL
 
Oh.
The HAVING clause it where it's at, yo.
 
googles HAVING clause
 
Good job working with what you've got, though, @Undo.
 
@jadarnel27 Heh, thanks ;)
The other thing I have is the whole database running on a USB 2.0 external hard drive connected to a 2003 laptop. So I don't have the best hardware :P
 
8:09 PM
Anyone wanna help fight some spam?
 
Joe
mmmm spam
 
I have some flags left so lets have it. Only football spam please
 
@ɥʇǝS Where?
readies flagbot
 
Flag any posts my a user named Blade19899 here: askubuntu.com
too many for me to link them all.
 
gotit
 
8:11 PM
I've linked a lot in here.
@seth you're going to be stabbed soon. — Blade19899 36 secs ago
 
@ɥʇǝS Hmm... almost a death threat. @Shog9, we report those right?
@Pops Spamathon on Ask Ubuntu, can you come in with your godly powers?
 
Wow, he must be really bored.
 
@ɥʇǝS Same text every time?
 
@Undo One sec.
 
@Undo Pretty much. Hopefully the flag system will come in soon.
 
8:13 PM
If it helps
@ɥʇǝS Ok, conveinent list: askubuntu.com/…
 
I wouldn't ask for help, but people are going to start getting worried (the OPs that is)
 
That's... weird.
 
@Undo oh cool.
 
Out of flags ;(
But we have a CM now ;)
 
Yeah, that sucks that he's putting those junk "answers" on new user's questions.
 
8:15 PM
My question: WHY?!?
Someone's thumping the valid button on my spam flags :D
 
@ɥʇǝS Not all posts; there seems to be a legit high-rep user with that name that the spammer is impersonating.
Perhaps he's hoping we'll accidentally destroy the real guy while we're cleaning him up?
 
@Pops Yes that's true. forgot to add that.
 
@Pops Ha! Possible... and kinda creative :P
 
@Pops no, he's pretending to be a moderator.
The spam used to be "MAKE US MODS" and such nonsense.
 
8:21 PM
Oh, that guy.
I didn't dig that far yet.
 
it would be cool if you could go through and delete all the users too.
 
Why is AU such a spam attraction?
 
"I’m too lazy to download this giant zip file." - That seems a rather odd statement. Downloading a ZIP file only requires a couple of button clicks. If you're that lazy then chances are you didn't click the link to read the blog in the first place.
 
@animuson 'Giant' zip file.
 
@animuson Yeah, but it's a 19GB zip file :P
 
8:23 PM
What does the size of the ZIP have to do with being lazy, though? I can see if you didn't have enough disk space. :P
 
@Undo It all started with one user getting mad, and he called his "friends" in. (he said it himself)
 
Joe
lazy=impatient?
 
@ɥʇǝS My goodness, he has... interesting friends :P
 
@Undo No kidding.
 
And I have imaginary friends!
 
8:24 PM
@ɥʇǝS I'M GONNA GET THE BOYS
 
Heh, all those posts are getting their owners dissociated one... by... one :P
Spam gone.
 
Did I get them all?
 
I think Pops might have done something very bad to them :P
@Pops From what I can see. Thanks!
 
Sure.
 
I think AU needs more mods.
nominates @ɥʇǝS
 
0
Q: Change last answerer on All Questions page when answer deleted

Lance RobertsThe All Questions frontpage still shows the last answerer/editor, even if that answer was deleted. This has been brought up as a bug before, so this is a feature-request to fix this. The main reason it needs to be fixed is because if you delete a spam answer, it's good to be able to watch the f...

 
DANG SEARCH CACHING
2
 
It was a big pain to follow the user, when his name wouldn't leave the frontpage.
 
@ɥʇǝS So is he persistent? Do we need to keep watching for the next half hour or so, or does he give up easily and move on to something else?
 
@Undo I think he'll be gone for a bit now. Thanks for your help :)
 
8:33 PM
@animuson Got those and two more. Now I think this round is over.
 
@ɥʇǝS No problem
 
@Undo Maybe someday..
 
We need like a special Tavern flag where the regulars can band together and unilaterally nuke spam.
 
So is it just me or have we been getting a ton more spam recently?
 
@hichris123 The latter, unfortunately.
 
8:34 PM
Not just you.
 
So... what happened?
 
@Undo I think it's more like he runs a script, goes to work, SE eventually blocks script. He comes back, edits script runs it again, SE eventually blocks script and on and on.
 
Did spammers suddenly just like SE for some reason?
 
@hichris123 We're huge, that's what it is.
Big traffic.
 
8:36 PM
@hichris123 Hahahahahahahahahaha "suddenly" hahahahahahahahahahahahaha
 
@ɥʇǝS Wow.
@Pops Hey, I don't have detailed spammer stats like you do. cue for Pops to give me spammer data
 
I don't have stats, I just see the junk the mods have to deal with constantly.
 
@hichris123 I went through 20 flags in about 20 minutes D:
 
This makes me really want to build a spam thing for Charcoal.
 
@Pops You don't have stats as a CM? Liar! :P
 
8:37 PM
Built for speed and reaching out to maximum people.
 
Hmm. Maybe this is like sockpuppeting, but for flag weight instead of rep! Everyone who was just talking to me about that spam, you are now UNDER SUSPICION.
@hichris123 "Don't have" is not the same as "can't get."
 
Permanently? :(
 
I DIDN'T WANNA DO IT THEY MADE ME! sobs
 
Something keeps making noise like a star trek doorbell next to me, and I can't for the life of me figure out what it is.. it's starting to freak me out :S
off-topic
 
@ɥʇǝS Ha, that's us :P
 
8:39 PM
@ɥʇǝS It's a direct ping in chat.
 
@Undo oh, this clown again, eh?
 
@Pops That means get the stats. :P
 
Yeah, I just figured that out lol.
 
@Shog9 Yup. There's a protocol for death threat-ish things, right?
As in if they look serious and not empty :P
 
All death threats are taken seriously.
 
8:41 PM
@Undo yeah, I'm personally not inclined to give this jackass any more attention, but if Seth (how the hell do I ping you, @ɥʇǝS?) is concerned he should contact us & we'll follow up.
 
So it's just another contact us thing? Ok
Just curious.
 
@Shog9 Nah, I'm not concerned.
I guess pinging me would be hard.. I though think about that more ;)
 
@+h matches. Took me a minute
 
fancy ping-evasion techniques work no more!
 
@Shog9 I can't test it on myself unfortunately :-/
@Undo A pity, 'cause you sometimes need it on SO, what with all the new users that have a problem mass pinging.
 
8:43 PM
@ɥʇǝS Ha, true
 
Well thanks for all the help folks.. I've got to move on now. See 'ya tips hat
Err, I should really get a hat...
 
We can put questions other people have spam-flagged in the sidebar.
I think I might do this in a userscript somehow.
 
@Undo you'd need people to submit spam
I've always thought of a chatroom where you submit spam, but this could work too
 
@Manishearth Yes. They install my userscript and it adds a button to the flag dialog, is what I was thinking.
@Manishearth The advantage here, I think, is that it would follow me around and always be there, so I can see if something is really blowing up.
 
yeah
 
8:56 PM
@Manishearth Is there a way to make a request to my server from a userscript?
Or does CORS kill that?
 
you can bypass CORS if you wish by setting appropriate headers
 
@Manishearth On my server side, right?
I can do that :D
 
yeah
 
I think I'm going to do this.
 
@Undo you can set it to *stackexchange.com or something
 
8:57 PM
(unless the powers that be say no)
@Manishearth It's up to the browser to honor it, right?
 
I don't mind helping :)
yeah
 
@Manishearth I'd love that ;)
 
Why not make have a couple of userscripts in the charcoal repo?
Or make a new one
or something
 
@Manishearth Let's keep it separate from Charcoal.
 
9:03 PM
(for those interested, we moved)
 
9:41 PM
Brown.
Mmmhmmm.
French fried taters.
And mustard.
Mmm.
 
Ewww, mustard.
 
Joe
Mustard is good when used appropriately, but is also very often not used appropriately =/
 
Mustard is always gross.
 
Mustard is amazing.
 
Joe
Without mustard, there would be no curry.
Without curry, there would be no heaven.
 
9:48 PM
What kind of mustard?
 
Rotella's needs to pick up gluten-free hamburger buns. I miss burgers so much. :(
 
Joe
Make them yourself :)
Hamburger buns aren't terribly hard to make
 
@rene Any kind, but I'm personally partial to dijon.
 
Hmmm I just earned a Tumbleweed badge on Super User. Yay?
 
I am extremely frustrated with our web server ops people right now.
 
Joe
9:53 PM
Why's that?
 
@AnnaLear heh +1 ;)
 
One of our apps started becoming intermittently unavailable, and I was seeing "timeout waiting for a connection from the connection pool" errors in the logs. This occurred right after an email was sent out inviting thousands and thousands of people to visit our app.
 
@jadarnel27 self-DDoS?
 
Joe
lol
Oops
 
Pretty much, @Manish =)
But the ops team just kind of blew me off when I called, because it was a Silverlight app. They said "we don't have the tools to troubleshoot those."
The thing is, all of the errors were coming from one web server of the four that are in the load balanced group.
By the time they even responded to me, it was 4:30, so all the traffic had died down.
 
Joe
9:59 PM
nice load-balancing there
 
"Well I don't see anything wrong on the web servers."
Of course you don't! There's no one using the app now!
@Joe Right?
 
Why is my neighbor's washing machine making my apartment vibrate so much? This is really unsettling.
 
That's of about the last 1 day and 20 ish hours.
 
Joe
@Pops Probably it's not quite level. Especially if it's a high efficiency washing machine. Those shake like crazy if they're not perfectly level.
 
I honestly don't know much about load balancers at all. And I'm not an ops professional. But I feel like saying "Silverlight, don't care." is just a bit too dismissive.
 
10:07 PM
Thing is, I've lived here for years, and I've never felt this much shaking. It's like they put a couple bricks in there or something.
 
How else would you wash your bricks?
 
Joe
Probably just a load getting imbalanced
Either that or there is a black hole forming in their washing machine
But, you know
 
Thanks for the answer, nice knowing you a-
 
Pops! NoOOooo00oo!!!1!
 
10:43 PM
Okay, weird question. I'm about to post a negative answer to my own Meta question. (i.e. "your question is invalid"). Should I make such an answer CW, or just leave it as is?
 
Joe
?
If your question is invalid, just delete it?
 
Nope. :) It should still stay around
 
Joe
What question?
 
Ah well, here you go. The OP is not going to like the answer, but he's a d**chebag anyway.
0
A: How to support questions about development environments that rely on more than code alone?

BartIf a question cannot be made sufficiently clear using the options provided by the site, it's more than likely simply not a fit. Questions like this have several issues. They are "debug this for me" questions. If you are unable to show us the code or take the specific screenshot with the inform...

 
@animuson Could you do me a favor?
 
10:55 PM
For the fun of it I should just engage in a heated discussion with myself until one of me gets suspended to cool down.
 
@animuson Your duty awaits you. Come hither!
 
I need to know what the CSS class is to generate that orange flag thingy in the topbar for modrators.
Wait, maybe Chrome Dev Tools can help!
Aha! mod-flag-indicator
Nevermind, animuson
You have been replaced by a chrome utility :P
 
My flag indicator is in a different spot and has a different class. :P
 
@animuson Oh? Please tell!
I'm making a thing
 
Now would be a good time to extort him @animuson.
After such insults
 
11:03 PM
I'll just go find another mod :P
 
11:24 PM
Haha, and I got a revival badge for talking to myself. Awesome.
 
<a class="topbar-icon icon-flag yes-hover" title="[way too many] posts flagged for moderator attention" href="/admin/dashboard">
    <span class="supernovabg unread-count">
        [way too many]
    </span>
</a>
 
@ThiefMaster It's not to the next biggest number. :P (edit history still shows, BTW)
 
Yeah it's not really a secret thing anyway
 
Why'd you edit it then?
 
"way too many" fits better imho
 
11:30 PM
You could just give your mod powers to me and Undo, and we'll make it be not enough. :P
 
11:46 PM
Is there a CM who can save a poor new user pissing off the entirety of The Workplace with an account merge? Here is the meta thread, but the poor guy keeps posting from different accounts, being unable to address the previous questions he asked with edits or comments, and posting new versions over...and over...and over... It looks like he finally registered this account
 
Simple side-effect of unregistered account there. Nothing for anyone to get p*ssed off about I think.
 
2
Q: Confusing wording in “about this site” pages

ScottI’ve been a member of Stack Exchange (specifically, Super User) for almost a year and a half, but I’m slowly expanding into other SE sites (e.g., “Unix & Linux” and “English Language & Usage”).  Every time I do, I look at the “about” page / tour (for example, here is the one for Super User, and I...

I think scott may have gone a little mad, 8 answers and counting
 
@Bart The guy has posted the same question half-a-dozen times in various forms, ignoring previous answers, making edits to new posts as new accounts to respond to comments to previous comments on previous questions, and is causing a whole slew of headaches for community moderation since we can't handle this with normal tools.
 
@RichardTingle Yeah... :P
 
@jmac I see. That is admittedly annoying.
 
11:53 PM
Holy crap. Top bar awesomeness on the mobile site.
 
Ha, @animuson to the rescue @RichardTingle
 
@Bart Look at this suggested edit -- totally different user name, edit summary is only 'clarifications', and so whoever reads these, unless they have been struggling with this user already, would be absolutely baffled as to what is going on
So general idea is if we can merge all his various accounts and questions, then we can start downvoting, deleting, and consolidating his posts so that he will have a clear way to interact with us without mucking up the entirety of our review queue.
 
True. Though it's still an annoying side-effect of allowing unregistered users to ask questions. But I can see why they allow it for new/small sites
 
> This post has been locked while disputes about its content are being resolved. For more info visit meta
 
Ooh, glorious topbar @jadarnel27
 
11:56 PM
The banner tells users on meta to visit meta when a meta post is locked. Very... meta.
 
@Bart We've had a lot of new people show up, but I don't think I've ever seen anything this bad in the year I've been looking. Usually people can stay unregistered, but still have access as long as they have cookies, so it isn't that much of an issue. Either this guy is using separate browsers, or different devices, or just has cookies off or something?
 
Or he has eaten "special" cookies and has gone off the deep end.
 
@hichris123 Like [meta-tag:meta-tag] levels of meta.
@Bart Well, yes, that is always a possibility. But his questions indicate he is a manager. And we all know managers are always very well adjusted people.
 
@jmac Yep. You're on meta? Well, why don't you visit meta?
 
Those moments when you're complaining that it's flipping cold in your room and at the same time are considering getting a popsicle.
 
11:59 PM
must ... not ... comment ... @jmac
 

« first day (1268 days earlier)      last day (3752 days later) »