bookchiq/delete_orphaned_featured_image_meta.sql

Last active September 29, 2021 19:27

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/bookchiq/ec951d634b8d3f108a2adf1e1dcb5f9a.js"></script>
Save bookchiq/ec951d634b8d3f108a2adf1e1dcb5f9a to your computer and use it in GitHub Desktop.

Download ZIP

Sometimes when using the WordPress importer, featured images aren't _quite_ imported but report that they were, throwing off has_post_thumbnail() results. This SQL checks if the "connected featured image" actually exists, and if not, removes the half-there connection.

Raw

delete_orphaned_featured_image_meta.sql

	DELETE pm
	FROM wp_postmeta pm
	LEFT JOIN wp_posts wp ON wp.ID = pm.meta_value
	WHERE
	pm.meta_key = "_thumbnail_id" AND
	wp.ID IS NULL

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment