form data saving to internal DB

Save form data to an internal database table.

Overview

The database table requires a value for a non-null unique ID column, and the data source mapping is incorrect.
Use the Modify Data Source option to provide a value for the unique ID column and correctly define all column values there.

Answered
ChronoForms v8
kr kraadde 11 Feb, 2025

Max,

a new issue now:

I tried to have my form data saved in the following dB table:

what happen is thet the following erroe message appeares and nothing is stored in the dB.

The save data setup looks like that:

What is here wrong?

BTW same database structure in CF5 worked perfectly.

Max_admin Max_admin 11 Feb, 2025
Answer
1 Likes

the uniq_id column in the table can NOT be null and so you must pass a value, maybe v5 had a default value for this, but v8 no

so you need to use the "Modify Data source" and supply a value:

form data saving to internal DB image 1

Also the Data Source {data} is incorrect, you may use {data:} but that will also cause issues, so you better define the columns values under the "Modify Data Source"

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.