Recently I changed some code that had an empty value in the post ID. That made the function unable to set a featured image in the current post. What ended up happening was the most recent image got set as the featured post for EVERY POST, on EVERY update. Oops.
Here is a snippet to fix the problem:
Oh, I had a very similar issue a few months ago. This would do the same trick, very quick:
DELETE FROM wp_postmetaWHERE 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;
Oh, I had a very similar issue a few months ago. This would do the same trick, very quick:
DELETE FROM wp_postmetaWHERE 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_idFROM 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.
Thanks, this saved my life!
Thanks,
I’m facing the same problem.
i need this code more than anything…
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