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:
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:
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?
Please try to drag a "Handle arrays" action before the "db save" action!
Regards,
Max
Regards,
Max
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!
Switched Save under Model ID to NO and added the Handle Arrays action. Now everything is saving properly.
Thanks!
This topic is locked and no more replies can be posted.
