Tavern on the Meta

2:17 AM

I love that all of my meta flags are either: comment flags, dupe flags, off-topic flags, or spam/offensive flags.

But almost all dupe flags.

Qantas 94 Heavy

2:54 AM

@Undo: except for you, all the users in the top 10 have at least 20k

3:09 AM

@Doorknob Yeah, I know. Having a Paypal issue that is delaying that, and also cause me to consider if I even really want a blog anymore. Most indicators point to no.

@TimPost You could blog about the joy of destroying spammers... and being lord of the swag.

The thing is .. mechanics tend to drive clunkers. Electricians have wires hanging out of their front porch. Carpenters have steps that sink when you use them. I write all day, and the last thing I really want to do when I have free time is write more.

Heh. Though you could just make it a part of your job...

Undo

3:37 AM

I want to read blog posts about destroying spammers and being lord of the swag, @TimPost.

Andy Clifton

4:18 AM

Evening all. Am I allowed to ask a serious question in here, or is that a breach of etiquette?

3

4:29 AM

We accept all types of questions here.

@animuson Um... What's your SE password?

@hichris123 hichriswillnevergetmypassword123

enters password in

It didn't work. :(

Hmm... how mad do you think SE would be if I tried to brute-force it? :P

Qantas 94 Heavy

5:05 AM

@hichris123: there are IP request limits in place, I know I've hit it trying to download all my reviews when I f***ed up my code

jmac

What percent of SO CMs were moderators prior to their hiring?

5:30 AM

[ SmokeDetector ] All-caps title: CONTINUED FROM THE ABOVE SECTION on math.stackexchange.com

@jmac Me, Grace, Jon, Anna Lear, Rebecca Chernoff. Anna since moved to the dev side of the force. Rebecca moved to the dev side of the force as well, and then moved on to other things.

Wasn't Marc also a mod before he became a dev?

Yep. Marc was a mod before he came on

As for the current team, 3/8 were moderators, or roughly 37.5%.

It just feels like my eyes are deceiving me not seeing Anna on that list...

Rebecca, Grace, Anna and myself were all pro-tem, elected, then hired, though Anna and I weren't pro-tems where we were actually elected.

Strike that, I don't think Rebecca was ever actually elected.

@animuson Anna is still very much around on our team.

5:44 AM

But she's not on that list! :(

She's hiding from us...

A: Transferring data from android to PC via bluetooth

6:17 AM

-1

This is a temporary post please do not delete it I'm new in stackoverflow and I do not Khow how can i speak to mr ridoy I hope mr Ridoy see this post and help me then I will delete this post I should solve my problem in a short time. It is very important for me

6:34 AM

Well, +1 for persistence.

7:11 AM

[ SmokeDetector ] All-caps title: HOW DID THEY GET THE ANSWER? on math.stackexchange.com

7:24 AM

This looks like status-fixed

Q: Why in the World has a Question on Algorithmic Trading Not Been Deleted Yet?

8:11 AM

3

I just came across "What technical skills needed for algorithmic trading, HFT, etc?" and immediately voted to delete. But that begs the question - why is this question from 2009 still here? Can we please do a better job deleting this and other old questions that are so totally off-topic?

So tempted to mention Programmers just to watch ChrisF hit the ceiling ...

@LaszloPapp: "I have tried using readonly collection, but have not had good results" is very much "not an answer"

8:39 AM

morning

Praveen

Hi, I don't understand why these edits are getting approved. stackoverflow.com/review/suggested-edits/4098507, stackoverflow.com/review/suggested-edits/4098505 These are simple edits.

deleting "thank you" word in questions edits are correct?

Is it correct to ask my question here in chat?

@ThiefMaster: hmm?

@Praveen removing salutations is fine if they're fixing everything else wrong with the post

(no I haven't checked your links)

@Flyk this one is polishing a piece of steaming turd. Too minor by definition, I'd say

if it's truly a steaming turd, get rid of it

if it's still open, it's fair game

8:53 AM

cv-pls stackoverflow.com/questions/21875320/…

Praveen

9:03 AM

@JanDvorak Thanks. I usually do that. Showing gratitude towards users who are reading their question is reasonably ok right?

because most of time I used to come across these type of edits

in short, by making these edits you are wasting your time on a post noone will read

Praveen

I thought those edits will be rejected. But while checking they seems to be approved. Better to remind community

it's not really a bannable offence to approve these, though

currently watching: Secret Garden - full concert

[ SmokeDetector ] All-caps title: THE REASON WHY YOU USE APOSTROPHE S on english.stackexchange.com

michaelb958

I've seen many bits of extraneous punctuation used to denote plurals, but the "greengrocer's space" is a new one.

9:26 AM

[ SmokeDetector ] All-caps title: DISPLAY IMAGE IN HTML USING WHERE CLAUSE on programmers.stackexchange.com

not just the title. The entire body is all-craps.

michaelb958

ChrisF/ceiling collision in 5... 4...

downvote-pls ^^^

9:42 AM

@LaszloPapp some NAA flag you counterflagged, i don't remember which post it was, but the flag was pretty valid

@ThiefMaster sounds surprising given that @LaszloPapp flags a lot of link-only answers that @BenjaminGruenbaum keeps counterflagging as "valid, but flagged too soon" :-)

[ SmokeDetector ] Phone number detected: Movers and Packers in Delhi @ +919911918545 on drupal.stackexchange.com

@Manishearth would having an at-sign be a sufficient criterion to call a question out?

@Manishearth bonus points if you call it "arobase"

10:08 AM

@ThiefMaster: OK, we can discuss it once you find the link.

until that, I cannot tell my opinion. :)

(but in general, I also make mistakes at reviews for sure)

@LaszloPapp stackoverflow.com/questions/2729875/…

10:35 AM

@ThiefMaster: hmm, I am not sure why you think I invalidated it, apparently mods can see that?

Either way, I thought the quote would be an attempt for explaning the issue.

if that is not correct, then it is not an answer for sure.

that looks like the exception message the guy got

yeah, I agree, on a second read.

@ThiefMaster: perhaps it is even better to move it into a comment?

Benjamin Gruenbaum

10:56 AM

@JanDvorak I don't counter flag them. I just don't validate them

SPArchaeologist

11:33 AM

afternoon

12:19 PM

@Manishearth the bot seems to be off (stackoverflow.com/questions/21880215/…)

Yup

@3ventic what's that userstyle you're using?

@JanDvorak Custom Stack Exchange Chat

thanks, lemme look

have you seen my script?

userscripts.org/scripts/show/162862

Oh, I like this style

Thanks @3ventic

12:24 PM

Benjamin Gruenbaum

ooh, old gravatars!

Somewhat improve my website design - done

I still think it looks kinda bad

but I'm no designer

Doorknob

12:39 PM

@hichris @Undo Fine, you've convinced me ;) I'm learning and using Bootstrap for my site!

1:29 PM

can one of you geniuses have a looksie at this and tell me where my obvious mistake is...

1:40 PM

@Flyk I have no logical explanation then, sorry.

yeah, this entire thing doesn't seem logical to me

@Flyk wait, is... that a typo question?

...?

is there a typo in my question?

maaaybe. I can't see one, but "something stupid" sounds like a typo.

1:55 PM

I'm pretty sure a typo in this instance would result in a syntax error

"No - pageContentCache after the insert has 22778 rows with one row duplicated while #contentcache has 22777 records with no duplicates" now I'm REALLY curious...

My usual Stack Overflow question: I post something that doesn't make sense at all, then few minutes later I realize my dumb mistake and delete the question.

@3ventic delay clicking the "send" button a few minutes, then

Yeah, that's what I learned

I get another pair of eyes on the issue so I only have to facepalm in front of one person, not 20-20 000 000

@3ventic Try spending 15 minutes on an answer, posting it, and deleting it within a minute because you realise your answer is wrong.

2:02 PM

I've done that too

But I learned that you can use HTML attributes without quotes.

and I got a badge!

also, a q-ban?

@Stijn I've done that before

Sometimes I should read the whole question before I answer it :(

s/Sometimes\s//;

s/\\s/ /g

Spaces in regexs always look wrong to me :(

Spaces in regex look weird.

2:07 PM

@rene by ddl you mean you want the create statements right?

I'm always scared it's going to break it for no reason

Yes, sorry if that was not clear

it's ok, this is starting to spread outside of my knowledge

@3ventic Ruby can even handle newlines

My code always breaks for no reason

Well... it's PHP so I guess that's a reason

but still

2:09 PM

If it's PHP, it's broken by definition

4

It gets kind of annoying when you have the code split up in 50 different files..

PHP is not broken by definition -_-

That's a lot of classes

huh... @rene - how long does SQL server cache query results for?

they're loaded in blocks right?

if a table is dropped, are the query results removed from cache?

I'm not sure, I believe that are hidden implementation details

2:14 PM

because... basically, without any changes, it's suddenly working as you'd expect it to work

DDL will commit a txn

@3ventic nice, _original.php

I dropped the tables (both the actual table and the temporary table) and recreated them, re-ran the proc that populates #contentcache and inserted that into pageContentCache and now there are no duplicates

using the same SQL that was causing me problems

@Stijn Backup

@3ventic source control? :)

2:16 PM

@Stijn Something we don't use

Probably should tbh

Oh dear :)

but I'm not sure how to set it up

now I've gone from confused to really confused

@Flyk hmmm, that sounds weird...

It's the kind of project that we edit on the fly anyway, only rarely doing it behind the scenes.

2:17 PM

@rene it's not like this is an issue specific to this particular customer site either, I've seen this problem occur on four different sites in the last month

our application captures the duplicates error when creating an index, which couldn't be reproduced

Are there any open transaction when that insert runs?

if there were an open transaction it would still be open, I've done nothing to rollback/commit

@3ventic Take a look at hginit.com when you have some spare time, it'll teach you the basics.

Not if that sp is issuing an implicit commit

At what point do you think a project is large enough to benefit from source control?

2:22 PM

It is a simple sql setup? Not a cluster with log shipping and fancy stuff like that ? @Flyk

yeah just a single server, run by the customer and on a nice server, but doing nothing fancy

knowing this particular customer they probably don't even do backups that frequently

Shadow Wizard

@Flyk any auto generated ID's somewhere? Or do you generate all the numbers yourself?

@ShadowWizard they're auto generated elsewhere in the system - all element ids, which are unique

if there was a duplicate element id, the page that element appeared on wouldn't load, and we've had no reports of part of their site causing stack traces

If you see this it is always another objectId? Or is it always 21912

no it's not always the same object id

all seven times I reproduced it it was a different object id

2:29 PM

Is that objectid your last id?

no

in no instances has the issue occured with the highest valued objectid

not ruling out that it could happen, just that it hasn't

it's not the lowest either

you did create the temp table outside of the stored procedure?

yeah

basically, it was originally a stored proc called inside a stored proc

since the top level stored proc was failing, I ran through it section by section manually

the top of the query drops the tables and recreates them

the next section calls a stored proc and inserts all of the results into the temporary table so I could go through them before they were put into the search cache

then the contents of that table is put into the search cache

then indexes are created

I'm transferring a copy of the data over here so I can play with it until it breaks again

yay for 60gb of data

This is on a sqlserver 2008 or up box

?

yeah 2008 r2