Page MenuHomePhabricator

Main topic list pagination can only paginate at most 500 topics (less sometimes, apparently due to moderation)
Open, MediumPublic

Description

I'm using https://www.mediawiki.org/wiki/Talk:Sandbox as an example, but it's not specific to that page.

This can be reproduced either by:

  • Patiently dragging down the scroll bar until you get to the end.
  • Turning off JS, copying the "Load more" link (blue button next to a page) link, changing 10 to 100 (the max), then opening that in a new tab. Continue opening the Load more in a new tab (you don't need to change the 10 after the first one). That means the first page is 10, the next four pages are 100, and the last page is currently 36 (446). It's not an even 500 because of moderation, I think.

Last one is currently https://www.mediawiki.org/w/index.php?title=Talk:Sandbox&topiclist_offset-dir=fwd&topiclist_limit=100&topiclist_offset=20140919202020&topiclist_sortby=updated .

The page has 972 topics:

mysql:research@x1-analytics-slave [flowdb]> SELECT COUNT(*) FROM flow_topic_list JOIN flow_workflow ON workflow_id = topic_list_id WHERE workflow_wiki = 'mediawikiwiki' AND workflow_namespace = 1 AND workflow_title_text = 'Sandbox';
+----------+
| COUNT(*) |
+----------+
|      972 |
+----------+
1 row in set (0.17 sec)

This is a consequence of the offset being done purely within the index, AFAICT:

See also T112230: History pagination does not work properly.

Event Timeline

Mattflaschen-WMF raised the priority of this task from to Unbreak Now!.
Mattflaschen-WMF updated the task description. (Show Details)
Restricted Application added a subscriber: Aklapper. · View Herald Transcript

That task has normal priority, this task has "Unbreak now" priority. Please correct. Thanks!

SBisson lowered the priority of this task from Unbreak Now! to Medium.Nov 30 2015, 11:34 AM
Mattflaschen-WMF renamed this task from Main topic list pagination can only paginate at most 500 topics to Main topic list pagination can only paginate at most 500 topics (less sometimes, apparently due to moderation).Jan 6 2016, 7:37 PM
jmatazzoni added a subscriber: jmatazzoni.

Hi Stephane, Triage team believes this may be fixed by the thing you're working on. That's why it's assigned to you. Is that so?

SBisson added a subscriber: SBisson.

Unfortunately, it's not the case. But it would be fixed by T147058: Remove Flow index layer