I had this problem as well on my '03 Protege5 wagon. Now, only the driver's side door locks/unlocks with the key fob and the lock/unlock button on the inside driver's door doesn't work at all.
I tried reprogramming the remote but that didn't work.
I took it to Mazda and the guy was baffled -...