After migrating a site from the live server to my test server (different URL), some of the images (not all) are not displaying. The src is correct, image is in the uploads folder, and everything looks good in the database. However, the image does not appear. Again it’s only “some” of the images and not all. Other images within the same folders, e.g. wp-content/uploads/2013/09/, are being loaded correctly.
Ideas?
P.S. And the rest of the content is correct.
UPDATE: Found out that all images that are affected include é within the image’s filename. Once I copied the filename into the post and meta tables, it worked. Not sure why?
I highly recommend updating all of your URLS.
UPDATE wp_posts set post_content=REPLACE(post_content, 'www.live.com/', 'www.test.com/');
note* images are uploadeded as posts in your database.* ( wp_posts table with a post_type of “attachment”. )
I would install a plugin like WP Migrate DB and enter the new server path and site address before exporting the database from your live site.
Otherwise, you can run a script like this one on your local installation https://github.com/interconnectit/Search-Replace-DB