phpbb_ for the table prefix if it differs in your config.php file: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);update_pm_counts() function in /includes/functions_privmsgs.php.Considering how many times this extension and mod has been reviewed over the years it's surprising that it's not been caught and no one has complained.
I'm also moving some SQL inside transactions to ensure consistency when updating both private message and user tables.
These will be addressed in a 3.2.14 release.
It should be noted that this behavior could occur only if you have the checkbox "Mark as read when they appear in the digest" next to the private message setting for Post settings in the Digests user control panel.
