submissions not being saved to DB

Question

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');
                        )

dadoonan · Accepted Answer

Bingo!