You were wrong. It wasn’t in the sugar. You got it wrong.
A bit. It won’t happen again.
I love the ambiguity here. You can’t be sure whether Sherlock means, “Testing unknown drugs on you won’t happen again,” or “Me being wrong won’t happen again.”
(But my bet would be on the latter.)