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

Jamie

Well-known member
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
xf_conversation_master
xf_conversation_message
xf_conversation_recipient
xf_conversation_user

Empty the content of those tables
 

Elizabeth

Well-known member
You could save the sql file to your hard drive, delete your's carefully and then reinsert the sql file.
 

Blandt

Well-known member
Wouldn't that delete all PM's? I am looking for only delete my PM's.

Jamie
Hmmm I really thought you wanted to prune all of them :confused: so yes .. look for your ID and empty your tables only (recipient and message)
 

Jamie

Well-known member
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
 
Top