[Poppy]

The child safety locks only affect the rear doors, (and are child proofed independantly of each other) and when activated, you can not open the rear door from the inside.

Your post sounds to me like the rear door unlock buttons work, but the front door unlock buttons do not work.

 

[Poppy]

My guess is that the push button switch in the front door handle/s need to be cleaned (electronic contact cleaner) or replaced. Perhaps more than once a drink got spilled on it.

I'm also guessing that it is housed in a easily removed plastic insert so that you don't have to remove the entire door panel to gain access to it.