https://legacy.forums.gravityhelp.com/topic/corrupt-form-metadata Gravity Support Forums Topic: Corrupt Form Metadata en-US Fri, 24 Apr 2026 11:06:12 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/corrupt-form-metadata#post-20622 Tue, 15 Mar 2011 13:30:09 +0000 Julio Lopez 20622@https://legacy.forums.gravityhelp.com/ <p>Hi Carl,</p> <p>So I figured out that there were some special characters in my form meta that were preventing the meta recovery tool from doing it's job. I had to go in and change characters like é to &eacute; and I was then able to fix the problem by running the meta recovery tool.</p> <p>Of course, this was after I'd written some scripts to pull entry data without using the form meta data. Oh well.</p> <p>Perhaps this code may lead to the development of a new tool plugin for instances where special characters are not the cause of irreparable bad form meta data.</p> <p>I created index.php (<a href="http://www.pastie.org/1675182" rel="nofollow">http://www.pastie.org/1675182</a>) to read the list of forms from the WP DB and to create a form with a select element that allows you to choose what form you want to collect data from.</p> <p>I then created recovery.php (<a href="http://www.pastie.org/1675204" rel="nofollow">http://www.pastie.org/1675204</a>) which is the value of the action attribute of the form on index.php which does the grunt work of getting the data and spitting it out as a csv file.</p> <p>My apologies for the messy, uncommented code. I was working quickly.</p> <p>Thanks again for all your help. </p> https://legacy.forums.gravityhelp.com/topic/corrupt-form-metadata#post-20354 Thu, 10 Mar 2011 15:31:18 +0000 Carl Hancock 20354@https://legacy.forums.gravityhelp.com/ <p>I would recommend using a solution like BackupBuddy or something similar to backup/restore/migrate.</p> <p>Entries are stored in the following tables:</p> <p>wp_rg_lead<br /> wp_rg_lead_detail<br /> wp_rg_lead_detail_long</p> <p>The wp_ portion is based on whatever your database table prefix setting in WordPress is set to. </p> https://legacy.forums.gravityhelp.com/topic/corrupt-form-metadata#post-20340 Thu, 10 Mar 2011 13:51:36 +0000 Julio Lopez 20340@https://legacy.forums.gravityhelp.com/ <p>PS. What tables hold the entries data?<br /> PPS. In case I have to restore my database from a backup again, what is the best way to back up and restore in order to preserve data integrity? </p> https://legacy.forums.gravityhelp.com/topic/corrupt-form-metadata#post-20330 Thu, 10 Mar 2011 12:55:53 +0000 Julio Lopez 20330@https://legacy.forums.gravityhelp.com/ <p>Ouch!! Really? Ok well I guess I'm going to have to start writing some kind of PHP scripts to read and parse through the data since the GF export util does not work for my corrupted forms. (sigh)</p> <p>If I come up with anything useful I'll be happy to share it on the forums as it may help others.</p> <p>Thanks for your help Carl! </p> https://legacy.forums.gravityhelp.com/topic/corrupt-form-metadata#post-20325 Thu, 10 Mar 2011 12:05:31 +0000 Carl Hancock 20325@https://legacy.forums.gravityhelp.com/ <p>The entries are directly tied to the form settings so. Try using the Import/Export tool to export the entries to CSV and see if that can work.</p> <p>You could pull out the entries from the database if you have to but you would have to write the queries to do so and parse the serialized data so it is human readable.</p> <p>Unfortunately it sounds like PHPMyAdmin did a number on your form data. Typically the meta recovery tool will work, but we have no control over what PHPMyAdmin does to the serialized data during the export/import process it uses and it doesn't handle serialized data properly. </p> https://legacy.forums.gravityhelp.com/topic/corrupt-form-metadata#post-20318 Thu, 10 Mar 2011 10:42:46 +0000 Julio Lopez 20318@https://legacy.forums.gravityhelp.com/ <p>Hi Carl,</p> <p>Thanks for the link. I have downloaded, installed and run the tool and was only able to recover one of my forms. Do you have any other suggestions? What is most important to me now is to recover the submitted data rather than the forms, they can always be rebuilt. Is there any way to pull out human readable records from the GF tables in the WP database without the form metadata? </p> https://legacy.forums.gravityhelp.com/topic/corrupt-form-metadata#post-20288 Wed, 09 Mar 2011 18:15:59 +0000 Carl Hancock 20288@https://legacy.forums.gravityhelp.com/ <p>I have added the Meta Recovery Add-On to the Downloads page. You can download, install and activate this Add-On. It will create a new navigation item under Forms called Meta Recovery, use that tool to select your forms individually and repair the meta data.</p> <p>Downloads page is here:</p> <p><a href="http://www.gravityhelp.com/downloads/" rel="nofollow">http://www.gravityhelp.com/downloads/</a></p> <p>This issue happens when PHPMyAdmin doesn't properly handle serialized data. </p> https://legacy.forums.gravityhelp.com/topic/corrupt-form-metadata#post-20287 Wed, 09 Mar 2011 18:08:03 +0000 Julio Lopez 20287@https://legacy.forums.gravityhelp.com/ <p>Hello,</p> <p>I'm the web developer at the Art Gallery of Ontario and we are a Gravity Forms customer. This week I discovered that some of our forms are not showing up on their respective pages and showing only the "Oops! We could not locate your form" error. In the wordpress admin they are listed, but upon editing them they look like a brand new form.</p> <p>After reading around on the forums I've come to the conclusion that the form metadata could be corrupted. I recently had to re-install wordpress 3.0.5 after a catastrophic upgrade to 3.1 resulted in many, many broken links. Anyway, I used phpMyAdmin to rebuild the database from a backup and guess that may have caused a problem.</p> <p>Is there anyway to recover my forms and their associated data that has been submitted? I thought I read somewhere that a tool is available, where can we get it?</p> <p>you can find an error page here: <a href="http://artmatters.ca/wp/birthday-party-information-form/" rel="nofollow">http://artmatters.ca/wp/birthday-party-information-form/</a></p> <p>The error is showing up before the footer.</p> <p>thanks in advance!! </p>