OK, I'm tearing my hair out here.
I refitted my kitchen over the last couple of months, and the last thing to do is fit my new light. When removing the last ceiling rose (put new ceiling in), I made sure I labelled the cables clearly:
"live in" - 1 red wire, 1 black wire, 1 earth
"to...