Integrity constraint violation NOT NULL about oc-formstore-plugin HOT 8 CLOSED

Okay sure, thanks for you assistance.

from oc-formstore-plugin.

Thanks for reporting this! When exactly do you get this error? When you try to submit the form? In backend or frontend?

It seems like an error in the mysql database configuration. What happens is that FormStore tries to create an entry in the table nocio_formstore_submissions with the field value treated=Null which is not allowed by the database scheme.

It looks like you are on xampp, so it's not a production environment I suppose? If it's not production, can you open the database on which OctoberCMS is installed, e.g. with phpmyadmin or the mysql client and allow the treated field to be nullable:

ALTER TABLE `nocio_formstore_submissions` CHANGE `treated` `treated` DATETIME NULL; 

from oc-formstore-plugin.

Also, can you check if all the fields in your model Lmh\Forms\Models\Test are nullable?

from oc-formstore-plugin.

Hi, this error was on the front-end when clicking the "Start" button.

After making the treated field NULL I was able to start and submit the form. However, when I tried it on another model which has fields that are NOT NULL it gave the same SQL error for those fields. So it may be worth adding to the documentation that all the form fields need to be nullable. (unless I've missed that)

Another minor issue I've noticed is in the backend when viewing the Submitted forms, the Data ID is not showing the correct ID field. I assume it is showing the id field from nocio_formstore_submissions instead of showing the data_id field. All the data has been stored correctly in the database.

Thanks for you assistance mate.

from oc-formstore-plugin.

Good catch, I've added it to the documentation, thanks. I'll also look into producing a better error message if fields are not nullable. The other minor issue should be a simple fix in the columns.yaml, feel free to send a pull request. Otherwise, I'll fix it soon.

from oc-formstore-plugin.

Sorry, I didn't explain that correctly. I think the issue may either be in the Model or the Controller.

Here's an example:

The data is blank, and the correct data_id in the DB is 7

Please let me know once you've had a chance to look at it. Thanks

from oc-formstore-plugin.

Ok I see, can you open a new issue, it seems like a different problem. Thanks

from oc-formstore-plugin.

@rangrage The upcoming version will address the issues you've pointed out. Thanks for your report.

from oc-formstore-plugin.