Council test purchasing reveals high failure rate