Nicholas Smalley appeared ‘absolutely plastered’ while teaching drums at a primary school - but an allegation he was drinking on school premises was not proven