Removing External Featured Image

  • Resolved alexpoucher

    (@alexpoucher)


    9 years, 11 months ago

    So here is the issue. I run the Newspaper theme, every time I update I am forced to try and figure out how to make this plugin work with the theme all over again. I cannot be bothered to do this anymore. My site has over 20,000 posts and random posts in that cluster contains “External Featured Images” I need a way to delete all posts using “External Featured Image” – There should be a way to do a MySQL Query to delete all posts containing a “External Featured Image” or some type of plugin that can do this. Half the posts now on my site are now showing up with no featured images since recently updating the Newspaper theme and I need those posts gone ASAP as I do not have the time or the resources to individually go through thousands of posts to delete them 1 by 1. I emailed you about this already David with no reply back.

    https://ww.wp.xz.cn/plugins/external-featured-image/

Viewing 1 replies (of 1 total)
  • Plugin Author David Aguilera

    (@davilera)

    9 years, 11 months ago

    Hi!

    I’m sorry you had to uninstall the plugin. I’m well aware of the compatibility problems between some themes and our plugin, and I’m really sorry I wasn’t able to find a way to make it work! I’m afraid there’s none… for all my attempts have failed so far.

    Anyway, about your issue at hand. This is the SQL query you need to use. Howeve, please make sure to have a backup of your database before running it; should things go wrong, you’ll have a way to revert the database to its previous state:

    UPDATE wp_posts
SET post_status = 'trash'
WHERE ID IN (
  SELECT post_id
  FROM wp_postmeta
  WHERE meta_key = '_nelioefi_url' AND meta_value <> ''
)

    As you can see, the inner query obtains the IDs of all posts using an external featured image. This result is used to feed the outer query, which changes the status of said posts to trash.

    If you want to actually delete those posts, you should use a DELETE SQL statement, but I think using trash is safer and more flexible.

    Regards,
    David

Viewing 1 replies (of 1 total)

The topic ‘Removing External Featured Image’ is closed to new replies.