will_paginate doubles the number of pages that are actually there.
Reported by Wayne Seguin | June 14th, 2007 @ 03:43 AM
I am trying to use will_paginate and am running into an issue
whereby the will_paginate helper displays double the number of pages that there physically are. I think it has to do with the fact that we're using quite a bit of custom finder code but cannot verify this as yet.
Is there a way to adjust the way total_pages is calculated? Perhaps using :count => parameter? I couldn't find how to use :count => documented anywhere to pursue this direction.
Comments and changes to this ticket
-
Mislav June 14th, 2007 @ 03:43 AM
- State changed from “new” to “invalid”
If you don't will_paginate to count your records, simply use the "total_entries" option. The value should be an integer and its presence makes the paginating finders skip the counting logic.
Total page number is then being calculated like this:
@total_pages = (@total_entries / @per_page.to_f).ceil -
Chris Wanstrath June 14th, 2007 @ 03:43 AM
This may or may not be fixed with changeset 258. Update the plugin and try again.
-
Wayne Seguin June 14th, 2007 @ 03:43 AM
It turns out that passing:
:count => { :select => "distinct o.id" }
fixed the issue for us.
Thanks for the response!
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.
Create new ticket
Create your profile
Help contribute to this project by taking a few moments to create your personal profile. Create your profile ยป
Everyone's favorite Ruby library for pagination of practically anything!
Wayne Seguin