After laboring on this problem for 5 days, and some Googling, I finally found the solution myself.

The first problem was on account of my lack of understanding of triggers and...