[Koha-bugs] [Bug 15331] New: Sort order breaks at offset=1000 (both OPAC and Intranet)

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15331

            Bug ID: 15331
           Summary: Sort order breaks at offset=1000 (both OPAC and
                    Intranet)
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Searching
          Assignee: gmcharlt at gmail.com
          Reporter: barton at bywatersolutions.com
        QA Contact: testopia at bugs.koha-community.org

To re-create:

1) Go to the advanced search page, in either Staff Client or OPAC.
2) Run a search which will return many thousands of results, sort by A-Z
3) Go to the page prior to offset=1000 (i.e. page 50 if you have 20
results/page or 40 if you have 25 results/page). This page will be properly
sorted alphabetically.
5) Go to the next page. This will *not* be sorted alphabetically.

Example:

http://catalog.bywatersolutions.com/cgi-bin/koha/opac-search.pl?&limit=mc-itype%2Cphr%3ABOOK&offset=980&sort_by=title_az

The results are

Amazing armored animals / 
Amazing bats / 
Amazing birds / 
The amazing bone / 
The amazing book of bird records : the largest, the smallest, the fastest, and
many more! / 
Amazing buildings / 
Amazing buildings / 
Amazing dinosaur facts / 
Amazing flying machines / 
Amazing grace / 
Amazing grace / 
The amazing impossible Erie Canal / 
Amazing Leonardo da Vinci inventions you can build yourself : learn some
hands-on history! / 
The amazing life of Benjamin Franklin / 
The amazing life of birds : (the twenty-day puberty journal of Duane Homer
Leech) / 
An amazing machine / 
Amazing magic tricks : apprentice level / 
Amazing magic tricks : master level / 
Amazing mammals / 
The Amazing Maurice and his educated rodents / 

The next titles in the catalog should be

Amazing mazes : mind bending mazes for ages 6-60 /
The amazing Mrs. Pollifax 
The amazing odorous adventures of Stinky Dog /

Instead, we get

http://catalog.bywatersolutions.com/cgi-bin/koha/opac-search.pl?&limit=mc-itype%2Cphr%3ABOOK&offset=1000&sort_by=title_az

The history of Herodotus Thucydides. 
Hippocratic writings. 
The day after Roswell / 
The demon-haunted world : science as a candle in the dark / 
The UFO phenomenon / 
Champ, beyond the legend (updated edition) / 
Area 51 : the dreamland chronicles / 
UFO crash at Roswell : the genesis of a modern myth /  
Chaos : making a new science / 
The black swan : the impact of the highly improbable / 
PC annoyances : how to fix the most annoying things about your personal
computer / 
PC help desk in a book : the do-it- yourself guide to PC troubleshooting and
repair /  
The little Mac book / 
Where wizards stay up late : the origins of the Internet / 
Web design tools and techniques / 
Degunking your email, spam, and viruses / 
IPhone and iPad apps marketing : secrets to selling your iPhone and iPad apps / 
Office 2007 all-in-one desk reference for dummies / 
Windows 95 secrets /

-- 
You are receiving this mail because:
You are watching all bug changes.