How to delete unread messages?

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Get Involved
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
bhbebe
Registered User
Posts: 81
Joined: Tue Apr 07, 2009 9:24 am

How to delete unread messages?

Post by bhbebe » Wed Oct 09, 2013 8:04 am

HI,

This "5 unread messages" appered and It won't go away. It is some sort of bug or something. Once SPAM user sent it to all users, but when I deleted that SPAM user and all of its posts, those messages stayed somewhere, but not in my inbox.
How to remove this?

Image

Best regards!

User avatar
Blackwolf_Oz
Registered User
Posts: 264
Joined: Sat Jan 02, 2010 5:15 am
Location: Melbourne Australia
Name: Nick
Contact:

Re: How to delete unread messages?

Post by Blackwolf_Oz » Wed Oct 09, 2013 8:29 am

Fix with the following query:

Code: Select all

UPDATE phpbb_users SET user_new_privmsg = 0 WHERE user_id = 151944 LIMIt 1;
You can make a script that will cycle through the users and recount their private messages, but a simpler solution is to just reset everyone to 0. You can do it with the following query:

Code: Select all

UPDATE phpbb_users SET user_new_privmsg = 0;
We are Anonymous. We are Legion. We do not forgive. We do not forget. Expect us.

Ultimate Edition, Ultimate Edition Oz, Oz Unity

Locked

Return to “[3.0.x] Support Forum”