Vivian Campbell, Cancer