Problem with save data in DB table

danielitob 30 Nov, 2016
Hi,
i read the faq and relative topic, but i have always problem with sava data with my form.

i have in on submit DB save and debugger actions.

After compiling form, i have:

Array
(
    [option] => com_chronoforms5
    [chronoform] => form_fornitore
    [event] => submit
    [nome] => aaa
    [cognome] => aaa
    [ragionesociale] => aasdasd
    [categoria] => 2
    [serviziOfferti] => a
    [indirizzo] => aaaaa
    [telefono] => 1
    [cellulare] => 1
    [email] => 
    [note] => 
    [comune] => AVELLINO
    [provincia] => XXX
    [captcha] => UZTXt
    [button45] => Submit
    [test] => Array
        (
            [id] => 3
        )
)

but in debug info i have an insert without my fields (the name of fields are the same of the db table)

Array
(
    [9] => Array
        (
            [DB Save] => Array
                (
                    [Queries] => Array
                        (
                            [0] => INSERT INTO `npoqf_chronoengine_chronoforms_datatable_form_fornitore` (`user_id`, `uniq_id`, `created`) values ('0', '77426028dc7acafc378df9e64b264557ddd8afc4', '2016-11-30 12:13:49');
                        )

                )

        )

)


How can i do?

Thanks and regards
DAniele
GreyHead 30 Nov, 2016
Hi Daniele,

What are the column names in your table?

Bob
danielitob 30 Nov, 2016
Hi Bob,
in my table, the name are:

id, uniq_id, user_id, created, modified, nome, cognome, ragionesociale, serviziOfferti, indirizzo, telefono, cellulare, email, note, comune, provincia, captcha, button45


These are data names of my form:

nome, cognome, ragionesociale, serviziOfferti, indirizzo, telefono, cellulare, email, note, comune, provincia


Regards
Daniele
GreyHead 30 Nov, 2016
Hi Daniele,

That looks fine - please try clicking the Delete Cache icon in the Forms Manager toolbar and see if that fixes the problem.

Bob
danielitob 30 Nov, 2016
Hi Bob
just done but problem still persists 😟

What can i do ?
Thanks
Regards
Daniele
GreyHead 30 Nov, 2016
Hi Daniele,

By all means PM me the site URL, the form name, and a SuperAdmin login and I'll take a quick look.

Bob
danielitob 30 Nov, 2016
hi bob,
thanks,
now i'm writing a PM with all data
regards
DAniele
GreyHead 01 Dec, 2016
Hi Daniele,

You had a Model Id - 'test' - set in the DB Save but there was no data in $form->data['test'] so nothing was saved. I've set Save Under Model ID to No and the data is now saving.

The Model ID is useful when you want to select part of the data to save.

Bob
danielitob 02 Dec, 2016
Hi Bob,
thanks very much.
Best regards
Daniele
This topic is locked and no more replies can be posted.