Forums

I have configured all the selection groups with field names ending with[] and then inserted these in to the Handle Arrays list.

The Handle Arrays action is placed BEFORE the DB Save action.

When the DB Save is enabled I get the following error:

1054 - Unknown column 'Array' in 'field list' SQL=INSERT INTO `cd3_chronoengine_chronoforms_datatable_PuppyApplication` (`Name`, `Age`, `Occupation`, `HomePhone`, `CellPhone`, `Email`, `Adress`, `City`, `State`, `Zip`, `household1-name`, `household1-age`, `household1-occupation`, `household2-name`, `household2-age`, `household2-occupation`, `household3-name`, `household3-age`, `household3-occupation`, `household4-name`, `household4-age`, `household4-occupation`, `household5-name`, `household5-age`, `household5-occupation`, `pet1-name`, `pet1-breed`, `pet1-sex`, `pet1-age`, `pet1-neutered`, `pet2-name`, `pet2-breed`, `pet2-sex`, `pet2-age`, `pet2-neutered`, `pet3-name`, `pet3-breed`, `pet3-age`, `pet4-name`, `pet4-breed`, `pet4-age`, `pet5-name`, `pet5-breed`, `pet5-age`, `puppy-gender`, `puppy-gender-reason`, `puppy-color`, `puppy-raised`, `experience-general`, `housing-ownership`, `housing-residency`, `housing-description`, `housing-past-residence`, `housing-fencing`, `housing-kennel`, `housing-kennel-area-width`, `housing-kennel-area-length`, `housing-care`, `housing-training`, `housing-hours-alone`, `housing-alone-stay`, `housing-alone-travel`, `housing-sleep`, `daily-schedule`, `hobbies`, `references`, `additional-queries`, `puppy-adoption-submit`, `user_id`, `uniq_id`, `created`) values ('Chamira', '', '', '001122121121', '00232568795', '', '', '', '', '', 'Brat', '3', 'Brat', '', '', '', '', '', '', '', '', '', '', '', '', 'Cat', 'Cat', Array, '11', Array, 'Dog', 'Dog', Array, '99', Array, '', '', '', '', '', '', '', '', '', Array, '', Array, Array, '', Array, '', '', '', Array, Array, '', '', '', '', Array, '', '', '', '', '', '', '', 'Submit', '0', '2f6eaf113e0938aff24631f5da7a39717dcb9603', '2014-10-28 11:45:08')

When I disable the DB Save, I get an email showing all the arrays correctly expanded:

----- APPLICANT DETAILS -----
Name 	Chamira
Age 	
Occupation 	
Home Phone 	001122121121
Cell Phone 	00232568795
Email 	
Street 	
City 	
State 	
Zip 	
----- HOUSEHOLD DETAILS -----
Household1-Name 	Brat
Household1-Age 	3
Household1-Occupation 	Brat
-----
Household2-Name 	
Household2-Age 	
Household2-Occupation 	
-----
Household3-Name 	
Household3-Age 	
Household3-Occupation 	
-----
Household4-Name 	
Household4-Age 	
Household4-Occupation 	
-----
Household5-Name 	
Household5-Age 	
Household5-Occupation 	
----- OTHER PETS -----
Pet1-Name 	Cat
Pet1-Breed 	Cat
Pet1-Gender 	array ( 0 => 'Male', )
Pet1-Age 	11
Pet1-Neutered 	array ( 0 => '', )
-----
Pet2-Name 	Dog
Pet2-Breed 	Dog
Pet2-Gender 	array ( 0 => 'Male', )
Pet2-Age 	99
Pet2-Neutered 	array ( 0 => '1', )
-----
Pet3-Name 	
Pet3-Breed 	
Pet3-Gender 	
Pet3-Age 	
Pet3-Neutered 	
-----
Pet4-Name 	
Pet4-Breed 	
Pet4-Gender 	
Pet4-Age 	
Pet4-Neutered 	
-----
Pet5-Name 	
Pet5-Breed 	
Pet5-Gender 	
Pet5-Age 	
Pet5-Neutered 	
----- PUPPY PREFERENCES -----
Do you have a preference regarding the gender of your puppy? 	array ( 0 => 'Female', )
Why? 	
Do you have a color preference? 	array ( 0 => 'Black spots', )
----- EXPERIENCE -----
Have you ever raised a puppy? 	array ( 0 => 'Yes', )
Please provide details regarding your prior experience as a dog owner: 	
----- HOUSING -----
Do you rent or own your home? 	array ( 0 => 'Rent', )
How long have you lived in your current home? 	
Briefly describe your current home and yard 	
List any address you have lived at in the last five years: 	
Is your yard completely and securely fenced? 	array ( 0 => 'Yes', )
Do you have an enclosed kennel area? 	array ( 0 => 'Yes', )
Kennel Area - Width 	
Kennel Area - Length 	
Who will be responsible for your dog's care? 	
Who will train your dog? 	
Do you plan to take your dog to obedience class? 	
How many hours per day will your dog be home alone? 	array ( 0 => '5', )
Where will your dog stay when no one is at home? 	
Where will your dog stay when you travel? 	
Where will your dog sleep? 	
----- ADDITIONAL DETAILS -----
Please describe your typical daily schedule: 	
Please list your hobbies, other interests or things you would like us to know about yourself, your family or your household: 	
Please list two references (e.g. veterinarian, friends, dog training instructor, etc.): 	
Do you have any additional questions or comments for us? 	

What could be wrong with my configuration?

Thanks, that was exactly what was wrong with the DB Save action.