Can not create new family

[bmakari]

Over the weekend, I had to add a few new families to the database. The experience of adding users individually is painful, so I decided to use the "Add New Family" feature, which appears to be broken.

Repro Steps:

1. Navigate to "Members > Add New Family"
2. Add family information
   NOTE: I tried just family name and address as well as adding members or leaving the section blank, both yielded same result
   Expected: New family members added
   Actual: SQL Error thrown (see below)

ERROR:
Cannot execute query.
INSERT INTO family_fam ( fam_Name, fam_Address1, fam_Address2, fam_City, fam_State, fam_Zip, fam_Country, fam_HomePhone, fam_WorkPhone, fam_CellPhone, fam_Email, fam_WeddingDate, fam_DateEntered, fam_EnteredBy, fam_SendNewsLetter, fam_OkToCanvass, fam_Canvasser, fam_Latitude, fam_Longitude, fam_Envelope) VALUES ('Trump','123 MAIN STREET','','','WA','','United States','','','9119119111','',NULL,'20160927005543',30,'TRUE','FALSE','','47.8121719','-122.3816412','0')

Incorrect integer value: '' for column 'fam_Canvasser' at row 1

[DawoudIO]

Looks like the "Ok To Canvass: " field is not shown due to the bCanvasser role...

vs the standard

[DawoudIO]

i can't repo this can you give more info