Okay I've scoured the forums looking for answers and I've tried everything pertaining to this problem. I can't seem to fix it. I have noticed that when I put less form fields in the code area it creates the table with no problem. I've tried mixind up the types and names of the fields with no solution, the only way it has worked is when I just use less form fields in general. Is it something to do with chronoforms trying to create too many fields in the newly created table and the server is kicking an error?Error while creating table :You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL) ENGINE = MYISAM' at line 1 SQL=CREATE TABLE `jos_chronoforms_test2` (`cf_id` INT(11) NOT NULL, `uid` VARCHAR(255) NOT NULL, `recordtime` VARCHAR(255) NOT NULL, `ipaddress` VARCHAR(255) NOT NULL, `cf_user_id` VARCHAR(255) NOT NULL, `teamName` VARCHAR(255) NOT NULL, `p1Gamertag` VARCHAR(255) NOT NULL, `p14v4` VARCHAR(255) NOT NULL, `p1ffa` VARCHAR(255) NOT NULL, `p12v2` VARCHAR(255) NOT NULL, `p2Gamertag` VARCHAR(255) NOT NULL, `p24v4` VARCHAR(255) NOT NULL, `p2ffa` VARCHAR(255) NOT NULL, `p22v2` VARCHAR(255) NOT NULL, `p3Gamertag` VARCHAR(255) NOT NULL, `p34v4` VARCHAR(255) NOT NULL, `p3ffa` VARCHAR(255) NOT NULL, `p32v2` VARCHAR(255) NOT NULL, `p4Gamertag` VARCHAR(255) NOT NULL, `p44v4` VARCHAR(255) NOT NULL, `p4ffa` VARCHAR(255) NOT NULL, `p42v2` VARCHAR(255) NOT NULL, `p1firstname` VARCHAR(255) NOT NULL, `p1lastname` VARCHAR(255) NOT NULL, `p1email` VARCHAR(255) NOT NULL, `p1addressl1` VARCHAR(255) NOT NULL, `p1addressl2` VARCHAR(255) NOT NULL, `p1city` VARCHAR(255) NOT NULL, `p1zipcode` VARCHAR(255) NOT NULL, `p1age` VARCHAR(255) NOT NULL, `p1phone` VARCHAR(255) NOT NULL, `p2firstname` VARCHAR(255) NOT NULL, `p2lastname` VARCHAR(255) NOT NULL, `p2email` VARCHAR(255) NOT NULL, `p2addressl1` VARCHAR(255) NOT NULL, `p2addressl2` VARCHAR(255) NOT NULL, `p2city` VARCHAR(255) NOT NULL, `p2zipcode` VARCHAR(255) NOT NULL, `p2age` VARCHAR(255) NOT NULL, `p2phone` VARCHAR(255) NOT NULL, `p3firstname` VARCHAR(255) NOT NULL, `p3lastname` VARCHAR(255) NOT NULL, `p3email` VARCHAR(255) NOT NULL, `p3addressl1` VARCHAR(255) NOT NULL, `p3addressl2` VARCHAR(255) NOT NULL, `p3city` VARCHAR(255) NOT NULL, `p3zipcode` VARCHAR(255) NOT NULL, `p3age` NOT NULL) ENGINE = MYISAM ;Here is the form code I use. I've removed all the form fields in player 4 section to try and solve the issue. Team Information Team Name 4v4 FFA 2v2 Player 1 Gamertag Player 2 Gamertag Player 3 Gamertag Player 4 Gamertag Player 1 Info Player 1 First Name * Player 1 Last Name * Player 1 Email * Player 1 Address 1 Player 1 Address 2 Player 1 City Player 1 State Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware District of Columbia Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming Player 1 Zipcode * Player 1 Gender * Male Female Player 1 Age * Player 1 Phone * Player 2 Info Player 2 First Name * Player 2 Last Name * Player 2 Email * Player 2 Address 1 Player 2 Address 2 Player 2 City Player 2 State Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware District of Columbia Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming Player 2 Zipcode * Player 2 Gender * Male Female Player 2 Age * Player 2 Phone * Player 3 Info Player 3 First Name * Player 3 Last Name * Player 3 Email * Player 3 Address 1 Player 3 Address 2 Player 3 City Player 3 State Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware District of Columbia Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming Player 3 Zipcode * Player 3 Gender * Male Female Player 3 Age * Player 3 Phone * Player 4 Info Player 4 First Name * Player 4 Last Name * Player 4 Email * Player 4 Address 1 Player 4 Address 2 Player 4 City Player 4 State Player 4 Zipcode * Player 4 Gender * Player 4 Age * Player 4 Phone *

Forums

ChronoForms v8 is now WordPress ready, ChronoMails is out

SQL - Error creating table.

lancealx 19 Aug, 2010

Okay I've scoured the forums looking for answers and I've tried everything pertaining to this problem. I can't seem to fix it. I have noticed that when I put less form fields in the code area it creates the table with no problem. I've tried mixind up the types and names of the fields with no solution, the only way it has worked is when I just use less form fields in general.

Is it something to do with chronoforms trying to create too many fields in the newly created table and the server is kicking an error?

Error while creating table :You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL) ENGINE = MYISAM' at line 1 SQL=CREATE TABLE `jos_chronoforms_test2` (`cf_id` INT(11) NOT NULL, `uid` VARCHAR(255) NOT NULL, `recordtime` VARCHAR(255) NOT NULL, `ipaddress` VARCHAR(255) NOT NULL, `cf_user_id` VARCHAR(255) NOT NULL, `teamName` VARCHAR(255) NOT NULL, `p1Gamertag` VARCHAR(255) NOT NULL, `p14v4` VARCHAR(255) NOT NULL, `p1ffa` VARCHAR(255) NOT NULL, `p12v2` VARCHAR(255) NOT NULL, `p2Gamertag` VARCHAR(255) NOT NULL, `p24v4` VARCHAR(255) NOT NULL, `p2ffa` VARCHAR(255) NOT NULL, `p22v2` VARCHAR(255) NOT NULL, `p3Gamertag` VARCHAR(255) NOT NULL, `p34v4` VARCHAR(255) NOT NULL, `p3ffa` VARCHAR(255) NOT NULL, `p32v2` VARCHAR(255) NOT NULL, `p4Gamertag` VARCHAR(255) NOT NULL, `p44v4` VARCHAR(255) NOT NULL, `p4ffa` VARCHAR(255) NOT NULL, `p42v2` VARCHAR(255) NOT NULL, `p1firstname` VARCHAR(255) NOT NULL, `p1lastname` VARCHAR(255) NOT NULL, `p1email` VARCHAR(255) NOT NULL, `p1addressl1` VARCHAR(255) NOT NULL, `p1addressl2` VARCHAR(255) NOT NULL, `p1city` VARCHAR(255) NOT NULL, `p1zipcode` VARCHAR(255) NOT NULL, `p1age` VARCHAR(255) NOT NULL, `p1phone` VARCHAR(255) NOT NULL, `p2firstname` VARCHAR(255) NOT NULL, `p2lastname` VARCHAR(255) NOT NULL, `p2email` VARCHAR(255) NOT NULL, `p2addressl1` VARCHAR(255) NOT NULL, `p2addressl2` VARCHAR(255) NOT NULL, `p2city` VARCHAR(255) NOT NULL, `p2zipcode` VARCHAR(255) NOT NULL, `p2age` VARCHAR(255) NOT NULL, `p2phone` VARCHAR(255) NOT NULL, `p3firstname` VARCHAR(255) NOT NULL, `p3lastname` VARCHAR(255) NOT NULL, `p3email` VARCHAR(255) NOT NULL, `p3addressl1` VARCHAR(255) NOT NULL, `p3addressl2` VARCHAR(255) NOT NULL, `p3city` VARCHAR(255) NOT NULL, `p3zipcode` VARCHAR(255) NOT NULL, `p3age` NOT NULL) ENGINE = MYISAM ;

Here is the form code I use. I've removed all the form fields in player 4 section to try and solve the issue.

<table width="600" border="0" class="fullborder" cellpadding="1" cellspacing="0">
  <tr>
    <td colspan="6" class="teaminfo">Team Information </td>
  </tr>
  <tr>
    <td class="bottomborder"><strong>Team Name </strong></td>
    <td class="bottomborder">
      <input name="teamName" type="text" size="25" maxlength="20">
    </td>
    <td class="centertext">4v4</td>
    <td class="centertext">FFA</td>
    <td class="centertext">2v2</td>
  </tr>
  <tr>
    <td class="bottomborder"><strong>Player 1 Gamertag </strong></td>
    <td class="bottomborder">
      <input name="p1Gamertag" type="text" size="20" maxlength="20">
    </td>
    <td class="centertext">
      <input name="p14v4" type="checkbox" value="yes" checked="checked">
    
</td>
    <td class="centertext"><input name="p1ffa" type="checkbox" value="yes"></td>
    <td class="centertext"><input name="p12v2" type="checkbox" value="yes"></td>
  </tr>
  <tr>
    <td class="bottomborder"><strong>Player 2 Gamertag</strong></td>
    <td class="bottomborder">
      <input name="p2Gamertag" type="text" size="20" maxlength="20">
    </td>
    <td class="centertext"><input name="p24v4" type="checkbox" value="yes" checked="checked"></td>

    <td class="centertext"><input name="p2ffa" type="checkbox" value="yes"></td>
    <td class="centertext"><input name="p22v2" type="checkbox" value="yes"></td>
  </tr>
  <tr>
    <td class="bottomborder"><strong>Player 3 Gamertag</strong></td>
    <td class="bottomborder">
      <input name="p3Gamertag" type="text" size="20" maxlength="20">
    </td>
    <td class="centertext"><input name="p34v4" type="checkbox" value="yes" checked="checked"></td>
    <td class="centertext"><input name="p3ffa" type="checkbox" value="yes"></td>
    <td class="centertext"><input name="p32v2" type="checkbox" value="yes"></td>
  </tr>
  <tr>
    <td class="bottomborder"><strong>Player 4 Gamertag</strong></td>
    <td class="bottomborder">
      <input name="p4Gamertag" type="text" size="20" maxlength="20">
    </td>
    <td class="centertext"><input name="p44v4" type="checkbox" value="yes" checked="checked"></td>
    <td class="centertext"><input name="p4ffa" type="checkbox" value="yes"></td>
    <td class="centertext"><input name="p42v2" type="checkbox" value="yes"></td>
  </tr>
</table>
<p> </p>
<table width="600" border="0" class="fullborder" cellspacing="0">
  <tr>
    <td colspan="2" class="teaminfo">Player 1 Info </td>
  </tr>
  <tr>
    <td class="bottomborder"><strong>Player 1 First Name * </strong></td>
    <td class="bottomborder">
      <input name="p1firstname" type="text" size="20" maxlength="20">
    </td>
  </tr>
  <tr>
    <td bgcolor="#CCCCCC" class="bottomborder"><p><strong>Player 1 Last Name * </strong></p>    </td>
    <td bgcolor="#CCCCCC" class="bottomborder">
      <input name="p1lastname" type="text" size="25" maxlength="25">
    </td>
  </tr>
  <tr>
    <td class="bottomborder"><strong>Player 1 Email * </strong></td>
    <td class="bottomborder">
      <input name="p1email" type="text" size="25" maxlength="35">
    </td>
  </tr>
  <tr bgcolor="#CCCCCC">
    <td class="bottomborder"><strong>Player 1 Address 1 </strong></td>
    <td class="bottomborder">
      <input name="p1addressl1" type="text" size="45" maxlength="45">
    </td>
  </tr>
  <tr>
    <td class="bottomborder"><strong>Player 1 Address 2 </strong></td>
    <td class="bottomborder">
      <input name="p1addressl2" type="text" size="45" maxlength="45">
    </td>
  </tr>
  <tr bgcolor="#CCCCCC">
    <td class="bottomborder"><strong>Player 1 City </strong></td>
    <td class="bottomborder">
      <input name="p1city" type="text" size="25" maxlength="25">
    </td>
  </tr>
  <tr>
    <td class="bottomborder"><strong>Player 1 State  </strong></td>
    <td class="bottomborder">
      <select name="p1state">
        <option value="AL" selected="selected">Alabama</option>
        <option value="AK">Alaska</option>
        <option value="AZ">Arizona</option>
        <option value="AR">Arkansas</option>
        <option value="CA">California</option>
        <option value="CO">Colorado</option>
        <option value="CT">Connecticut</option>
        <option value="DE">Delaware</option>
        <option value="DC">District of Columbia</option>
        <option value="FL">Florida</option>
        <option value="GA">Georgia</option>
        <option value="HI">Hawaii</option>
        <option value="ID">Idaho</option>
        <option value="IL">Illinois</option>
        <option value="IN">Indiana</option>
        <option value="IA">Iowa</option>
        <option value="KS">Kansas</option>
        <option value="KY">Kentucky</option>
        <option value="LA">Louisiana</option>
        <option value="ME">Maine</option>
        <option value="MD">Maryland</option>
        <option value="MA">Massachusetts</option>
        <option value="MI">Michigan</option>
        <option value="MN">Minnesota</option>
        <option value="MS">Mississippi</option>
        <option value="MO">Missouri</option>
        <option value="MT">Montana</option>
        <option value="NE">Nebraska</option>
        <option value="NV">Nevada</option>
        <option value="NH">New Hampshire</option>
        <option value="NJ">New Jersey</option>
        <option value="NM">New Mexico</option>
        <option value="NY">New York</option>
        <option value="NC">North Carolina</option>
        <option value="ND">North Dakota</option>
        <option value="OH">Ohio</option>
        <option value="OK">Oklahoma</option>
        <option value="OR">Oregon</option>
        <option value="PA">Pennsylvania</option>
        <option value="RI">Rhode Island</option>
        <option value="SC">South Carolina</option>
        <option value="SD">South Dakota</option>
        <option value="TN">Tennessee</option>
        <option value="TX">Texas</option>
        <option value="UT">Utah</option>
        <option value="VT">Vermont</option>
        <option value="VA">Virginia</option>
        <option value="WA">Washington</option>
        <option value="WV">West Virginia</option>
        <option value="WI">Wisconsin</option>
        <option value="WY">Wyoming</option>
      </select>
    </td>
  </tr>
  <tr bgcolor="#CCCCCC">
    <td class="bottomborder"><strong>Player 1 Zipcode * </strong></td>
    <td class="bottomborder">
      <input name="p1zipcode" type="text" size="10" maxlength="5">
    </td>
  </tr>
  <tr>
    <td class="bottomborder"><strong>Player 1 Gender * </strong></td>
    <td class="bottomborder">
      <select name="p1gender">
        <option value="Male" selected="selected">Male</option>
        <option value="Female">Female</option>
      </select>
    </td>
  </tr>
  <tr bgcolor="#CCCCCC">
    <td class="bottomborder"><strong>Player 1 Age * </strong></td>
    <td class="bottomborder">
      <input name="p1age" type="text" size="5" maxlength="12">
    </td>
  </tr>
  <tr>
    <td class="bottomborder"><strong>Player 1 Phone * </strong></td>
    <td class="bottomborder">
      <input name="p1phone" type="text" size="10" maxlength="10">
    </td>
  </tr>
</table>
<p> </p>
<table width="600" border="0" class="fullborder" cellspacing="0">
  <tr>
    <td colspan="2" class="teaminfo">Player 2 Info </td>
  </tr>
  <tr>
    <td class="bottomborder"><strong>Player 2 First Name * </strong></td>
    <td class="bottomborder">
      <input name="p2firstname" type="text" size="20" maxlength="20" />
    </td>
  </tr>
  <tr>
    <td bgcolor="#CCCCCC" class="bottomborder"><p><strong>Player 2 Last Name * </strong></p></td>
    <td bgcolor="#CCCCCC" class="bottomborder">
      <input name="p2lastname" type="text" size="25" maxlength="25" />
    </td>
  </tr>
  <tr>
    <td class="bottomborder"><strong>Player 2 Email * </strong></td>
    <td class="bottomborder">
      <input name="p2email" type="text" size="25" maxlength="35" />
    </td>
  </tr>
  <tr bgcolor="#CCCCCC">
    <td class="bottomborder"><strong>Player 2 Address 1 </strong></td>
    <td class="bottomborder">
      <input name="p2addressl1" type="text" size="45" maxlength="45" />
    </td>
  </tr>
  <tr>
    <td class="bottomborder"><strong>Player 2 Address 2 </strong></td>
    <td class="bottomborder">
      <input name="p2addressl2" type="text" size="45" maxlength="45" />
    </td>
  </tr>
  <tr bgcolor="#CCCCCC">
    <td class="bottomborder"><strong>Player 2 City </strong></td>
    <td class="bottomborder">
      <input name="p2city" type="text" size="25" maxlength="25" />
    </td>
  </tr>
  <tr>
    <td class="bottomborder"><strong>Player 2 State </strong></td>
    <td class="bottomborder">
      <select name="p2state">
        <option value="AL" selected="selected">Alabama</option>
        <option value="AK">Alaska</option>
        <option value="AZ">Arizona</option>
        <option value="AR">Arkansas</option>
        <option value="CA">California</option>
        <option value="CO">Colorado</option>
        <option value="CT">Connecticut</option>
        <option value="DE">Delaware</option>
        <option value="DC">District of Columbia</option>
        <option value="FL">Florida</option>
        <option value="GA">Georgia</option>
        <option value="HI">Hawaii</option>
        <option value="ID">Idaho</option>
        <option value="IL">Illinois</option>
        <option value="IN">Indiana</option>
        <option value="IA">Iowa</option>
        <option value="KS">Kansas</option>
        <option value="KY">Kentucky</option>
        <option value="LA">Louisiana</option>
        <option value="ME">Maine</option>
        <option value="MD">Maryland</option>
        <option value="MA">Massachusetts</option>
        <option value="MI">Michigan</option>
        <option value="MN">Minnesota</option>
        <option value="MS">Mississippi</option>
        <option value="MO">Missouri</option>
        <option value="MT">Montana</option>
        <option value="NE">Nebraska</option>
        <option value="NV">Nevada</option>
        <option value="NH">New Hampshire</option>
        <option value="NJ">New Jersey</option>
        <option value="NM">New Mexico</option>
        <option value="NY">New York</option>
        <option value="NC">North Carolina</option>
        <option value="ND">North Dakota</option>
        <option value="OH">Ohio</option>
        <option value="OK">Oklahoma</option>
        <option value="OR">Oregon</option>
        <option value="PA">Pennsylvania</option>
        <option value="RI">Rhode Island</option>
        <option value="SC">South Carolina</option>
        <option value="SD">South Dakota</option>
        <option value="TN">Tennessee</option>
        <option value="TX">Texas</option>
        <option value="UT">Utah</option>
        <option value="VT">Vermont</option>
        <option value="VA">Virginia</option>
        <option value="WA">Washington</option>
        <option value="WV">West Virginia</option>
        <option value="WI">Wisconsin</option>
        <option value="WY">Wyoming</option>
      </select>
    </td>
  </tr>
  <tr bgcolor="#CCCCCC">
    <td class="bottomborder"><strong>Player 2 Zipcode * </strong></td>
    <td class="bottomborder">
      <input name="p2zipcode" type="text" size="10" maxlength="5" />
    </td>
  </tr>
  <tr>
    <td class="bottomborder"><strong>Player 2 Gender * </strong></td>
    <td class="bottomborder">
      <select name="p2gender">
        <option value="Male" selected="selected">Male</option>
        <option value="Female">Female</option>
      </select>
    </td>
  </tr>
  <tr bgcolor="#CCCCCC">
    <td class="bottomborder"><strong>Player 2 Age * </strong></td>
    <td class="bottomborder">
      <input name="p2age" type="text" size="5" maxlength="12" />
    </td>
  </tr>
  <tr>
    <td class="bottomborder"><strong>Player 2 Phone * </strong></td>
    <td class="bottomborder">
      <input name="p2phone" type="text" size="10" maxlength="10" />
    </td>
  </tr>
</table>
<p> </p>
<table width="600" border="0" class="fullborder" cellspacing="0">
  <tr>
    <td colspan="2" class="teaminfo">Player 3 Info </td>
  </tr>
  <tr>
    <td class="bottomborder"><strong>Player 3 First Name * </strong></td>
    <td class="bottomborder">
      <input name="p3firstname" type="text" size="20" maxlength="20" />
    </td>
  </tr>
  <tr>
    <td bgcolor="#CCCCCC" class="bottomborder"><p><strong>Player 3 Last Name * </strong></p></td>
    <td bgcolor="#CCCCCC" class="bottomborder">
      <input name="p3lastname" type="text" size="25" maxlength="25" />
    </td>
  </tr>
  <tr>
    <td class="bottomborder"><strong>Player 3 Email * </strong></td>
    <td class="bottomborder">
      <input name="p3email" type="text" size="25" maxlength="35" />
    </td>
  </tr>
  <tr bgcolor="#CCCCCC">
    <td class="bottomborder"><strong>Player 3 Address 1 </strong></td>
    <td class="bottomborder">
      <input name="p3addressl1" type="text" size="45" maxlength="45" />
    </td>
  </tr>
  <tr>
    <td class="bottomborder"><strong>Player 3 Address 2 </strong></td>
    <td class="bottomborder">
      <input name="p3addressl2" type="text" size="45" maxlength="45" />
    </td>
  </tr>
  <tr bgcolor="#CCCCCC">
    <td class="bottomborder"><strong>Player 3 City </strong></td>
    <td class="bottomborder">
      <input name="p3city" type="text" size="25" maxlength="25" />
    </td>
  </tr>
  <tr>
    <td class="bottomborder"><strong>Player 3 State </strong></td>
    <td class="bottomborder">
      <select name="p3state">
        <option value="AL" selected="selected">Alabama</option>
        <option value="AK">Alaska</option>
        <option value="AZ">Arizona</option>
        <option value="AR">Arkansas</option>
        <option value="CA">California</option>
        <option value="CO">Colorado</option>
        <option value="CT">Connecticut</option>
        <option value="DE">Delaware</option>
        <option value="DC">District of Columbia</option>
        <option value="FL">Florida</option>
        <option value="GA">Georgia</option>
        <option value="HI">Hawaii</option>
        <option value="ID">Idaho</option>
        <option value="IL">Illinois</option>
        <option value="IN">Indiana</option>
        <option value="IA">Iowa</option>
        <option value="KS">Kansas</option>
        <option value="KY">Kentucky</option>
        <option value="LA">Louisiana</option>
        <option value="ME">Maine</option>
        <option value="MD">Maryland</option>
        <option value="MA">Massachusetts</option>
        <option value="MI">Michigan</option>
        <option value="MN">Minnesota</option>
        <option value="MS">Mississippi</option>
        <option value="MO">Missouri</option>
        <option value="MT">Montana</option>
        <option value="NE">Nebraska</option>
        <option value="NV">Nevada</option>
        <option value="NH">New Hampshire</option>
        <option value="NJ">New Jersey</option>
        <option value="NM">New Mexico</option>
        <option value="NY">New York</option>
        <option value="NC">North Carolina</option>
        <option value="ND">North Dakota</option>
        <option value="OH">Ohio</option>
        <option value="OK">Oklahoma</option>
        <option value="OR">Oregon</option>
        <option value="PA">Pennsylvania</option>
        <option value="RI">Rhode Island</option>
        <option value="SC">South Carolina</option>
        <option value="SD">South Dakota</option>
        <option value="TN">Tennessee</option>
        <option value="TX">Texas</option>
        <option value="UT">Utah</option>
        <option value="VT">Vermont</option>
        <option value="VA">Virginia</option>
        <option value="WA">Washington</option>
        <option value="WV">West Virginia</option>
        <option value="WI">Wisconsin</option>
        <option value="WY">Wyoming</option>
      </select>
    </td>
  </tr>
  <tr bgcolor="#CCCCCC">
    <td class="bottomborder"><strong>Player 3 Zipcode * </strong></td>
    <td class="bottomborder">
      <input name="p3zipcode" type="text" size="10" maxlength="5" />
    </td>
  </tr>
  <tr>
    <td class="bottomborder"><strong>Player 3 Gender * </strong></td>
    <td class="bottomborder">
      <select name="p3gender">
        <option value="Male" selected="selected">Male</option>
        <option value="Female">Female</option>
      </select>
    </td>
  </tr>
  <tr bgcolor="#CCCCCC">
    <td class="bottomborder"><strong>Player 3 Age * </strong></td>
    <td class="bottomborder">
      <input name="p3age" type="text" size="5" maxlength="12" />
    </td>
  </tr>
  <tr>
    <td class="bottomborder"><strong>Player 3 Phone * </strong></td>
    <td class="bottomborder">
      <input name="p3phone" type="text" size="10" maxlength="10" />
    </td>
  </tr>
</table>
<p> </p>
<table width="600" border="0" class="fullborder" cellspacing="0">
  <tr>
    <td colspan="2" class="teaminfo">Player 4 Info </td>
  </tr>
  <tr>
    <td class="bottomborder"><strong>Player 4 First Name * </strong></td>
    <td class="bottomborder"> </td>
  </tr>
  <tr>
    <td bgcolor="#CCCCCC" class="bottomborder"><p><strong>Player 4 Last Name * </strong></p></td>
    <td bgcolor="#CCCCCC" class="bottomborder"> </td>
  </tr>
  <tr>
    <td class="bottomborder"><strong>Player 4 Email * </strong></td>
    <td class="bottomborder"> </td>
  </tr>
  <tr bgcolor="#CCCCCC">
    <td class="bottomborder"><strong>Player 4 Address 1 </strong></td>
    <td class="bottomborder"> </td>
  </tr>
  <tr>
    <td class="bottomborder"><strong>Player 4 Address 2 </strong></td>
    <td class="bottomborder"> </td>
  </tr>
  <tr bgcolor="#CCCCCC">
    <td class="bottomborder"><strong>Player 4 City </strong></td>
    <td class="bottomborder"> </td>
  </tr>
  <tr>
    <td class="bottomborder"><strong>Player 4 State </strong></td>
    <td class="bottomborder"> </td>
  </tr>
  <tr bgcolor="#CCCCCC">
    <td class="bottomborder"><strong>Player 4 Zipcode * </strong></td>
    <td class="bottomborder"> </td>
  </tr>
  <tr>
    <td class="bottomborder"><strong>Player 4 Gender * </strong></td>
    <td class="bottomborder"> </td>
  </tr>
  <tr bgcolor="#CCCCCC">
    <td class="bottomborder"><strong>Player 4 Age * </strong></td>
    <td class="bottomborder"> </td>
  </tr>
  <tr>
    <td class="bottomborder"><strong>Player 4 Phone * </strong></td>
    <td class="bottomborder"> </td>
  </tr>
</table>
<p> </p>

GreyHead 19 Aug, 2010

Hi LanceAlx,

There is no column type defind for the last column - it should look like

. . . `p3age` VARCHAR(255) NOT NULL) . . .

Bob

lancealx 19 Aug, 2010

Hey Bob,

Thanks for the quick reply. I took a look at that and double checked the column type when creating the table. Chronoforms defaults all my fields to VARCHAR(255). I never changed the settings so I just tried resubmitting and the exact same error results came up.

So I just tried removing the p3age field and it gave the same error but for a different field now.

Error while creating table :You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL) ENGINE = MYISAM' at line 1 SQL=CREATE TABLE `jos_chronoforms_test2` (`cf_id` INT(11) NOT NULL, `uid` VARCHAR(255) NOT NULL, `recordtime` VARCHAR(255) NOT NULL, `ipaddress` VARCHAR(255) NOT NULL, `cf_user_id` VARCHAR(255) NOT NULL, `teamName` VARCHAR(255) NOT NULL, `p1Gamertag` VARCHAR(255) NOT NULL, `p14v4` VARCHAR(255) NOT NULL, `p1ffa` VARCHAR(255) NOT NULL, `p12v2` VARCHAR(255) NOT NULL, `p2Gamertag` VARCHAR(255) NOT NULL, `p24v4` VARCHAR(255) NOT NULL, `p2ffa` VARCHAR(255) NOT NULL, `p22v2` VARCHAR(255) NOT NULL, `p3Gamertag` VARCHAR(255) NOT NULL, `p34v4` VARCHAR(255) NOT NULL, `p3ffa` VARCHAR(255) NOT NULL, `p32v2` VARCHAR(255) NOT NULL, `p4Gamertag` VARCHAR(255) NOT NULL, `p44v4` VARCHAR(255) NOT NULL, `p4ffa` VARCHAR(255) NOT NULL, `p42v2` VARCHAR(255) NOT NULL, `p1firstname` VARCHAR(255) NOT NULL, `p1lastname` VARCHAR(255) NOT NULL, `p1email` VARCHAR(255) NOT NULL, `p1addressl1` VARCHAR(255) NOT NULL, `p1addressl2` VARCHAR(255) NOT NULL, `p1city` VARCHAR(255) NOT NULL, `p1zipcode` VARCHAR(255) NOT NULL, `p1age` VARCHAR(255) NOT NULL, `p1phone` VARCHAR(255) NOT NULL, `p2firstname` VARCHAR(255) NOT NULL, `p2lastname` VARCHAR(255) NOT NULL, `p2email` VARCHAR(255) NOT NULL, `p2addressl1` VARCHAR(255) NOT NULL, `p2addressl2` VARCHAR(255) NOT NULL, `p2city` VARCHAR(255) NOT NULL, `p2zipcode` VARCHAR(255) NOT NULL, `p2age` VARCHAR(255) NOT NULL, `p2phone` VARCHAR(255) NOT NULL, `p3firstname` VARCHAR(255) NOT NULL, `p3lastname` VARCHAR(255) NOT NULL, `p3email` VARCHAR(255) NOT NULL, `p3addressl1` VARCHAR(255) NOT NULL, `p3addressl2` VARCHAR(255) NOT NULL, `p3city` VARCHAR(255) NOT NULL, `p3zipcode` VARCHAR(255) NOT NULL, `p1state` NOT NULL) ENGINE = MYISAM ;

GreyHead 19 Aug, 2010

Hi LanceAlx,

I've no idea why that should happen and I haven't seen it reported before. I suggest that you paste the SQL directly into PHPMyAdmin, fix the error and create the table there.

Bob

lancealx 19 Aug, 2010

I ran the query in phpmyadmin. But now when I submit the form, many fields are not being saved.

Query:

CREATE TABLE `jos_chronoforms_test2` 
(`cf_id` INT(11) NOT NULL,
 `uid` VARCHAR(255) NOT NULL,
  `recordtime` VARCHAR(255) NOT NULL,
   `ipaddress` VARCHAR(255) NOT NULL,
    `cf_user_id` VARCHAR(255) NOT NULL,
     `teamName` VARCHAR(255) NOT NULL,
      `p1Gamertag` VARCHAR(255) NOT NULL,
       `p14v4` VARCHAR(255) NOT NULL,
        `p1ffa` VARCHAR(255) NOT NULL,
         `p12v2` VARCHAR(255) NOT NULL,
          `p2Gamertag` VARCHAR(255) NOT NULL,
           `p24v4` VARCHAR(255) NOT NULL,
            `p2ffa` VARCHAR(255) NOT NULL,
             `p22v2` VARCHAR(255) NOT NULL,
              `p3Gamertag` VARCHAR(255) NOT NULL,
               `p34v4` VARCHAR(255) NOT NULL,
                `p3ffa` VARCHAR(255) NOT NULL,
                 `p32v2` VARCHAR(255) NOT NULL,
                  `p4Gamertag` VARCHAR(255) NOT NULL,
                   `p44v4` VARCHAR(255) NOT NULL,
                    `p4ffa` VARCHAR(255) NOT NULL,
                     `p42v2` VARCHAR(255) NOT NULL,
                      `p1firstname` VARCHAR(255) NOT NULL,
                       `p1lastname` VARCHAR(255) NOT NULL,
                        `p1email` VARCHAR(255) NOT NULL,
                         `p1addressl1` VARCHAR(255) NOT NULL,
                          `p1addressl2` VARCHAR(255) NOT NULL,
                           `p1city` VARCHAR(255) NOT NULL,
                            `p1zipcode` VARCHAR(255) NOT NULL,
                             `p1age` VARCHAR(255) NOT NULL,
                              `p1phone` VARCHAR(255) NOT NULL,
                               `p2firstname` VARCHAR(255) NOT NULL,
                                `p2lastname` VARCHAR(255) NOT NULL,
                                 `p2email` VARCHAR(255) NOT NULL,
                                  `p2addressl1` VARCHAR(255) NOT NULL,
                                   `p2addressl2` VARCHAR(255) NOT NULL,
                                    `p2city` VARCHAR(255) NOT NULL,
                                     `p2zipcode` VARCHAR(255) NOT NULL,
                                      `p2age` VARCHAR(255) NOT NULL,
                                       `p2phone` VARCHAR(255) NOT NULL,
                                        `p3firstname` VARCHAR(255) NOT NULL,
                                         `p3lastname` VARCHAR(255) NOT NULL,
                                          `p3email` VARCHAR(255) NOT NULL,
                                           `p3addressl1` VARCHAR(255) NOT NULL,
                                            `p3addressl2` VARCHAR(255) NOT NULL,
                                             `p3city` VARCHAR(255) NOT NULL,
                                              `p3zipcode` VARCHAR(255) NOT NULL,
                                               `p3age` VARCHAR(255) NOT NULL,
                                                `p3phone` VARCHAR(255) NOT NULL,
                                                
                                                 `p4firstname` VARCHAR(255) NOT NULL,
                               					  `p4lastname` VARCHAR(255) NOT NULL,
                                				   `p4email` VARCHAR(255) NOT NULL,
                                 			 		`p4addressl1` VARCHAR(255) NOT NULL,
                                   					 `p4addressl2` VARCHAR(255) NOT NULL,
                                    				  `p4city` VARCHAR(255) NOT NULL,
                                     				   `p4zipcode` VARCHAR(255) NOT NULL,
                                      `p4age` VARCHAR(255) NOT NULL,
                                       `p4phone` VARCHAR(255) NOT NULL)

Missed Fields:

Field name Field Data 
cf_id :  0  
uid :  IZWRjOGVmZmI4MGVm4a18b84f4ece2bd9af6090f0b3b31b2e  
recordtime :  2010-08-19 - 12:30:11  
ipaddress :  xx.xxx.xxx.xxx
cf_user_id :  0  
teamName :  team name!  
p1Gamertag :  GT1  
p14v4 :  yes  
p1ffa :  yes  
p12v2 :  yes  
p2Gamertag :   
p24v4 :  yes  
p2ffa :   
p22v2 :   
p3Gamertag :   
p34v4 :  yes  
p3ffa :   
p32v2 :   
p4Gamertag :   
p44v4 :  yes  
p4ffa :   
p42v2 :   
p1firstname :   
p1lastname :   
p1email :  lancealx@gmail.com  
p1addressl1 :   
p1addressl2 :   
p1city :   
p1zipcode :   
p1age :   
p1phone :   
p2firstname :   
p2lastname :   
p2email :   
p2addressl1 :   
p2addressl2 :   
p2city :   
p2zipcode :   
p2age :   
p2phone :   
p3firstname :   
p3lastname :   
p3email :   
p3addressl1 :   
p3addressl2 :   
p3city :   
p3zipcode :   
p3age :   
p3phone :   
p4firstname :   
p4lastname :   
p4email :   
p4addressl1 :   
p4addressl2 :   
p4city :   
p4zipcode :   
p4age :   
p4phone :

GreyHead 19 Aug, 2010

Hi LanceAlx,

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

This topic is locked and no more replies can be posted.