Forums

Since yesterday I have had a form (just this single form, other forms are working fine) result in a page not found error 1062 or 23000 when DB Save is added to my submit area. When I disable it, the form submits, when I enable it the page will not load.

This just began happening yesterday, perhaps after the 5.0.14 update. I do have a nocaptcha loaded and checked, but I've rebuilt this entire form twice now, and it seems to be the DB Save. It is in the same site database, not an external one.

Within submit, I also have an email element, and that does work, but the message and page does not load, it rather goes to a site error page. All the DB Save options are default, I've only chosen the table name.

Thanks for any help.

Hi jmeidal,

The Error code suggests that there is a Duplicate record being found. This can happen if you have a value for ID set in the form data - perhaps from an article ID. If that is happening then you need to unset the ID value before the DB Save.

Bob

Yes, I do see there is a DB record conflict. If I remove the data from the DB table the form will save the data one time, before the error reoccurs.

But how do I clear the ID permanently? I assume in the Update Conditions field or custom code?

Thanks for that link. I did test the unset of "id" which still did not seem to work.

It was solved when I removed the table I had made in MySQL and created it automatically within ChronoForms. Multiple entries now submit and save fine.