Thanks for the props, but really its not that complicated. I tried to fix both sides again today. I tried every possible combination of gear positions, sadly nothing worked.
Hehe now I'm sure it's an electrical problem. It has to be because as the doors are locked or unlocked, the gear inside goes through its range of motion, completes a circuit inside the actuator and the little motor inside spins. This only happens on the driver's side. The passenger side does nothing... but then why does it cause the driver's side to unlock? I'm soo confused!!!
My search for " door lock " threads leads me to think that its the tcu. I'm not sure what tcu stands for, but there is a thread that shows it:
http://nicoclub.com/zerothread?id=71432
I don't feel like messing with it right now, but I'll keep you posted on how things go, and maybe along the way someone might be able to help me find a solution to this irritating problem.
Quick question, do you think if I have an alarm with a lock/unlock feature installed, that will solve the problem? Please say yes because I just bought one. (for security reasons , of course, not because of this stupid convenience problem)