PLEASE NOTE: These forums are no longer utilized and are provided as an archive for informational purposes only. All support issues will be handled via email using our support ticket system. For more detailed information on this change, please see this blog post.

Did a find/replace on an email address in MySQL, now forms are missing?

  1. Hey gang,

    I just migrated a new WordPress website from my development server to my client's server. Everything worked fine and the move was a success. But then I exported the MySQL data using phpMyAdmin and opened it in Notepad++ (as I always do) to do a find/replace on my email address, swapping it out for the client's email address.

    After importing the new MySQL data, with only the email addresses having been changed, WordPress no longer displays the forms. Instead, I get the infamous "Oops! We could not locate your form." error...

    The rg_form_meta table still contains all of the form data, but in WordPress the form is blank.

    How can I recover these forms?

    Here is a link to the development site: http://sandbox.buccanpalmbeach.com/

    The forms are accessible (or should be!) by clicking the links in the footer.

    Thanks in advance!

    Posted 12 years ago on Tuesday May 15, 2012 | Permalink
  2. David Peralty

    Have you tried the meta recovery tool?
    http://www.gravityhelp.com/downloads/

    Posted 12 years ago on Tuesday May 15, 2012 | Permalink
  3. @David: Thanks for the quick response!

    I just tried the meta recovery tool, but no luck. It says "This form's meta could not be recovered." for all three forms...

    Any other suggestions?

    Posted 12 years ago on Tuesday May 15, 2012 | Permalink
  4. David Peralty

    Are you able to remove the current forms, and export/import them using the built-in Gravity Forms import/export tool?

    Posted 12 years ago on Tuesday May 15, 2012 | Permalink
  5. @David: Thanks again. I tried to export the forms and got the following message:

    Warning: Invalid argument supplied for foreach() in /public_html/sandbox/wp-content/plugins/gravityforms/export.php on line 34

    Warning: Cannot modify header information - headers already sent by (output started at /public_html/sandbox/wp-content/plugins/gravityforms/export.php:34) in /public_html/sandbox/wp-content/plugins/gravityforms/export.php on line 146

    Posted 12 years ago on Wednesday May 16, 2012 | Permalink
  6. David Peralty

    You are exporting from your dev site, right? Can you re-install Gravity Forms on both sites before proceeding (It won't effect any forms you've created, but I want to reduce the chance of an issue in one of the files).

    Posted 12 years ago on Wednesday May 16, 2012 | Permalink
  7. @David: I was able to resolve the issue by restoring a backup on the development server, exporting the forms, and then importing them on the new site. Everything is working now, and the site just went live today. Check it out at: http://buccanpalmbeach.com/

    Thanks for your help on this!

    Posted 12 years ago on Friday May 18, 2012 | Permalink
  8. Right on, glad you are up and running. Thanks for letting us know.

    Posted 12 years ago on Friday May 18, 2012 | Permalink

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