After upgrading from 7.x-2.3 to 7.x-2.4, I noticed that the "Last Post" field mostly shows the correct information, but is sometimes "n/a" in the main forums page even if there are topics & posts. It also looks like the more time has passed since the last post, the higher chance that it'll say "n/a". I tried emptying the cache and also reverting back to 7.x-2.3 to confirm that the issue disappears and is specific to 7.x-2.4. Does anyone else have this problem?

CommentFileSizeAuthor
#6 empty-last-post-2302403-6.patch1.72 KBAlexKirienko
Last Post Empty.png31.61 KBjay.lee.bio
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

akinliat’s picture

akinliat CreditAttribution: akinliat commented

I can confirm. I get the same result -- forums that have no new posts eventually have the last post replaced with "n/a" in 7.x-2.4. I reverted to 7.x-2.3, and the last posts all reappeared.

Elin Yordanov’s picture

Elin Yordanov CreditAttribution: Elin Yordanov commented

I can confirm this bug which is introduced after 7.x-2.4 upgrade.

gratefulsk’s picture

gratefulsk CreditAttribution: gratefulsk commented

I'm getting this too. I have 6 forums and 4 of them say n/a. When I disable advanced forum every cell in the Last Post column gets populated. Does anyone know how to fix this?

Elin Yordanov’s picture

Elin Yordanov CreditAttribution: Elin Yordanov commented

@gratefulsk install 7.x-2.3 version of Advanced Forum and don't update it until this issue is solved.

You can download it here:
https://www.drupal.org/node/2036631

adwuk’s picture

adwuk CreditAttribution: adwuk commented

I have the same problem, and reverting back to 2.3 certainly resolves the issue. Looking at the changes in 2.4, I'm guessing that the problem is somewhere in core-overrides.inc where there was the introduction of cached forum counts and a new query for last edited nodes.

AlexKirienko’s picture

AlexKirienko CreditAttribution: AlexKirienko at WikiJob commented
Version: 7.x-2.4 » 7.x-2.x-dev
Status: Active » Needs review
FileSize
empty-last-post-2302403-6.patch1.72 KB

Hi.

I have faced similar problem. After research I have found source of problem - "Subquery optimization for last commented node" - https://www.drupal.org/node/2222861

With such optimization last post will be searched in last 1000 posts. And If you have few forums with very old posts, like I have, Latest post in such forum will be outside of 1000 latest posts.

Please check attached patch for latest dev version. It will increase limit to 10000 posts to search, and add settings to change this value if needed.

DrCord’s picture

DrCord CreditAttribution: DrCord commented

I can also confirm this problem and that the patch in #6 fixes the problem. TYVM for the patch!

podarok’s picture

podarok
🇺🇦 he/him/his
Primary language Ukrainian
Location Ukraine
CreditAttribution: podarok commented
Status: Needs review » Fixed

thanks, commited

  • podarok committed 0a38abb on 7.x-2.x authored by AlexKirienko 
    Issue #2302403 by AlexKirienko, DrCord: Last post is sometimes n/a?

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.