Error: Data could not be saved. Cannot insert the value NULL int column 'ID', table 'XXX.dbo.GUESTPASSPROGRAM'; column does not allow nulls. INSERT fails. The statement has been terminated - when entering program for guest passes

The following error may be received when entering a program name into the program list for the guest pass configuration: 

Data could not be saved. Cannot insert the value NULL int column 'ID', table 'XXX.dbo.GUESTPASSPROGRAM'; column does not allow nulls. INSERT fails. The statement has been terminated.
This occurs if the program name entered in the box is an invalid program name. Please confirm the name of the program, and then reenter the program name. 

Steps to Duplicate

  1. Click Tickets > Guest Passes
  2. Enable Guest Passes (if not already enabled)
  3. Enter an invalid program name within the program list
  4. Tab out of the field
  5. Click Save
  6. See error

Environment

 Altru Arts & Cultural

Was this article helpful?