I am willing to send 0,1 btc to anyone who can help me fix this issue.
So far I have done:
-I had my wallet open all the time
-I tried re-installing the blocks
-I tried to use zapwallettxes to delete the unconfirmed transaction. This didn't change anything.
-I tried sending the raw transaction through the console, which did not work (TX rejected (code -22))
First backup your wallet to a safe location. Then download pywallet from https://github.com/jackjack-jj/pywallet. Install everything that it tells you to install on the README. Then open up a command prompt and go to the folder which contains pywallet.py. Type into the command prompt
Then start up Bitcoin core like you did earlier from the command prompt with zapwallettxes but instead of having the option -zapwallettxes, make it the option -rescan.
This should remove all of the transactions from your wallet and then it should rescan the blockchain for the transactions. This should only get all of the confirmed transactions so you should be able to spend your coins normally again.