Your house is wired in double covered singles, which is an entirely normal way of wiring lighting circuits.
Just to double check, you connected both blacks together in the neutral terminal, the green / yellow to the earth terminal, and the red to live terminal?
Could you have blown a fuse whilst you were doing this work?
i'm surprised it didn't work with red in L and blacks in N.
are you certain all bulbs in both rooms are ok?
is there a small switch built into the new spot fitting?
sorry to ask these questions but sometimes it pays to check the simplest things first.
If you need to find a tradesperson to get your job done, please try our local search below,
or if you are doing it yourself you can find suppliers local to you.
Select the supplier or trade you require, enter your location to begin your search.
Please select a service and enter a location to continue...
Are you a trade or supplier? You can create your listing free at DIYnot Local