Without a datasheet or pinout for the BC547, or a schematic, it's hard to say. I can note that it *appears* that you are applying 9 V to a 5 V buzzer.
Also, 100K is a very large value for such a high gain circuit, and enables false tripping due to noise. Reduce to 10K.
Also, when the door is...