Thanks guys for your help - I've managed to sort it..I imported my backup to 1.9.6 dropping any existing tables - additionally I manually dropped the new tables(content,email_account,note,organization,sequence,ticket_status,user_account and _search) and the upgrade completed ok. So the upgrader does not cater for those tables existing..