Yea I have no idea what was causing the issue. Eventually I just gave up and downloaded the blockchain on another computer and moved the wallet.dat over, that seemed to fix it. It did show the transaction still, I just had to double spend before it loaded the false one in the blockchain, now it's all fine.