It's true partnership in friendship most of the times( surely not always) turn out unsuccessful. it seems like you really had bad experience with it. are you still working on that guestroom project? Is it successful?
anyways Keep flourishing and yes, we should learn from our mistakes otherwise it's worthless.