Thanks guys. When I changed the switch there were only 2 wires. I’m going to take a look tomorrow and have a feel around through the hole in ceiling. At the moment I can see two grey wires, one is neutral and the other grey has a live and an earth coming out it. Maybe I did yank it out the ceiling and there’s something else lurking up there! Ha
Your terminology could be a bit clearer.
A "wire" is a single piece of copper covered in insulation.
A "cable" is one or more wires with or without insulation covered in an outer sheath.
If I am understanding what you are saying, you have 2 CABLES each covered in a great outer sheath.
Cable 1 has a black wire emerging from it.
Cable 2 has a red wire and a sleeved earth wire coming out of it.
That leaves some things missing. BOTH cables should have an earth core and the two earth cores should be joined together. Both cables should have both a red and a black wire as well.
It sounds to me like the missing cores are poked up through the hole in the ceiling, and probably jooned in a connector block. Not the right way to do it but encountered frequently especially with some light fittings that just don't have room to terminate all the cables properly.
Chances are the hidden connection in the ceiling has failed.
What yo need to do is retrieve both grey cables in their entirety from within the ceiling so you can see what you have got and connect them properly.