# \[SOLVED\] Pagination by sort error

**URL:** <https://discourse.cakephp.org/t/solved-pagination-by-sort-error/10795>\
**Category:** Need Help\
**Tags:** help\
**Created:** [November 28, 2022, 11:03am UTC](https://discourse.cakephp.org/t/solved-pagination-by-sort-error/10795 "2022-11-28T11:03:03Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ed3](https://avatars.discourse-cdn.com/v4/letter/e/4af34b/32.png) [@ed3](https://discourse.cakephp.org/u/ed3)\
**Post date:** [November 28, 2022, 11:03am UTC](https://discourse.cakephp.org/t/solved-pagination-by-sort-error/10795/1 "2022-11-28T11:03:03Z")

</div>

Pagination by sort gives me the error:  
`strpos() expects parameter 1 to be string, int given`  
Tested with: Cakephp 4.4.7, php 7.4  
CORE\src\Datasource\Paging\NumericPaginator.php line 607

---

<div class="post-metadata">

**Author:** ![KevinPfeifer](https://yyz1.discourse-cdn.com/flex029/user_avatar/discourse.cakephp.org/kevinpfeifer/32/3365_2.png) [@KevinPfeifer](https://discourse.cakephp.org/u/KevinPfeifer)\
**Post date:** [November 28, 2022, 11:58am UTC](https://discourse.cakephp.org/t/solved-pagination-by-sort-error/10795/2 "2022-11-28T11:58:20Z")

</div>

Can you post your `->paginate()` method? It should look like this:

```auto
$this->paginate($query, ['order' => ['MyTable.name' => 'asc']])

```

or if you use the controller property something like this

```auto
class ArticlesController extends AppController
{
    public $paginate = [
        'order' => [
            'MyTable.name' => 'asc'
        ]
    ];
}

```

See [Pagination - 4.x](https://book.cakephp.org/4/en/controllers/pagination.html#advanced-usage)

---

<div class="post-metadata">

**Author:** ![ed3](https://avatars.discourse-cdn.com/v4/letter/e/4af34b/32.png) [@ed3](https://discourse.cakephp.org/u/ed3)\
**Post date:** [November 28, 2022, 12:35pm UTC](https://discourse.cakephp.org/t/solved-pagination-by-sort-error/10795/3 "2022-11-28T12:35:30Z")

</div>

Order type was missing in my code:  
`'order' => ['MyTable.name']`