Forums

no information in the database

rtttt 01 Nov, 2010
good evening,
I just install and configure Chrono Forms, everything works
well unless I send the information I do not find them in the database??

thank you
GreyHead 01 Nov, 2010
Hi rtttt ,

Do you have a DB Connection set up?

Bob
rtttt 01 Nov, 2010
oui,
GreyHead 01 Nov, 2010
Hi rttt,

And nothing saves in the database at all?

Do the input names in your form match the column names in the database?

Do any of your input names contain a space, dash, or some other special character like è ü ò, etc?

Bob
GreyHead 02 Nov, 2010
Hi rtttt,

Please turn debug on in the form General Tab, then submit the form and post the debug - including the 'dummy emails' results here.

Bob
rtttt 02 Nov, 2010
hello🙂 ,

GreyHead 02 Nov, 2010
Hi rttt,

The input names from the Form are text_1, text_2 and text_3; these don't match the column names in the database table and so won't be saved.

Bob
rtttt 02 Nov, 2010
Hello,
I have the same names but nothing has changed,
here's what I did:
download and installation Chrono Forms =>Form wizard =>
create form =>create table => Publish

Thank you
GreyHead 02 Nov, 2010
Hi rttt,

The same names as what exactly?

Your PHP MyAdmin image clearly shows different column names from the input names shown in the DeBug info (see the $_POST array entry).

Bob
rtttt 02 Nov, 2010
Hello,
yes I changed
in dummy email: {Nom}, {Email}, {commentaire}
in PHP MyAdmin: Nom, Email, commentaire
but nothing has changed.
in my email I received information correctly:


Thank you
GreyHead 02 Nov, 2010
Hi rtttt,

But the email template image you posted shows
Nom:
{text_1}
Email:
{text_2}
Commentaire:
{text_3}


Please read my posts again.

Bob
rtttt 02 Nov, 2010
Hello,
yes it's true before it was:
Nom:
{text_1}
Email:
{text_2}
Commentaire:
{text_3}

but I changed to:
Nom:
{Nom}
Email:
{Email}
Commentaire:
{commentaire}


Thank you
GreyHead 02 Nov, 2010
Hi rtttt,

Hard to help you if the information you post here is incorrect or out of date :-(

If you've also changed the column names then you'll need to refresh 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.
This topic is locked and no more replies can be posted.