Manually delete post from database

Drop this into a file in your plugin directory and you should be able to do this from your WP installation using a query string.

/*
Plugin Name: Delete Specific Post
Description: Rid the post forever!
Version: 0.1
Author: WPSE
License: GPL2
*/

add_filter('query_vars', 'delete_post_query_var');
function delete_post_query_var($vars){
    $vars[] = 'delete_post';
    return $vars;
}

add_action('admin_init', 'manually_delete_post', 0);
function manually_delete_post(){

    if(!is_user_logged_in())
        return;

    if(!current_user_can('manage_options'))
        return;

    if(get_query_var('delete_post')){
        $id = esc_attr(get_query_var('delete_post'));
        $delete = wp_delete_post($id, true); //True force deletes the post and doesn't send it to the Trash
        if($delete)
            echo "Post $id deleted successfully!";
        else
            echo "Post $id was not deleted.";
        exit;
    }
}

All you need to do is make sure you’re logged into an administrator account, then visit: http://yourdomain.com/wp-admin/?delete_post=POSTID

Related Posts:

  1. MySql query to get posts with all meta and terms
  2. Need to change all links in page content but not in post content
  3. MySQL Query to Retrieve Category from wp_posts
  4. SQL Query for getting all posts in their latest revised state
  5. Search & Remove Specific Shortcode From All Posts
  6. How to force update all posts after import
  7. Query All users that has post
  8. Can’t publish new posts
  9. Manually removing revision post types
  10. Reset/Reorder posts ID in the MySQL wp_posts table
  11. How do I find which articles are missing a featured image in The WordPress database?
  12. Tags to Post-ID mysql query. Tag Search
  13. Delete WordPress posts from URL list sql query
  14. wp_insert_post – duration
  15. Get user categories with most posts in it
  16. Custom order for Mysql array
  17. List authors with the last post title and order by last post date
  18. How to Mysql select a list of posts with meta_values AND all relevant categories?
  19. Remove a shortcode from all WordPress posts
  20. Order posts alphabetically: how to set order=asc in mysql query?
  21. What do these phpMyAdmin errors mean on my WordPress databaes?
  22. What happens if I delete all the rows that represents a post revision from the posts table into WordPress database?
  23. Bulk delete WordPress posts with phpMyAdmin
  24. Delete post results in “Cannot delete or update a parent row: a foreign key constraint fails”
  25. Inner join overrides Advanced Custom Fields plugin’s get_field [closed]
  26. update image path with words starting uppercase to lowercase chars
  27. Queries take 120+ seconds on my large WordPress site
  28. Database hacked – random posts are modified
  29. Can’t update WordPress Page if post_content is Empty
  30. Restore woocommerce orders
  31. How to select particular month post from table and update the post status using MySQL?
  32. How do post IDs work in WordPress?
  33. Get author posts count after excluding a category
  34. get last post’s link with SQL query
  35. How can I get posts from 9/13/11 to today with SQL? [closed]
  36. query for filtering published posts?
  37. MySQL: Possible to replace all of wp_posts.post_content(id#) via UPDATE + REPLACE + SELECT?
  38. Deleting post tags removes categories
  39. Return records between two meta datetimes saved as strings
  40. WP query taxonomy optimization
  41. MYSQL: Create SQL query to search for string and replace
  42. Query to fetch custom taxonomy along with post title
  43. Mysql update menu_order problem
  44. Bulk find & replace on WordPress posts/pages (minus image paths)
  45. WordPress MySQL Search and replace with wildcard?
  46. Add postmeta to all blog posts
  47. ‘posts’ table should not store the absolute image path
  48. Dev and prod on the same database- dev version active for IOS
  49. load post data into mysql
  50. Adding wordpress posts using phpmyadmin
  51. SQL trigger failes with post_content
  52. get backup file from wordpress database in x days
  53. Converting Posts to Pages
  54. How to change the publishing date of each posts?
  55. SQL query to remove first image in all posts
  56. Delete junk text from all the post using my sql command
  57. FIND and REPLACE wp_posts AND IGNORE custom post type mysql query
  58. How to create a post based on data in a table?
  59. If meta_key exists then don’t select this post?
  60. How to update wp_posts with just the returned comment count from wp_comments (SQL GROUP BY)
  61. Stop WordPress Wrapping Images In A “P” Tag
  62. How to mark articles as read?
  63. I have over 4000 posts, will querying some of them cause performance issues?
  64. Post X of Y in single.php / sidebar.php
  65. How can I get a list of latest posts outside of my WP install?
  66. Paragraphs removed when using get_post_custom()?
  67. Post taxonomy from exif data
  68. Underscores.me retrieve next / previous post thumbnail in post_nav function
  69. Adding a text link under the post title in the lists of posts
  70. Count to how many categories a post belongs to
  71. How to list users and their post amount?
  72. Create cron job without a plugin?
  73. Number format for wp_count_posts()
  74. Posts and Attachments with “Published” status in Search
  75. Genesis + Ajax + Jquery | Failling to call action
  76. Shortcode to display the latest news article within a page
  77. How to make the first post in the loop be styled like a “new / featured” post?
  78. Help diagnosing scheduled post problem with transition_post_status
  79. Archiving posts in wordpress
  80. User Selectable Delete of Pages
  81. Develop Admin Panel Page
  82. How to show content without excerpt?
  83. Add hero image to home page (blog format) via the dashboard
  84. Having pages after specifying post_type post
  85. I want to show my post for limited time, how is it possible?
  86. Query function not executed between element [closed]
  87. Your ideas on my though “delete or move all of the posts in a specific category when 3 days are passed”
  88. How Can I Always Display A Particular Post First Using WP_Query?
  89. How to preserve HTML from posts in RSS feed
  90. Run a function when a custom post is update?
  91. WordPress Post ids big increment
  92. How do I customize the post page
  93. How can we print out total number of posts filtered by post type and category?
  94. All my posts don’t show, only the headline is displayed on the homepage
  95. How to prevent people from seeing an attachment to a scheduled post that’s released in future?
  96. standard wpGallery for post won’t work
  97. How remove “recent comments” title without modifying code? [closed]
  98. Return All Post from publish to draft [duplicate]
  99. Displaying all images from a WordPress post (including media library)
  100. WordPress shows a count of published items on the site, but the items are not appearing when you click on the “published” link

Leave a Comment