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.
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.
Hi commitmenttitle,
Have you enabled the DB Connection on the DB Connection tab?
Bob
Have you enabled the DB Connection on the DB Connection tab?
Bob
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.
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?
Why would that make it work?
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
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
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"?
This topic is locked and no more replies can be posted.