{"action":"created","issue":{"url":"https://api.github.com/repos/mattbrailsford/UnVersion/issues/3","labels_url":"https://api.github.com/repos/mattbrailsford/UnVersion/issues/3/labels{/name}","comments_url":"https://api.github.com/repos/mattbrailsford/UnVersion/issues/3/comments","events_url":"https://api.github.com/repos/mattbrailsford/UnVersion/issues/3/events","html_url":"https://github.com/mattbrailsford/UnVersion/issues/3","id":89722919,"number":3,"title":"he DELETE statement conflicted with the REFERENCE constraint \"FK_cmsPreviewXml_cmsContentVersion_VersionId\".","user":{"login":"bipin24x7","id":8508274,"avatar_url":"https://avatars.githubusercontent.com/u/8508274?v=3","gravatar_id":"","url":"https://api.github.com/users/bipin24x7","html_url":"https://github.com/bipin24x7","followers_url":"https://api.github.com/users/bipin24x7/followers","following_url":"https://api.github.com/users/bipin24x7/following{/other_user}","gists_url":"https://api.github.com/users/bipin24x7/gists{/gist_id}","starred_url":"https://api.github.com/users/bipin24x7/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bipin24x7/subscriptions","organizations_url":"https://api.github.com/users/bipin24x7/orgs","repos_url":"https://api.github.com/users/bipin24x7/repos","events_url":"https://api.github.com/users/bipin24x7/events{/privacy}","received_events_url":"https://api.github.com/users/bipin24x7/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-06-20T05:52:19Z","updated_at":"2016-01-30T00:36:57Z","closed_at":null,"body":"I am also getting another error. Please let me know what is the fix for this?\r\n\r\n2015-06-20 07:48:24,854 [6] WARN  Our.Umbraco.UnVersion.Services.UnVersionService - Executing \r\n                                    DELETE\r\n                                    FROM\tcmsContentVersion\r\n                                    WHERE\tcontentId = 10328 AND versionId  NOT IN ('56c2b4fe-b2b9-4733-a2b9-6f6c3161fdb7','2112b8a0-46c5-456b-aca3-649fffb966b8','20fb8136-1cc6-4b4c-abfb-fa8c45decc8c')\r\nSystem.Data.SqlClient.SqlException (0x80131904): The DELETE statement conflicted with the REFERENCE constraint \"FK_cmsPreviewXml_cmsContentVersion_VersionId\". The conflict occurred in database \"HandymanDB\", table \"dbo.cmsPreviewXml\", column 'versionId'.\r\nThe statement has been terminated.\r\n   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)\r\n   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)\r\n   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)\r\n   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()\r\n   at Our.Umbraco.UnVersion.Services.UnVersionService.ExecuteSql(String sql, SqlConnection connection)\r\nClientConnectionId:9cf4abe7-bac1-4f90-bab3-73ce96f1ac81"},"comment":{"url":"https://api.github.com/repos/mattbrailsford/UnVersion/issues/comments/177031673","html_url":"https://github.com/mattbrailsford/UnVersion/issues/3#issuecomment-177031673","issue_url":"https://api.github.com/repos/mattbrailsford/UnVersion/issues/3","id":177031673,"user":{"login":"bipin24x7","id":8508274,"avatar_url":"https://avatars.githubusercontent.com/u/8508274?v=3","gravatar_id":"","url":"https://api.github.com/users/bipin24x7","html_url":"https://github.com/bipin24x7","followers_url":"https://api.github.com/users/bipin24x7/followers","following_url":"https://api.github.com/users/bipin24x7/following{/other_user}","gists_url":"https://api.github.com/users/bipin24x7/gists{/gist_id}","starred_url":"https://api.github.com/users/bipin24x7/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bipin24x7/subscriptions","organizations_url":"https://api.github.com/users/bipin24x7/orgs","repos_url":"https://api.github.com/users/bipin24x7/repos","events_url":"https://api.github.com/users/bipin24x7/events{/privacy}","received_events_url":"https://api.github.com/users/bipin24x7/received_events","type":"User","site_admin":false},"created_at":"2016-01-30T00:36:57Z","updated_at":"2016-01-30T00:36:57Z","body":"Do you have any updates on this bug?"}}