With some of the new DB Fields / Updates the code doesn't match the column count. For anyone having trouble try this structure.
See the 2 highlighted values. This will match up the column count.
Code:
insert into lootdrop_entries select 100001, id, 1, 1, 2, 0, 0, 127, 1 from items where name like 'Crude Defiant%' and nodrop = 1;