UBB.Developers Forums UBB.threads 6 Bug Reports Togglesub bug (5.4.3)

In togglesub the section that grabs the last_post is missing the order by statement. At present it is retrieving the first post instead of the last. This means someone subscribing to a board using the Subscribe/Unsubscribe link within a forum will get every posting ever made to it when they get their digest. Ouch!

After line 73: [:blue]WHERE B_Board = '$Board_q'
Add [:red]ORDER BY B_Number DESC


Actually I did a max(B_Number) on the select rather than the order by but I don't know that all the other database systems use that. It works faster than the order by in mySQL though.

PS Scream, I am subscribed to this board and receiving two digests. One from the Perl system and another from the PHP system. Is it supposed to be doing that?

Interesting. Thanks for the note and fix for this.

As for the dual subscriptions. No, it shouldn't be doing that. I think there is an extra cron on the system somewhere that I cannot seem to track down.