mysql error: duplicate fieldname

dw

dwikristianto 15 Jun, 2007

hi all,

when i try to create table from form code below :


<table width="100%" border="0" cellspacing="0" cellpadding="4" summary="form">
  <tr>
    <td align="right" valign="middle">Business/Company Name</td>
    <td width="1%">:</td>
    <td align="left" valign="middle"><input name="company_name" type="text" id="company_name" /></td>
  </tr>
  <tr>
    <td align="right" valign="middle">Personal Name</td>
    <td>:</td>
    <td align="left" valign="middle"><input name="personal_name" type="text" id="personal_name" /></td>
  </tr>
  <tr>
    <td align="right" valign="middle">Position (CEO, Manager etc.)</td>
    <td width="1%">:</td>
    <td align="left" valign="middle"><input name="position" type="text" id="position" /></td>
  </tr>
  <tr>
    <td align="right" valign="middle">Email Address</td>
    <td>:</td>
    <td align="left" valign="middle"><input name="email_addr" type="text" id="email_addr" /></td>
  </tr>
  <tr>
    <td align="right" valign="middle">Primary Phone</td>
    <td width="1%">:</td>
    <td align="left" valign="middle"><input name="phone_primary" type="text" id="phone_primary" /></td>
  </tr>
  <tr>
    <td align="right" valign="middle">Secondary Phone</td>
    <td>:</td>
    <td align="left" valign="middle"><input name="phone_secondary" type="text" id="phone_secondary" /></td>
  </tr>
  <tr>
    <td align="right" valign="middle">If we need to contact you, <br />
      what is the best time ? </td>
    <td width="1%">:</td>
    <td align="left" valign="middle"><input name="contact_time" type="radio" value="Morning" class="radio" />
      Morning
      <input name="contact_time" type="radio" value="Afternoon" class="radio" />
      Afternoon
      <input name="contact_time" type="radio" value="Evening" class="radio" />
      Evening</td>
  </tr>
  <tr>
    <td align="right" valign="middle">Business Type</td>
    <td>:</td>
    <td align="left" valign="middle"><select name="business_type" id="business_type">
        <option value="marketing">Marketing</option>
        <option value="advertising">Advertising</option>
        <option value="industry">Industry</option>
        <option value="other">Other</option>
      </select>
    </td>
  </tr>
  <tr>
    <td align="right" valign="middle">Business Description (brief)</td>
    <td> </td>
    <td align="left" valign="middle"><textarea name="business_desc" rows="7" id="business_desc"></textarea></td>
  </tr>
  <tr>
    <td align="right" valign="middle">Address </td>
    <td>:</td>
    <td align="left" valign="middle"><input name="address" type="text" id="address" /></td>
  </tr>
  <tr>
    <td align="right" valign="middle">City</td>
    <td>:</td>
    <td align="left" valign="middle"><input name="city" type="text" id="city" /></td>
  </tr>
  <tr>
    <td align="right" valign="middle">State</td>
    <td>:</td>
    <td align="left" valign="middle"><input name="state" type="text" id="state" /></td>
  </tr>
  <tr>
    <td align="right" valign="middle">Zip Code</td>
    <td>:</td>
    <td align="left" valign="middle"><input name="zipcode" type="text" id="zipcode" /></td>
  </tr>
  <tr>
    <td align="right" valign="middle">Website (If applicable)</td>
    <td>:</td>
    <td align="left" valign="middle"><input name="website" type="text" id="website" /></td>
  </tr>
  <tr>
    <td align="right" valign="middle">I need a custom quote for</td>
    <td>:</td>
    <td align="left" valign="middle"><select name="custom_quote" id="custom_quote" onchange="quoteChanged(this.value);">
        <option value="null" selected="selected">Choose one..</option>
        <option>Design</option>
        <option>Print</option>
        <option>Business Directory</option>
      </select>
      <span id="designtype" style="display:none;"> <br />
      Design Type :
      <select name="design_ops" id="design_ops">
        <option value="null" selected="selected">Choose one..</option>
        <option>Website Design</option>
        <option>Logo Design</option>
        <option>Custom Graphic Design</option>
      </select>
      </span></td>
  </tr>
  <tr>
    <td align="right" valign="middle"> </td>
    <td> </td>
    <td align="left" valign="middle"> </td>
  </tr>
  <tr>
    <td align="right" valign="middle"> </td>
    <td> </td>
    <td align="left" valign="middle"><input name="submit" type="submit" id="submit" value="Continue" class="buttons" /></td>
  </tr>
</table>

it produce mysql error: duplicate fieldname at contact_time

here is html code for contact_time :


    <td align="left" valign="middle"><input name="contact_time" type="radio" value="Morning" class="radio" />
      Morning
      <input name="contact_time" type="radio" value="Afternoon" class="radio" />
      Afternoon
      <input name="contact_time" type="radio" value="Evening" class="radio" />
      Evening</td>

i'm using v2. any solustion or hint on this ?

many thanks,
dwi

Max_admin 15 Jun, 2007

Hi,

I put ur code and choose contact_time as a field or not choose it but I never get any errors!!!

Max

Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?

dw

dwikristianto 16 Jun, 2007

hi max,

many thanks for the testing.

i just found here that the production server still use v1, that's why it produce error. after uninstall the old and install v2, it run smooth.

sorry for that, the blame is mine.

regards,
dwi

Forums

mysql error: duplicate fieldname