How do I delete all posts by a user?

[DannyITR]

I tried pruning the user but that just sets them to guest. Is there a way to mass delete a user's posts?

[Steve Machol]

You had the option to remove their posts when you removed the user. Now thsat you skipped this, you will need to do it either manually with with a query. Something like:

DELETE FROM post WHERE username='user name';

..substituting this user's username of course. Make a backup of your database before doing this.

[DannyITR]

ok thanks!

[Jake999]

Hi Steve, when I open a user's account, then select "delete user" I do not see an option to remove all of their posts.

What am I doing wrong?

Thanks for the help!

You had the option to remove their posts when you removed the user. Now thsat you skipped this, you will need to do it either manually with with a query. Something like:

DELETE FROM post WHERE username='user name';

..substituting this user's username of course. Make a backup of your database before doing this.

[Steve Machol]

Jake999, in the future please start a new thread for your problem or question. However the answer is that you will be given this option to remove the users posts if you continue.