https://legacy.forums.gravityhelp.com/topic/errors-upgrading-to-16 Gravity Support Forums Topic: Errors Upgrading to 1.6 en-US Sun, 10 May 2026 22:33:45 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/errors-upgrading-to-16#post-39948 Thu, 03 Nov 2011 15:30:29 +0000 Alex Cancado 39948@https://legacy.forums.gravityhelp.com/ <p>Jonathan,<br /> This version of Gravity Forms tries to ensure that the wp_rg_field_detail_long and wp_rg_form_meta table has a primary key. This is to provide compatibility with other plugins such as VaultPress that requires a primary key in every table.<br /> It looks like that process didn't quite go right in your installation. This won't affect Gravity Forms, but it may create issues if you try to use VaultPress or any other plugins that require primary keys on database tables.<br /> What I would recommend is that you login to your database using phpMyAdmin and make sure you have a primary key defined in the wp_rg_field_detail_long and wp_rg_form_meta tables. If you are not comfortable doing that, I will be happy to check that out for you. Just email me at <a href="mailto:alex@rocketgenius.com">alex@rocketgenius.com</a> and send me your phpMyAdmin login. </p> https://legacy.forums.gravityhelp.com/topic/errors-upgrading-to-16#post-39847 Thu, 03 Nov 2011 09:21:20 +0000 Jonathan 39847@https://legacy.forums.gravityhelp.com/ <p>Thanks for getting back to me. I'm pretty sure the database user has the correct permissions, since I've installed a large number of plugins with no errors. In any case, how would I go about reinstalling without deleting the forms and entries already in the system?</p> <p>Thanks a lot for the help.</p> <p>Jonathan </p> https://legacy.forums.gravityhelp.com/topic/errors-upgrading-to-16#post-39790 Wed, 02 Nov 2011 22:29:42 +0000 Chris Hajer 39790@https://legacy.forums.gravityhelp.com/ <p>Sounds like the database user does not have permission to ALTER the tables. Please check the capabilities of the database user, and I would recommend reinstalling after ensuring they have the capability to perform these actions.</p> <p>If those were the only errors, things would PROBABLY still work correctly, as they were just indexes, but it's best to get things correct so you don't run into trouble down the road. </p> https://legacy.forums.gravityhelp.com/topic/errors-upgrading-to-16#post-39720 Wed, 02 Nov 2011 14:08:38 +0000 Jonathan 39720@https://legacy.forums.gravityhelp.com/ <p>Hi,</p> <p>We just upgraded to 1.6 and received the following errors from WordPress:</p> <p>WordPress database error: [Multiple primary key defined]<br /> ALTER TABLE xxxx_rg_lead_detail_long ADD PRIMARY KEY (lead_detail_id)</p> <p>WordPress database error: [Can't DROP 'lead_detail_key'; check that column/key exists]<br /> DROP INDEX lead_detail_key ON xxxx_rg_lead_detail_long</p> <p>Warning: Cannot modify header information - headers already sent by (output started at .../wp-includes/wp-db.php:941) in .../wp-includes/pluggable.php on line 934</p> <p>Is everything going to work correctly? Should we revert our database? </p> <p>Thank you.</p> <p>Jonathan </p>