Good to hear that it has started to make sense, it's amazing how many things do once hindsight is allowed is allowed to rear its head!
If you can find the manufacturer and any numbers on the connector you may be able to identify the right parts to allow the connector to be refurbished without having to do any new crimps, failing that then it might have to be a full set new crimps, housing, and the internal parts of the housing. I've managed to sort out such things before after a session on Google identifying parts then searching for specific part numbers on the likes of eBay. Sometimes there are even videos on YouTube to show how the connector is dismantled and re-assembled.
