Forums

I connected my form to the MySQL database using the Create Table feature. I have a Textarea text box and created a field with the same form name "message". I set the input to "Text" and nothing get inputted into that field. Everything else gets in there just fine but won't put the text from "message" in there.
Any clues?

Hi adgrocks01,

[sendfb][/sendfb]
Bob

Thanks Bob.
Here it is.
Mike

Hi Mike,

It's working fine here. I had to create a new table using the Create Table icon but the textarea info saves OK.

Please check that the table column name is just message

Bob

Bob,
That's what I did, but I switched from VARCHAR to TEXT. Is that acceptable? If it is, then that is what I did. I will test it again.
Thanks,
Mike

Hi Mike,

Either TEXT or VARCHAR should be OK.

Bob

Just tested it and again.
Here is a screen shot of the table I am creating.
does the name of the table have to match the form? I am calling it jos_chronoforms_contacts instead of jos_chronoforms_form1. Then again, it's posting all of the information except for the message.
Thanks,
Mike

Hi Mike,

Please backup your form and attach it here, or show me the dbclasses field data somehow, this is what I want to check!

Regards
Max

Max,
Look up the thread. I've already done that and Bob checked it out. He was able to get it to work, but it won't work for me.
Let me know if there is something else I can get you.
Mike

Hi Mike,

Sorry didn't see this!

I checked your form, it has reCaptcha and Email verification plugins enabled, the second one is really tricky to configure, I don't suggest testing anything while its enabled, I have edited your form HTML code to remove the PHP code with thanks message at the top, here is your form code now:

<h1>Reach Out To Us!</h1>
<p>You can reach us at <a href="mailto:info@bxxxxxxxx.com">info@baxxxxxxx.com</a> or use the simple form below.</p>
<input type="hidden" name="page" value="http://baldwin84.com/index.php?option=com_chronocontact&Itemid=50">
<fieldset>
	<label>First Name:</label><br />
	<input id="first_name" type="text" name="first_name" class="input" value="" /><br /><br />
        <label>Last Name <i>(include your maiden name if applicable)</i> :</label><br />
	<input id="last_name" type="text" name="last_name" class="input" value="" /><br /><br />
	<label>Email:</label><br />
	<input id="email" type="text" name="email" class="input" value="" /><br /><br />
	<label>Message: </label><br />

	<textarea id="message" name="message" rows="3" cols="40"></textarea>
</fieldset>
				
<fieldset id="button">
        {ReCaptcha}
        <br />	
        <input type="submit" name="submit" id="submit_btn" value="Send" />
</fieldset>

ok, so, before making any changes to your form, I tested it and the message field didn't go through, after disabling the plugins and removing the PHP code and adding the thanks message to the "onSubmit after email" box and removing the redirect URL its working fine!

my suggestion is to test step by step and get everything works fine before enabling the Email verification plugin then let me know and I will guide you how to get it working!

Regards,
Max

Ok,
So all I did was re-create the table with a different name and then re-connected it using the DB Connection tool and it worked. Something weird must have been cached. that's all I can think of.
Thanks for the quick responses and help.
Mike