This version fixes a critical issue with private messages counts that has existed since version 3.2.12. If you are using versions 3.2.12 and 3.2.13 you should update ASAP!
This is one of these bugs that stares you in the face but for whatever reason I couldn't see. Essentially what happens is that if just one subscriber opts to have private messages in their digest AND elects to have them marked as read, it resets the unread and new private message counts for ALL users!
There are two things you need to do to get things right again:
- Update to version 3.2.14 ASAP. See links above.
- Execute some SQL to fix the private message counts
- Check your
config.phpfile to determine the value of your table prefix, which is typicallyphpbb_. If it's notphpbb_, write it down. Also, note the name of your forum's database in the file. - Start phpMyAdmin. It's usually available in your web host control panel.
- Select the database containing your forum.
- Execute the SQL below, changing
phpbb_if your table prefix is different.
Code: Select all
UPDATE phpbb_users u
SET user_new_privmsg = (SELECT if(sum(pm_new) IS NULL, 0, sum(pm_new))
FROM phpbb_privmsgs_to pt
WHERE pt.user_id = u.user_id AND folder_id IN (-3, -4)),
user_unread_privmsg = (SELECT if(sum(pm_unread) IS NULL, 0, sum(pm_unread))
FROM phpbb_privmsgs_to pt
WHERE pt.user_id = u.user_id AND folder_id <> -2);