Form Not Posting to Database

commitmenttitle 22 Feb, 2010
Hi, I'm trying to use the DB connection feature, but the table never gets populated. Here's what I did:

1) Created the form
2) Used the "Create Table" button and and created the DB table, checking each of the columns (I want them all to be stored in the record)
3) Published the form

Filling out the form works fine, but when I look at the table, either directly with SQL queries or using the GUI provided with ChronoForms, it is empty. What am I doing wrong? The table name is valid (jos_chronoforms_Closing_Log) and I receive no errors, just no data either.
GreyHead 22 Feb, 2010
Hi commitmenttitle,

Have you enabled the DB Connection on the DB Connection tab?

Bob
commitmenttitle 22 Feb, 2010

Hi commitmenttitle,

Have you enabled the DB Connection on the DB Connection tab?

Bob



Yes. Data storage is enabled and the correct table is selected.
commitmenttitle 22 Feb, 2010
It seems to work now. All I changed was adding an email container (there were none before) and changing the option to post to the database to after the email instead of before it.

Why would that make it work?
GreyHead 22 Feb, 2010
Hi commitmenttitle.

At some point the DB Connection had switched from the default 'After Email' to 'Before Email'. From a quirk of history ChronoForms doesn't execute the Before Email actions unless Email is enabled on the form General tab.

Bob
commitmenttitle 24 Feb, 2010

Hi commitmenttitle.

At some point the DB Connection had switched from the default 'After Email' to 'Before Email'. From a quirk of history ChronoForms doesn't execute the Before Email actions unless Email is enabled on the form General tab.

Bob



Oh, ok. So if I don't want to use an email at all, I should just leave it on "after email"?
GreyHead 24 Feb, 2010
Hi commitmenttitle,

Yes.

Bob
This topic is locked and no more replies can be posted.