I don't always have good advice either and I also have a difficult time comforting people... I don't feel confident that I won't say/do the wrong thing, because I'm used to that happening.

It's helpful for me to think of what advice I would give myself if I was the other person... It very well could be something different that the person is looking for, but then we can just listen and try to figure out what would be best for them.