Form showing entries, but no entries are there

Gravity Support Forums » Plugin Support » Gravity Forms

bghouse
Member

I was doing some testing with forms I had setup on my site, and integration with Aweber. When done, I went and deleted all my test entries and emptied the trash. Two of my forms cleaned themselves out fine - but one form still shows (2) Unread and (2) Entries - both on the form page and in the dashboard.

I've emptied trash multiple times and there is no caching on the site. Any idea why it's stuck?

Worse case, I'll go clean this up in the sql table I guess before handing off to my client, but I was a little worried that something might be wrong.

Posted 12 years ago on Saturday July 14, 2012 | Permalink
Chris Hajer
Key Master

Normally it is a caching problem. But that does not seem to be the case for you? I've never heard this problem reported before. If you're comfortable with MySQL you can certainly go in an clean up the entries and reset the autoincrements if you like. Or, you could export the forms, uninstall the plugin, delete the wp_rg_ tables (if you used wp_ for your database prefix), reinstall the plugin, and import the forms so you have a fresh start.

If caching was present at some point even if it's not active now, that could have thrown off the counts as well.

Posted 12 years ago on Sunday July 15, 2012 | Permalink
bghouse
Member

Hmm... I did have caching active at one point, maybe that's it. I really don't want to try to delete and re-install, as the site needs to go live on schedule on Monday morning.

Along the same line, is there an easy way to reset the conversion statistics to erase my testing data?

I'm not sure where in the tables this is being stored

Posted 12 years ago on Sunday July 15, 2012 | Permalink
Chris Hajer
Key Master

The caching is likely what caused the entries and entry count to get out of sync. That happened to me a long time ago when I first started with Gravity Forms.

You have a lot of discrete things you need to reset (views, view counts, submissions (for conversions.) I think it would be quicker to export the forms, delete the tables, reinstall the plugin, then reimport the forms than it would be to find an be certain all the pieces of information are reset to zero. I have not looked for where those counts are stored in a long time but if you look at the Gravity Forms (rg_) tables, it should be apparent. Worst case, it would not work, and you'd have to reinstall anyway.

Posted 12 years ago on Sunday July 15, 2012 | Permalink
bghouse
Member

Hmm... maybe that's feature that could be added - a "Reset Conversion Statistics" button. I can imagine a lot of folks do extensive testing before launching, which would throw off those statistics.

I have serious customizations going here, everything from custom functions populating drop down selectors to extensive CSS based on form numbers. So if I can't figure out how to do this in tables, it's going to be stuck this way I'm afraid.

Posted 12 years ago on Sunday July 15, 2012 | Permalink
bghouse
Member

This was actually much easier than I thought....

1.) Resetting the conversion stats. This is stored in wp_rg_form_view. You can remove these entries to reset the count to zero. No changes to an auto counter seemed to be necessary, it just started over with the next view registering as (1)

2.) For the weird entries, I had two entries still in the table for that form, but they probably were corrupted as they had NULL in most of the fields. Deleting fixed the problem.

Posted 12 years ago on Sunday July 15, 2012 | Permalink
Chris Hajer
Key Master

Glad you sorted that out, and quickly (less than 15 minutes?). Thanks for the information.

Posted 12 years ago on Sunday July 15, 2012 | Permalink

This topic has been resolved and has been closed to new replies.