Changed company answers causing problems for metric renames
+issue
MC Mining (https://wikirate.org/MC_Mining_Limited) used to be called Coal of Africa. They rebranded, so we renamed the company. With the last couple of metrics I've tried to rename, I keep getting the error Problems with X metric: +COAL_OF_AFRICA: +2017 company valid company required. This morning I deleted a value with no company attached to it (but with Coal of Africa in the URL) for a different metric, but the same is coming up for the below hazardous waste metric. The URL for the answer https://wikirate.org/Research_Page?company=Coal%20of%20Africa&metric=Global+Reporting+Initiative%2BHazardous+Waste+Recycled+%28G4-EN23-a%29&view=edit&year=2017
I'm not sure what happened - maybe they didn't get renamed in the name change. Is it possible to find how many more of these exist and delete or rename (to MC Mining Limited) these values?
+screenshot
+Discussion
Will be much easier to clean up this data (and prevent it from happening again) with the new code.
I think this is fixed on staging.