Moved Domains - Form Data not showing but it's in the database

Gravity Support Forums » Plugin Support » Gravity Forms

konemarketing
Member

I've just packaged up and moved a site to another domain on my server. Everything went smoothly except for the information inside gravity forms.

On the new domain, when I try to pull up a page that has a gravity form I get the "Ooops" message.

So I login to the wordpress admin panel and I see that Gravity Forms is still installed and it's even showing the 3 forms there that I had created. However, when I click to edit each of the three forms it brings me to a blank slate as if I had just created a new one. "Untitled Form..."

I explored through the database and I see that all of my form data is within the display_meta field but still not working.

I've tried re-installing gravity forms with new database entries and copying over the fields to replace them. Nothing has worked. Can anyone shed some light on the situation?

Thanks!

Posted 14 years ago on Saturday February 26, 2011 | Permalink
Chris Hajer
Key Master

What was the old domain name and new domain name? Maybe the serialized data lengths got corrupted.

I tried to help a similar problem for another user:

http://www.gravityhelp.com/forums/topic/oops-we-could-not-locate-your-form-2#post-19029

Posted 14 years ago on Sunday February 27, 2011 | Permalink
Carl Hancock
Administrator

As @illinoisharley mention it is most likely an issue of the data got corrupted depending on how you migrated your site. How did you migrate the data? PHPMyAdmin is known to cause problems with serialized data if you used it to export/import.

Let us know, we have an add-on that can correct the corrupt serialized data that we can send you that you can activate and then utilize to correct the issue.

Posted 14 years ago on Sunday February 27, 2011 | Permalink
asapconnections
Member

I've run into this exact situation - I moved a site from one server to another via a db dump in phpmyadmin, now my forms are writing to the db but nothing is showing in wp-admin. Where can I find the add-on?

Thanks!

Posted 13 years ago on Thursday December 13, 2012 | Permalink
Chris Hajer
Key Master

You can download it from the bottom of this page:
http://www.gravityhelp.com/downloads/#Gravity_Forms_Meta_Recovery_Tool

Posted 13 years ago on Thursday December 13, 2012 | Permalink
asapconnections
Member

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?

Thanks

Posted 12 years ago on Friday January 4, 2013 | Permalink
Chris Hajer
Key Master

Because you are a developer license holder, I would suggest submitting the Priority Support Form to see if they have any additional ideas for you.

I've used this tool to find and replace domain names in a MySQL database which utilizes serialized values. http://interconnectit.com/products/search-and-replace-for-wordpress-databases/

Maybe that will work for you.

When you moved your site from one domain to the other, what procedure did you use?

Posted 12 years ago on Monday January 7, 2013 | Permalink
asapconnections
Member

To move the site I copied my wp-content folder to a clean wp install on the new server.

On the old server I did not have access to phpmyadmin so I produced my sql files from the plugin WP Db backup 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.

Now the forms seem to work, all of the entries are there in the db, but do not show on the back end.

Posted 12 years ago on Sunday January 13, 2013 | Permalink
asapconnections
Member

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.

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.

Posted 12 years ago on Sunday January 13, 2013 | Permalink
Chris Hajer
Key Master

When you export the forms as XML and import them into a new site, you won't get any entries; just the forms.

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?

Posted 12 years ago on Sunday January 13, 2013 | Permalink
asapconnections
Member

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.

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.

Thanks,
Jeremy

Posted 12 years ago on Monday January 14, 2013 | Permalink
Chris Hajer
Key Master

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.

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.

Posted 12 years ago on Tuesday January 15, 2013 | Permalink
Chris Hajer
Key Master

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.

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.

Posted 12 years ago on Tuesday January 15, 2013 | Permalink
asapconnections
Member

Heya -

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.

Thanks for your help on this..

Jeremy

Posted 12 years ago on Monday January 21, 2013 | Permalink

This topic has been resolved and has been closed to new replies.