https://legacy.forums.gravityhelp.com/topic/changing-form-id Gravity Support Forums Topic: Changing Form ID en-US Sun, 19 Apr 2026 23:25:35 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/changing-form-id#post-33038 Fri, 19 Aug 2011 14:50:29 +0000 vixvii 33038@https://legacy.forums.gravityhelp.com/ <p>Vayu,</p> <p>Thanks so much for this and I actually wasn't aware of this. I haven't attempted changing any IDs in the database just in case it breaks anything. My biggest problem is that I am now up to ID 18 with forms and I need to change form ID 7 to 13. So I am a bit cautious of this... For now I just replace the 7 in my code to a 13 on my live site. I am going to remove my dev site soon and copy my live site back to the dev server - hopefully without any form ID issues.</p> <p>But say I have an issue with importing Form ID 7 and I delete it before importing any other forms and set the Auto Increment back to 7, this should work to re-import Form ID 7?</p> <p>Thanks again! </p> https://legacy.forums.gravityhelp.com/topic/changing-form-id#post-33009 Fri, 19 Aug 2011 07:31:16 +0000 Vayu 33009@https://legacy.forums.gravityhelp.com/ <p>Hi vixvii.</p> <p>I had to do the same and ran into problems, when I changed the ID in the database.</p> <p>If you haven't created any other forms, then you can delete the form in the production site. That will delete all entries for that form as well, so don't do that if this is an issue.</p> <p>Before importing the form again, you'll need to reset the autoincrement id in the database. You can do that like this:</p> <pre><code>ALTER TABLE &lt;code&gt;table_name&lt;/code&gt; AUTO_INCREMENT=1</code></pre> <p>You would need to do that for the following tables:</p> <p>wp_rg_form<br /> wp_rg_form_meta</p> <p>Then you can import your form and it should work as ID 1.</p> <p>I am sure you are aware of this, but be careful if this is on a live site, so make backups before. :-)</p> <p>Vayu </p> https://legacy.forums.gravityhelp.com/topic/changing-form-id#post-31803 Fri, 05 Aug 2011 07:26:29 +0000 vixvii 31803@https://legacy.forums.gravityhelp.com/ <p>Chris, Thanks for the reply</p> <p>The problem started when I migrated (see topic <a href="http://www.gravityhelp.com/forums/topic/migrating-gravity-forms)" rel="nofollow">http://www.gravityhelp.com/forums/topic/migrating-gravity-forms)</a></p> <p>This one form did not import properly on the live server when I migrated. I made a complete DB backup on the development server and restored on the live server. So my user registration form was there, but had no fields. So I exported it from the dev server and imported on the live server, which worked, but of course gave it a different ID.</p> <p>What kind of errors will I face if I had to change the ID? I'm thinking that I should maybe re-create my live server on the dev server if something goes wrong again. </p> https://legacy.forums.gravityhelp.com/topic/changing-form-id#post-31667 Thu, 04 Aug 2011 00:09:11 +0000 Chris Hajer 31667@https://legacy.forums.gravityhelp.com/ <p>Can you recreate the form on the development server to match the production server? If the environments were the same, the new form should get the same ID on the development server as it has on the live server. Changing the ID would be complicated and prone to error.</p> <p>Or, how about export all the forms from the live server and just import them on the development server? I would be sure to back up everything first, in case something goes wrong. </p> https://legacy.forums.gravityhelp.com/topic/changing-form-id#post-31565 Wed, 03 Aug 2011 12:31:16 +0000 vixvii 31565@https://legacy.forums.gravityhelp.com/ <p>Could you possibly help with a SQL function to change the ID of a form? I have a series of forms on my development server and then the same on my live server. But when migrating to the live server one form did not migrate properly and I had to recreate it, which resulted in the form having a different ID than on the development server.</p> <p>I would like to change the ID of the equivalent form on the development server to match the live server's form ID. This will make coding so much easier as I have to constantly change form IDs in the code.</p> <p>Any help on this will really be appreciated. </p>