Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 158 Stack Exchange communities.

What is meta?
Here's how it works:
  1. Any Stack Exchange user can ask a question
  2. The community provides support, votes on ideas, and reports bugs
  3. Your voice helps shape the way Stack Exchange operates

(I hope this is the correct place to post this - I'm not sure who "owns" the data explorer)

I originally registered on data explorer with my main open id provider and got an account (user 15). Since then, I have logged in twice using my gmail open id by mistake. Each time I was given a new account (users 40 and 965). I now have three accounts, two of which I have done nothing with and do not need.

How do I get the two duplicate accounts removed (40 and 965)?

As an aside, is there a plan to allow more than one open id per account the same as the SOFU sites do?

share|improve this question
This is the right place to post questions about Data Explorer. It was originally created independently by Sam Saffron but is now in cooperation with the Stack Overflow peops. – Grace Note Jun 19 '10 at 22:13
@ccomet: I knew Sam was behind it, but now its url has changed to odata.sta... I wasn't sure who was the "responsible person". – adrianbanks Jun 19 '10 at 22:21
Ah, I see. Actualy, he seems to even have the power to mark [status-completed] here on Meta without the diamond. – Grace Note Jun 19 '10 at 22:22
@adrian:… – Jon Seigel Jun 19 '10 at 22:23
@ccomet: He's a regular user like you or I. [status-completed] gets added quickly by observant mods or through flagging. – Jon Seigel Jun 19 '10 at 22:24
@Jon among many others. I presume this was to simply speed up the tagging process since there are a lot of Data Explorer questions and he addresses them fairly quickly. – Grace Note Jun 19 '10 at 22:26
If someone could point him this way it would be much appreciated :) – adrianbanks Jun 19 '10 at 22:28
@ccomet: Wow. Never saw that before. Thanks. – Jon Seigel Jun 19 '10 at 22:41
@Jon @ccomet ... for the record, waffles is not yet an admin and the history shenanigans are due to some database history wizardry and/or tag renaming done by admins. I started tagging stuff status-completeded and the admins renamed the tags. As for the history of SEDE, Stack Overflow has always been behind it from get go. As for waffles becoming an admin, this may happen sometime in the future. – waffles Jun 21 '10 at 2:16
@waffles: Ahhhhh that makes sense. I didn't think Jeff had implemented that kind of permission system. – Jon Seigel Jun 21 '10 at 2:22
@ccomet: Comment ping. – Jon Seigel Jun 21 '10 at 12:30
@waffles So Jeff did yet more of his global rewrite of history. It makes more sense than the permissions, yeah... also explains that one of those posts questioned you using "status-completeded" but the history showed no sign of that ever happening. It's temporal anomalies like this that explain why we need more totally rad programmers. – Grace Note Jun 21 '10 at 12:38
@Jon Thanks for the ping~ – Grace Note Jun 21 '10 at 12:39
up vote 3 down vote accepted

Adrian, I just merged your accounts and another 10 or so dupe accounts I came by.

I am also setting up a permanent redirect for the old cloudexchange url which is causing a lot of these account so show up.

As it stands the DB supports multiple open ids per account, but there is not UI to associate them, I sort it out with spMergeUserBasedOnEmail which is far from ideal.

For the time beings I am trying to run:

select email, count(*) from Users 
where len(isnull(email, '')) > 0
group by email
having count(*) > 1

Once a week or so to catch the accounts and then will run a merge.

As soon as SEDE goes open source I will welcome a patch that sorts out this mess and brings stuff inline with SO.

I think it makes sense to post a separate feature request for to allow for multiple open ids per account, it is totally status-approved

share|improve this answer

You must log in to answer this question.

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