RailsPlugins.org

Not working when setting per_page in the model

will_paginate 3.0.pre seems to have a problem with the .includes() syntax. This generates an error:

@users = User.joins(:profile).includes(:profile).order("last_name,first_name").paginate(:per_page => 3, :page => params[:page])

If I remove the .include(), the query/pagination works, but it results in the N+1 issue.

@users = User.joins(:profile).order("last_name,first_name").paginate(:per_page => 3, :page => params[:page])

I also noticed that this syntax ignores the page-size setting in the Model:
class User < ActiveRecord::Base
cattr_reader :per_page
@@per_page = 2
end

I was getting the error that a few others mentioned when trying to upgrade an existing app:
undefined method `paginate' for #...

I finally figured out that I left the following line out of my application.rb when I was doing the upgrade.. therefore the initializers in the railtie did not execute when the app server started:

Bundler.require(:default, Rails.env) if defined?(Bundler)

yup.. I might need that in there ;-)

Git Head version of rails on June 25th 2010 at 1:15pm EST

/gems/ree-1.8.7-2010.02/gems/will_paginate-2.3.14/lib/will_paginate.rb:39:in `enable_activerecord': undefined method `returning' for WillPaginate:Module (NoMethodError)

Was working with previously pulled version.

My mistake. For some reason bundle install downgraded my version of will_paginate to 2.3.14. Works after re-installing will_paginate 3

Almost works, except when setting the 'per_page' in the model using:

class Post < ActiveRecord::Base
self.per_page = 8
end

Number of results is not limited (documented here: http://github.com/mislav/will_paginate/tree/v3.0.pre).

To clarify further, the problem occurs when:

# returns 30 results
Company.where(:category => params[:category]).paginate(:page => params[:page]).count

But not when:

# returns 8 results
Company.paginate(:page => params[:page]).count

Yup! This is the line.
gem "will_paginate", :git => "http://github.com/mislav/will_paginate.git", :branch => "rails3"

Using:

# in Gemfile:
gem "will_paginate", :git => "http://github.com/mislav/will_paginate.git", :branch => "rails3"
# in Controller:
@customers = Customer.all.paginate(:per_page => 5, :page => params[:page])

gem "will_paginate", :git => "http://github.com/mislav/will_paginate.git", :branch => "rails3" (thanks stephan.hagemann)

gem "will_paginate", :git => "http://github.com/mislav/will_paginate.git", :branch => "rails3"

same error

http://groups.google.com/group/will_paginate/browse_thread/thread/2ae5ab07020221af/d44777a34aed6806?lnk=gst&q=rails+3#d44777a34aed6806

Trying to use includes or joins renders this no method error. If I remove either the paginate or the includes statement, it works fine.

undefined method `quote_table_name' for #

Put the following line into the Gemfile:

gem 'will_paginate', '3.0.pre'

Then run "bundle install"

That's the way I made it works.

gem "will_paginate", :git => "http://github.com/mislav/will_paginate.git", :branch => "rails3"

DEPRECATION WARNING: railtie_name is deprecated and has no effect. (called from /home/dpf/websites/authorigin/vendor/bundle/gems/will_paginate-3.0.pre/lib/will_paginate/railtie.rb:6)

Rails 3, beta3 breaks when using will_paginate 3.0.pre with undefined method `total_pages' for # error.

gem "will_paginate", :git => "git://github.com/seivan/will_paginate.git", :branch => "rails3"

I get the error "no method found paginate for Class"
through little debugging I found that the code does enter the initializer "will_paginate.active_record" do |app| block inside the lib/will_paginate/railtie.rb file.
i copied the two lines requiring /finders/active_record and pasted into the class level, then it worked.

sorry, error in my comments, i wanted to say the code does NOT enter the block.

make sure this is in your application.rb:

Bundler.require(:default, Rails.env) if defined?(Bundler)

I left it out and got the same error... initializer blocks don't run when app server is started without this line.

Breaks when I try to use the 'includes' method.

Caveats:

will_paginate 2.3 does not use the new scoping constructs built into ActiveRecord 3.0

I found that you have to convert it into something will_paginate understands, using #all, so for example:

instead of

Lenders.by_state('AR').order(:name).paginate(:per_page => 25, :page => 1)

You have to do

Lenders.by_state('AR').order(:name).all.paginate(:per_page => 25, :page => 1)

I have not checked 3.0pre yet though.

Hm, found the versioning selector here ...

3.0pre fixes all of my issues. Works great.

How is it being installed in rails3? Just putting it in my Gemfile and adding a require in environment hasn't been enough. Even after copying the rails3 branch into vendor/plugins I still get a CALCULATIONOPTIONS error.

I added a line to my Gemfile that looks like this:

gem 'will_paginate', '3.0.pre'

After that it just worked. I wanted to change the previous and next labels so I created a will_paginate.rb initializer file and put my configuration there.

Hope that helps.

Hey Jack, you are not supposed to require it in your environment. Bundler should require it automatically for you, just take a look at config/application.rb and you will see Bundler.require.

Generated a new app, and it seems to be working there. Will see if I can track down what might be happening in the other.

Yep, that was the issue. Didn't have the newer config/application.rb setup. Generated the rails 3 app maybe a couple weeks back. Looks good now.