Rocker Bono charity auction to help fight AIDS in Africa has raised a near-record breaking $42.6m (€29m) - far more than organisers were expecting to fetch.