removed null on charfields. ran sql updates. closes #564