The most difficult thing in life is to console somebody. And for a person like me who doesn't exhibit emotions very openly, it becomes even more difficult. These are the moments when sincere and heartfelt words appear to be cheesy and superficial. Consoling words are sincere and comforting only if they are backed by a sincere action. If you can't be of any help or are not willing to take out sometime for the people who need help, then better don't give false hope. There are people who would pose to be your true well wishers and to satisfy their curiosity would gather from you every detail of what has happened. Nobody needs lecturing, preaching or trite cliches.
A warm hug, a sincere nod, a patient ear and a holding hand is all that you need to console somebody.