database row every record is 0

Hello

I am using chronoforms for a large form wich writes the results to a database wich afterwards can be downloaded as a csv file. Everything seems to be working fine, except for some rows that appear sometimes in the DB. In this rows every record except the ID is a 0. But there are questions to be answered in the form trough comoboxes were 0 is not present. So I assume the end user is doing something wich causes an error writing to the DB.

I have not been able to reproduce the error, and it seems that most of the times the form is used, it works properly and writes correct results to the database.

I hope someone has experienced this same issue and can help me out, or point me in the correct direction.

Many thanks in advance and best regards

Hi Andres,

Sounds like you may be getting empty submissions either from spam or from web-bots. I suggest that you add some simple server side validation before the DB save to block these and see if that removes the problem.

Bob

Hi Bob,

by validation you mean something like captcha? That is probably a good idea.

Anyway, the form is not reachable if you are not logged in with a certain user. Are this web bots able to reach the form anyway?

Thanks for your help

Hi Anndres,

No, not Captcha, use the Server Validation action and check a few required fields to check that they aren't empty.

Bob