[Forum] Need to delete posts by a former member who was deleted

[kjetterman]

Hello,

I accidentally deleted a member without deleting her posts first. Now her posts are still on the forum with her name and the title "guest". I can't delete her posts in the admin panel because she is not a member.

How would I do this using an SQL query? Thanks for your help!

[borbole]

Hello,

I accidentally deleted a member without deleting her posts first. Now her posts are still on the forum with her name and the title "guest". I can't delete her posts in the admin panel because she is not a member.

How would I do this using an SQL query? Thanks for your help!

Try this query:

DELETE FROM post WHERE username = 'usernameofdeleteduser';

If your db tables have a prefix, include that in your query as well and replace usernameofdeleteduser with the actual username of the deleted user.

[kjetterman]

It deleted the threads that she made but it didn't delete her username and/or the complete thread. It just deleted the words. I updated my counters.

How do I get rid of all of the threads she started?

[borbole]

It deleted the threads that she made but it didn't delete her username and/or the complete thread. It just deleted the words. I updated my counters.

How do I get rid of all of the threads she started?

Just to make sure. You want to delete all the threads as well of that user whom you deleted?

If so, run this query:

DELETE FROM thread WHERE postusername = 'usernameofdeleteduser';

[Lynne]

Just a comment, but deleting a thread like that is going to leave a bunch of orphan posts - all the posts in the thread made by other users will just be in limbo.