Data Explorer (SEDE)

« first day (651 days earlier) ← previous day next day → last day (1676 days later) »

rene

11:27

→ 1 message moved to Sandbox/Trash Bin/Something

4 hours later…

Feeds

15:50

Q: Is bounty returned by moderator shown in revision history (timeline, SEDE)?

Moderators can refund the bounty to the users offering bounties. (However, this only happens in some rare situations. If that happens, can we see this in the timeline and revision history. Is some event recorded in PostHistory table in Data Explorer? Based on what I read in the FAQ post "How doe...

3 hours later…

Martin

18:50

@Glorfindel Thanks for the query posted in the answer to my recent question: When a bounty is returned by moderator, is this shown in the revision history (timeline, SEDE)?

I will just point out that among the results there are still some posts which are probably false positives. (Of course, it is not a big problem - there are only a few posts which the query returns, so one can simply look through them manually.)

To explain what I mean, I will use this query on Mathematics: data.stackexchange.com/math/query/1236765/…

You can see that there are some instances were pn.DeletionUserId isn't a moderator. (Yannic Muller, George Carlin, Abishek, etc.)

math.stackexchange.com/posts/3465251/revisions math.stackexchange.com/posts/3354783/revisions math.stackexchange.com/posts/2783577/revisions math.stackexchange.com/posts/236640/revisions

Glorfindel

Yeah, strange ...

Martin

I am not really sure why two different users are shown in SEDE. (In the revision history I see the same user offering and awarding bounty.)

Glorfindel

I'm not sure why the OwnerUserId isn't set correctly there.

I'll have a look what the query says on Ask Different.

Martin

I was thinking that perhaps this might happen if two useraccounts were merged, but something like that is unlikely for high-rep users.

Glorfindel

Could be a merge, perhaps the Math.SE moderators are willing to take a look.

I didn't find such instances on Ask Different or Chess.SE

Or you could ask another question on Meta - why is user X shown as posting a bounty in the revision history, while SEDE shows another (deleted) user?

Might as well be a bug ...

Martin

19:11

BTW isn't it unusual that number is shown instead of "User Link".

Usually, when the user is deleted, I saw nothing in place or User Link. (I suppose userid is NULL in such cases.) For example, in this query: data.stackexchange.com/mathoverflow/query/1235453/… (That was a query I had at hand, it shows only UserDisplayName for deleted users, user9072 is close to the top in that query.)

Martin

19:25

I have asked in Math Mods' Office. Maybe asking another question on Meta Stack Exchange makes sense too - but if I do it, then probably later.

I do not want two related questions so close after each other. Moreover, I'll have to do some stuff IRL.

Martin

19:42

Another unusual thing is that I found a question on MO which is not deleted, but just a number is shown instead of the [Post Link].

See this query on MathOverflow: data.stackexchange.com/mathoverflow/query/1236765/…

There is a row with questions 232926 mathoverflow.net/posts/232926/revisions

Oh, i see, that one was migrated: Construction of a Global Isomorphism(permutation) for Graph Isomorphism using Local Isomorphism

2 hours later…

Glorfindel