More Awesome Than You!

I've searched for every wording of this problem I could think of, but I haven't found any answers. Two of my sims got married and rolled wants to go on vacation in France for their honeymoon. I sent them home early after an uneventful two days, and when the home neighborhood reloaded, one sim was missing. Upon looking at his wife's relationship panel, it behaved as if he was still a foreign visitor. The first thing I tried was to invite him over as a foreign visitor and then add him to the family via the testing cheats. When I did that, he maintained all of his relationships and skills, but his celebrity status/memories/work status/inventory had been completely wiped. Luckily, I was able to reload the previous save - on their first day in France. However, I'd like to prevent this from happening again so that I can actually get them home without the guy being kidnapped by what I assume is the sim version of the French Foreign Legion.

I'm running a clean game with the exception of Awesomemod. Any ideas/reasons why this might be happening?

First- Did you actually try again first to see if it wasn't a once off glitch?
Second- Try completing their entire trip if the first suggestion still resulted in the same thing, and see what happens.

What were you DOING in France? It could be something that was being done there could have bugged him out. Did you move them into a holiday home? Did you try moving them into a holiday home, and then going home?
I had this very issue at one point, but I just reloaded an old save and the wife came home the next time around.

I suggest using The Traveler from Twallan. It will prevent stuff like this from happening in the first place. If something does happen, you can show the logs to Twallan and then he can try to fix it. You can also get his mod Overwatch, which will recover missing sims.

http://nraas.wikispaces.com/Traveler+FAQ

I had the same problem.  I used the "resetsim" cheat and it fixed my problem