I solved the problem, turns out that somehow my game was accessing the wrong fuel tanks in the story mode, the old ones from before some update. So I uninstalled the game through steam and then deleted all files for KSP in steamapps/common. On a fresh reinstall the fuel tanks were different looking to the old ones but unlocked in the same way and worked without issue.
