Urgent! HY000, 1364, Field 'email_address_12_9732' doesn't have a default value

Resolve a database field error after migrating CF forms.

Overview

The error occurs because a form field in the database table lacks a default value after migration.
Access the database table linked to the form in the save action and remove the problematic field causing the error.

Answered
ChronoForms v6
Hi Max or anyone
i did the migration from joomla 3 to joomla 4 and installed the latest installer update for chronforms 6 from this site:
https://www.chronoengine.com/downloads/chronoforms/chronoforms-v6
Chronoforms & Connectivity v6 Extensions + Plugin for J4
there are about 50 forms that are still active and they should be replaced continuously.
unfortunately, the forms cannot be sent. the following error message appears:
HY000, 1364, Field 'email_address_12_9732' doesn't have a default value
this is the honepot field, i have removed it also in the actions, but the error message still appears and it is not possible to send the registrations.
what can i do? i urgently need a solution
Regards,
Vreni
Max_admin Max_admin 19 Dec, 2023
Answer
Hi Vreni,

This is an error from the database, just find the database table which the form is saving to (in the db save action) and drop that field from the table
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
vr vreni.angst@agimus-web.ch 19 Dec, 2023
1 Likes
Hi Max
thanks for the quick reply - great!
after the honeypot field, the error message also appeared for the send button.
I remove both fields under modify table, then sending works again.
best regards,
vreni
This topic is locked and no more replies can be posted.