{"action":"closed","issue":{"url":"https://api.github.com/repos/OrchardCMS/Orchard/issues/473","labels_url":"https://api.github.com/repos/OrchardCMS/Orchard/issues/473/labels{/name}","comments_url":"https://api.github.com/repos/OrchardCMS/Orchard/issues/473/comments","events_url":"https://api.github.com/repos/OrchardCMS/Orchard/issues/473/events","html_url":"https://github.com/OrchardCMS/Orchard/issues/473","id":68170287,"number":473,"title":"Creating a user with the same UserName as a deleted user causes login to fail","user":{"login":"orchardbot","id":11788683,"avatar_url":"https://avatars.githubusercontent.com/u/11788683?v=3","gravatar_id":"","url":"https://api.github.com/users/orchardbot","html_url":"https://github.com/orchardbot","followers_url":"https://api.github.com/users/orchardbot/followers","following_url":"https://api.github.com/users/orchardbot/following{/other_user}","gists_url":"https://api.github.com/users/orchardbot/gists{/gist_id}","starred_url":"https://api.github.com/users/orchardbot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/orchardbot/subscriptions","organizations_url":"https://api.github.com/users/orchardbot/orgs","repos_url":"https://api.github.com/users/orchardbot/repos","events_url":"https://api.github.com/users/orchardbot/events{/privacy}","received_events_url":"https://api.github.com/users/orchardbot/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2010-10-12T02:17:08Z","updated_at":"2015-04-13T19:08:06Z","closed_at":"2015-04-13T19:08:06Z","body":"__TimothyWalters__ created:\r\nhttps://orchard.codeplex.com/workitem/16638\r\n\r\nReproduction:\r\n1. Create user (e.g. FredBloggs)\r\n2. Delete user\r\n3. Create user with same name\r\n4. Attempt to login as new user\r\n\r\nMembershipService.cs ValidateUser() method fails with a repository error of \"Sequence contains more than one element\", due to multiple records in the Orchard_Users_UserPartRecord table having the same value for UserName, although one is marked as not published in the Orchard_Framework_ContentItemVersionRecord table."}}