Forums

First time user of Chronoforms and I seem to be missing something.

I've created a form and successfully connected it to the db. However when I submit the form, the only information being saved to the db record is the uniq_id.

As you can see the debugger output is displaying the submitted information, but it is not being submitted to the db.

Advise please,
david

-------------------------------

Data Array
Array
(
    [chronoform] => EducationalSubmission
    [event] => submit
    [Name] => john doe
    [Email] => john@doe.com
    [Ciry] => New York CIty
    [State] => NY
    [Title] => Title goes here
    [URLclient] => If your exercise is available on the web, please enter the full url.
    [button10] => Submit
    [ip_address] => xx.xx.xx.xx
    [Data] => Array
        (
            [id] => 8
        )

)
Array
(
)
Errors
Array
(
)
Debug Info
Array
(
    [1] => Array
        (
            [Email] => Array
                (
                    [0] => An email with the details below was sent successfully:
                    [1] => To:john@doe.com, dadoonan@mac.com
                    [2] => Subject:chronoforms test
                    [3] => From name:ACASE Forum
                    [4] => From email:dadoonan@gmail.com
                    [5] => CC:
                    [6] => BCC:
                    [7] => Reply name:ACASE
                    [8] => Reply email:dadoonan@gmail.com
                    [9] => Attachments:
                    [10] => Body:
<table>
<tr><td>Name</td><td>john doe</td></tr>
<tr><td>Email</td><td>john@doe.com</td></tr>
<tr><td>City</td><td>New York CIty</td></tr>
<tr><td>State</td><td>NY</td></tr>
<tr><td>Exercise Title</td><td>Title goes here</td></tr>
<tr><td>URL</td><td>If your exercise is available on the web, please enter the full url.</td></tr>
<tr><td>Upload</td><td></td></tr>
<tr><td>Enter Code</td><td></td></tr>
<tr><td>Reviewer Name</td><td></td></tr>
<tr><td>Review Date</td><td></td></tr>
<tr><td>Date review sent to client</td><td></td></tr>
<tr><td>URL</td><td></td></tr>
<tr><td>Review File</td><td></td></tr>
<tr><td>Review Response</td><td></td></tr>
</table><br /><br />IP: xx.xx.xx.xx
                )

        )

    [3] => Array
        (
            [DB Save] => Array
                (
                    [Queries] => Array
                        (
                            [0] => INSERT INTO `xxxx_chronoengine_chronoforms_datatable_EducationalSubmission` (`user_id`, `uniq_id`, `created`) values ('0', '1ca1794437438676f0c42094bdd45825ca486d9f', '2015-01-30 20:21:24');
                        )

Hi david,

It looks as though the column names may not match the input names exactly e.g. it must be Ciry and not City, ciry or city

Bob

Thanks, but changing the field name to City in the DB and in the form did not solve the issue.

None of the fields are being written to the db

[3] => Array
(
[DB Save] => Array
(
[Queries] => Array
(
[0] => INSERT INTO `maz56_chronoengine_chronoforms_datatable_EducationalSubmission` (`user_id`, `uniq_id`, `created`) values ('0', '4b7165eebcc97b455635d2a1c6de7c7d09459694', '2015-02-02 13:43:33');
)

)

)

)

Hi David,

If you have changed column names or input names please click the Delete Cache icon in the Forms Manager toolbar to clear ChronoForms' temporary records.

What are the column names in your table? Can you post them here?

Bob

These are saved from a public form

Name
Email
City
State
Title
URLclient
Upload

These names are saved from an admin only form, along with those from above
ReviewerName
Date
ReviewDateSent
URLreview
ReviewFile
ReviewResponse

Hi David,

Ah I think I see the problem. Somewhere the Model ID is set to Data so ChronoForms is looking for the data to save in the Data sub-array - and it isn't there. Please turn off the Use Model ID option.

Bob

Hi I have a similar problem: data from my module are saved in table ONLY if I fill the form from component page, NOT from module / plugin.
Can You help me?
Thanks

This is a different issue, please try to disable the module's cache OR to set the "Relative url" to "No" under the "HTML" action settings!

Regards,
Max

THANK YOU SO MUCH!
It works!
Regards,
Elisabetta