PM indicator count inaccurate?

[BadgerDog]

The indicator count of how many "unread" PM's exist seems to have got out of balance?

I logged onto the PM's area and deleted two of them without reading them. Now, I have no unread PM's showing, except the count on the main forum home page still shows as having one (1) unread PM?

How can I manually reset that counter to zero?

Thanks for any help, or posting a simple piece of code I can execute to do this....

Regards,
Badger

[Jase2]

UPDATE user SET pmunread = 'X' WHERE userid = 'X';

Replace X with the new total.
replace X with the user id.

[BadgerDog]

Thanks.... :up:

I assume I need to set-up direct access to the database from someplace other than the AdminCP function, as provided by vBulletin's standard software?

I'd also like to reset the "Threads" counter to zero as shown below:

Quick Moderation

Threads (4)
Posts (0)
Events (0)
Attachments (0)
Users (0)

Would you have a command I can excecute to do that?

Appreciate your help....

Regards,
Badger