He may well have mis-wired the ceiling rose. There can be as many as eight wires 3 Red - 3 Black - Brown & Blue and some earth wires as well. The fuse or breaker for the upstairs lights has probably blown/tripped too.
Peccavi
October 2008
Automatic Answer
We may have found other answers which could help you.