Pagination missing latest pages and posts
-
I have a topic (seems to just be one at the moment) where page 580 (yeah it's a long thread!) is the last page shown when the user is viewing the forum in pagination mode instead of infinite scroll mode, and the final post is one from about 4 days ago.
However, there have been about 70 new replies to the topic since then, which are visible if one uses infinite scroll mode and scrolls to the bottom.
It's like the pagination just froze at page 580 and isn't updating any more.
I've tried rebuilding and restarting to clear the caches, but this hasn't resolved it.
Anyone ever faced this or have any ideas what's going on?
nodebb version is 3.1.4.
-
In that case you can run below queries in redis to check the topic and it's post count values and fix them if they are out of sync.
Get real reply count
zcard tid:<topic_id>:posts
Check stored value in topic hash
hget topic:<topic_id> postcount
Now, if the return from the second query isn't equal to result of the zcard + 1 then you can run below query to fix it.
hset topic:<topic_id> postcount <correct_value>
Replace
<topic_id>
with the id of the topic and<correct_value>
with the result of the first query + 1.Let me know if that fixes the pagination issue.
-
In that case you can run below queries in redis to check the topic and it's post count values and fix them if they are out of sync.
Get real reply count
zcard tid:<topic_id>:posts
Check stored value in topic hash
hget topic:<topic_id> postcount
Now, if the return from the second query isn't equal to result of the zcard + 1 then you can run below query to fix it.
hset topic:<topic_id> postcount <correct_value>
Replace
<topic_id>
with the id of the topic and<correct_value>
with the result of the first query + 1.Let me know if that fixes the pagination issue.
-