So do I change the red wires back to the L2 position or is it ok as it is ??
As I said before, it really makes no difference - and since it's now working the way you want, there's no point in changing it back.So do I change the red wires back to the L2 position or is it ok as it is ??

I don't recall seeing all of the wiring in the ceiling, just the neutral loop and switchwire.
It has to be worth checking those connections are correct. The only other thing I would do as a spark is IR and EFLI tests. I have to assume (I know, I know!) the IR is OK because the CPD is not failing. On a DIY level, the earth loop could be tested by checking continuity between the ceiling light and the switch then between the switch and a socket, having first tested the socket with a socket and see.

whats the secondary not sure , can you tell from the photos
on the transformer picture, on the left ( first lot of screws) is the wiring from the light itself, blue on the left brown on the right. The second lot of screws is the wire from the transformer to the wires in the ceiling, again blue on the left brown on the right
That all sounds reasonable.yes on the photo the first set of wires are from the light , blue on the left brown on the right then the 2nd set of screws the wire is from the ceiling blue on the left brown on the right. Then it goes into the connector from the ceiling blue into the 2 black wires and brown into the single black wire
I can't see the wiring instructions from the transformer manufacturer. Could you post a photo of them please?yes on the photo the first set of wires are from the light , blue on the left brown on the right then the 2nd set of screws the wire is from the ceiling blue on the left brown on the right. Then it goes into the connector from the ceiling blue into the 2 black wires and brown into the single black wire
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.
Are you a trade or supplier? You can create your listing free at DIYnot Local