{"action":"created","issue":{"url":"https://api.github.com/repos/HTBox/crisischeckin/issues/402","labels_url":"https://api.github.com/repos/HTBox/crisischeckin/issues/402/labels{/name}","comments_url":"https://api.github.com/repos/HTBox/crisischeckin/issues/402/comments","events_url":"https://api.github.com/repos/HTBox/crisischeckin/issues/402/events","html_url":"https://github.com/HTBox/crisischeckin/issues/402","id":109369168,"number":402,"title":"Volunteer  Foreign Key Contstraint Error","user":{"login":"chazkyle","id":12817727,"avatar_url":"https://avatars.githubusercontent.com/u/12817727?v=3","gravatar_id":"","url":"https://api.github.com/users/chazkyle","html_url":"https://github.com/chazkyle","followers_url":"https://api.github.com/users/chazkyle/followers","following_url":"https://api.github.com/users/chazkyle/following{/other_user}","gists_url":"https://api.github.com/users/chazkyle/gists{/gist_id}","starred_url":"https://api.github.com/users/chazkyle/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chazkyle/subscriptions","organizations_url":"https://api.github.com/users/chazkyle/orgs","repos_url":"https://api.github.com/users/chazkyle/repos","events_url":"https://api.github.com/users/chazkyle/events{/privacy}","received_events_url":"https://api.github.com/users/chazkyle/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-10-01T19:44:49Z","updated_at":"2016-01-07T10:53:03Z","closed_at":null,"body":"REPO: \r\nhttps://crisischeckin-d.azurewebsites.net/Home\r\n\r\nChoose Disaster that doesn't have an activity. Enter valid date range and location. Click Volunteer\r\n\r\nERROR:\r\nServer Error in '/' Application.\r\nThe INSERT statement conflicted with the FOREIGN KEY constraint \"FK_dbo.Commitment_dbo.Cluster_ClusterId\". The conflict occurred in database \"crisischeckin-dev\", table \"dbo.Cluster\", column 'Id'.\r\nThe statement has been terminated.\r\nDescription: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.\r\n\r\nException Details: System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint \"FK_dbo.Commitment_dbo.Cluster_ClusterId\". The conflict occurred in database \"crisischeckin-dev\", table \"dbo.Cluster\", column 'Id'.\r\nThe statement has been terminated.\r\n\r\nSource Error:\r\n\r\nAn unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below."},"comment":{"url":"https://api.github.com/repos/HTBox/crisischeckin/issues/comments/169628294","html_url":"https://github.com/HTBox/crisischeckin/issues/402#issuecomment-169628294","issue_url":"https://api.github.com/repos/HTBox/crisischeckin/issues/402","id":169628294,"user":{"login":"mjmilan","id":6794223,"avatar_url":"https://avatars.githubusercontent.com/u/6794223?v=3","gravatar_id":"","url":"https://api.github.com/users/mjmilan","html_url":"https://github.com/mjmilan","followers_url":"https://api.github.com/users/mjmilan/followers","following_url":"https://api.github.com/users/mjmilan/following{/other_user}","gists_url":"https://api.github.com/users/mjmilan/gists{/gist_id}","starred_url":"https://api.github.com/users/mjmilan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mjmilan/subscriptions","organizations_url":"https://api.github.com/users/mjmilan/orgs","repos_url":"https://api.github.com/users/mjmilan/repos","events_url":"https://api.github.com/users/mjmilan/events{/privacy}","received_events_url":"https://api.github.com/users/mjmilan/received_events","type":"User","site_admin":false},"created_at":"2016-01-07T10:53:03Z","updated_at":"2016-01-07T10:53:03Z","body":"@chazkyle \r\n\r\nIs this still a valid issue Charles?\r\n\r\nThe reason I ask is that I am new to the project, so I've been looking for this \"Actvity\" that Disasters are supposed to have, but I can't find any trace of them. I am proceeding under the assumption that at some point before I started looking at the project they were renamed to Clusters, though I'm not sure about that because the exception text you have supplied clearly refers to Clusters as well.\r\n\r\nIf we can assume Clusters and Activities to be one and the same, then I am finding it impossible through normal use of the application to create a Disaster with no Cluster selected - the validation is checking that we have at least one Cluster selected.\r\n\r\nIn short, I think this can probably be closed, but this should be a decision taken by either @chazkyle , @tonysurma , @BillWagner or @RichardCampbell ."}}