I recall reading something about this issue when the last major upgrade of MT occured, but I think there is still a problem with it.

They fixed it so that if a comment goes into moderation, it doesn't rebuild the indexes. This is good, as it keeps any comment listings on the index from being changed to reflect comments that aren't approved yet. However, I've found that if someone posts a legit comment after the moderated comment--if that moderated comment is at that time still awaiting approval or deletion--that when the indexes are rebuilt, the comment listings reflect the latest comments, which include moderated entries.

The code I use on my main index is below:



This list provides the linked entry names of the last 5 posts to be commented on from 2 of my blogs. It also displays the name of the last person who commented on each of these 5 entries. When the situation I described above occurs, an entry that possesses a comment in moderation will appear on the list--but since the comment is not there yet, it will either display the name of the last legit commenter on that entry or else display a blank where the name should be.

I didn't have as much of an issue with this prior to upgrading to v.3.2 because I used MT-Blacklist which outright banned much of my spam. But now that I am using SpamLookup with the Junk folder, this problem happens frequently as it doesn't outright stop the entries from coming through, but rather gathers them in a folder and allows them to write to the database.

I was just wondering if SA was aware of this bug and if there were any plans to fix it. SpamLookup has so far been more successful at keeping spam from appearing on my site, but the result is that if I want my recently commented list to be accurate, I will have to constantly login to my admin and delete the junk and then rebuild the index.