Simple form will not save to database

Resolve a form not saving to the database due to a missing default value error.

Overview

The issue occurs because MySQL strict mode requires every table field to have a value or be defined as nullable, and the form omits some non-nullable fields.
Ensure all database table fields not included in the form are set to allow NULL values or have default values defined in the table structure.

Answered
ChronoForms v7
mo momentis 21 Jul, 2022
Answer
I am creating a simple form that saves to a database table. The table has some fields that aren't included on the form, which is by design. When I attempt to enter data and save, I am getting an error that the field does not have a default value. I have no idea what I am doing wrong.
mo momentis 21 Jul, 2022
MySQL on the server is running in strict mode. If that's the case, every table field needs a value or have it's null state defined in the table setup.
This topic is locked and no more replies can be posted.