Closed Bug 496272 Opened 15 years ago Closed 14 years ago

"Firefox" forum titles/entries don't show up for posts older than time_control even though they are counted in the pagination

Categories

(support.mozilla.org :: Forum, task)

x86
All
task
Not set
normal

Tracking

(Not tracked)

RESOLVED INCOMPLETE
Future

People

(Reporter: stephend, Unassigned)

References

()

Details

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.
Severity: blocker → normal
Summary: "Firefox" forum titles/entries don't show up → "Firefox" forum titles/entries don't show up for posts older than time_control even though they are counted in the pagination
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?
Target Milestone: 1.1 → 1.2
Forum UX milestone?
Target Milestone: 1.2 → Future
Old code.
Status: NEW → RESOLVED
Closed: 14 years ago
Resolution: --- → INCOMPLETE
You need to log in before you can comment on or make changes to this bug.