But the old light MUST have had neutral to it, so I still don't see why you cannot connect the same L, N, E that previously went to the old light, to this new one.
As already mentioned you will have to leave the switch in the house turned on all the time for it to operate automatically at night.
Post pictures of the actual cable you have coming from the house and how you have actually connected it to the light.