You need a means to secure the lamp holder to what remains, I suspect the part for the job is broken, even if it wasn't broken, you, by your own admission would not know what to do. However, since your neighbour is of the opinion it can be repaired, ask him to do it. I understand you don't want to d...