Tributes to Michael Martindale flooded in after his death and a murder investigation was initially launched