Councillor Leo Hauville's climate change motion collapses