Forums

I have a form with a checkbox group. I've got it set up to send an email and then save the submission to the DB. When I set up the DB save with Save under Model ID set to NO I get this error:

1054 Unknown column 'Array' in 'field list' SQL=INSERT INTO `g96ak_chronoengine_chronoforms_datatable_Support` (`checkbox_group2`, `first_name`, `last_name`, `organization`, `address1`, `address2`, `city`, `state`, `zip`, `email`, `phone`, `comment`, `created`) values (Array, 'BNR', 'Test', '', '123 Main', '', 'Huntersville', 'NC', '28078', 'bnr@bnrtest.com', '555-555-1212', 'Testing', '2014-08-29 00:06:14');

The form does not display the thank you message or the debugging info when it is set up like this.

When I switch Save under Model ID set to YES, the thank you message and debugging info both display and there is a new record inserted into the table, but the record is blank.

This is the debugging info:

Debug Info
Array
(
    [1] => Array
        (
            [Email] => Array
                (
                    [0] => An email with the details below was sent successfully:
                    [1] => To:elizabeth@voteyesforbonds.com, info@voteyesforbonds.com
                    [2] => Subject:Website Campaign Support Submission
                    [3] => From name:
                    [4] => From email:bnr@bnrtest.com
                    [5] => CC:
                    [6] => BCC:bf@bnrbranding.com
                    [7] => Reply name:
                    [8] => Reply email:
                    [9] => Attachments:
                    [10] => Body:
<table>
<tr><td>I would like to:</td><td>array (
  0 => 'endorse',
  1 => 'volunteer',
)</td></tr>
<tr><td>Name</td><td>BNR Test</td></tr>
<tr><td>Organization</td><td></td></tr>
<tr><td>Address</td><td>123 Main</td></tr>
<tr><td>Address 2</td><td></td></tr>
<tr><td>City</td><td>Huntersville</td></tr>
<tr><td>State</td><td>NC</td></tr>
<tr><td>Zip</td><td>28078</td></tr>
<tr><td>Email</td><td>bnr@bnrtest.com</td></tr>
<tr><td>Phone</td><td>555-555-1212</td></tr>
<tr><td>Comment</td><td>Testing</td></tr>
</table><br /><br />IP: 75.181.134.78
                )

        )

    [8] => Array
        (
            [DB Save] => Array
                (
                    [Queries] => Array
                        (
                            [0] => INSERT INTO `g96ak_chronoengine_chronoforms_datatable_Support` (`created`) values ('2014-08-29 00:11:00');
                        )

                )

        )

)

Do I have something set up wrong or is this a bug?

So THAT is what that action is for!

Switched Save under Model ID to NO and added the Handle Arrays action. Now everything is saving properly.

Thanks!