Forums

Hey guys,

Quick question - I am working on a site for a client and its using 2 Chrono forms. Both are set up (as far as I can tell) with the methods show in the video tutorial. The only problem is that both forms are only emailing the data, not writing it to the tables in the database. Is there something I missed in setting it up?

Thanks,

Slade

Hi Slade,

You have to set up data saving by clicking the 'Create Data Table' link in the Forms Manager.

Bob

Hey Bob,

Thanks for the quick response. I have the tables set up (Create Data Table link) to capture the data, but when I enter in some sample data via the form, it will email me the data as it should, but when I go back into the forms management tab and select the form and then click "view data" it doesn't have any data to view.

Any thoughts?

Thanks

Slade

Hi Slade,

There are two possibilities here.

First, that there's some kind of problem with the data you are trying to save, to check this I echo out the SQL statement and test it in PHPMyAdmin to see if there is a MySQL error message.

Second, if you are using a Redirect URL there is a bug in some recent versions of chroncontact .php that throws the saving out.

Probably the best first diagnosis is to look at what output you get with DeBug on (please temporarily remove any Redirect URL first).

Bob

Hey Bob,

Thanks for the reply. I am going to send you a message with the form results from the debug. That portion looks like its functioning properly.

I am not clear on how to echo the SQL statement, so any guidance on that would be helpful.

Thanks again,

Slade

Hi Slade,

Just emailed you - your form works fine on my test site :-( I've sent you some debug code to try in the Autogenerated tab.

Bob

Same to me.
If i use a redirection link, the data won't stored.
Without, everything works perfectly!
How can i fix this, i need a confirmation page!!

BTW, i'm using the latest version.

Hi ifritz,

There's a bug in some versions of chronocontact.php - please replace it with the version in the attached file which I've copied over from another thread.

Bob

Thank you very much for that. It works!!!!!!!