prevent 0 attendance to be inserted