ActionView::Template::Error (undefined method `expr' for 15:Fixnum) Rails 4.2.3

[lustremedia]

Using Rails 4.2.3
Using will_paginate (3.0.7)

When calling:

def index
    @user = User.order("ID DESC").paginate(page: params[:page], per_page: 15)
end

I got following error ActionView::Template::Error (undefined method expr' for 15:Fixnum)` not much more in the stack trace.

The error seems to occur when the user objects are looped in the view.

<% @users.each do |user| %>
...

Works fine:

def index
  @user = User.all
end

[Seralto]

I'm having this issue with Firebird database.
What DB are you using?

[lustremedia]

@Seralto I am on Oracle!

[Seralto]

This is strange @lustremedia, because the gem has a conditional to Oracle in active_record.rb file:

...
oracle = self.connection.adapter_name =~ /^(oracle|oci$)/i
if oracle
  query = <<-SQL
    SELECT * FROM (
      SELECT rownum rnum, a.* FROM (#{query}) a
      WHERE rownum <= #{pager.offset + pager.per_page}
    ) WHERE rnum >= #{pager.offset}
  SQL
 ...

[lustremedia]

Strange, could it be the ordering that causes the issue?

[Seralto]

I don't know, I'm having problems with Firebird and I can't find a solution...

[mateusnava]

I have the same problem :-(. @Seralto, did you fix this?

[Seralto]

Hi @mateusnava, I changed my database to PostgreSQL and it solve my problem.
But if you are using "https://github.com/rowland/activerecord-fb-adapter", try to include the git path to the adapter in your Gemfile: gem 'activerecord-fb-adapter', git: "https://github.com/rowland/activerecord-fb-adapter"

[mateusnava]

@Seralto, is not working, for this moment I make a (sux) "monkey patch".

class Fixnum
def expr
self
end
end


[Seralto]

@mateusnava, use gem 'activerecord-fb-adapter', '~> 1.0', '>= 1.0.3'.
This works for me.

[mislav]

Closing as most likely an issue with the database adapter. This library has no invocation of expr.