The "repair" worked great.
I have used the console commands before, for a failed transaction, but i wanted to wait for some feedback from the community. Got my answers so much quicker than i hoped for.
Thank you very much.
Glad it worked for you too, was not a nice feeling to see most of my coins missing this morning =)