Drug advisor sacked