I'm having the same issue. It's essentially game breaking, and one of the most annoying things to happen in the game, honestly. Except for me, I went to add a new sim to a previous sims house and it deleted all the organizations that original sims was a part of, but kept the sprites around, bugging her and making it impossible for her to do anything. It's gotten to the point where the original sim has a constant moodlet that causes her to feel guilty for not paying attention to the sprites. But I can't do anything with the sprites because i'm not part of the secret society anymore because the game deleted it from her organizations. I've even tried to rejoin the secret society, just to immediately leave it. I've gotten the specific moodlet to pop up two more times, and neither time the society showed up at my house. The game is basically acting as if i'm still in the society, without giving me any of the commands to do so. It's so frustrating, and it's making me not want to play the game, which is unfortunate, because I was really excited about this expansion and love everything else about it.
