Lighthouse has a new layout. Prefer the old one? Return to the old layout, and switch back any time from the link at the top of each page.

will_paginate appends more limits to already-limited sql

#227

I have a SQL statement which UNIONs 4 SQLs together.

The SQL also contains a GROUP BY and an ORDER BY.

When clicking Next in the view page, end up with a SQL that ends:

LIMIT 0, 5 LIMIT 5, 5

and causes a failure.

Using MySQL

Rails 2.0.2

Mac OSX 10.4

Latest will_paginate gem (installed today).

Reported by Adrian · May 29th, 2008 @ 05:51 PM

State: resolved
Milestone: none
Assigned to: Mislav Mislav

Activity

  1. Mislav
    Mislav

    I'll have to see how you are making the call to will_paginate and how is it

    integrated in the controller.

    http://pastie.org

    On Thu, May 29, 2008 at 5:52 PM, Lighthouse

    wrote:

    May 29th, 2008 @ 07:25 PM

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.