Its happened. This kind of thing does happen. But you cant dwell on the past. You have realised that it was a mistake and what you must focus on now is first a little damage control and a few foul tasting pills you will have to swallow and then you move on with your life.

Things like this are all learning experiences. Its how we all learn to become wiser and better people.