create table error

I am not able to add more tables to my form. I get the following error:

Error while creating table :Table 'jos_chronoforms_Breed_Associations' already exists SQL=CREATE TABLE `jos_chronoforms_Breed_Associations` (`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, PRIMARY KEY (`cf_id`)) ENGINE = MYISAM ;

I was able to add the cf_id, uid, recordtime, ipaddress, & cf_userid fields as described in the tutorial, but not the other fields I have set up via the wizard.

Any help much appreciated ... the form html is below.....

<div class="form_item">
<div class="form_element cf_heading">
<h1 class="cf_text">Breed Associations</h1>
</div>
<div class="cfclear"> </div>
</div>

<div class="form_item">
<div class="form_element cf_textbox">
<label class="cf_label" style="width: 150px;">Title</label>
<input class="cf_inputbox" maxlength="150" size="30" title="" id="text_9" name="text_9" 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;">Web Address</label>
<input class="cf_inputbox validate-url" maxlength="150" size="30" title="" id="text_2" name="text_2" 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;">Address</label>
<input class="cf_inputbox" maxlength="150" size="30" title="" id="text_3" name="text_3" 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;">Phone Number</label>
<input class="cf_inputbox validate-digits" maxlength="150" size="30" title="" id="text_5" name="text_5" type="text" />

</div>
<div class="cfclear"> </div>
</div>

<div class="form_item">
<div class="form_element cf_button">
<input value="Submit" name="button_6" type="submit" />
</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 validate-email" maxlength="150" size="30" title="" id="text_4" name="text_4" type="text" />

</div>
<div class="cfclear"> </div>
</div>

Hi musenut,

I'm not sure what your question is. The message "Table 'jos_chronoforms_Breed_Associations' already exists" is pretty clear. If you wan to add more columns then you need to either (a) drop the exisitng table and start over or (b) edit the exisiting table to add more columns to it. You can do either of these from the ChronoForms Tables Manager or with PHPMYAdmin.

If the form columns are missing from the table then you probaly didn't select them before creating the table (green bars are selected, red bars are not selected).

Bobb

Hey Bobb - I figured out my problem - I got confused by the red/green - 'x' versus 'checkmark' set up in the create table window. To make a successful field it has to have an red x in it which is a bit counter-intuitive - but I got it - thanks for you help!