What is the structure of the “Featured Image” field in the DB? (2 posts)

  1. Eddie
    Posted 2 years ago #

    Featured images got messed up after an import with the "media tools 1.1" plugin. The plugin wrongly designated (in the DB) the incorrect filename for the images: Instead of pointing to the correct file, it appended a "1" to its name, causing, for example, a 404 for "Protest-11-620x264.jpg", when it should point to "Protest-1-620x264.jpg"

    I need to do a search & replace in the DB on *_wp_attachment_metadata* field and remove the extra "1" from the filenames. Naturally I will use a regex, but how do I process the contents of the field? Which one of the sections of the data has which featured image to use? In other words, what do I need look for to know the filename is the right one to search&replace?

  2. Eddie
    Posted 2 years ago #

    This question has a bounty of 50 points on SE http://wordpress.stackexchange.com/questions/135525/

Topic Closed

This topic has been closed to new replies.

About this Topic