Forums

ChronoForms v8 is now WordPress ready, ChronoMails is out

The JED needs volunteers!

Parse error: syntax error, unexpected '-', expecting ',' or

ya
yaksushi 10 Sep, 2010
I get this error when I set the DB to writable

Parse error: syntax error, unexpected '-', expecting ',' or ';' in /home/yakangl1/public_html/components/com_chronocontact/chronocontact.php(53) : eval()'d code on line 9

I've checked my fields and they don't start with numbers or have spaces in them any ideas?
Gr
GreyHead 10 Sep, 2010
Hi yaksushi,

You probably have a dash '-' in one of your input names. Dashes give ChronoForms and MySQL problems. Please rename the input using only [a-z], [A-Z], [0-9] or underscore '_'. No dashes, spaces or other special characters.

Bob
ya
yaksushi 10 Sep, 2010
I checked I don't see any... Any other ideas?

<div class="form_item">
  <div class="form_element cf_heading">
    <h2 class="cf_text">CKO Kayak Fishing Tournament Registration</h2>
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_heading">
    <h3 class="cf_text">Lake Cumberland</h3>
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_multiholder" style="margin-left:0px!important;">
      <label class="cf_label" style="display: none;"></label>
    <table cellspacing="0" cellpadding="0" width="95%" title="" class="multi_container">
        <tbody width="100%">
            <tr width="100%">
                <td style="width: auto; vertical-align: middle; text-align: left;">
<div class="form_item">
  <div class="form_element cf_text"> <span class="cf_text">Select what type of registration this is</span> </div>
  <div class="cfclear"> </div>
</div>
</td>
<td style="width: auto; vertical-align: middle; text-align: left;">
<div class="form_item">
  <div class="form_element cf_dropdown">
    <label class="cf_label" style="width: 150px;">Registration Type:</label>
    <select class="cf_inputbox validate-selection" id="select_42" size="1" title=""  name="Registration_Type">
    <option value="">Choose Option</option>
      <option value="Adult Registration">Adult Registration</option>
<option value="Youth Registration">Youth Registration</option>

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

            </tr>
        </tbody>
    </table>
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_multiholder" style="margin-left:0px!important;">
      <label class="cf_label" style="display: none;"></label>
    <table cellspacing="0" cellpadding="0" width="95%" title="" class="multi_container">
        <tbody width="100%">
            <tr width="100%">
                <td style="width: auto; vertical-align: middle; text-align: left;">
<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 validate-alpha" maxlength="150" size="30" title="Please enter your first name" id="text_3" name="First_Name" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>
</td>
<td style="width: auto; vertical-align: middle; text-align: left;">
<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 validate-alpha" maxlength="150" size="30" title="Please enter your last name" id="text_4" name="Last_Name" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>
</td>
<td style="width: auto; vertical-align: middle; text-align: left;">
<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px;">Suffix:</label>
    <input class="cf_inputbox" maxlength="150" size="30" title="" id="text_5" name="Suffix" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>
</td>

            </tr>
        </tbody>
    </table>
  </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="89" title="Please enter your address" id="text_6" name="Address" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_multiholder" style="margin-left:0px!important;">
      <label class="cf_label" style="display: none;"></label>
    <table cellspacing="0" cellpadding="0" width="95%" title="" class="multi_container">
        <tbody width="100%">
            <tr width="100%">
                <td style="width: auto; vertical-align: middle; text-align: left;">
<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px;">City:</label>
    <input class="cf_inputbox required validate-alpha" maxlength="150" size="30" title="Please enter your city" id="text_8" name=" City" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>
</td>
<td style="width: auto; vertical-align: middle; text-align: left;">
<div class="form_item">
  <div class="form_element cf_dropdown">
    <label class="cf_label" style="width: 150px;"> State:</label>
    <select class="cf_inputbox validate-selection" id="select_42" size="1" title=""  name="State">
    <option value="">Choose Option</option>
      <option value="Alabama">Alabama</option>
<option value="Alaska">Alaska</option>
<option value="Arizona">Arizona</option>
<option value="Arkansas">Arkansas</option>
<option value="California">California</option>
<option value="Colorado">Colorado</option>
<option value="Connecticut">Connecticut</option>
<option value="Delaware">Delaware</option>
<option value="Florida">Florida</option>
<option value="Georgia">Georgia</option>
<option value="Hawaii">Hawaii</option>
<option value="Idaho">Idaho</option>
<option value="Illinois">Illinois</option>
<option value="Indiana">Indiana</option>
<option value="Iowa">Iowa</option>
<option value="Kansas">Kansas</option>
<option value="Kentucky">Kentucky</option>
<option value="Louisiana">Louisiana</option>
<option value="Maine">Maine</option>
<option value="Maryland">Maryland</option>
<option value="Massachusetts">Massachusetts</option>
<option value="Michigan">Michigan</option>
<option value="Minnesota">Minnesota</option>
<option value="Mississippi">Mississippi</option>
<option value="Missouri">Missouri</option>
<option value="Montana">Montana</option>
<option value="Nebraska">Nebraska</option>
<option value="Nevada">Nevada</option>
<option value="New Hampshire">New Hampshire</option>
<option value="New Jersey">New Jersey</option>
<option value="New Mexico">New Mexico</option>
<option value="New York">New York</option>
<option value="North Carolina">North Carolina</option>
<option value="North Dakota">North Dakota</option>
<option value="Ohio">Ohio</option>
<option value="Oklahoma">Oklahoma</option>
<option value="Oregon">Oregon</option>
<option value="Pennsylvania">Pennsylvania</option>
<option value="Rhode Island">Rhode Island</option>
<option value="South Carolina">South Carolina</option>
<option value="South Dakota">South Dakota</option>
<option value="Tennessee">Tennessee</option>
<option value="Texas">Texas</option>
<option value="Utah">Utah</option>
<option value="Vermont">Vermont</option>
<option value="Virginia">Virginia</option>
<option value="Washington">Washington</option>
<option value="West Virginia">West Virginia</option>
<option value="Wisconsin">Wisconsin</option>
<option value="Wyoming">Wyoming</option>

    </select>
    
  </div>
  <div class="cfclear"> </div>
</div>
</td>
<td style="width: auto; vertical-align: middle; text-align: left;">
<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px;">Zip:</label>
    <input class="cf_inputbox required validate-number" maxlength="5" size="30" title="Please enter your zip code" id="text_10" name="Zip" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>
</td>

            </tr>
        </tbody>
    </table>
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_multiholder" style="margin-left:0px!important;">
      <label class="cf_label" style="display: none;"></label>
    <table cellspacing="0" cellpadding="0" width="95%" title="" class="multi_container">
        <tbody width="100%">
            <tr width="100%">
                <td style="width: auto; vertical-align: middle; text-align: left;">
<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="10" size="30" title="Please enter a valid 8 digit phone numer with out spaces or dashes ex: 5025554444" id="text_11" name="Home_Phone" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>
</td>
<td style="width: auto; vertical-align: middle; text-align: left;">
<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px;">Cell Phone:</label>
    <input class="cf_inputbox validate-number" maxlength="8" size="30" title="Please enter a valid 8 digit phone numer with out spaces or dashes ex: 5025554444" id="text_18" name="Cell_Phone" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>
</td>
<td style="width: auto; vertical-align: middle; text-align: left;">
<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px;">Email:</label>
    <input class="cf_inputbox required validate-email" maxlength="150" size="30" title="Please enter your email address " id="text_12" name="Email" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>
</td>

            </tr>
        </tbody>
    </table>
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_multiholder" style="margin-left:0px!important;">
      <label class="cf_label" style="display: none;"></label>
    <table cellspacing="0" cellpadding="0" width="95%" title="" class="multi_container">
        <tbody width="100%">
            <tr width="100%">
                <td style="width: auto; vertical-align: middle; text-align: left;">
<div class="form_item">
  <div class="form_element cf_dropdown">
    <label class="cf_label" style="width: 150px;">Gender:</label>
    <select class="cf_inputbox validate-selection" id="select_13" size="1" title=""  name="Gender">
    <option value="">Choose Option</option>
      <option value="Male">Male</option>
<option value="Female">Female</option>

    </select>
    
  </div>
  <div class="cfclear"> </div>
</div>
</td>
<td style="width: auto; vertical-align: middle; text-align: left;">
<div class="form_item">
  <div class="form_element cf_dropdown">
    <label class="cf_label" style="width: 150px;">Age Range:</label>
    <select class="cf_inputbox validate-selection" id="select_14" size="1" title=""  name="Age_Range">
    <option value="">Choose Option</option>
      <option value="12-17">12-17</option>
<option value="18-24">18-24</option>
<option value="25-34">25-34</option>
<option value="35-44">35-44</option>
<option value="45-54">45-54</option>
<option value="55-64">55-64</option>
<option value="65 & Over">65 & Over</option>

    </select>
    
  </div>
  <div class="cfclear"> </div>
</div>
</td>
<td style="width: auto; vertical-align: middle; text-align: left;">
<div class="form_item">
  <div class="form_element cf_text"> <span class="cf_text">Under 18 you must have parents or legal guardian’s signature below.</span> </div>
  <div class="cfclear"> </div>
</div>
</td>

            </tr>
        </tbody>
    </table>
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_multiholder" style="margin-left:0px!important;">
      <label class="cf_label" style="display: none;"></label>
    <table cellspacing="0" cellpadding="0" width="95%" title="" class="multi_container">
        <tbody width="100%">
            <tr width="100%">
                <td style="width: auto; vertical-align: middle; text-align: left;">
<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px;">Emergency Contact:</label>
    <input class="cf_inputbox required validate-alpha" maxlength="150" size="30" title="Please enter an emergency contact" id="text_20" name="Emergency_Contact" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>
</td>
<td style="width: auto; vertical-align: middle; text-align: left;">
<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px;">Contact Phone: </label>
    <input class="cf_inputbox required validate-digits" maxlength="10" size="30" title="Please enter a valid phone number ex: 1-555-555-5555" id="text_19" name="Contact_Phone" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>
</td>

            </tr>
        </tbody>
    </table>
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_multiholder" style="margin-left:0px!important;">
      <label class="cf_label" style="display: none;"></label>
    <table cellspacing="0" cellpadding="0" width="95%" title="" class="multi_container">
        <tbody width="100%">
            <tr width="100%">
                <td style="width: auto; vertical-align: middle; text-align: left;">
<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px;">Kayak Make:</label>
    <input class="cf_inputbox required" maxlength="150" size="30" title="Please enter your kayak make" id="text_23" name="Kayak_Make" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>
</td>
<td style="width: auto; vertical-align: middle; text-align: left;">
<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px;">Kayak Model:</label>
    <input class="cf_inputbox required" maxlength="150" size="30" title="Please enter your kayak model" id="text_24" name="Kayak_Model" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>
</td>
<td style="width: auto; vertical-align: middle; text-align: left;">
<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px;">Kayak Color:</label>
    <input class="cf_inputbox required validate-alpha" maxlength="20" size="30" title="Please enter your kayak color" id="text_22" name="Kayak_Color" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>
</td>

            </tr>
        </tbody>
    </table>
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_multiholder" style="margin-left:0px!important;">
      <label class="cf_label" style="display: none;"></label>
    <table cellspacing="0" cellpadding="0" width="95%" title="" class="multi_container">
        <tbody width="100%">
            <tr width="100%">
                <td style="width: auto; vertical-align: middle; text-align: left;">
<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px;">Camera Make:</label>
    <input class="cf_inputbox required" maxlength="20" size="30" title="Please enter your camera make" id="text_26" name="Camera_Make" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>
</td>
<td style="width: auto; vertical-align: middle; text-align: left;">
<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px;">Camera Model:</label>
    <input class="cf_inputbox required" maxlength="20" size="30" title="Please enter your camera model" id="text_27" name="Camera_Model" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>
</td>

            </tr>
        </tbody>
    </table>
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_text"> <span class="cf_text">-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------</span> </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_heading">
    <h4 class="cf_text">Participant listed above acknowledges and accepts the following: </h4>
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_text"> <span class="cf_text">1. To follow all tournament rules. Failure to do so will result in immediate disqualification. </span> </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_text"> <span class="cf_text">2. Acknowledges and fully understands that he/she will be engaging in activities that involve serious risk of injury including permanent disability and death which might result not only from his/her actions, inactions and negligence but the actions of, inactions and negligence of others or the condition of equipment used. Furthermore, there may be risks not known to Cumberland Kayaks and Outfitters and any of their sponsors or not reasonably foreseeable.</span> </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_text"> <span class="cf_text">3. Assumes the foregoing risks and accepts personal responsibility for the damages following in any injury, permanent disability or death.</span> </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_text"> <span class="cf_text">Signed________________________________________ Date___________________________ </span> </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_text"> <span class="cf_text">Parent/Guardian________________________________Date___________________________</span> </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_heading">
    <h4 class="cf_text">A copy of this from will be emailed to you, please keep it for your records.  We will have the forms for you to sign on tournament day.</h4>
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_button">
    <input value="Submit" name="button_35" type="submit" />
  </div>
  <div class="cfclear"> </div>
</div>
Gr
GreyHead 10 Sep, 2010
Hi yaksush,

There's an extrta space left in City but I didn't spot anything else from a quick scan.

Is there a dash in the form name, the database table name or any of the column names?

Bob
ya
yaksushi 11 Sep, 2010
Must have been something with the table, I deleted it and created a new one and I don't see the error anymore thanks for your help!
This topic is locked and no more replies can be posted.