Delete posts of deleted user wordpress

Question

I am using buddypress with wordpress.I accidentally deleted a user directly in data base table wp_users. Therefore just the user only deleted but the posts posted by him remains in the site. How to delete all the posts related to that deleted user. Is there any way?

Give the table schema of wp_users and posts

Rajesh Paul
– Rajesh Paul

2013-12-27 18:22:05 +00:00
Commented Dec 27, 2013 at 18:22 — Rajesh Paul
– Rajesh Paul, Commented Dec 27, 2013 at 18:22

jogesh_pi · Accepted Answer · 2013-12-27 05:13:47Z

1

Do it carefully this is the Query to detect all the posts from the deleted user to confirm that, the select query show you the post of the user that are not found in wp_users table.

SELECT *
    FROM `wp_posts`
WHERE `post_author` NOT
    IN (
        SELECT id
           FROM `wp_users`
       )

And this is hows you run the delete query.

DELETE
    FROM `wp_posts`
WHERE `post_author` NOT
    IN (
        SELECT id
           FROM `wp_users`
       )

Run this query in your database.

answered Dec 27, 2013 at 5:13

jogesh_pi

9,7745 gold badges40 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Delete posts of deleted user wordpress

1 Answer 1

Run this query in your database.

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Run this query in your database.

Comments

Your Answer

Sign up or log in

Post as a guest

Related