Root Access

Ivo Flipse

00:05

does anyone know how to query data.SE for really old, low views and low votes questions?

TomWij

@IvoFlipse: Let me try

date views and votes

seems we need to throw that in a formula and sort on it

KronoS

00:28

data.stackexchange.com/superuser/q/65777/…

like this @IvoFlipse

Ivo Flipse

what's the date range?

oh wait this one has 'high votes' @KronoS

I'm after low votes

TomWij

Hmm

What would be a reasonable upper limit for views/votes?

KronoS

data.stackexchange.com/superuser/q/65777/…

made changes... just barely getting my hands dirty on this...

Ivo Flipse

change the > 0 to < 1

KronoS

data.stackexchange.com/superuser/q/65777/…

I know have it less than 2... and views less than 350

Ivo Flipse

00:33

damn I need to stop checking out those questions or they'll get more views :(

KronoS

-1

Q: Hardware Pen device for presentation

Hi I have a scenario. Hope you could suggest the software and hardware required? I teach maths. I write math equations as i do in a paper/ohp and this should get displayed on the screen. I find hardware 'pen' - writing and pointing device. Tablet pen- I accept my limited knowledge on that. Here...

Mark Szymanski

o.o

KronoS

like this one... I think this maybe the type your looking for

Mark Szymanski

Apparently I have like 241 comments.

KronoS

I'm going to save the query

TomWij

00:34

@IvoFlipse: What about this one?

data.stackexchange.com/superuser/q/65816/…

Ivo Flipse

I like that one

I think I'll delete a bunch of those tomorrow

TomWij

Just made that query up, but something is still bothering me...

Changing the "Score, ViewCount" part of the ORDER BY clause into a formula and changing the limits specified in the WHERE clause might give better results, but anyhow... Should be sufficient enough to get the oldest cleaned.

Tried Score * ViewCount, but that obviously doesn't work as Score is 0 most of the times. :D

Ivo Flipse

yeah I'm planning on outright deleting anything that get's no attention, no votes, no answers, no views

and preferably has been asked by an inactive user

studiohack

@MarkSzymanski: I have 487 - but only 2 of them have a score of 5 or higher...I must not be sarcastic enough.....

Mark Szymanski

Heh.

Only one of mine have a +5 score.

TomWij

00:39

Yeah, 1.5 years later he probably has already solved the problem or the problem just doesn't exist anymore.

And we can't spend time on fixing such a problem either given we don't know if it (or its user) is still there.

Ivo Flipse

exactly

but it remains unanswered

and it's hurting our stats

so if we delete a 1000 bad ones :P

studiohack

yeah

that will really help our stats @IvoFlipse

Ivo Flipse

66k questions

I'm sure we can loose some dead weight

studiohack

that's for sure...

Ivo Flipse

out of those 12k or so that's unanswered

Mark Szymanski

00:40

If I could delete questions, I would help.

TomWij

@IvoFlipse: Hmm, just thinking about it, my query doesn't check if they are answered.

Ivo Flipse

you can flag questions that should be deleted @MarkSzymanski

studiohack

as in without checkmarks or absolutely no answers posted?

TomWij

Want me to adjust?

studiohack

@IvoFlipse

Ivo Flipse

00:41

please do

Mark Szymanski

Ok.

Ivo Flipse

preferably no answers at all @studiohack

and if they have, no upvotes on those answers

TomWij

@studiohack: It doesn't check answers at all, it just looks for lowest votes/views questions of a long time ago.

hmm

Mark Szymanski

I found one that is more than a year old, with no accepted answers. The asker seems to be dead, too.

Flagged it.

studiohack

makes sense @IvoFlipse

TomWij

00:42

How could I easily check if they are unanswered, one moment...

Ivo Flipse

low views, very old, no activity and no upvoted material

studiohack

@TomWij: ah okay...

Ivo Flipse

but watch out, if we all start looking at questions now

the views go up!

Mark Szymanski

They'll get more views ;)

I'll stop looking now :P

I'll just keep browsing the front page to try to find questions to answer and get more rep from :P

Ivo Flipse

good boy ;)

studiohack

00:45

@IvoFlipse: does this question have any lasting value? confusingly worded, etc

0

Q: Facebook pop ups

How do you allow Facebook to create pop ups so i can upload a video on my page? It says it wont let me until I disable my pop-up blocker or allow this page to create popups, then try again. Any idea how to do any of those things?

facebook web-browser

Ivo Flipse

not anymore it does

but preferably no or really only one upvote

studiohack

yippee! this is fun!

@IvoFlipse: right.

Ivo Flipse

let's start with the real lowest hanging fruit

I had to upvote the champ, because he lost 2 upvotes there :P

studiohack

would I just go to the questions page and start browsing?

as in, start at the first page @IvoFlipse

Ivo Flipse

no I'd wait for @TomWij or @KronoS to come up with a better query

the first page doesn't have old questions does it?

or sorted for date? :P

Mark Szymanski

00:47

I just saw that "good boy" reply you just left me, @IvoFlipse... >.>

Ivo Flipse

yes you are ;)

studiohack

merge this dupe's with the original? then delete the dupe?

36

Q: Screenshot Taking Tools

Possible Duplicate: Screenshot utilities for Windows What are the good screenshot taking tools available (open source and commercial)?

tools screenshot

Ivo Flipse

now get back to your rep-hunting!

2

Mark Szymanski

growls

Ivo Flipse

down boy

Mark Szymanski

00:49

facepaws

Oh. Yeah.

facepalms

TomWij

@IvoFlipse What about this one?

data.stackexchange.com/superuser/q/65891/…

The WHERE clause has been changed to check if it is unanswered.

studiohack

this one is answered: superuser.com/questions/31492/video-streaming

and it is on @TomWij's list

or newest query

TomWij

@studiohack: No, that's unanswered. As there are no upvotes or accept marks given...

studiohack

ahhh! so that's what you mean by ananswered.

kill this one

0

Q: Virtual PC and DPCs

In my environment, we're using VPC images for several users. Some users are seeing "Not Responding" messages from their VPC image for long periods of time. When exploring this in ProcessExplorer on the host machine, we see the process "DPCs" (Deferred Procedure Calls) taking up gobs of processor...

virtual-pc dpc

TomWij

Actually, unanswered is pretty ambiguous...

@IvoFlipse: What type of unanswered questions does Area 51 (or your stats) base itself on? The one I think about?

studiohack

00:53

this one is downvoted, but some answers may be the same between OP and dupe...so delete w/o merging?

Ivo Flipse

no accepted answer

studiohack

-4

Q: What's your preferred hex editor/viewer (any platform)?

Possible Duplicate: Hex Editors for Windows? community wiki I don't do much of it, but... I'm on Windows and use XVI32. Not the prettiest. Edit: see also, Hex Editors for Windows?, What is a good Windows hex editor / viewer? [SO]

software-rec favorites list

Ivo Flipse

preferably ignore questions closed as duplicates

because dupes aren't always a bad thing

studiohack

no upvotes, but 3 answers on this one...

-3

Q: 4 Browsers on a Single Machine

I have 4 browsers installed on my PC. IE8 Firefox (Default) Safari Opera My problem is that sometimes the other browsers don't work. Is there anyone that could explain why?

windows browser

TomWij

Hmm

Ivo Flipse

00:54

but downvoted dupes (because they suck that is) can go too

studiohack

okay, will do @IvoFlipse

TomWij

But would the stats count them in or not?

Ivo Flipse

oh and best to just flag them

because I'm going to try and wrap my work up and go to bed :P

count which in?

after I delete they don't exist anymore

TomWij

duplicate questions which are unanswered

studiohack

okay

Ivo Flipse

00:55

at least not in the new queries

I think closed questions are expelled too

because we can't answer them anymore

you might want to ask it on MSO though

studiohack

right...off-topic/subjective etc

KronoS

we should probably divide this up @studiohack @IvoFlipse @TomWij

studiohack

okay @KronoS

like how?

currently getting the easy ones out, by looking at the ones with low votes, -1 or lower

KronoS

One takes the more recent the other takes latest?

studiohack

on @TomWij's query?

TomWij

00:57

@IvoFlipse: Gonna leave the unanswered check as is, multiple Meta.SO questions verify it is not accepted + no upvotes.

studiohack

btw @IvoFlipse: I only have a set number of inform mod flags...

Ivo Flipse

then create a question on Meta.SU

KronoS

and how recent do we want to go?

2010 too recent?

Ivo Flipse

and you keep a list of questions that should be deleted

start with 2009

and link to this conversation + the query your using

studiohack

okay, can I create a post, and you make it CW, so that @KronoS and others can edit and add posts?

KronoS

00:59

gets ready to work his butt off again for @IvoFlipse

Ivo Flipse

then I can just open all those links and delete them

yeah

but you can all add your own answer with questions too if you feel like it

though perhaps better we don't

because it will become harder to keep track of what has been closed :\

studiohack

0

Q: Questions for deletion

Questions that should be deleted, as per moderator approval.

discussion

so create new post for each new question that should be deleted?

@IvoFlipse

TomWij

@KronoS: Given the current filter limits there are 500 unanswered questions from 2009. Afterwards we'll need to discuss how recent we will go or perhaps increase the filter limits to show more crappy questions.

Ivo Flipse

no, create a list of questions you want delete in one answer

studiohack

oh, okay...

Ivo Flipse

01:02

something else that would trigger crap is users with only 1 question

KronoS

I'm assuming we mark as low quality? @IvoFlipse

Ivo Flipse

that qualifies for all the other points off course

yes, but if you run out of flags @KronoS you can use the meta question to list them

KronoS

we should also write a script that somehow searches a few words from the body with a gmail search... to filter out the spammers.

got it

studiohack

1

Q: Experience with Nuance PDF Converter Professional 6 or alternatives?

This is really a question on behalf of someone who asks me for IT advice. They've been offered a reduced rate purchase of Nuance PDF Converter Professional 6 as they're an Omnipage user, and asked me whether it was any good. That's obviously a somewhat open and subjective question, so more to...

pdf convert

closed as subjective or delete?

KronoS

i got 14 left...

studiohack

01:03

i only have 12

@KronoS: we opened a question on meta (SU) for questions that should be deleted

Ivo Flipse

it's gone @studiohack

studiohack

I'm enjoying this -

Ivo Flipse

somebody just needs to add some more info to that MSU question ;P

studiohack

okay, like what?

TomWij

@IvoFlipse: Editing it atm.

studiohack

01:04

this question is only for @KronoS, @IvoFlipse etc

? joking lol

@IvoFlipse: let me know when you leave for good, and I'll stop posting links in here

unless you want them going to Meta starting now?

0

Q: Can not mount disc from cdrecord in sao mode

Possible Duplicate: Can not mount disc from cdrecord in sao mode I tried to burn a livecd iso with my DVD-RW, and it seems it can not burn with cdrecord command in default tao mode. Then I switched to sao mode, it was burned. But it seems I can not get the burned disc mounted. moun...

linux

Ivo Flipse

start now

because nobody will ever be able to read this transcript :P

KronoS

oh also do we just flag.. or vote to close and flag?

studiohack

flag is quicker @KronoS

@IvoFlipse: my question is blank

KronoS

lol wow we got Jeff's attention right away

2

@studiohack do you want me to flag those you just posted?

I've still a got a few left

studiohack

no, @IvoFlipse is going to go through and delete later

@KronoS: you can add more to an answer in my question, edit my answer, or just create a new answer - partly why I had Ivo make it CW

@KronoS: which questions are you taking?

TomWij

01:13

@IvoFlipse: Feel free to adjust further or merge with any parallel edits.

0

Q: Old unanswered inactive questions with low views/votes

@IvoFlipse was looking for a query to find old unanswered inactive questions with low views/votes. Because those kind of questions clutter the site and keep the unanswered question ratio high, it is a good idea to keep the site clean from questions like these. It's very unlikely that someone th...

support unanswered delete

KronoS

@studiohack the ones you just posted on meta

Ivo Flipse

sounds good enough :)

studiohack

@TomWij nice job

@IvoFlipse: I'll keep the links to just 5-10 per answer, then it is easier to see progress :-)

KronoS

And then strikethrough answers that were completed

studiohack

sure...how do I do strikethrough, I've never figured that out?

not for this purpose, but in general?

KronoS

01:16

there's a code like <strk> or something like that

TomWij

@IvoFlipse: We might want to create three lists in a single answer: To be deleted, Not deleted, Deleted

Ivo Flipse

<s> is the code

I striked them through

62

Q: What HTML tags are allowed on Stack Overflow, Server Fault, and Super User?

The Stack Overflow site engine, as you know, uses Markdown for questions and answers. Per the Markdown spec, you are allowed to freely intermix HTML and Markdown tags. However, we do not allow all HTML tags, as that would be an XSS paradise. To that end, the Stack Overflow engine allows only the...

support faq markdown html

TomWij

Ah, better idea. :-)

Yeah, I know, didn't think of it.

studiohack

@IvoFlipse: see the last two URLs of the post you just cleaned up on SU Meta

they were not deleted - got covered up by your edit of strikethrough :P

TomWij

@studiohack: Yeah, saw it, adding them in...

studiohack

01:20

the more the merrier :P

Ivo Flipse

best not to keep multiple revisions of one answer then ;P

they're gone too now

studiohack

okay moved on

KronoS

and there goes my last flag...

Ivo Flipse

I'm going to kill all old off-topic, not a real question and dicussion questions too some day

2

great job already you guys :)

studiohack

I'm posting questions instead of flagging @KronoS

thanks @IvoFlipse

KronoS

01:26

@IvoFlipse you can close/delete my question that I flagged... it's no use to anyone...

I'm done now too... gotta curb my addiction to SU and actually get some homework done

0

Q: App to video chat between iPod Touch 4 and Android phone?

I am looking to do a video chat between an iPod Touch 4 and an Android phone (not sure which version, but less than a year old). Both of these devices have video cameras and microphones, I'm just not sure the easiest way to video chat between the two. Any suggestions?

iphone android ipod-touch chat video-chat

since I ran out of flag @IvoFlipse can you take care of this

studiohack

voted to close also @KronoS

KronoS

oh and let us know when you're gone so that we don't litter your inbox with messages

Ivo Flipse

hehe, I'm still not done yet

no need to crash and burn @KronoS

after 1,5 years there's hardly any rush to get rid of them

TomWij

@IvoFlipse Multiple revisions should be fine, just check the history every now and then to see if nothing is red there.

studiohack

lol

TomWij

01:30

Or well...

studiohack

can anyone clarify for me

4 revs, 2 users 73%
TomWij

TomWij

A small number of answers could work well too, it decreases the change of simultaneous edits.

studiohack

what this means? on my SU Meta question?

I understand the revs part, and the 2 users part, but what about the 73% part?

KronoS

1

Q: Can't open microsoft related web pages (but ping works !)

It seems that I can't open all Microsoft pages (microsoft.com, support.microsoft.com etc) but pinging Microsoft's IP works (65.55.21.250). even opening Microsoft pages with the IP's works http://65.55.21.250/en/us/default.aspx The hosts file is clean, no signs of bad entries. any help?

windows internet dns

@studiohack this is actually a dupe

TomWij

@studiohack Changed the question for 73%

studiohack

01:31

@TomWij: 73% what?

you changed 73% of the question?

TomWij

Dunno, characters.

KronoS

@TomWij owns 73% of your soul now @studiohack

studiohack

@KronoS: I know facepalm I should have known it was related to your latest SU Blog post...

wasn;t thinking

Ivo Flipse

@KronoS Jeff's question wasn't meant to close every question as a dupe

studiohack

@TomWij: that's sad...not gonna happen

KronoS

01:32

ya that only shows how much people really read the blog :(

@IvoFlipse I know but this one is pretty related

studiohack

I knew before hand about your blog post, but didn't make the connection - sorry

Ivo Flipse

perhaps

studiohack

WHY so many of these virtal questions?!!!

1

Q: How virtual is virtualization?

While reading different materials on different subjects every now and then I come back upon the question: How virtual really is virtualization? With "virtualization" I mean things like Virtual PC and VMWare, which allow you to run an guest OS. In particular, what I don't understand is: Does the...

virtualization

KronoS

esp since all the answers are the same @IvoFlipse

studiohack

the above ^ question is related to sandboxing of virtual solutions

TomWij

01:34

The thing that's weird to me...

5 answers in 5 minutes. :-S

KronoS

@TomWij ya I though the same thing

TomWij

Ah, nvm, migrated from SO, doh...

KronoS

aight I really am leaving now lol...

talk at you guys later

TomWij

Cya

studiohack

night @KronoS! thanks for the help!

KronoS

01:36

no porb ;)

studiohack

I corrected mine @KronoS. ;P haha

Ivo Flipse

after others have seen the scalps we collected @studiohack, you can repurpose answers that have been 'processed'

studiohack

@IvoFlipse - clarify?

I don't know what you mean by 'scalps' and repurposing?

oh scalps! :P

Ivo Flipse

scalps as in all the deleted questions

studiohack

delete them or what?

Ivo Flipse

01:44

yes you can delete the text and put in new questions

no need to use any fancy formatting

and any comments, if you doubt for instance

leave them at the question

studiohack

ah, okay...make sense. and yes, I know about scalping humans :P

Ivo Flipse

I'll spot them there

studiohack

oh, as a comment?

on the question?

Ivo Flipse

yes, but only when you really doubt

so most of the time, don't bother

studiohack

which would you rather i do: doubt and comment or doubt and link?

Ivo Flipse

01:45

but if you leave them in the 'answer' on MSU, and we delete it, it's gone!

studiohack

or doubt and skip?

Ivo Flipse

no, always link

but if you doubt, you may comment

but I wouldn't worry

studiohack

okay, thanks for all the clarification @IvoFlipse

:-)

Ivo Flipse

they are abandoned

hi @instanceofTom :)

studiohack

sure...

thank goodness for Lazarus!

Ivo Flipse

01:50

well now I'm going to get ready for bed

so good luck

and don't burn yourself down :)

studiohack

good night @IvoFlipse - good talking with you today

CmdrGuard

Hello.

studiohack

@CmdrGuard: hello

new to Super User?

CmdrGuard

Yes. But not to stackexchange.

I have a few posts at stackoverflow

I have never done chat over there. And frankly, I thought I needed more reputation over here to be able to chat.

studiohack

no, but if you have less than a certain amount, you get kicked out of the room after 4 hours...

not exactly sure what rep level exactly...

CmdrGuard

01:56

haha

well then I shall preemptively kick myself out

I just wanted to see the interface

studiohack

it's all good @CmdrGuard

CmdrGuard

and I must say, it is quite impressive

studiohack

it is nice...

CmdrGuard

Anyways, thanks for the chit chat. Hope to run into you later studiohack

studiohack

have a good one @CmdrGuard

Sathya

03:13

faqoverflow.com

KronoS

@Sathya what is this exactly... the community FAQ's and top answers all in one site?

studiohack

@Sathya: who is the author?

@KronoS: voted to close ;)

KronoS

@studiohack thanks

Sathya

no idea @KronoS @studiohack found on Hacker News comment thread about @GregHewill's SO Top questions eBook

studiohack

interesting....

Sathya

03:19

news.ycombinator.com/item?id=2132883

studiohack

06:04

finally got the Sportsmanship badge!

DMA57361

08:49

morning all

I see we started on the clean out while I was asleep

@studiohack nice job

DMA57361

09:53

Stuck at home today, so I've tweaked the "abandoned" query a bit - data.stackexchange.com/superuser/s/842 - don't know how many will be left because @studiohack may have raised all the Q's on meta already :P

Ivo Flipse

don't count on it

DMA57361

no, there are a lot :/

I'll probably add some to meta at some point

Ivo Flipse

though the time frame is a perhaps a bit too 'fresh'

what's the cut off date?

DMA57361

my query?

Ivo Flipse

yeah

DMA57361

09:57

last activity on the question and by the owner is at least 6 months ago

Ivo Flipse

ah that the owner visited the site

that's a nice twist

I suggest you add that to the meta question :)

DMA57361

yeah, thought it'd help reduce the potential for false positive matches

Ivo Flipse

at least those users are dead to us, because they probably will never come back

have you tried tweaking it to something like 12 months?

DMA57361

indeed

Ivo Flipse

can't edit it :S

DMA57361

09:59

erm...

Ivo Flipse

I just copy pasted it for now and edited the 6 to 12

DMA57361

try clone

Transcript for