PLEASE NOTE: These forums are no longer utilized and are provided as an archive for informational purposes only. All support issues will be handled via email using our support ticket system. For more detailed information on this change, please see this blog post.

Older Entries being replaced by new ones

  1. jgrandea
    Member

    When two or more people are concurrently filling-out forms, the last one to hit the submit button replaces the entries of the first ones to submit. So, when there are about 10 people filling out forms and the gap in the time they submitted the form is very minimal, only 1 entry is reflected.

    The most irritating part is that the ALL counter on the upper left reflects the number of entries submitted even when you can see only one. The counter continuously adds up even after you have exported the entries and none can be seen anymore.

    The worst part is I discovered this only after going live. It was a nightmare as I kept on losing data that had been submitted already. I tested the form yes, but since I was the only one testing, everything was ok, until 5 or more people started filling out forms all at once.

    It seems that there has to be some gap in the submission in order for the entries to add up and to be reflected accurately.

    Please help.

    Am using the latest version.

    Posted 13 years ago on Friday July 30, 2010 | Permalink
  2. You are most likely running some sort of caching plugin that is doing database caching. Any plugin that does database caching that doesn't whitelist the Gravity Forms related tables can cause problems with entry submissions because it interferes with database interaction.

    I believe the latest (not older) version of W3 Total Cache's database caching is compatible with Gravity Forms as it should whitelist our database tables and never use cache for database interaction for forms.

    Check your plugins and see what caching plugins you are using.

    Posted 13 years ago on Friday July 30, 2010 | Permalink
  3. jgrandea
    Member

    That's what I thought also. I just couldn't pinpoint what the culprit was. I disabled page caching initially, but it made no difference. So I activated it back again. I was afraid that the people filling out forms might slow the site down and that they might be disappointed.

    Anyway, I deactivated database caching. What about page caching? Will it have any effect?

    What about the counter? I erased already all entries; deactivated database caching; emptied all cached pages; but the counter still read All - 186 Unread-186 even if there are no more entries. Is this natural?

    Posted 13 years ago on Friday July 30, 2010 | Permalink
  4. The counter data is stored elsewhere because it doesn't do a count of all entries each time for performance reasons. If you want to erase everything the best thing to do maybe to export your forms, use the uninstall feature in the Settings page of Gravity Forms which will completely uninstall the plugin (including data) and then re-install. Then import your forms and start again.

    I'm not aware of any problems page caching presents EXCEPT if the page caching also does any caching in the admin (which it should not). The main issue is database caching which prevent Gravity Forms from interacting with the database because database caching returns cached results... so when a form is submitted depending on the cache status it returns an entry id for an existing entry rather than a new entry id so then the form tries to write data to that existing entry id.

    Posted 13 years ago on Friday July 30, 2010 | Permalink