Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

paging through entries filtered by tag losing some entries and repeating others #2883

Open
kareila opened this issue Feb 21, 2021 · 1 comment · May be fixed by #3018
Open

paging through entries filtered by tag losing some entries and repeating others #2883

kareila opened this issue Feb 21, 2021 · 1 comment · May be fixed by #3018

Comments

@kareila
Copy link
Member

kareila commented Feb 21, 2021

Detailed report here: https://www.dreamwidth.org/support/see_request?id=43162

Summary: user keeps changing the "Skip N" value for their journal, and whichever amount is skipped, the Nth entry will be repeated at the top of the next page, and the N+1-th entry will not be shown.

@kareila
Copy link
Member Author

kareila commented Mar 7, 2021

@momijizukamori determined that this is most likely caused by a bad sorting in the recent_items query: https://github.com/dreamwidth/dw-free/blob/c8e8ae70f324c67b7794439f3706e8a7500740c4/cgi-bin/DW/Logic/LogItems.pm#L586 Should be ordered by jitemid desc instead of (or in addition to) journalid; otherwise entries in the same journal with identical timestamps won't be sorted consistently, which is what was happening in the community that reported the problem.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment