• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Is there a way to delete all PM's from one user via a SQL statment?

Jamie

Well-known member
#1
I have always kept all PM's that I thought were important, but with that number pushing 600, I would like to prune them.

When I imported, it marked everything as new, which isn't ideal, so now I am looking for a way to remove just my PM's.

I have already ran a SQL update to mark them as read as far as the Inbox Alerts goes, but I would like to delete them at this point.

Thanks for any help with this.

Jamie
 

Blandt

Well-known member
#2
xf_conversation_master
xf_conversation_message
xf_conversation_recipient
xf_conversation_user

Empty the content of those tables
 

Jamie

Well-known member
#7
Ah ok.. I thought it would be that when you said purge those tables, I thought to myself, what if I just did it to the userid 1. :)

Thanks, I will give that a go on my test site!

Jamie