I have a similar problem but I'm further down the road to disaster, so any advice would be gratefully received.
I'm replacing a ceiling rose, which had three cables into it, each with red cable, black cable and the earth.
My new fitting has only terminals for live, neutral and earth and so...