v1.1.213.0 - Custom Fields - unable to delete

Topics: Customizing BugNET, General
Feb 28, 2013 at 4:12 PM
By Mistake, somehow created duplicate entry in Custom Fields (same value & description). After spotting this, tried to rename one. BugNet Corrupted all Defects logged and changed value of the custom field of all defects (setting the value to this particular duplicate entry)!!!

This has created lot of unnecessary work to modify all defects one by one.
Does anyone know why this happened?

Second issue - now I have updated all issues, and trying to delete the duplicate entry, but no luck. Error details below...how can I delete?

Thanks.

Webpage error details

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; .NET CLR 1.1.4322; OfficeLiveConnector.1.5; OfficeLivePatch.1.3; .NET4.0C; .NET4.0E)
Timestamp: Thu, 28 Feb 2013 16:12:12 UTC


Message: Sys.WebForms.PageRequestManagerServerErrorException: Cannot insert the value NULL into column 'CustomFieldValue', table 'BugNET.dbo.BugNet_ProjectCustomFieldValues'; column does not allow nulls. UPDATE fails.
Line: 2
Char: 74704
Code: 0
URI: http://srv40047/BugNet/ScriptResource.axd?d=5fHfnTpwYW2TsnCIIECHxXzHkcTNIgBFfT0a2r3kCRPe49KsA263ps0WrsXnZqEiGRtQQi_rtuSvicYoS7FSKym_GvbaAvarKaxvzvI_ey7plW6OlEOZZOL9iOMbIOXI2e5Fwg2&t=ffffffffc9f82b39


Message: Sys.WebForms.PageRequestManagerServerErrorException: Cannot insert the value NULL into column 'CustomFieldValue', table 'BugNET.dbo.BugNet_ProjectCustomFieldValues'; column does not allow nulls. UPDATE fails.
Line: 2
Char: 74704
Code: 0

URI: http://srv40047/BugNet/ScriptResource.axd?d=5fHfnTpwYW2TsnCIIECHxXzHkcTNIgBFfT0a2r3kCRPe49KsA263ps0WrsXnZqEiGRtQQi_rtuSvicYoS7FSKym_GvbaAvarKaxvzvI_ey7plW6OlEOZZOL9iOMbIOXI2e5Fwg2&t=ffffffffc9f82b39