5 Comments


  1. Oh, I had a very similar issue a few months ago. This would do the same trick, very quick:

    DELETE FROM wp_postmeta
    WHERE meta_key = '_thumbnail_id';

    INSERT INTO wp_postmeta
    (post_id,
    meta_key,
    meta_value)
    SELECT post_parent,
    '_thumbnail_id',
    Min(ID)
    FROM wp_posts
    WHERE post_type = 'attachment'
    AND post_mime_type LIKE '%image%'
    AND post_parent > 0
    AND post_parent NOT IN (SELECT post_id
    FROM wp_postmeta
    WHERE meta_key = '_thumbnail_id')
    GROUP BY post_parent;

    Reply

  2. Oh, I had a very similar issue a few months ago. This would do the same trick, very quick:

    DELETE FROM wp_postmeta
    WHERE meta_key = '_thumbnail_id';

    INSERT INTO wp_postmeta
    (post_id,
    meta_key,
    meta_value)
    SELECT post_parent,
    '_thumbnail_id',
    Min(ID)
    FROM wp_posts
    WHERE post_type = 'attachment'
    AND post_mime_type LIKE '%image%'
    AND post_parent > 0
    GROUP BY post_parent;

    and adding:
    AND post_parent NOT IN (SELECT post_id
    FROM wp_postmeta
    WHERE meta_key = '_thumbnail_id')

    to the last SELECT will do this only if the post doesn’t have a featured image already.

    Reply
  3. justanotherblogger

    I just transferred my blog and have an problem. My images are not showing up in the posts and my featured image is not showing up. I have tried fixes,plugins is there a code I can use or a plugin that will fix the problem. Thanks

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>