I've created a content type that has a list / select option field, and I've entered the key|value pairs as necessary for the select list to function.
Data has been entred, and it's been decided that certain terms no longer apply and that they should be deleted.
However, when trying to remove said terms, I get the following error:
Allowed values list: some values are being removed while currently in use.
Obviously, in the life of a project, values are going to change. What's a practical way to remove items once nodes are associated with the listed terms?
This is about the closest thing that I could find:
It references a d6 plugin and some patch trickery I'd prefer not to have to resort to. If I did have to ultimately resort to using the patch to remove the validation check on that field, is there any harm in leaving those items orphaned on the nodes they were associated with?
Update, I have come accross this issue again with a government client who, for the last 7 years of having a Drupal site has had 50 states and territories in a select list. Now, policy has changed and the territories no longer needed to be included. Being able to remove items from the select lists is important, and thus I'm offering a bounty.
I'm looking for a safe solution to be able to remove items from a select list. What I don't know is if that solution should update any of the nodes as I'm not sure how the field values are stored in relation to a node's total content.
I'm happy with a pure SQL solution to run in MySQL; or, I'm looking for a module.