Form not working please fix it asap

Hi @noorjan77,

Hope this message finds you well, and sorry to hear you are experiencing this issue.

Since you downgraded the version we are unable to reproduce the issue.

– Can you provide a temporal site where you can update Forminator to the latest version and create a test form we can use for testing? We need to check the error.
– Are the forms the same for all your sites?
– Could you share the exact error you are getting?

Please let us know those in your next reply.

Best regards,
Laura

hii have upgraded the forminator to the latest on this site.https://securitytrainingsolutionsltd.co.uk/find-us/. And I get this error code. An error occurred while processing the form. Please try again

`Hi @noorjan77

Thank you for response!

I tested the form and I noticed the actual error behind the issue but I must admit I’m quite surprised that it’s not happening in 1.28 version of the plugin.

The error is a DB error and states that there’s a “duplicate entry” for the “primary” DB column in “wp_frmt_form_entry” table. This table is where Forminator stores basic submission data and its “primary” column is the “entry_id” one.

“Primary” also means unique. It’s a number and should never repeat, instead it should automatically increment upon each DB insert and that increment is performed by the DB engine itself.

The most common reasons for such error are:

1. The field does not have “AUTO_INCREMENT” option set in the database for some reason
2. there is some kind of custom code added to site (that is supposed to hook to Forminator code in some way) that attempts to override that entry_id.

That being said, please try this:

1. if you have any custom code meant to change how Forminator forms are working active – temporarily disable/remove it and see if that solves the issue

2. if it doesn’t or you don’t have such code

– access site’s DB using phpMyAdmin
– find the “wp_frmt_form_entry” table and select it
– switch to “Structure” tab to see DB structure
– and check if the “entry_id” has AUTO_INREMENT set; it should look like this (note: red rectangles and arrow are added by me to point out important information)

https://app.screencast.com/ymHkCYxp7jDsi

If there’s no AUTO_INREMENT there, edit that field, check the checkbox for A_I (AUTO_INCREMENT) option and save changes.

Note: I’d strongly suggest taking full backup first, just to stay on the safe side. If you don’t feel comfortable editing DB, your host support should be able to help you with that.

Kind regards,
Adam

Hello @noorjan77,

I hope the above suggestions helped.

As we haven’t heard from you for a while, we’re marking this thread as resolved.

Please don’t hesitate to let us know if you still have any questions!

Best Regards,
Dmytro

i tried it it gives error message.

 Query error:
#1062 – ALTER TABLE causes auto_increment resequencing, resulting in duplicate entry ‘1’ for key ‘PRIMARY’

ALTER TABLE wp_frmt_form_entry CHANGE entry_id entry_id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'AUTO_INCREMENT';

Hi @noorjan77

The mentioned error you have shared is generic. It points that there is already an entry with the value?1?in the?entry_id?column, and the query is somehow leading to an attempt to create another entry or re-sequence the?AUTO_INCREMENT?values in a way that would create a duplicate.

Could you please share a screenshot of the table structure of wp_frmt_form_entry? You should find that under the “Structure” tab:

View post on imgur.com

Also please do share the form export so that we could also check the form settings. Please check the following doc on how to export a form:

https://wpmudev.com/docs/wpmu-dev-plugins/forminator/#import-export

If you are concerned about any sensitive information in the form, then you can duplicate your form, remove any sensitive information, and then export it.

You can share the export file via Google Drive, Dropbox or any cloud service in the next reply.

Looking forward to your response.

Best Regards,

Nithin

hi there thanks for the quick reply. Here is the link for Google drive. https://drive.google.com/drive/folders/1HTsPvhEx8o2ExHpc67ZPjCcMluqIhU2u

this form was working fine but after migration to another hosting this happened. When form submitted it still goes but on the front it shows error. Also on the backend forminator submission nothing shows. I really appreciate your help and before I go I want to tell you this website have 4 forms same thing happens with all the forms. Thanks

Hi @noorjan77,

To investigate the issue further, I imported the form to a test website. However, I was unable to replicate the issue, the form submission works fine on my test website with the export that you have shared.

Since this issue seems specific to your website, could you please try reinstalling Forminator and see if that resolves the problem? Additionally, try importing the form onto your website to check if the issue persists with the imported form.

Please update us here with the results so that we can help you further.

Kind Regards,
Nebu John