Reset PM Totals in nav template

[sherykah]

I've purged the Private Messages from the database [pm, pmtext, pmreceipt,] optimized the database and updated counter in the Admin Panel but I still see the total of Private Messages at the top of the forum.

How do I reset the total to zero?

[Steve Machol]

To delete all PMs, run these 4 queries:

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

Of course, backup your database first.

[sherykah]

Thank you. The update worked.

[akia]

Thanks!!!! This has just sorted a problem out for me which I've been trying to solve for months.