Delete ALL private messages

[spaceman]

Is there any mod that allows admin to delete ALL private messages (including members)?

Thank you.

[Aaron]

There's no mod available to do that, however, you can easily delete all private messages via PHPMyAdmin. Run the following SQL queries:

Code Select Expand

TRUNCATE `smf_personal_messages`

Code Select Expand

TRUNCATE `smf_pm_recipients`

Code Select Expand

UPDATE `smf_members` SET `instantMessages`= '0', `unreadMessages`='0'

Please note that smf_ is the prefix of your forum's tables. If you've chosen a different one at the installation you'll need to change that in the queries.

That'll do!
Aaron.

[margarett]

I am sorry to be "digging the grave" and get such terribly old topic. But, that's what search is for!

SMF 1.1(.1), how can I use this command to delete ALL PMs, except unread ones? (if possible, of course...)

[perplexed]

There's no mod available to do that, however, you can easily delete all private messages via PHPMyAdmin. Run the following SQL queries:

Code Select Expand

TRUNCATE `smf_personal_messages`

Code Select Expand

TRUNCATE `smf_pm_recipients`

Code Select Expand

UPDATE `smf_members` SET `instantMessages`= '0', `unreadMessages`='0'

Please note that smf_ is the prefix of your forum's tables. If you've chosen a different one at the installation you'll need to change that in the queries.

That'll do!
Aaron.

Hello

I want to check that this only deletes the PMs and not the members also?

~thanks

[perplexed]

*waits 24hrs*

bump

can someone clarify for me please, I don't want to mess this up

~thanks

[perplexed]

anyone know the answer?

[margarett]

Yes you can see in the code that it does not harm your users. It deletes PMs and then set the "pm count" to "0"

[perplexed]

thanks margarett but I have not done this before, is there more instructions on what to do?

Do I enter each line as a separate query?
What else do I have to select?

Sorry but I'm new at this side of things

[margarett]

You open "phpmyadmin" and select your SMF DB

Then you select a tab "SQL". There you can enter those commands. Use one at a time...

Remember to backup

[perplexed]

whoo hoo, that worked a treat, just what I needed, thanks again

*wonders what else I can do with this*

[margarett]

You can do alot, indeed. But you can also mess up pretty much, if you don't know what you are doing...

[perplexed]

lol yeah well that's why I'm so cautious  

[redone]

Indeed be careful when using phpmyadmin as you could potentially cause some serious damage to your database. As ever, always make sure you have a good and up to date backup.

[margarett]

Well, and delete only read ones, is it possible?

[usrfsledge]

Code Select Expand

TRUNCATE `smf_personal_messages`

Code Select Expand

TRUNCATE `smf_pm_recipients`

Code Select Expand

UPDATE `smf_members` SET `instant_messages`= '0', `unread_messages`='0'

Little fix in last line of code for current version. Job done, thanks!

[Irisado]

Thanks for the information, however, please do not revive topics which are so old in future.  Topic locked.