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

  1. Eddie - Digital Marketing Consultant
    Posted 1 year 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 - Digital Marketing Consultant
    Posted 1 year 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

  • RSS feed for this topic
  • Started 1 year ago by Eddie - Digital Marketing Consultant
  • Latest reply from Eddie - Digital Marketing Consultant
  • This topic is not resolved
  • WordPress version: 3.8.1