#1 ✓invalid

Combination issues - acts_as_ferret scored search, will_paginate and mysql

Reported by Jens | January 30th, 2010 @ 10:56 AM

I am currently running the latest ferret (0.11.6), acts_as_ferret(0.4.4)
and will_paginate(2.3.11) running against a mysql database. I have a
search with conditions (member.published_at IS NOT NULL) intended to be
ordered by ferret score and paginated. However, every attempt to display
the results in sequence order by ferret_score is failing.

For example, if I have 150 matching records and a page length of 30
records, the first 30 records returned are the oldest 30 records of the
150 sorted by score. The next 30 records returned include rows with
ferret scores that are higher then records in the first set of 30, but
newer records (have a larger primary key) and are hence returned in the
second page of results.

So, it appears that you cannot paginate a ferret score based search with
this combination of plugins. Is that true or am I doing something
woefully wrong?

Comments and changes to this ticket

  • Jens

    Jens September 14th, 2010 @ 05:52 PM

    • State changed from “new” to “invalid”
    • Milestone order changed from “0” to “0”

    using will_paginate on top of aaf search results won't work. However aaf mimics will_paginate's behaviour by having it's own :page and :per_page options.

Please Sign in or create a free account to add a new ticket.

With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.

New-ticket Create new ticket

Create your profile

Help contribute to this project by taking a few moments to create your personal profile. Create your profile ยป

Shared Ticket Bins

People watching this ticket