For as much as Paul McCartney feels like a wise sage of rock and roll, he had some moments that came back to bite him time and time again.