What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 133 Stack Exchange communities.

This I came across visiting the data explorer. It's not quite restricted to it, though.

Whenever I load up a query, the value in UserId textbox is 255753, whereas mine is actually 255756.

255753 is an unregistered user which has been last seen 2 minutes before I actually signed up. Even the gravatars are the same.

share|improve this question
    
For some reason, you have the same email hash as well (presumably why you have the same Gravatar). –  Gelatin Feb 15 '11 at 19:55

1 Answer 1

up vote 3 down vote accepted

The field value is "guessed" by trying to match your SEDE e-mail hash to a user's e-mail hash from the selected site's data set:

select top 1 Id from Users where EmailHash = @EmailHash

Looking at the two gravatars, it appears you accidentally created an extra account -- the unregistered one has a lower Id value, so it comes up before your real account.


Please follow the appropriate instructions to merge your accounts together (cleaner).

I have added an ordering clause to the query so if there are multiple accounts with the same e-mail hash, the one with the highest reputation will populate the text box.

share|improve this answer
    
Great. Thanks a lot. –  Linus Kleen May 20 '11 at 12:45

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .