WordPress Remove Attachment Rows Where File Doesn’t Exist

Here’s a nifty script I cooked up tonight. This basically looks through all of your attachments and see if the associated real files exist on the server. If they don’t, the attachment database row is deleted. I realize this isn’t the most useful tool for everyday use. It was built for a one-off use case and I didn’t want this script to get dusty in my local files. So, here it is for your consumption or truncation!

<?php /** * Usage when logged in: http://yourdomain.com/wp-admin/remove-404-attachments=secretpassword */ # Hook late into admin_init add_action('admin_init', 'remove_404_attachments', 9999999); function remove_404_attachments(){ # Must be an admin if(!current_user_can('manage_options')) return; # Fire this only when needed if(!isset($_GET['remove-404-attachmentss']) && $_GET['remove-404-attachments'] === 'secretpassword') return; # Run the query global $wpdb; $sql = $wpdb->prepare("SELECT ID FROM $wpdb->posts WHERE post_type = 'attachment'"); $attachments = $wpdb->get_results($sql); # Spin cycle foreach($attachments as $attachment){ # Get the absolute path of the attachment $file_path = get_attached_file($attachment->ID, true); # Check if the attachment exits if(!file_exists($file_path)){ $deleted = wp_delete_attachment($attachment->ID, true); if($deleted) show_message("$file_path Deleted"); else show_message("Post #$attachment->ID could not be deleted from the database."); } else show_message("$file_path exists."); } exit; }

WordPress