Image thumbnails not available post migration, but still accessible via direct URL – DB issue

Domain change

This kind of error may be caused by wrong host name in image urls that are stored in the database.

It is necessary to replace strings holding your old domain with new one:

http://olddomain.com --> http://newdomain.com

In every migtration process I use the following recommended tool: https://interconnectit.com/products/search-and-replace-for-wordpress-databases/

Upload it to your WP root directory and open in the browser. Then follow the steps reading instructions and warnings carefully.

Database prefix change

By use of this tool other source of potential problems can be solved: changed database tables prefix. If migration process includes introducing a new (hopefully safer than default wp_) prefix for DB tables, the change has to be reflected in some DB records.

So, use the above tool also to search and replace your old prefix, for example wp_ with je9128d_ in following two tables:

  • je9128d_usermeta
  • je9128d_options