Page MenuHomePhabricator

Backwards scrolling at Special:Whatlinkshere is broken
Closed, ResolvedPublic

Description

From http://lists.wikimedia.org/pipermail/wikitech-l/2007-March/030644.html

Revision: 20616

Author: raymond
Date: 2007-03-22 01:22:24 -0800 (Thu, 22 Mar 2007)

Log Message:

  • (bug 4624) Namespace selection for Special:Whatlinkshere

Found another bug: scrolling backwards at Special:Whatlinkshere was broken

since ?

'previous' shows always the first page in reversed order but not the real

previous page.

Fixed now by changing backwards scrolling mechanism.

Ok, together with r20714 (removing unsed variable only) the backwards
scrolling isn't completely fixed :-(

The current version is a little bit better because it is possible to
scroll once back, the second click jumps to the beginning of the list in
correct order.

The previous version jumps at the first backwards click to the beginning
of the list, in reversed order.

I think we need a database request to figure out the offset for every
backwards scrolling in dependency of the current page and the limit. But
I do not know how to do this in the cheapest way, without melting the
servers :-(


Version: 1.10.x
Severity: normal

Details

Reference
bz9487

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 21 2014, 9:38 PM
bzimport set Reference to bz9487.
bzimport added a subscriber: Unknown Object (MLST).

ayg wrote:

What this needs is a "to" parameter, to specify a maximum id. Pseudo-code would be:

SELECT ... FROM table WHERE id < 1234 ORDER BY id DESC LIMIT 50

Then you need to reverse the result set in PHP.

ayg wrote:

Should be fixed by Aaron in r35371.

r35371 and friends reverted as they don't work on MySQL 4.0.

  • Bug 19236 has been marked as a duplicate of this bug. ***
  • This bug has been marked as a duplicate of bug 6424 ***