A few years ago I had an aux cable always plugged into the socket and one day someone applied too much force on the connector, breaking it, and also damaging the socket, because from that day the socket stopped working (tested with a few working cables).
This is the socket I'm talking about (It's not my photo but I'm not near my car now and I just found the same one in Google):

I wonder if that's something I can repair myself or I'll take it to a (very expensive) service center, or just get one of those AM/FM to Aux transmitters instead.
*The 12V and the USB sockets still work
Thanks