So I have a ton of old posts that have images attached (via the Media Uploader) to the post content, but don’t have featured images. OF COURSE, my theme wants to use featured images. \ud83d\ude42<\/p>\n
I have the post_id of each post in my set. I have both the meta_id value of the image for each post and the URL of each image.<\/p>\n
I want to just do a SQL statement\/insert\/update in my database backend to set all the featured images, but I can’t seem to get it to work. I tried inserting the post_id, meta_key=”_thumbnail_id”, and meta_value=my image ID into the _postmeta table and … nothing. They don’t show up as attached on the front-end. Am I missing a step? Do I need to regenerate thumbnails or something afterward?<\/p>\n
Any insight is greatly appreciated, thanks!<\/p>\n
P.S. I know there have been solutions\/ideas posted elsewhere about how to accomplish this with php or wp hooks, etc. I just want to update from the database side if possible…SO much less confusing for me. \ud83d\ude42<\/p>\n","protected":false},"template":"","class_list":["post-6037241","topic","type-topic","status-closed","hentry","topic-tag-database","topic-tag-featured","topic-tag-featured-image","topic-tag-image","topic-tag-thumbnail"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/6037241","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/6037241\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=6037241"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}