Digests

Digests 3.2.14 released - critical bugs fixed - update ASAP! - Digests

Digests 3.2.14 released - critical bugs fixed - update ASAP!

by MarkDHamill » Fri Jun 14, 2019 9:52 pm

Digests version 3.2.14 is released. It can be downloaded from GitHub or from my digests extensions page.

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
To fix the private message counts, you will need to run some SQL. Typically this is done using phpMyAdmin. This discusses how to do it with phpMyAdmin:
  • Check your config.php file to determine the value of your table prefix, which is typically phpbb_. If it's not phpbb_, 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.
Here is the SQL:

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);
Sorry for the error.
Need phpBB services or a phpBB consultant? I offer most phpBB services. Getting lost managing phpBB? Buy my book, Mastering phpBB Administration. Kindle and paper versions available.
User avatar
MarkDHamill
Registered User
Posts: 4152
Joined: Fri Aug 02, 2002 12:36 am
Location: Florence, MA USA
Contact:

Re: Digests 3.2.14 released - critical bugs fixed - update A

by MarkDHamill » Fri Jun 14, 2019 11:06 pm

Also, for translators, there was one language file addition, but it was to turn a log file language string into one that is used interactively, so I made the change for you to your language files. In some cases I changed the ordering. Compare your language file in GitHub to see how they were changed:

https://github.com/MarkDHamill/digests/ ... 3...3.2.14
Last edited by MarkDHamill on Wed Jul 03, 2019 9:21 pm
Need phpBB services or a phpBB consultant? I offer most phpBB services. Getting lost managing phpBB? Buy my book, Mastering phpBB Administration. Kindle and paper versions available.
User avatar
MarkDHamill
Registered User
Posts: 4152
Joined: Fri Aug 02, 2002 12:36 am
Location: Florence, MA USA
Contact:

Re: Digests 3.2.14 released - critical bugs fixed - update A

by MarkDHamill » Sat Jun 15, 2019 1:35 am

One minor new feature in this release: any private message notifications are now marked as read, in addition to marking new and unread private message in the interface. This only applies if you want private messages appear as read if they appear in the digest.
Need phpBB services or a phpBB consultant? I offer most phpBB services. Getting lost managing phpBB? Buy my book, Mastering phpBB Administration. Kindle and paper versions available.
User avatar
MarkDHamill
Registered User
Posts: 4152
Joined: Fri Aug 02, 2002 12:36 am
Location: Florence, MA USA
Contact:

Re: Digests 3.2.14 released - critical bugs fixed - update A

by sbloomer » Fri Jul 12, 2019 1:38 pm

Is this version OK on 3.2.7? I want to update my phpBB.
sbloomer
Registered User
Posts: 87
Joined: Fri Jun 12, 2009 8:18 pm
Contact:

Re: Digests 3.2.14 released - critical bugs fixed - update A

by MarkDHamill » Fri Jul 12, 2019 1:52 pm

Yes, there should be no problem.
Need phpBB services or a phpBB consultant? I offer most phpBB services. Getting lost managing phpBB? Buy my book, Mastering phpBB Administration. Kindle and paper versions available.
User avatar
MarkDHamill
Registered User
Posts: 4152
Joined: Fri Aug 02, 2002 12:36 am
Location: Florence, MA USA
Contact: