Is there any way to clear the total of private messages?
You mean as a user (and only your own) or as an admin (and all messages of all users) ?
Is possible to clear the private messages table on your database?
There are many things you could mean by "clear total messages". Do you mean remove the bit that says "(Unread 0, Total 1,829)"? OR delete all your messages?
Yes I meant private messages totals for all users. for example (Unread 0, Total 35)
Run the following query in phpmyadmin;
DELETE FROM `mybb_privatemessages` WHERE `status` = '1' AND `folder` = '1';
This will delete all Read PMs from Inbox Folder.
is there any way just to delete the total private messages count without actually deleting read pm's?
Just run this;
DELETE FROM `mybb_privatemessages`;
Its always advised to take Backup of
mybb_privatemessages table.
After running the above query, Go to: ACP > Tools and Maintenance > Cache Manager > usergroups > and Rebuild Cache.
hmmm still not clearing the total messages for some reason
I've tested, and its confirmed. It should do it. Make sure you are using this on correct database. Also make sure you've Recount and rebuild Stats counter.