The 81-year-old singer was due to perform to fans tonight but had to pull out after travelling to the venue as he shared a glum photo from the stage