i'd say either define the columns your inserting into or add the value 0 to the select statement so you are passing a value through to the "seen" column

maybe that will resolve your issue