Error when connected to DB

I am having a problem, and I notice that it only happens when the form is connected to the database.

URL: https://www.puahonline.org/auction-purchase-page

This is the Error:

Parse error: syntax error, unexpected '$', expecting T_VARIABLE in /home/puahonli/public_html/components/com_chronocontact/chronocontact.php(53) : eval()'d code on line 14
Thank you!!
Your donations help make all the difference. You will receive confirmation shortly.

Fatal error: Call to a member function bind() on a non-object in /home/puahonli/public_html/components/com_chronocontact/libraries/customcode.php(71) : eval()'d code on line 13

This is my code:

<div class="form_item">
  <div class="form_element cf_heading">
    <h3 class="cf_text">Auction Packages</h3>
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_heading">
    <h4 class="cf_text">Please tell us how many of each you would like</h4>
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 250px;">Buy 50 Ladies package- includes Chanel bag, sunglasses, $101 Gift Certificate to Chuckies & $180 to Esti's</label>
    <input class="cf_inputbox" maxlength="150" size="5" title="" id="text_2" name="a50ladies" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 250px;">Buy $35 Apple iPad & Vivitar Itwist 925 DVR digital camera</label>
    <input class="cf_inputbox" maxlength="150" size="5" title="" id="text_3" name="a35ipad" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 250px;">Buy $35 Jewelry- Choice of magnificent jewelry from Aqua Jewels</label>
    <input class="cf_inputbox" maxlength="150" size="5" title="" id="text_4" name="a35jewelry" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 250px;">Buy $35 Canvas Artwork by Nicole Cohen</label>
    <input class="cf_inputbox" maxlength="150" size="5" title="" id="text_5" name="a35canvas" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 250px;">Buy $20 Baby package- $500 Gift Certificate to Dimples Baby</label>
    <input class="cf_inputbox" maxlength="150" size="5" title="" id="text_6" name="a20baby" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 250px;">Buy $20 Home package- includes 2 picture frames from Silver Spoons, $300 gift certificate to Textures</label>
    <input class="cf_inputbox" maxlength="150" size="5" title="" id="text_7" name="20home" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 250px;">Buy $10 Spa package: includes massage, facial, manicure, pedicure, robe & slippers </label>
    <input class="cf_inputbox" maxlength="150" size="5" title="" id="text_8" name="a10spa" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 250px;">Buy $10 Split the Pot</label>
    <input class="cf_inputbox" maxlength="150" size="5" title="" id="text_9" name="a10split" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 250px;">Buy $50 >>>> $65 worth of coupons</label>
    <input class="cf_inputbox" maxlength="150" size="5" title="" id="text_10" name="a50-65worth" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 250px;">Buy $100 >>>>> $150 </label>
    <input class="cf_inputbox" maxlength="150" size="5" title="" id="text_11" name="a100-150worth" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 250px;">Buy $200 >>>>> $300 </label>
    <input class="cf_inputbox" maxlength="150" size="5" title="" id="text_12" name="a200-300worth" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 250px;">Buy $300 >>>>> $450</label>
    <input class="cf_inputbox" maxlength="150" size="5" title="" id="text_13" name="a300-450worth" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 250px;">Buy $500 >>>>> $700</label>
    <input class="cf_inputbox" maxlength="150" size="5" title="" id="text_14" name="a500-700worth" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 250px;">Buy $1000 >>>>> $1500</label>
    <input class="cf_inputbox" maxlength="150" size="5" title="" id="text_15" name="a1000-1500worth" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_heading">
    <h3 class="cf_text">Your Information</h3>
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px;">Name</label>
    <input class="cf_inputbox required" maxlength="150" size="30" title="" id="text_21" name="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;">Address</label>
    <input class="cf_inputbox required" maxlength="150" size="30" title="" id="text_22" name="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_23" 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_24" 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</label>
    <input class="cf_inputbox required" maxlength="150" size="30" title="" id="text_25" name="zip" 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;">Telephone</label>
    <input class="cf_inputbox required" maxlength="150" size="30" title="" id="text_24" name="telephone" 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</label>
    <input class="cf_inputbox required validate-email" maxlength="150" size="30" title="" id="text_25" name="email" 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;">Credit Card</label>
    <input class="cf_inputbox required" maxlength="150" size="30" title="" id="text_26" name="credit_card" 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;">Exp. Month</label>
    <input class="cf_inputbox required" maxlength="150" size="30" title="" id="text_27" name="exp_month" 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;">Exp. Year</label>
    <input class="cf_inputbox required" maxlength="150" size="30" title="" id="text_28" name="exp_year" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_checkbox">
    <label class="cf_label" style="display: none;">Journal Contract</label>
    <div class="float_left">
      <input value="We here by authorize you to charge our credit card in accordance with what we have selected here, based on the rates listed above." title="" class="radio validate-one-required" id="check00" name="check0[]" type="checkbox" />
      <label for="check00" class="check_label">We here by authorize you to charge our credit card in accordance with what we have selected here, based on the rates listed above.</label>
      <br />
      

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

<div class="form_item">
  <div class="form_element cf_button">
    <input value="Submit" name="button_3" type="submit" />
  </div>
  <div class="cfclear"> </div>
</div>

Your help is so greatly appreciated!

Hi Joomlawhiz,

You have at least one input name starting with a number name="20home". This is not allowed - names must begin with a letter -- this is probably what is breaking the database save.

Bob

Hi Bob,

I thought that might be the problem, which is why started adding the "a" in front of each of them. I missed that "20home". This has been updated ("a20home"), but the form is still not working. Here again is my code. Please have a look to see if anything else looks weird.

<div class="form_item">
  <div class="form_element cf_heading">
    <h3 class="cf_text">Auction Packages</h3>
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_heading">
    <h4 class="cf_text">Please tell us how many of each you would like</h4>
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 250px;">Buy 50 Ladies package- includes Chanel bag, sunglasses, $101 Gift Certificate to Chuckies & $180 to Esti's</label>
    <input class="cf_inputbox" maxlength="150" size="5" title="" id="text_2" name="a50ladies" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 250px;">Buy $35 Apple iPad & Vivitar Itwist 925 DVR digital camera</label>
    <input class="cf_inputbox" maxlength="150" size="5" title="" id="text_3" name="a35ipad" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 250px;">Buy $35 Jewelry- Choice of magnificent jewelry from Aqua Jewels</label>
    <input class="cf_inputbox" maxlength="150" size="5" title="" id="text_4" name="a35jewelry" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 250px;">Buy $35 Canvas Artwork by Nicole Cohen</label>
    <input class="cf_inputbox" maxlength="150" size="5" title="" id="text_5" name="a35canvas" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 250px;">Buy $20 Baby package- $500 Gift Certificate to Dimples Baby</label>
    <input class="cf_inputbox" maxlength="150" size="5" title="" id="text_6" name="a20baby" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 250px;">Buy $20 Home package- includes 2 picture frames from Silver Spoons, $300 gift certificate to Textures</label>
    <input class="cf_inputbox" maxlength="150" size="5" title="" id="text_7" name="a20home" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 250px;">Buy $10 Spa package: includes massage, facial, manicure, pedicure, robe & slippers </label>
    <input class="cf_inputbox" maxlength="150" size="5" title="" id="text_8" name="a10spa" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 250px;">Buy $10 Split the Pot</label>
    <input class="cf_inputbox" maxlength="150" size="5" title="" id="text_9" name="a10split" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 250px;">Buy $50 >>>> $65 worth of coupons</label>
    <input class="cf_inputbox" maxlength="150" size="5" title="" id="text_10" name="a50-65worth" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 250px;">Buy $100 >>>>> $150 </label>
    <input class="cf_inputbox" maxlength="150" size="5" title="" id="text_11" name="a100-150worth" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 250px;">Buy $200 >>>>> $300 </label>
    <input class="cf_inputbox" maxlength="150" size="5" title="" id="text_12" name="a200-300worth" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 250px;">Buy $300 >>>>> $450</label>
    <input class="cf_inputbox" maxlength="150" size="5" title="" id="text_13" name="a300-450worth" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 250px;">Buy $500 >>>>> $700</label>
    <input class="cf_inputbox" maxlength="150" size="5" title="" id="text_14" name="a500-700worth" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 250px;">Buy $1000 >>>>> $1500</label>
    <input class="cf_inputbox" maxlength="150" size="5" title="" id="text_15" name="a1000-1500worth" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_heading">
    <h3 class="cf_text">Your Information</h3>
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px;">Name</label>
    <input class="cf_inputbox required" maxlength="150" size="30" title="" id="text_21" name="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;">Address</label>
    <input class="cf_inputbox required" maxlength="150" size="30" title="" id="text_22" name="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_23" 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_24" 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</label>
    <input class="cf_inputbox required" maxlength="150" size="30" title="" id="text_25" name="zip" 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;">Telephone</label>
    <input class="cf_inputbox required" maxlength="150" size="30" title="" id="text_24" name="telephone" 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</label>
    <input class="cf_inputbox required validate-email" maxlength="150" size="30" title="" id="text_25" name="email" 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;">Credit Card</label>
    <input class="cf_inputbox required" maxlength="150" size="30" title="" id="text_26" name="credit_card" 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;">Exp. Month</label>
    <input class="cf_inputbox required" maxlength="150" size="30" title="" id="text_27" name="exp_month" 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;">Exp. Year</label>
    <input class="cf_inputbox required" maxlength="150" size="30" title="" id="text_28" name="exp_year" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_checkbox">
    <label class="cf_label" style="display: none;">Journal Contract</label>
    <div class="float_left">
      <input value="We here by authorize you to charge our credit card in accordance with what we have selected here, based on the rates listed above." title="" class="radio validate-one-required" id="check00" name="check0[]" type="checkbox" />
      <label for="check00" class="check_label">We here by authorize you to charge our credit card in accordance with what we have selected here, based on the rates listed above.</label>
      <br />
      

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

<div class="form_item">
  <div class="form_element cf_button">
    <input value="Submit" name="button_3" type="submit" />
  </div>
  <div class="cfclear"> </div>
</div>

Thank you so much!

Hi joomlawhiz,

Have you also changed the column name in the databse table to match? And refreshed the DB Connection (see below)?

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.

Hi Bob,

I tried disconnecting and reconnecting as you suggested. I also made some changes to the text of the form, trying to do away with excess punctuation. I noticed that the error I am getting is different.

New error:


Parse error: syntax error, unexpected '-', expecting ',' or ';' in /home/puahonli/public_html/components/com_chronocontact/chronocontact.php(53) : eval()'d code on line 17
Thank you!!
Your donations help make all the difference. You will receive confirmation shortly.

Fatal error: Call to a member function bind() on a non-object in /home/puahonli/public_html/components/com_chronocontact/libraries/customcode.php(71) : eval()'d code on line 13

I don't know if that makes a difference, but I figured it might. Let me know what you think. Again, thanks for your help!

Hi joomlawhiz ,

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