https://legacy.forums.gravityhelp.com/topic/form-working-ok-but-no-entries Gravity Support Forums Topic: Form working ok, but no entries en-US Sun, 05 Apr 2026 14:57:56 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/form-working-ok-but-no-entries#post-26294 Wed, 25 May 2011 11:46:59 +0000 Carl Hancock 26294@https://legacy.forums.gravityhelp.com/ <p>The problem is as I outlined above, the database user your site is using doesn't have Alter permissions so Gravity Forms was unable to update it's database tables. </p> <p>The first thing you ou need to do is make sure the database user configured in wp-config.php is updated so it has the Alter permission, really it needs Full Permissions to your database to be safe. </p> <p>If you aren't familiar with MySQL then it is going to be more difficult. The easiest solution is to the uninstall Gravity Forms using the Uninstall option on the Settings. However, be aware this will delete ALL your Gravity Forms data. So this may not be an option for you.</p> <p>The solution to retain your data is after correcting the database users permissions, you then need to delete the rg_form_version option your WordPress options database table.</p> <p>If you need assistance with this let me know. We would only be able to assist you after you have had the database user corrected. </p> https://legacy.forums.gravityhelp.com/topic/form-working-ok-but-no-entries#post-26293 Wed, 25 May 2011 11:36:51 +0000 kt0916 26293@https://legacy.forums.gravityhelp.com/ <p>I'm having the same problems since the upgrade on the loflcon.com website--entries not being recorded. For the layperson, how do I fix this myself? </p> https://legacy.forums.gravityhelp.com/topic/form-working-ok-but-no-entries#post-26282 Wed, 25 May 2011 11:00:47 +0000 Carl Hancock 26282@https://legacy.forums.gravityhelp.com/ <p>@transom The most likely issue is the database user your WordPress site is configured to use in wp-config.php does not have full access to your database which is a major problem for WordPress, themes and plugins that need the Alter permission to make updates to existing tables. This is why this problem happened. Gravity Forms was unable to alter the lead table to add the new columns. </p> <p>You need to update the database user configured in your wp-config.php file so that it has full permissions to your database, otherwise you may run into issues like this with Gravity Forms or other plugins, themes and even WordPress in the future. </p> https://legacy.forums.gravityhelp.com/topic/form-working-ok-but-no-entries#post-26265 Wed, 25 May 2011 01:48:23 +0000 transom 26265@https://legacy.forums.gravityhelp.com/ <p>I just dealt with this same problem. Basically the lead table doesn't get 8 fields added to it during the upgrade. Following the instruction above DID NOT solve the problem so I had to modify the table by hand (which did solve the issue)</p> <p>While doing so, it seemed to be that the CREATE TABLE command is a bit "sloppy". It has been my experience that the deltaDB function is quite picky about spacing and syntax. In general, I have had to export the table structure from MySQL and use exactly that syntax to keep deltaDB happy. </p> https://legacy.forums.gravityhelp.com/topic/form-working-ok-but-no-entries#post-24152 Tue, 26 Apr 2011 11:44:57 +0000 Carl Hancock 24152@https://legacy.forums.gravityhelp.com/ <p>So everyone that encounters this issue is aware, we have narrowed down the problem on 2 user sites having this issue to a database user permission issue.</p> <p>The database user the WordPress site is configured to use in the wp-config.php does not have the ALTER permission which means when the Gravity Forms update runs it is unable to alter it's database tables to accomodate the new features/changes.</p> <p>You need to make sure the database user WordPress is using does have the ALTER permission (as well as the CREATE permission) so that it can properly execute database commands dealing with creating/editing tables.</p> <p>Once you correct the database user you then have to update a WordPress option in the wp_options table so that the Gravity Forms setup will execute again. You have to delete the rg_form_version option in the wp_options table and then deactivate and activate Gravity Forms again.</p> <p>So the issue is some users WordPress sites are using a database user that doesn't have the ALTER permission. </p> https://legacy.forums.gravityhelp.com/topic/form-working-ok-but-no-entries#post-24149 Tue, 26 Apr 2011 11:39:49 +0000 chrisrobinson 24149@https://legacy.forums.gravityhelp.com/ <p>@carlhancock I have created users for you guys to use, however the request makes me nervous. I sent my contact information via your contact us, that tells us not to use it for support requests. </p> https://legacy.forums.gravityhelp.com/topic/form-working-ok-but-no-entries#post-24103 Mon, 25 Apr 2011 17:22:31 +0000 Carl Hancock 24103@https://legacy.forums.gravityhelp.com/ <p>@chrisrobinson We are unable to replicate this issue locally and we have been waiting for ANY user to send us FTP information for a site having this issue so we can debug it, it's an upgrade issue impacting a limited number of sites. Unfortunately nobody has provided us with this information to debug it. </p> <p>If you can send us a WordPress admin login and FTP login for the site having the issue via our Contact Us form, we can take a look and debug the issue and determine the problem and correct it so you don't need to roll back or uninstall.</p> <p>We can't replicate it the only way to debug it is on a site that is experiencing the issue. So if you can provide us this information we would be glad to take a look and determine what is going on. </p> https://legacy.forums.gravityhelp.com/topic/form-working-ok-but-no-entries#post-24101 Mon, 25 Apr 2011 17:07:41 +0000 chrisrobinson 24101@https://legacy.forums.gravityhelp.com/ <p>This happened to us here as of Friday, and there are some forms that we just can't have the data disappearing on. Is there a way to roll back the update? </p> <p>And the uninstall and reinstall just means wiping out Gravity Forms, correct? What happens with all the forms made? Will they have to be remade?</p> <p>With 40+ forms that's a lot of added time and attempting to re-enter data if that's possible. </p> https://legacy.forums.gravityhelp.com/topic/form-working-ok-but-no-entries#post-21949 Tue, 29 Mar 2011 11:40:31 +0000 Carl Hancock 21949@https://legacy.forums.gravityhelp.com/ <p>@smkorby It sounds like the install didn't happen properly the first time. There is no easy to way import entries currently. You'd have to write custom code and know how to properly serialize the data. We do plan on creating an import add-on in the future, but it's not currently in development. How many entries? </p> https://legacy.forums.gravityhelp.com/topic/form-working-ok-but-no-entries#post-21948 Tue, 29 Mar 2011 11:37:48 +0000 smkorby 21948@https://legacy.forums.gravityhelp.com/ <p>Nope. Not on a windows server. I was able to get the forms working again by completely uninstalling and reinstalling Gravity Forms. </p> <p>I exported the entries before I uninstalled. Is there any way to get the entries back?</p> <p>Thanks! </p>