The mystery location of a giant volcanic eruption that has puzzled scientists for almost 200 years has finally been solved.