make sure spam and deleted columns have a not null value