https://legacy.forums.gravityhelp.com/topic/moved-domains-form-data-not-showing-but-its-in-the-database Gravity Support Forums Topic: Moved Domains - Form Data not showing but it's in the database en-US Thu, 30 Apr 2026 10:14:48 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/moved-domains-form-data-not-showing-but-its-in-the-database#post-127818 Mon, 21 Jan 2013 17:07:32 +0000 asapconnections 127818@https://legacy.forums.gravityhelp.com/ <p>Heya - </p> <p>Priority Support has me all fixed up. For some reason when my site transferred the wp_rg_lead table didn't make it over. I found this table create statement in my sql backups, ran that and then the inserts that followed, and now everything's working as expect.</p> <p>Thanks for your help on this..</p> <p>Jeremy </p> https://legacy.forums.gravityhelp.com/topic/moved-domains-form-data-not-showing-but-its-in-the-database#post-121873 Mon, 14 Jan 2013 20:43:58 +0000 Chris Hajer 121873@https://legacy.forums.gravityhelp.com/ <p>The main issue, which I may have mentioned before, is that when changing domains, the length of the domain name string changes, which corrupts the serialized data. That is why the entries no longer show. The serialized values become invalid and can't be read by normal PHP functions. You can repair this if you know what you're looking for. You can even just try repairing one entry at a time then using the same process on the others.</p> <p>The interconnectIT tool I linked to normally works for me, in fact has worked for me every time. There may be one step we're doing different from each other, but going from memory, it's hard to say what that might be. I will leave this open for Rob on Priority Support to see if he can help you more directly. </p> https://legacy.forums.gravityhelp.com/topic/moved-domains-form-data-not-showing-but-its-in-the-database#post-121872 Mon, 14 Jan 2013 20:43:57 +0000 Chris Hajer 121872@https://legacy.forums.gravityhelp.com/ <p>The main issue, which I may have mentioned before, is that when changing domains, the length of the domain name string changes, which corrupts the serialized data. That is why the entries no longer show. The serialized values become invalid and can't be read by normal PHP functions. You can repair this if you know what you're looking for. You can even just try repairing one entry at a time then using the same process on the others.</p> <p>The interconnectIT tool I linked to normally works for me, in fact has worked for me every time. There may be one step we're doing different from each other, but going from memory, it's hard to say what that might be. I will leave this open for Rob on Priority Support to see if he can help you more directly. </p> https://legacy.forums.gravityhelp.com/topic/moved-domains-form-data-not-showing-but-its-in-the-database#post-121559 Mon, 14 Jan 2013 10:18:27 +0000 asapconnections 121559@https://legacy.forums.gravityhelp.com/ <p>I realize the data won't come with the xml , but the old forms and the newly imported forms won't show newly added entries either. The old data is one thing, I've got that in a CSV from the db and we can at least work with it. I just don't quite get how these meta tables work in relation to the data or I could likely fix it,, the data is there, the form id is right, I don't see why gf won't show it. My data import and site transfer worked fine for everything else on the site with quite a bit of customization. </p> <p>I did lose access to the old domain as i found over the weekend. At this point I'm ready to just drop all my gf tables and import the forms again, even if I lose the old entries. Still don't get why they're not showing though. Thanks for your help. I did post a priority ticket over the weekend so maybe thteyll have some more insight for me.</p> <p>Thanks,<br /> Jeremy </p> https://legacy.forums.gravityhelp.com/topic/moved-domains-form-data-not-showing-but-its-in-the-database#post-120857 Sun, 13 Jan 2013 13:02:24 +0000 Chris Hajer 120857@https://legacy.forums.gravityhelp.com/ <p>When you export the forms as XML and import them into a new site, you won't get any entries; just the forms. </p> <p>I would make a backup of the old database and new database now, before you do anything else, so you don't make things worse. Then I would get some local help to fix the problem. I'm not sure where it went wrong, based on your description of your process. I would go back to the original domain and original database, and if things are working correctly there, I would start over from scratch. Do you have the option of doing that? </p> https://legacy.forums.gravityhelp.com/topic/moved-domains-form-data-not-showing-but-its-in-the-database#post-120604 Sun, 13 Jan 2013 00:56:26 +0000 asapconnections 120604@https://legacy.forums.gravityhelp.com/ <p>I also tried importing the old forms with the xml export I made on the old site. The forms seem to work but no entries are appearing.</p> <p>I noticed in the tables in the current db that the wp1_rg_lead_meta table is empty. Also the most recent entries in the wp1_rg_lead_detail table are created with a lead_id of 0. </p> https://legacy.forums.gravityhelp.com/topic/moved-domains-form-data-not-showing-but-its-in-the-database#post-120595 Sun, 13 Jan 2013 00:33:01 +0000 asapconnections 120595@https://legacy.forums.gravityhelp.com/ <p>To move the site I copied my wp-content folder to a clean wp install on the new server. </p> <p>On the old server I did not have access to phpmyadmin so I produced my sql files from the plugin <a href="http://austinmatzko.com/wordpress-plugins/wp-db-backup/" rel="nofollow">WP Db backup</a> which just gives an sql dump in a zip file. I then imported this sql into phpmyadmin on the new server and used the tool you linked to above to change the domain. I have the sql dump created on the old site but the old server no longer has the site so I cannot get a new export.</p> <p>Now the forms seem to work, all of the entries are there in the db, but do not show on the back end. </p> https://legacy.forums.gravityhelp.com/topic/moved-domains-form-data-not-showing-but-its-in-the-database#post-115974 Mon, 07 Jan 2013 08:17:25 +0000 Chris Hajer 115974@https://legacy.forums.gravityhelp.com/ <p>Because you are a developer license holder, I would suggest submitting the <a href="http://www.gravityhelp.com/priority-support/" rel="nofollow">Priority Support Form</a> to see if they have any additional ideas for you.</p> <p>I've used this tool to find and replace domain names in a MySQL database which utilizes serialized values. <a href="http://interconnectit.com/products/search-and-replace-for-wordpress-databases/" rel="nofollow">http://interconnectit.com/products/search-and-replace-for-wordpress-databases/</a></p> <p>Maybe that will work for you.</p> <p>When you moved your site from one domain to the other, what procedure did you use? </p> https://legacy.forums.gravityhelp.com/topic/moved-domains-form-data-not-showing-but-its-in-the-database#post-113372 Thu, 03 Jan 2013 22:33:59 +0000 asapconnections 113372@https://legacy.forums.gravityhelp.com/ <p>I've installed the tool and when I run it I get the message "Meta recovered successfully", but there are still no entries showing. Any other ideas?</p> <p>Thanks </p> https://legacy.forums.gravityhelp.com/topic/moved-domains-form-data-not-showing-but-its-in-the-database#post-101910 Wed, 12 Dec 2012 23:46:37 +0000 Chris Hajer 101910@https://legacy.forums.gravityhelp.com/ <p>You can download it from the bottom of this page:<br /> <a href="http://www.gravityhelp.com/downloads/#Gravity_Forms_Meta_Recovery_Tool" rel="nofollow">http://www.gravityhelp.com/downloads/#Gravity_Forms_Meta_Recovery_Tool</a> </p>