How to fix " Field 'form_id' doesn't have a default value" problem??

Fix "Field 'form_id' doesn't have a default value" error in ChronoForms.

Overview

The error occurs when the database table's unique ID column lacks a default value and no value is provided during form submission.
Ensure the AUTO_INCREMENT setting is enabled for the unique ID column in your database table to automatically generate values.

kr kraadde 11 Apr, 2024

How to fix the problem with "Field 'form_id' doesn't have a default value" ? The DB table has indeed values in the field form_id!

Max_admin 11 Apr, 2024

Where do you get this error ? can you post a screenshot ?

Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.

si simelas 11 Apr, 2024

Hi all,

I got this once when for any obscure reason the AUTO_INCREMENT id got unchecked. It was during an import DB process.

kr kraadde 11 Apr, 2024

Max,

here the screenshots .

Thanks for helping

kr kraadde 11 Apr, 2024

Max,

here the screenshots .

Thanks for helping

kr kraadde 11 Apr, 2024

Max,

here the screenshots .

Thanks for helping

Max_admin 12 Apr, 2024

Answer

is this an old table ? v8 uses "form_id" column and the value is never empty

but the problem you have is as "simelas" has pointed, the uniq_id column has no default value and you did not provide a value to be saved

Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.

This topic is locked and no more replies can be posted.