While testing bug 467483, I noticed that the "Firefox" forum topic has " Page 1 of 6287 Next »", but not actual forum titles appearing on http://support-stage.mozilla.org/tiki-view_forum.php?locale=en-US&forumId=1.
This is actually a problem on my local machine too. I believe only recent forum threads are being displayed, even though the count below shows the total number. Since we're not active on stage, this is noticeable. AFAIK, this is a separate bug that doesn't relate to bug 467483, and it's been there for as long as I can remember. Not sure how prevalent it is on production, since I don't spend a lot of time on the forums. Cheng, got any input? (if i remember well, the problem lies in the queries)
Happens on prod too if you go back far enough... https://support.mozilla.com/tiki-view_forum.php?locale=en-US&forumId=1&comments_threshold=0&thread_sort_mode=lastPost_desc&comments_per_page=20&time_control=1209600&poster=&issue_solved=&reply_state=&comments_offset=100000 I'm guessing it has to do with the time_control parameter in the URL as that seems to limit things to 2 weeks and bumping it up a factor of 10 (to 20 weeks) makes things work again.
This bug reminds me of another bug about the actual count (# of pages) not being the one displayed. I can't remember which... but it was fairly recent. Anyone?
time_control was added in https://bugzilla.mozilla.org/show_bug.cgi?id=452953 to deal with massively slow queries. Perhaps the queries are better now and we can get rid of it. Anyhow, we've lived with this for a bunch of months so it's obviously not a blocker. I wouldn't be against a better fix for slow queries than this sledgehammer approach but it shouldn't block 1.1.
I'm not very confident of being able to get rid of the time_control parameter just because of the sheer amount of records added to the tiki_comments table every day. Should this bug be able making the pagination use the time_control param in its query?
Forum UX milestone?