prospurring

Hi wfphil,

Thank you for this response. I was unaware that WordFence had resolved it!

I **did**, however, find the instructions to export/import settings before my site migration, and this saved me oodles of time. For others who want to learn more, you can find the export/import instructions here: https://www.wordfence.com/help/tools/import-export/

Now I’ll be adding an item on my to do list, to reset the WordFence tables on all my sites. Thanks again.

Doh! I found the culprit extension and I’ll let them know! Thank you!
Consider this resolved.

• This reply was modified 7 years, 11 months ago by prospurring.

Please note: I tested a site where I had WordFence installed by deactivating and deleting the WordFence plugin, but the WordFence tables remain in the MySQL database.

So, if you have or have previously used WordFence, you have two choices:

#1) Use WP Migrate DB Pro. In the “Tables” section, choose “Migrate only selected tables below.” Look for all of the tables that begin with wp_wf (assuming a table prefix of wp_). Click on the first one to select it, scroll down, and press Ctrl and click on the last one to select the range of wp_wf tables. Then under the box, select Invert Selection to select all the tables EXCEPT the WordFence tables. Proceed with the migration. Because this does not destroy any data in the SOURCE WordPress install, I chose this option. I’ve tested it and my resulting migrated site works fine.
– OR –
#2) Deactivate and delete WordFence from the SOURCE WordPress installation that you want to migrate. Then delete the WordFence tables from the database manually (using phpMyAdmin or something similar). Then you could migrate using the free version of WP Migrate DB. Theoretically this should work – but no promises. I did not test this option, because if you delete the wrong table, you could break the SOURCE WordPress install completely and you might not ever be able to migrate it.

Because I’m working on a deadline, I chose to purchase the WP Migrate DB Pro version. When I attempted to use the Pro version, I got an error message saying the Migration Failed:

{"wpmdb_error":1,"body":"

WordPress database error:<\/strong> [Can't find file:
'.\\2015@002dag\\_mig_wp_wfbadleechers.frm' (errno: 2 - No such file or directory)]
RENAME TABLE '_mig_wp_wfbadleechers' TO 'wp_wfbadleechers'>\/code><\/p><\/div>"}

This is a table generated in my version of WordPress using a free version of the WordFence security plugin.

This is a known incompatibility between WordFence and WP Migrate DB: https://www.ads-software.com/support/topic/wp-migrate-db-migration-fails-due-to-wordfence-1?replies=2

By using WP Migrate DB Pro (paid version), I am able to de-select the migration of all WordFence tables within my WordPress site, and then successfully migrate the site. I can then re-establish WordFence protection for the migrated site using the WordFence plugin on that migrated site.

Therefore, I believe that WP Migrate DB and WP Migrate DB Pro are working as they should; if you’re using WordFence, you may want to use the Pro version. Marking as resolved.

Because the error is not related to CloudFlare, I am marking this topic resolved.

I pointed the DNS for one site that I’m trying to migrate away from CloudFlare and back to the webhost, hoping that the errors would resolve, but they didn’t. When I import the .sql.gz file locally using phpMyAdmin, I still get errors. So, it may not be related to CloudFlare at all. That being said, I’m still getting errors when I attempt to import the .sql.gz file.

Excellent! Thanks! ?

Thank you! This plugin is EXACTLY what I wanted!
I just didn’t know to search for author slug.
Thanks, Chris!

P.S. This link is not helpful to me…
https://www.ads-software.com/support/topic/assistance-changing-author-permalink-url

I would like it more neatly laid out for me.

I want to say again that I am really new to all of this. I am a designer and not a programmer. So learning how to do things in PHP in WordPress is a bit like learning a foreign language to me. I can tell you what I want to do in my native tongue, but I have no idea how to say that (or do that) in PHP.

Someone on the DIY Themes / Thesis Forums pointed me to
this page in the codex: https://codex.www.ads-software.com/Custom_Fields. Based on my reading of this page, it looks like I will need to use the get_post_custom() command.

The thesis_post_image custom field contains a URL of an image that I want to display in my posts. And the thesis_post_image_alt custom field contains a string of text to be used as the alt text. So, I am assuming I can use the get_post_custom() command to fetch these values.

However, I am unclear as to how I would tell WordPress to display the image and use the alt text based on those values. It isn’t as simple as displaying the values themselves as described on the page. What I want it to do is read the URL and alt text, and do something with it – instead of displaying the URL, I want it to display the image (from the URL) using the alt text. I’m not sure how to do that.

Also, I don’t know where I would put this in the PHP code. Where would I insert this? And how could I make the program look for the custom fields only on posts, and not pages or other post types? And only when a full page is displayed, not an excerpt? Do I need a conditional statement as a wrapper, to say to only do this if it is a post and if there are values for the custom fields?

I hope that I am making sense, trying to explain what I am trying to achieve in non-programmer speak.

Thanks again for any help or assistance you can provide!