All fields and forms gone after migrating WP site & updating MySQL database

[geoffmyers]

I am using the paid version of User Meta Pro. After migrating an existing WordPress site to a new URL/domain with User Meta installed and configured previously and updating all instances of the old URL in the MySQL database then re-uploading the new MySQL database with the new URL, all fields data and forms data are gone from User Meta. I get the following error messages on every page which had User Meta short codes: “Fields not found.” I checked the MySQL database and all the correct tables and rows were there. This is an urgent issue that I need resolved ASAP. I have the paid version, so I hope to hear back within a matter of an hour or two. Thank you so much! — Geoff Myers, geoff@simdex.org, +1 651-247-8170.

[geoffmyers]

The wp_usermeta DB table has 46,630 rows in it, so the data are clearly there, but there’s some sort of disconnect between the User Meta Pro WP plugin and the MySQL database, even though I did find & replace of the old URL with the new URL in the database after migrating it to the new domain/URL. Please let me know your thoughts ASAP. Thanks in advance for your timely response.

[Support]

Hello, UMP store its field, forms and every other settings to wp_options table. Please check your wp_options table for options_name: user_meta_fields and user_meta_forms
Thanks.

[geoffmyers]

Yes, those rows are present in wp_options (SQL dump attached):

https://www.dropbox.com/s/ipu6l779qeg6egd/wp_options-user_meta.sql

The previous WP site URL was http://192.185.114.241/~amem
The new WP site URL is http://amemminnesota.org

Yet, when I go into User Meta Pro in the WP admin, there are NO fields or forms whatsoever…

Please let me know your thoughts ASAP. Thanks in advance for your timely response.

[Support]

Please run following code to your functions.php (under current theme)

if( is_admin() ){ 
   $fields = get_option('user_meta_fields');
   var_dump($fields);
}

Then go to your admin dashboard. And see dump values.

[geoffmyers]

It returned bool(false). What should I do next?

[Support]

So it means, there are empty value in wp_options table with option_name “user_meta_fields”. Maybe your sql file not imported properly.

[geoffmyers]

Can I give you full access to the server so you can have a closer look please (FTP, cPanel, phpMyAdmin)?

[Support]

Okay, send your details to support(at)user-meta.com with this topic url.
Thanks.

[Author]

Posts