What I tried is (and this may sound ridiculous) blow dry the block part and the connector part (for a minute or 2 be a bit careful though) and after doing that the light quickly turned green and charged my macbook. That made sense in my case because I charged my macbook next to a big window with a bit of cold air coming in (this is during winter time).
I read somewhere that the problem may be that the charger gets too cold for it to work. When I connect my charger my battery percentage basically stays at the same percentage. In my case my macbook would not charge too and the light wouldn't come on.
