Chronoforms 8.0.7 - Database

Resolve a 500 error when saving form data to a database in ChronoForms 8.

Overview

The error occurs due to a mismatch in data source configuration and a potential software bug.
Ensure the primary key is correctly set in the database table and update ChronoForms to version 8.0.8 or later.

Answered
ChronoForms v8
rb rbock 01 Aug, 2023
Hello...

I need help with the Data Save Action.

my table field = NAME
my form field = name
DataSource = {data:}
Override Data = NAME={data:name}

So I get a 500 error.
Max_admin Max_admin 01 Aug, 2023
what is the error ? enable debug mode in Joomla
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
rb rbock 01 Aug, 2023
error Uncaught Throwable of type TypeError thrown with message "Cannot access offset of type string on string". Stack trace: #0 [ROOT]/administrator/components/com_chronoforms8/pages/display_element.php(84): require()
Max_admin Max_admin 01 Aug, 2023
unlike v7, the data source keys should match the table, so remove {data:} from the Data source and keep the Override data, does it work ?
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
rb rbock 01 Aug, 2023
table field ID = INT 11 + PK + AUTO_INCREMENT

On CF8 set ID as Primary Key
Max_admin Max_admin 01 Aug, 2023
yes, I forgot that setting the primary key will get it working with any data source.

so does it work now ?
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
rb rbock 01 Aug, 2023
The option was already set for me. It still doesn't work.
Max_admin Max_admin 01 Aug, 2023
try v8.0.8 ?
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
rb rbock 01 Aug, 2023
Answer
It works.

data source is empty...
Max_admin Max_admin 01 Aug, 2023
if you have the PKey set then it should work regardless of the 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.