Acutally, where there is 1 pin physically missing from the cable (pin 9), I'm 100% sure I have been looking at the cables properly, especially where the last cable had the RGB in the correct positions. I had a lot of cables given to me a while ago, so I'm not so sure that the other 3 were even VGA cables, but they sure looked like it. This time I used a known good VGA cable.
I know this cable was from an old LCD monitor that I had, could that be the problem?