Hello everybody I need a urgent help I am getting an error while creating a table for my form
Error while creating table :Incorrect column name 'Birth_Date ' SQL=CREATE TABLE `jos_chronoforms_hh` (`cf_id` INT(11) NOT NULL auto_increment, `uid` VARCHAR(255) NOT NULL, `recordtime` VARCHAR(255) NOT NULL, `ipaddress` VARCHAR(255) NOT NULL, `cf_user_id` VARCHAR(255) NOT NULL, `First_Name` VARCHAR(255) NOT NULL, `Last_Name` VARCHAR(255) NOT NULL, `Birth_Date ` VARCHAR(255) NOT NULL, `Age` VARCHAR(255) NOT NULL, `Student_Address` VARCHAR(255) NOT NULL, `City` VARCHAR(255) NOT NULL, `State` VARCHAR(255) NOT NULL, `Zip_Code` VARCHAR(255) NOT NULL, `Student_Home_Phone` VARCHAR(255) NOT NULL, `Student_Cell` VARCHAR(255) NOT NULL, `School_Name` VARCHAR(255) NOT NULL, `Student_School_Address` VARCHAR(255) NOT NULL, `Grade` VARCHAR(255) NOT NULL, `Parent_Name` VARCHAR(255) NOT NULL, `Parent_Home_Phone` VARCHAR(255) NOT NULL, `Parent_Cell` VARCHAR(255) NOT NULL, `Parent_Email_Address` VARCHAR(255) NOT NULL, `Emergency_Name` VARCHAR(255) NOT NULL, `Emergency_Home _Phone _Number` VARCHAR(255) NOT NULL, `Emergency_Cell` VARCHAR(255) NOT NULL, `Sex` VARCHAR(255) NOT NULL, `Ethnicity` VARCHAR(255) NOT NULL, `Annual_Income ` VARCHAR(255) NOT NULL, `Primary_language` VARCHAR(255) NOT NULL, `Liability` VARCHAR(255) NOT NULL, `Emergency_Permission` VARCHAR(255) NOT NULL, `How_Child_Will_Go_Home` VARCHAR(255) NOT NULL, `Permission_to_go_to_stores` VARCHAR(255) NOT NULL, `Medical_Conditions` VARCHAR(255) NOT NULL, PRIMARY KEY (`cf_id`)) ENGINE = MYISAM ;
this is the error .I don knw why its giving me that error.and this form used to work perfectly..
please help!!!
Error while creating table :Incorrect column name 'Birth_Date ' SQL=CREATE TABLE `jos_chronoforms_hh` (`cf_id` INT(11) NOT NULL auto_increment, `uid` VARCHAR(255) NOT NULL, `recordtime` VARCHAR(255) NOT NULL, `ipaddress` VARCHAR(255) NOT NULL, `cf_user_id` VARCHAR(255) NOT NULL, `First_Name` VARCHAR(255) NOT NULL, `Last_Name` VARCHAR(255) NOT NULL, `Birth_Date ` VARCHAR(255) NOT NULL, `Age` VARCHAR(255) NOT NULL, `Student_Address` VARCHAR(255) NOT NULL, `City` VARCHAR(255) NOT NULL, `State` VARCHAR(255) NOT NULL, `Zip_Code` VARCHAR(255) NOT NULL, `Student_Home_Phone` VARCHAR(255) NOT NULL, `Student_Cell` VARCHAR(255) NOT NULL, `School_Name` VARCHAR(255) NOT NULL, `Student_School_Address` VARCHAR(255) NOT NULL, `Grade` VARCHAR(255) NOT NULL, `Parent_Name` VARCHAR(255) NOT NULL, `Parent_Home_Phone` VARCHAR(255) NOT NULL, `Parent_Cell` VARCHAR(255) NOT NULL, `Parent_Email_Address` VARCHAR(255) NOT NULL, `Emergency_Name` VARCHAR(255) NOT NULL, `Emergency_Home _Phone _Number` VARCHAR(255) NOT NULL, `Emergency_Cell` VARCHAR(255) NOT NULL, `Sex` VARCHAR(255) NOT NULL, `Ethnicity` VARCHAR(255) NOT NULL, `Annual_Income ` VARCHAR(255) NOT NULL, `Primary_language` VARCHAR(255) NOT NULL, `Liability` VARCHAR(255) NOT NULL, `Emergency_Permission` VARCHAR(255) NOT NULL, `How_Child_Will_Go_Home` VARCHAR(255) NOT NULL, `Permission_to_go_to_stores` VARCHAR(255) NOT NULL, `Medical_Conditions` VARCHAR(255) NOT NULL, PRIMARY KEY (`cf_id`)) ENGINE = MYISAM ;
this is the error .I don knw why its giving me that error.and this form used to work perfectly..
please help!!!
Hi mankss ,
You have a stray space after 'date' it needs to be `Birth_Date`. Probably you need to edit the Form HTML to remove it.
Bob
You have a stray space after 'date' it needs to be `Birth_Date`. Probably you need to edit the Form HTML to remove it.
Bob
Hi Bob,
Thanks for the quick reply but now I am getting strange error-
and this is the HTML code of my form:-
I will highly appreciate if you can resolve this .....thanks in advance
Thanks for the quick reply but now I am getting strange error-
Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in C:\xampp\htdocs\ifsinc\components\com_chronocontact\chronocontact.php(53) : eval()'d code on line 23
and this is the HTML code of my form:-
<div class="form_item">
<div class="form_element cf_heading">
<h1 class="cf_text">Registration Form</h1>
</div>
<div class="cfclear"> </div>
</div>
<div class="form_item">
<div class="form_element cf_textbox">
<label class="cf_label" style="width: 150px;">First Name</label>
<input class="cf_inputbox required" maxlength="150" size="30" title="" id="text_0" name="First_Name" type="text" />
</div>
<div class="cfclear"> </div>
</div>
<div class="form_item">
<div class="form_element cf_textbox">
<label class="cf_label" style="width: 150px;">Last Name</label>
<input class="cf_inputbox required" maxlength="150" size="30" title="" id="text_1" name="Last_Name" type="text" />
</div>
<div class="cfclear"> </div>
</div>
<div class="form_item">
<div class="form_element cf_textbox">
<label class="cf_label" style="width: 150px;">Birth Date</label>
<input class="cf_inputbox required" maxlength="150" size="30" title="" id="text_3" name="Birth_Date" type="text" />
<a class="tooltiplink" onclick="return false;"><img height="16" border="0" width="16" class="tooltipimg" alt="" src="components/com_chronocontact/css/images/tooltip.png"/></a>
<div class="tooltipdiv">Birth Date :: mm / dd / yyyy</div>
</div>
<div class="cfclear"> </div>
</div>
<div class="form_item">
<div class="form_element cf_textbox">
<label class="cf_label" style="width: 150px;">Age</label>
<input class="cf_inputbox required" maxlength="150" size="30" title="" id="text_2" name="Age" type="text" />
</div>
<div class="cfclear"> </div>
</div>
<div class="form_item">
<div class="form_element cf_dropdown">
<label class="cf_label" style="width: 150px;">Sex</label>
<select class="cf_inputbox validate-selection" id="select_4" size="1" title="" name="Sex">
<option value="">Choose Option</option>
<option value="Male">Male</option>
<option value="Female">Female</option>
</select>
</div>
<div class="cfclear"> </div>
</div>
<div class="form_item">
<div class="form_element cf_textbox">
<label class="cf_label" style="width: 150px;">Address</label>
<input class="cf_inputbox required" maxlength="150" size="30" title="" id="text_21" name="Student_Address" type="text" />
</div>
<div class="cfclear"> </div>
</div>
<div class="form_item">
<div class="form_element cf_textbox">
<label class="cf_label" style="width: 150px;">City</label>
<input class="cf_inputbox required" maxlength="150" size="30" title="" id="text_20" name="City" type="text" />
</div>
<div class="cfclear"> </div>
</div>
<div class="form_item">
<div class="form_element cf_textbox">
<label class="cf_label" style="width: 150px;">State</label>
<input class="cf_inputbox required" maxlength="150" size="30" title="" id="text_19" name="State" type="text" />
</div>
<div class="cfclear"> </div>
</div>
<div class="form_item">
<div class="form_element cf_textbox">
<label class="cf_label" style="width: 150px;">Zip Code</label>
<input class="cf_inputbox" maxlength="150" size="30" title="" id="text_18" name="Zip_Code" type="text" />
</div>
<div class="cfclear"> </div>
</div>
<div class="form_item">
<div class="form_element cf_textbox">
<label class="cf_label" style="width: 150px;">Home Phone</label>
<input class="cf_inputbox required validate-number" maxlength="150" size="30" title="" id="text_6" name="Student_Home_Phone" type="text" />
</div>
<div class="cfclear"> </div>
</div>
<div class="form_item">
<div class="form_element cf_textbox">
<label class="cf_label" style="width: 150px;">Cell / Work Phone</label>
<input class="cf_inputbox validate-number" maxlength="150" size="30" title="" id="text_17" name="Student_Cell" type="text" />
</div>
<div class="cfclear"> </div>
</div>
<div class="form_item">
<div class="form_element cf_textbox">
<label class="cf_label" style="width: 150px;">Present School's Name</label>
<input class="cf_inputbox required" maxlength="150" size="30" title="" id="text_16" name="School_Name" type="text" />
</div>
<div class="cfclear"> </div>
</div>
<div class="form_item">
<div class="form_element cf_textbox">
<label class="cf_label" style="width: 150px;">School's Address</label>
<input class="cf_inputbox required" maxlength="150" size="30" title="" id="text_15" name="Student_School_Address" type="text" />
</div>
<div class="cfclear"> </div>
</div>
<div class="form_item">
<div class="form_element cf_textbox">
<label class="cf_label" style="width: 150px;">Grade</label>
<input class="cf_inputbox" maxlength="150" size="30" title="" id="text_14" name="Grade" type="text" />
</div>
<div class="cfclear"> </div>
</div>
<div class="form_item">
<div class="form_element cf_textbox">
<label class="cf_label" style="width: 150px;">Parent Name</label>
<input class="cf_inputbox required" maxlength="150" size="30" title="" id="text_13" name="Parent_Name" type="text" />
</div>
<div class="cfclear"> </div>
</div>
<div class="form_item">
<div class="form_element cf_textbox">
<label class="cf_label" style="width: 150px;">Home Phone</label>
<input class="cf_inputbox required validate-number" maxlength="150" size="30" title="" id="text_12" name="Parent_Home_Phone" type="text" />
</div>
<div class="cfclear"> </div>
</div>
<div class="form_item">
<div class="form_element cf_textbox">
<label class="cf_label" style="width: 150px;">Work / Cell</label>
<input class="cf_inputbox validate-number" maxlength="150" size="30" title="" id="text_11" name="Parent_Cell" type="text" />
</div>
<div class="cfclear"> </div>
</div>
<div class="form_item">
<div class="form_element cf_textbox">
<label class="cf_label" style="width: 150px;">Email Address</label>
<input class="cf_inputbox required validate-email" maxlength="150" size="30" title="" id="text_10" name="Parent_Email_Address" type="text" />
</div>
<div class="cfclear"> </div>
</div>
<div class="form_item">
<div class="form_element cf_textbox">
<label class="cf_label" style="width: 150px;">Alternate Emergency Name</label>
<input class="cf_inputbox required" maxlength="150" size="30" title="" id="text_9" name="Emergency_Name" type="text" />
</div>
<div class="cfclear"> </div>
</div>
<div class="form_item">
<div class="form_element cf_textbox">
<label class="cf_label" style="width: 150px;">Home Phone</label>
<input class="cf_inputbox required" maxlength="150" size="30" title="" id="text_7" name="Emergency_Home _Phone _Number" type="text" />
</div>
<div class="cfclear"> </div>
</div>
<div class="form_item">
<div class="form_element cf_textbox">
<label class="cf_label" style="width: 150px;">Work / Cell</label>
<input class="cf_inputbox" maxlength="150" size="30" title="" id="text_8" name="Emergency_Cell" type="text" />
</div>
<div class="cfclear"> </div>
</div>
<div class="form_item">
<div class="form_element cf_dropdown">
<label class="cf_label" style="width: 150px;">Ethnicity</label>
<select class="cf_inputbox validate-selection" id="select_23" size="1" title="" name="Ethnicity">
<option value="">Choose Option</option>
<option value="African American">African American</option>
<option value="Asian">Asian</option>
<option value="Caucasian">Caucasian</option>
<option value="Latino">Latino</option>
<option value="Native American">Native American</option>
<option value="Other">Other</option>
</select>
</div>
<div class="cfclear"> </div>
</div>
<div class="form_item">
<div class="form_element cf_dropdown">
<label class="cf_label" style="width: 150px;">Annual Income</label>
<select class="cf_inputbox validate-selection" id="select_24" size="1" title="" name="Annual_Income">
<option value="">Choose Option</option>
<option value="< $ 5,000">< $ 5,000</option>
<option value="$ 5,000 - $ 9,999">$ 5,000 - $ 9,999</option>
<option value="$ 10,000 - $ 14,999">$ 10,000 - $ 14,999</option>
<option value="$ 25,000 - $ 34,999">$ 25,000 - $ 34,999</option>
<option value="$ 35,000 >">$ 35,000 ></option>
</select>
</div>
<div class="cfclear"> </div>
</div>
<div class="form_item">
<div class="form_element cf_dropdown">
<label class="cf_label" style="width: 150px;">Primary language</label>
<select class="cf_inputbox validate-selection" id="select_22" size="1" title="" name="Primary_language">
<option value="">Choose Option</option>
<option value="English">English</option>
<option value="Spanish">Spanish</option>
<option value="Other">Other</option>
</select>
</div>
<div class="cfclear"> </div>
</div>
<div class="form_item">
<div class="form_element cf_textbox">
<label class="cf_label" style="width: 150px;">If, other (Indicate)</label>
<input class="cf_inputbox" maxlength="150" size="30" title="" id="text_25" name="Other_Language" type="text" />
</div>
<div class="cfclear"> </div>
</div>
<div class="form_item">
<div class="form_element cf_dropdown">
<label class="cf_label" style="width: 450px;">I hereby release Intercultural Family Services, Inc. (IFSI) and its agents and employees, from all liability for personal injury, illness or property damage occurring on or off the IFSI premises, whether or not caused by negligence of IFSI and/or its agents or employees. I have read the registration information and understand the program’s policies as outlined. I understand that I am responsible for tuition payments as described. I certify that the student is in good health and capable of participating in all school activities and classes. I hereby give permission for IFSI to take photographs and videotapes for promotional uses for the organization.</label>
<select class="cf_inputbox validate-selection" id="select_27" size="1" title="" name="Liability">
<option value="">Choose Option</option>
<option value="I accept">I accept</option>
<option value="I don't accept">I don't accept</option>
</select>
</div>
<div class="cfclear"> </div>
</div>
<div class="form_item">
<div class="form_element cf_dropdown">
<label class="cf_label" style="width: 450px;">In case of emergency, I give permission for my child to be given first aid by trained IFSI personnel and to be taken to the nearest hospital or medical center for emergency treatment, if necessary.</label>
<select class="cf_inputbox validate-selection" id="select_28" size="1" title="" name="Emergency_Permission">
<option value="">Choose Option</option>
<option value="I accept">I accept</option>
<option value="I don't accept">I don't accept</option>
</select>
</div>
<div class="cfclear"> </div>
</div>
<div class="form_item">
<div class="form_element cf_dropdown">
<label class="cf_label" style="width: 450px;">Please indicate how your child/children will go home from Intercultural Family Services, Inc. A child under 12 must go home with their parent/guardian or someone approved above or brings written instructions that they will be going with someone else.</label>
<select class="cf_inputbox validate-selection" id="select_30" size="1" title="" name="How_Child_Will_Go_Home">
<option value="">Choose Option</option>
<option value="Travel on his/her own (over 12)">Travel on his/her own (over 12)</option>
<option value="Picked up by parent/guardian">Picked up by parent/guardian</option>
<option value="carpooling with another family">carpooling with another family</option>
</select>
</div>
<div class="cfclear"> </div>
</div>
<div class="form_item">
<div class="form_element cf_dropdown">
<label class="cf_label" style="width: 450px;">I ___ do ___ do not give my child (over 12) permission to go to convenience stores and/or restaurants that are walking distance from Intercultural Family Services, Inc., to purchase food. Staff will not accompany children.</label>
<select class="cf_inputbox validate-selection" id="select_29" size="1" title="" name="Permission_to_go_to_stores">
<option value="">Choose Option</option>
<option value="I do">I do</option>
<option value="I don't">I don't</option>
</select>
</div>
<div class="cfclear"> </div>
</div>
<div class="form_item">
<div class="form_element cf_dropdown">
<label class="cf_label" style="width: 450px;">Does the child/youth have any medical conditions the program should be aware of? (Medications, special instructions, etc.</label>
<select class="cf_inputbox validate-selection" id="select_26" size="1" title="" name="Medical_Conditions">
<option value="">Choose Option</option>
<option value="Yes">Yes</option>
<option value="No">No</option>
</select>
</div>
<div class="cfclear"> </div>
</div>
<div class="form_item">
<div class="form_element cf_textbox">
<label class="cf_label" style="width: 150px;">If yes, indicate</label>
<input class="cf_inputbox" maxlength="150" size="30" title="" id="text_31" name="Medications" type="text" />
</div>
<div class="cfclear"> </div>
</div>
<div class="form_item">
<div class="form_element cf_heading">
<h1 class="cf_text">Select Time and Class</h1>
</div>
<div class="cfclear"> </div>
</div>
<div class="form_item">
<div class="form_element cf_dropdown">
<label class="cf_label" style="width: 150px;">10 am to 11 am</label>
<select class="cf_inputbox" id="select_35" size="1" title="" name="10am_to_11am">
<option value="">Choose Option</option>
<option value="Intermediate Guitar">Intermediate Guitar</option>
<option value="Intermediate Children’s Piano">Intermediate Children’s Piano</option>
<option value="Hip Hop">Hip Hop</option>
<option value="Beginner Violin">Beginner Violin</option>
<option value="Intermediate Teen Piano">Intermediate Teen Piano</option>
<option value="Martial Arts">Martial Arts</option>
</select>
</div>
<div class="cfclear"> </div>
</div>
<div class="form_item">
<div class="form_element cf_dropdown">
<label class="cf_label" style="width: 150px;">11 am to 12 pm</label>
<select class="cf_inputbox" id="select_36" size="1" title="" name="11am_to_12pm">
<option value="">Choose Option</option>
<option value="Beginner Guitar">Beginner Guitar</option>
<option value="Vocal Arts">Vocal Arts</option>
<option value="Beginner Teen Piano">Beginner Teen Piano</option>
<option value="Hip Hop Dance">Hip Hop Dance</option>
<option value="Intermediate Violin">Intermediate Violin</option>
<option value="Martial Arts">Martial Arts</option>
</select>
</div>
<div class="cfclear"> </div>
</div>
<div class="form_item">
<div class="form_element cf_dropdown">
<label class="cf_label" style="width: 150px;">12:30 pm to 1:30 pm</label>
<select class="cf_inputbox" id="select_34" size="1" title="" name="12_30pm_to_1_30pm">
<option value="">Choose Option</option>
<option value="Aspiring Composers">Aspiring Composers</option>
<option value="Sewing">Sewing</option>
<option value="Beginner African Drumming">Beginner African Drumming</option>
<option value="Beginner Children’s Piano">Beginner Children’s Piano</option>
<option value="Beginner Guitar">Beginner Guitar</option>
<option value="Beginner Violin">Beginner Violin</option>
</select>
</div>
<div class="cfclear"> </div>
</div>
<div class="form_item">
<div class="form_element cf_button">
<input value="Submit" name="button_37" type="submit" />
</div>
<div class="cfclear"> </div>
</div>I will highly appreciate if you can resolve this .....thanks in advance
Hi mankss,
You need to refresh the DB Connection after any changes to database column names. In the Form Editor click the DB Connection tab and set the Connection to 'No'. Click the 'Apply icon in the toolbar to save the form, open the DB Connection tab, set the Connection back to 'Yes' and re-save the form. This will refresh the copy of the table information that ChronoForms uses.
Bob
You need to refresh the DB Connection after any changes to database column names. In the Form Editor click the DB Connection tab and set the Connection to 'No'. Click the 'Apply icon in the toolbar to save the form, open the DB Connection tab, set the Connection back to 'Yes' and re-save the form. This will refresh the copy of the table information that ChronoForms uses.
Bob
Hi,
Also, you'll have to rename the dropdowns "10am_to_11am", "11am_to_12pm", and "12_30pm_to_1_30pm", as form field names cannot start with a digit, only the letters a-z. You'll also have to alter or re-create your database table to reflect these changes, and finally refresh the DB connection as mentioned by Bob.
/Fredrik
Also, you'll have to rename the dropdowns "10am_to_11am", "11am_to_12pm", and "12_30pm_to_1_30pm", as form field names cannot start with a digit, only the letters a-z. You'll also have to alter or re-create your database table to reflect these changes, and finally refresh the DB connection as mentioned by Bob.
/Fredrik
I love you guys finally my form is up and running...thanks BOB and nml375 you guys are awesome.....you know wat i was about switch to diff form joomla extension.....but now i will never ever....gonna think about it ...
Keep up the good work guys
Keep up the good work guys
the only problem i have now is...with the required field for example first name and last name.....they are not coming as mandatory field, I mean now i can save my form with out filling these two fields...so i am now wondering where I am doing wrong
bob and nml375 can you guys help me with that..
thanks in advance
bob and nml375 can you guys help me with that..
thanks in advance
This topic is locked and no more replies can be posted.
