If you think a bug might affect users in the 57 release, please set the correct tracking and status flags for Release Management.

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

RESOLVED INCOMPLETE

Status

support.mozilla.org
Forum
RESOLVED INCOMPLETE
8 years ago
7 years ago

People

(Reporter: stephend, Unassigned)

Tracking

unspecified
Future
x86
All

Firefox Tracking Flags

(Not tracked)

Details

(URL)

(Reporter)

Description

8 years ago
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)

Comment 2

8 years ago
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?

Comment 4

8 years ago
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

Comment 5

8 years ago
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

Comment 6

8 years ago
Forum UX milestone?
Target Milestone: 1.2 → Future
Old code.
Status: NEW → RESOLVED
Last Resolved: 7 years ago
Resolution: --- → INCOMPLETE
You need to log in before you can comment on or make changes to this bug.