# Form submission results showing different data than what was entered **URL:** \ **Category:** Product Support\ **Created:** [April 5, 2018, 1:45pm UTC](https://forum.mautic.org/t/form-submission-results-showing-different-data-than-what-was-entered/10402 "2018-04-05T13:45:59Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![bob-herman](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/bob-herman/32/288_2.png) [@bob-herman](https://forum.mautic.org/u/bob-herman)\ **Post date:** [April 5, 2018, 1:45pm UTC](https://forum.mautic.org/t/form-submission-results-showing-different-data-than-what-was-entered/10402/1 "2018-04-05T13:45:59Z")
I’m testing to make sure forms on web site work properly. The form submission results like first name, last name, email do not match what the user entered. If I view the contact, the data does in fact match what the user entered, i.e. the data stored w/the contact is correct but the form results show different data. I’m testing from my own machine so perhaps something to do w/tracking, and I’m using a WordPress site w/Contact Form 7 and CF7 Mautic plugin to integrate forms. The form data shown doesn’t match any previous contact, i.e. I’ll enter bobtest20 as first name on site but form results will show bobtest9 and contact is correct w/bobtest20. Any ideas? Thank you! Bob H. ---
**Author:** ![bob-herman](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/bob-herman/32/288_2.png) [@bob-herman](https://forum.mautic.org/u/bob-herman)\ **Post date:** [April 5, 2018, 11:43pm UTC](https://forum.mautic.org/t/form-submission-results-showing-different-data-than-what-was-entered/10402/2 "2018-04-05T23:43:11Z")
Hi @mxyzptlkfishstix : Thanks for your help. I tried from another computer, clearing the cache first, but same issue. Maybe related to the CF7 Mautic plugin? But since the contact is added to Mautic w/correct data I wouldn’t think so. Only the form shows incorrect data for the submission, which is quite a big issue since form actions like adding points, adding to segment, etc. are not applying to the correct contact. Funny thing is, the contact shown by the form doesn’t even exist as a Contact anymore (they did prior but I deleted the old test users). Must be a table in the dB for form submissions that is separate from Contacts table, ya? On a side note, the email that I have Contact Form 7 sending out has the correctly entered data. In my Tracking cfg., I have: Identify visitors by IP: NO Identify visitor by device fingerprint: YES Identify visitor by tracking url: YES Now another issue popped up in the last day. I have a segment (broadcast) email. For the past few weeks, when adding contacts to the segment, the email would update w/the new contacts so I could send the email to them. As of yesterday, it stopped updating. All the Cron jobs are running but don’t think a Cron job handles this, or does one of them? Any idea what might have caused this behavior? Thanks, Bob H. ---
**Author:** ![bob-herman](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/bob-herman/32/288_2.png) [@bob-herman](https://forum.mautic.org/u/bob-herman)\ **Post date:** [April 6, 2018, 9:46pm UTC](https://forum.mautic.org/t/form-submission-results-showing-different-data-than-what-was-entered/10402/3 "2018-04-06T21:46:51Z")
I cloned the form and re-cfg. the CF7 Mautic plugin to use the new form and it’s working as expected. I guess we can consider this issue resolved but scary, no idea what caused the orig. form to have a mind of its’ own when recording submitted data. ---
**Author:** ![bob-herman](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/bob-herman/32/288_2.png) [@bob-herman](https://forum.mautic.org/u/bob-herman)\ **Post date:** [April 7, 2018, 11:23am UTC](https://forum.mautic.org/t/form-submission-results-showing-different-data-than-what-was-entered/10402/4 "2018-04-07T11:23:44Z")
Got it, thanks. If it happens again, I’ll try clearing the WordPress cache as a troubleshooting step. I had tried clearing the Mautic cache but that didn’t solve it. ---
**Author:** ![nestor](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/nestor/32/328_2.png) [@nestor](https://forum.mautic.org/u/nestor)\ **Post date:** [May 30, 2018, 11:20pm UTC](https://forum.mautic.org/t/form-submission-results-showing-different-data-than-what-was-entered/10402/5 "2018-05-30T23:20:23Z")
I also had this issue, and here is what I found and how I solved: - Al those users that appear in the form, are users that you tried before and then you delete. - When you delete a User in the form in mautic, its not deleted from the database, you can see by looking the table of that form, something like prfix\_form\_results\_1\_name\_of\_form - If you check the logs of mautic in app/log, you will probably found something like: mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\UniqueConstraintViolationException: “An exception occurred while executing ‘INSERT INTO mkt\_form\_results\_1\_ecommerce (referralname, referralemail, referralposttitle, referralreferrer, submission\_id, form\_id) VALUES (?, ?, ?, ?, ?, ?)’ with params [data removed]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘1’ for key ‘PRIMARY’” at /public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 66 {“exception”:"[object] Which as far as I understand is teling that is trying to save the user but there is already a entry “1” How I solved? Truncate the table of the form, and stop deleting the users created for tests (Warning: when you truncate the table of the form it will delete all the users/contacts of that form). So my question is: Is there a bug in Mautic that doesn`t delete the contacts of the form in the database when is deleted from the admin panel? ---
**Author:** ![bizcrony](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/bizcrony/32/409_2.png) [@bizcrony](https://forum.mautic.org/u/bizcrony)\ **Post date:** [May 31, 2018, 7:05am UTC](https://forum.mautic.org/t/form-submission-results-showing-different-data-than-what-was-entered/10402/6 "2018-05-31T07:05:02Z")
@Nestor what PHp Version ? ---
**Author:** ![nestor](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/nestor/32/328_2.png) [@nestor](https://forum.mautic.org/u/nestor)\ **Post date:** [May 31, 2018, 10:09am UTC](https://forum.mautic.org/t/form-submission-results-showing-different-data-than-what-was-entered/10402/7 "2018-05-31T10:09:15Z")
Hi @bizcrony, The PHP version is: PHP Version 7.1.17-1+0 (hosted at Cloudways) ---
**Author:** ![bizcrony](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/bizcrony/32/409_2.png) [@bizcrony](https://forum.mautic.org/u/bizcrony)\ **Post date:** [May 31, 2018, 10:12am UTC](https://forum.mautic.org/t/form-submission-results-showing-different-data-than-what-was-entered/10402/8 "2018-05-31T10:12:48Z")
Downgrade the PHP to 7 not 7.1 ---
**Author:** ![nestor](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/nestor/32/328_2.png) [@nestor](https://forum.mautic.org/u/nestor)\ **Post date:** [May 31, 2018, 10:29am UTC](https://forum.mautic.org/t/form-submission-results-showing-different-data-than-what-was-entered/10402/9 "2018-05-31T10:29:39Z")
Just tried with PHP 7.0 and that doesn`t solve the issue, if you delete a user from a form in the Mautic panel, it will remain in the table of that form. ---
**Author:** ![bizcrony](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/bizcrony/32/409_2.png) [@bizcrony](https://forum.mautic.org/u/bizcrony)\ **Post date:** [May 31, 2018, 10:34am UTC](https://forum.mautic.org/t/form-submission-results-showing-different-data-than-what-was-entered/10402/10 "2018-05-31T10:34:48Z")
Oh this is an cache issue, delete cache and update schema ---
**Author:** ![nestor](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/nestor/32/328_2.png) [@nestor](https://forum.mautic.org/u/nestor)\ **Post date:** [May 31, 2018, 10:58am UTC](https://forum.mautic.org/t/form-submission-results-showing-different-data-than-what-was-entered/10402/11 "2018-05-31T10:58:58Z")
It was a new Mautic setup (so no cache issue) But I will just leave it at that, hopefully someone at the Mautic Dev team will find this. Thanks! ---
**Author:** ![bizcrony](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/bizcrony/32/409_2.png) [@bizcrony](https://forum.mautic.org/u/bizcrony)\ **Post date:** [May 31, 2018, 11:00am UTC](https://forum.mautic.org/t/form-submission-results-showing-different-data-than-what-was-entered/10402/12 "2018-05-31T11:00:26Z")
Hope So