Forums

Hello,

Saving to database gives error:

1054 - Unknown column 'Array' in 'field list' SQL=INSERT INTO `uus4_chronoengine_chronoforms_datatable_ProgrammiKasutamine3` (`nimi`, `ettevotteNimi`, `text58`, `epost`, `button46`, `kysimus`, `Tarkvarapakett`, `Opsysteem`, `teiekysimus`, `button16`, `user_id`, `uniq_id`, `created`) values ('MY name', 'Company OÜ', '5555555', 'jaak@company.ee', 'Saada', Array, 'StandardBooks', 'Linux', 'sdhahdfhfdhsdhsdhdfhdfhsdhdshsdhsdhdshsdhdshsdhdsh', 'Saada küsimus', '0', '6859dfa0c00d6483c6e988febeb331cf916210a6', '2015-02-06 12:07:27');

Throught Chronoform admin:

1. Forms list - select the form
2. I create database table for selected form
3. from form setup I include DB Save to submit action
4. DB save edit - > choose database table
5. Save form

Error is displayed.

What can I do to solve this problem?

Jaak

Hello jaak,
I'm not a Chrono professional, but after checking your new post, I think that the following links may help:
How do I save form data to a database table?
My form data isn't saving to the database correctly
My form won't save
My CFv5 form data isn't saving to the database correctly
How to post information from a Chronoform to ZoHo
What are the 'Easy Form' and 'Form' Wizards?
How can I add a mask to format a form input?
How to load record data from a database table into your form
P.S: I'm just an automated service😉

Hi Jaak,

Please drag a Handle Arrays action into the OnSubmit event and move it up before the DB Save action.

Bob