MASS delete all PM's in 3.5

[skipper1972]

Just recently switched my entire board over to a new site and I was Looking for a querry or a way to delete all the PM's on my board. I found a querry for vb 3.0x versions But i dont believe that will work for 3.5.

Any help much apprecaited. Thanks

[jmaldo]

Looking for this myself. Im sure someone here has the answer.


I tried this query, but no dice.

https://vborg.vbsupport.ru/showthread.php?t=103362&highlight=mass+pm+delete

[skipper1972]

Can I jsut delete the entire table pmtext table and make another one?

Anyone?

[Marco van Herwaarden]

The you could better do a: TRUNCATE TABLE pm.

But all your counters will be off, members will seem to have PM's but they are gone.

[skipper1972]

The you could better do a: TRUNCATE TABLE pm.

But all your counters will be off, members will seem to have PM's but they are gone.


Its a fresh board...0 posts basically. I ran that querry and all pm's are gone. Thank you.

Now, is there anyway to reset the counters on the data?

Thanks in advance

[stinger2]

did you try all these 4 queries......?? or just the truncate PM one??

UPDATE `user` SET `pmtotal` = '0',`pmunread` = '0';
TRUNCATE TABLE `pm`;
TRUNCATE TABLE `pmtext`;
TRUNCATE TABLE `pmreceipt`;

[skipper1972]

Excellent thank you very much Stinger2 & Marco. IT worked.

Cheers

[stinger2]

you are welcome .....glad to be of help