Forums

dbsave problem

graaooor 14 Sep, 2015
Hello,
I have a problem with the dbsave.
Some of my data are stored, others are not : They don't appear in the insert query.
Here is the debug :
Array
(
    [option] => com_chronoforms5
    [chronoform] => contact05
    [event] => submit
    [Itemid] => 
    [civilite] => 1
    [nom] => CHEVAL
    [prenom] => François
    [email] => cheval@domain.com
    [telephone] => 0102030405
    [adr1] => 22 route Nationale
    [cp] => 41000
    [ville] => BLOIS
    [message] => fffff
    [recaptcha_challenge_field] => 03AHJ_Vus0dVf5Jbzx5Yth0tYR9RGMG1xa_A2sGCQmQOscjgh1-jdN5wdIoNHWsiZBOZ-ZttE4YCiktMoLnsEjJGKnVf8TcL329TdLHVYM1uhhFWHJ9Ws1hwXbyc0JYRs_IowsMd6qDhc18-VsSXR6taqlxs6xrgh_-QmKznlw8DEiEci_erJKRn4aQBtPJUGlkFbTcQfPzdfmyheL8j0smVfZCknKVhQkEsvEDQ-EsFpUfE4OGStsS1w
    [recaptcha_response_field] => 822
    [button27] => Submit
    [origine] => CONTACT01
    [ip_address] => 88.123.250.xx
    [id] => 78
)

The request is :

    [16] => Array
        (
            [DB Save] => Array
                (
                    [Queries] => Array
                        (
                            [0] => INSERT INTO `spi_contacts` (`civilite`, `nom`, `prenom`, `email`, `adr1`, `cp`, `ville`, `created`) values ('1', 'CHEVAL', 'François', 'cheval@domain.com', '22 route Nationale', '41000', 'BLOIS', '2015-09-14 14:57:36');
                        )

                )

        )


I have in my table "spi_contacts" the columns "origine","telephone" and they don't appear in the Insert query.
Can you tell me why they are not stored ?

Thanks.
GreyHead 15 Sep, 2015
Hi graaooor,

If you added those columns later please try clicking the Delete Cache icon in the Forms Manager tool-bar and see if that fixes the problem. Everything else looks OK

Bob
graaooor 16 Sep, 2015
Ok. It works now !
Thanks.
This topic is locked and no more replies can be posted.