Hi,
I've a big problem with ChronoForms_V3.1_RC5.5.
the form was used for a lotery game during 13 days. The fields required were name, firstname, adress, email.
It worked fine, but at some moments, names haven't been recorded (the field was required, and tested online - the validation alert (field in red) was working)
from day 3 to day 6 on 13, many many fieldname are empty (others in the same period are ok)
Only email , birthdate (which was not required)are written in the database (PhpMyadmin source)😲
after and before, it is ok. I haven't modify anything in the form or on the website during the game.
What should have been the problem ? Is there a way to recover the "erased" names ?
thanks for your help. it's an important lotery, we have more than 9000 gamers
Hi Repitol,
There's no bug here that I'm aware of.
ChronoForms records what it receives. So somewhere down the line the data isn't being received. Clearly something changed around Day 6 but impossible to say what that is from here.
If data is that critical then it may be worth adding server-side validation as well as the browser validation.
Please post a link to the form so we can take a quick look.
Bob
Thanks for your reply, Bob.
unfortunately, the direct access link can be posted only in Private Message due to to the end of the game online.
I've registred 2283 error lines (form without name or adress) on a total of 13639.
Many are due to email adress with numbers in (ex. myadress022@myserver.com)
others to multiple "neighbour" consons (ex. myadressxlb@myserver.com)
but on the first days as for the next days, the problem does'nt appear anymore. so... 🤨
regards,
repitol
Hi repitol,
Please take a Form Backup using the icon in the Forms Manager and post it here (as a zipped file) or PM or email it to me and I'll take a closer look. That's easier than poking around the live form.
Bob
Yep,
I send it by PM
Thanks a lot.
Hi Repitol,
I created a table and ran a few tests and everything appears to be OK. Both the 'problem' emails you quoted save all the entered fields OK.
Bob
Hi Bob,
thanks for the tests. I've received all of them.
I cannot explain what is the problem with the DB. How forms could have been recorded with missing required forms.
Thought it was due to special characters in mail adress, but many other forms have these characters without any problems.
see screenshot of the DB, how empty fields are recorded from time to time. Maybe spamming ? I Don't think that's the case for all of them (in a day 56 consecutive records are empty)
Well, that's a mistery... a corrupted db is the best explanation. 🙄
thanks
Hi Repitol,
Hmm . . . if the emails have that pattern of including numbers and random consonant strings then it could well be spam (many of the spammers in the forums here have emails like maryjo1456@. . .) They may be hitting the form without JavaScript and so by-passing the validation. Adding a server-side check would block them better.
Bob
Hi Bob,
you're right. It was spams. I created a new Chronoform page to enable every mails without namefield I received to play again.
No gamers send the new form.
It's important to add captcha to the form. I made a mistake ignoring that possibility.
Thanks again for the time you spent on my "false" problem. Hope it will help other users.
