# Wierd pagination problem - Unknown options: order?

**URL:** <https://www.ruby-forum.com/t/wierd-pagination-problem-unknown-options-order/61355>\
**Category:** Rails\
**Created:** [May 23, 2006, 1:34pm UTC](https://www.ruby-forum.com/t/wierd-pagination-problem-unknown-options-order/61355 "2006-05-23T13:34:09Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![printmkr](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/9f8e36/32.png) [@printmkr](https://www.ruby-forum.com/u/printmkr)\
**Post date:** [May 23, 2006, 1:34pm UTC](https://www.ruby-forum.com/t/wierd-pagination-problem-unknown-options-order/61355/1 "2006-05-23T13:34:09Z")

</div>

I am trying to use pagination with the order option. I am following  
examples I’ve seen all over the web, but I am getting an error. My code  
seems simple:

def list  
@upload\_pages, @uploads = paginate :uploads, :per\_page =\> 20, :order  
=\> ‘id’  
end

Yet I keep getting this error:

* * *

ActionController::ActionControllerError in Data#list

Unknown options: order

/app/controllers/data\_controller.rb:12:in `list’  
/home/bclinton/work/eds/script/server:51

* * *

If I take the order option out, it works fine. Anyone have any idea  
what I am doing wrong here?

---

<div class="post-metadata">

**Author:** ![printmkr](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/9f8e36/32.png) [@printmkr](https://www.ruby-forum.com/u/printmkr)\
**Post date:** [May 23, 2006, 1:40pm UTC](https://www.ruby-forum.com/t/wierd-pagination-problem-unknown-options-order/61355/2 "2006-05-23T13:40:47Z")

</div>

On 23-May-06, at 6:34 AM, Bill C. wrote:

> end  
> Try putting your parameters in parentheses:

@upload\_pages, @uploads = paginate ( :uploads, :per\_page =\>  
20, :order =\> ‘id’)

---

<div class="post-metadata">

**Author:** ![printmkr](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/9f8e36/32.png) [@printmkr](https://www.ruby-forum.com/u/printmkr)\
**Post date:** [May 23, 2006, 1:44pm UTC](https://www.ruby-forum.com/t/wierd-pagination-problem-unknown-options-order/61355/3 "2006-05-23T13:44:04Z")

</div>

On 23-May-06, at 6:38 AM, Mike O. wrote:

> Try putting your parameters in parentheses:
> 
> @upload\_pages, @uploads = paginate ( :uploads, :per\_page =\>  
> 20, :order =\> ‘id’)

oops - the space before/after the ( was unintentional.

---

<div class="post-metadata">

**Author:** ![printmkr](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/9f8e36/32.png) [@printmkr](https://www.ruby-forum.com/u/printmkr)\
**Post date:** [May 23, 2006, 2:06pm UTC](https://www.ruby-forum.com/t/wierd-pagination-problem-unknown-options-order/61355/4 "2006-05-23T14:06:00Z")

</div>

Mike O. wrote:

> On 23-May-06, at 6:34 AM, Bill C. wrote:
> 
> > end  
> > Try putting your parameters in parentheses:
> 
> @upload\_pages, @uploads = paginate ( :uploads, :per\_page =\>  
> 20, :order =\> ‘id’)

Thanks for the suggestion, it was something I hadn’t tried.  
Unfortunately I still get the same error. Here is my code now (the  
commented line works):

def list  
@upload\_pages, @uploads = paginate(:uploads, :per\_page =\> 20, :order  
=\> ‘id’)

# @upload\_pages, @uploads = paginate(:uploads, :per\_page =\> 20)

end

Here is the beginning of the trace in case it helps:

/vendor/actionpack/lib/action\_controller/pagination.rb:86:in  
`validate_options!' /vendor/actionpack/lib/action_controller/pagination.rb:110:in`paginate’  
/vendor/actionpack/lib/action\_controller/base.rb:756:in  
`perform_action_without_filters' /vendor/actionpack/lib/action_controller/filters.rb:295:in`perform\_action\_without\_benchmark’  
/vendor/actionpack/lib/action\_controller/benchmarking.rb:41:in  
`perform_action_without_rescue' /vendor/actionpack/lib/action_controller/benchmarking.rb:41:in`measure’

---

<div class="post-metadata">

**Author:** ![printmkr](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/9f8e36/32.png) [@printmkr](https://www.ruby-forum.com/u/printmkr)\
**Post date:** [May 23, 2006, 2:30pm UTC](https://www.ruby-forum.com/t/wierd-pagination-problem-unknown-options-order/61355/5 "2006-05-23T14:30:39Z")

</div>

On 23-May-06, at 7:06 AM, Bill C. wrote:

> Thanks for the suggestion, it was something I hadn’t tried.  
> Unfortunately I still get the same error. Here is my code now (the  
> commented line works):
> 
> def list  
> @upload\_pages, @uploads = paginate(:uploads, :per\_page =\>  
> 20, :order  
> =\> ‘id’)
> 
> # @upload\_pages, @uploads = paginate(:uploads, :per\_page =\> 20)
> 
> end

Are you using 1.1.2? :order option appears to have been added on  
August 23 - you could check actionpack/lib/action\_controller/  
pagination.rb (around line 70) for :order in this:

```
 DEFAULT_OPTIONS = {
     :class_name => nil,
     :singular_name => nil,
     :per_page => 10,
     :conditions => nil,
     :order_by => nil,
     :order => nil,
     :join => nil,
     :joins => nil,
     :count => nil,
     :include => nil,
     :select => nil,
     :parameter => 'page'
   }

```

I’m fairly new to this myself, so I’m not really sure what else to  
suggest if your stuff is all current.

---

<div class="post-metadata">

**Author:** ![printmkr](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/9f8e36/32.png) [@printmkr](https://www.ruby-forum.com/u/printmkr)\
**Post date:** [May 23, 2006, 5:02pm UTC](https://www.ruby-forum.com/t/wierd-pagination-problem-unknown-options-order/61355/6 "2006-05-23T17:02:35Z")

</div>

Hello there,

Bill C. wrote:

> Unknown options: order  
> I can’t really test it now but I think the problem is that the method  
> paginate does only expect two parameters, and you gave it three.

I would try something like this:

@upload\_pages, @uploads = paginate :uploads, {:per\_page =\> 20,  
:order =\> ‘id’}

I hope that helps.

## Greetings, Philipp

“They that can give up essential liberty to obtain a little temporary  
safety deserve neither liberty nor safety.” Benjamin Franklin

> **[Filzip home. Try a great, free zip program.](http://www.filzip.com)**
>
> FiZip. Try a great, free ZIP program (ZDNet). Filzip Homepage