https://legacy.forums.gravityhelp.com/topic/edited-the-database-and-now-my-form-has-gone Gravity Support Forums Topic: Edited the database and now my form has gone en-US Wed, 29 Apr 2026 10:34:47 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/edited-the-database-and-now-my-form-has-gone#post-64837 Thu, 05 Jul 2012 07:58:21 +0000 Chris Hajer 64837@https://legacy.forums.gravityhelp.com/ <p>Ignore the Warning for now. It's unrelated, and just a warning, nothing more. </p> https://legacy.forums.gravityhelp.com/topic/edited-the-database-and-now-my-form-has-gone#post-64836 Thu, 05 Jul 2012 07:57:30 +0000 Chris Hajer 64836@https://legacy.forums.gravityhelp.com/ <p>This statement right here is where the problem started:<br /> <pre><code>UPDATE wp_rg_lead_detail SET value = replace(value, &#39;oldtext&#39;,&#39;newtext&#39;);</code></pre> <p>If oldtext has a different number of characters than new text (e.g. you changed from Baseball to Tennis, 8 characters to 6) you have likely caused an error with the serialized data. There are ways to fix those serialized values.</p> <p>I would suggest taking a database backup right now, before you go any further. Then, find and replace newtext with oldtext to put things back the way they were. Then test. If it works, then you need to go about properly doing a find and replace while updating the serialized values as well.</p> <p>Please make a database backup before attempting any of this. </p> https://legacy.forums.gravityhelp.com/topic/edited-the-database-and-now-my-form-has-gone#post-64811 Wed, 04 Jul 2012 20:09:07 +0000 blairdods 64811@https://legacy.forums.gravityhelp.com/ <p>I am also receiving this error when click on "Entries" also if that helps:</p> <p>Warning: Invalid argument supplied for foreach() in /home/site_url/wp-content/plugins/gravityforms/forms_model.php on line 2608 </p> https://legacy.forums.gravityhelp.com/topic/edited-the-database-and-now-my-form-has-gone#post-64810 Wed, 04 Jul 2012 20:06:33 +0000 blairdods 64810@https://legacy.forums.gravityhelp.com/ <p>I used this:</p> <p>UPDATE wp_rg_lead_detail SET value = replace(value, 'oldtext','newtext');</p> <p>There is no backup from the last few days since I completed the form. </p> https://legacy.forums.gravityhelp.com/topic/edited-the-database-and-now-my-form-has-gone#post-64809 Wed, 04 Jul 2012 18:59:43 +0000 David Peralty 64809@https://legacy.forums.gravityhelp.com/ <p>How did you do the find/replace? I don't know of anything off the top of my head. Can you restore an older database backup? </p> https://legacy.forums.gravityhelp.com/topic/edited-the-database-and-now-my-form-has-gone#post-64808 Wed, 04 Jul 2012 18:56:36 +0000 blairdods 64808@https://legacy.forums.gravityhelp.com/ <p>Thanks - I just tried the tool and received this message:</p> <p>"This form's meta could not be recovered."</p> <p>I reversed the find and replace on the database but nothing helped.</p> <p>Is there anything else I can try - I have spent days on this so I can't afford to lose it.</p> <p>Thanks </p> https://legacy.forums.gravityhelp.com/topic/edited-the-database-and-now-my-form-has-gone#post-64805 Wed, 04 Jul 2012 18:51:03 +0000 David Peralty 64805@https://legacy.forums.gravityhelp.com/ <p>You might have accidentally corrupted the table. Do you have a backup you can restore from?<br /> Also, can you try the Meta restoration plugin on our downloads page:<br /> <a href="http://www.gravityhelp.com/downloads/" rel="nofollow">http://www.gravityhelp.com/downloads/</a> </p> https://legacy.forums.gravityhelp.com/topic/edited-the-database-and-now-my-form-has-gone#post-64804 Wed, 04 Jul 2012 18:41:28 +0000 blairdods 64804@https://legacy.forums.gravityhelp.com/ <p>Hi there</p> <p>I have a multi-page form (using conditional logic based on 26 pages) and I wanted to update some text that appeared in many places on the form. I updated this using MySQL in two tables, but now the form is empty in admin and on the front end it displays "Oops! We could not locate your form.".</p> <p>The two tables I edited were "wp_rg_form_meta" and "wp_rg_lead_detail".</p> <p>Any ideas as to how I can get the form working again - all the information is still in the database.</p> <p>Thanks </p>