Forums

Intermittent NULL entries in Database and no Email sent to Admin

hsmith 07 Nov, 2019
We are seeing intermittent NULL entries when the data are saved to the database and log file. Customers seem to get a blank copy of the submission email in this event. However, no email is sent to admin and we are not able to respond to the customer:



I have a single page form with AJAX, server validations and check security fields options selected on settings tab.:


Since the server validations and security fields options are set to on, i do not have any events set up to check captcha or validate fields:




Once the form is submitted, data are saved, emails sent to admin and customer, and thank you page is displayed. I see nothing interesting in the debugger and cannot replicate the issue by submitting to the form myself. From the screenshots above, am i missing something in the setup that would be causing this issue?

Thanks,
Holden
GreyHead 10 Nov, 2019
Hi Holden,

I wonder if you need an action to check the Serverside validation?

Bob
hsmith 10 Nov, 2019
Hi Bob,

I tried adding a serverside validation action, but I have gotten the same results over the past 2 days.



I'm wondering if there is an issue with upgrading from chronoforms 5 to 6? The form was originally developed in 5, and the component was upgrading about 6 months ago (start of the issue). The form was unchanged during the upgrade. Do you see any value added by recreating the form from scratch?

Thanks,
Holden
GreyHead 12 Nov, 2019
Hi Holden,

It may be simpler to rebuild in v6 rather than pin down exactly where the current bug is :-(

Bob
hsmith 14 Nov, 2019
Hi Bob,

I've recreated the form from scratch in 6.1. However, i just received the first blank entry in 24 hours.

Here a the current settings:



and actions setup:



I'm very confused on why this would occur. Again, i'm unable to recreate the issue myself, so it's either a configuration in the form, browser incompatibility or something I'm missing??? Any T/S suggestions would be greatly appreciated. I can also provide backend if that helps.

Holden
hsmith 14 Nov, 2019
I'm beginning to wonder if there's something going on with the "auto" settings. I added a validation step (should be redundant), but still receiving blank emails.



How is this possible? I was under the assumption that the actions were read from top to bottom. I.e., if failed the validation step, then it would would not write to DB or send email? Seems like it skipped the DB write and went right to the email. Is there something wrong with my setup?
healyhatman 15 Nov, 2019
Turn off the auto settings and see what happens.
hsmith 18 Nov, 2019
I turned off the auto server validation setting. However, i'm still receiving the occasional blank email.







Any thoughts about why I'm still getting blank emails? The event loaders should stop processing if any of them return a false. If it were a bot, it would have to get past the recaptcha check AND the server validation step, before the data are written to the DB and emails sent out.
healyhatman 19 Nov, 2019
Very strange. You have log data turned on, what does the log data table look like? Is it also empty on those entries?
hsmith 19 Nov, 2019
It's showing blank entries in the log table as well with only IP address and creation date filled in.

I can provide backend or more screenshots if you would like to take a look.
hsmith 27 Nov, 2019
We are still getting blank admin emails and log/database entries. These events occur a couple times a day < 1%. I still don't see what would be causing this.

Any thoughts?
healyhatman 28 Nov, 2019
Send me access details and I'll have a look to make sure you've set it up correctly.
hsmith 03 Dec, 2019
what's the best email to send backend info to? kamron@skyspider.com.au?
hsmith 04 Dec, 2019
sent via PM. Thanks!
healyhatman 04 Dec, 2019
Answer
Solved it. Because you didn't have Follow Page Order turned on, it didn't know where to get the validation rules from.

It should be fine now, you can test by navigating directly to yoursite.com/formlink?event=submit
hsmith 04 Dec, 2019
Thank you! I thought that this option was unnecessary since it's only a single page form. I will continue to test/monitor over the next week.
This topic is locked and no more replies can be posted.