Zend\Paginator\Paginator's getItem() trigger an "Fatal error: ..."

[tasmaniski]

Fatal error: Cannot use object of type Zend\Db\ResultSet\ResultSet as array

I got this error in Zend\Paginator\Paginator when I call method getItem()

Eg:

$select = $myMapper->getSqlSelect();
$resultSet = new ResultSet();
$paginatorAdapter = new DbSelect($select, $myMapper->getAdapter(), $resultSet);
$paginator = new Paginator($paginatorAdapter);

//echo get_class($paginator); Zend\Paginator\Paginator
$paginator->getItem(1);

[samsonasik]

could you try remove , $resultSet from the DbSelect parameter list, i'm not test it, but it should be ok with :

 $paginatorAdapter = new DbSelect($select, $myMapper->getAdapter());

[tasmaniski]

Still same...
I guess it's a bug, but I am waiting for someone else to confirm too.

[samsonasik]

I've tested with Album module from zf2 doc and its work. i've tested with :

     public function fetchAll($paginated=false)
     {
     $sql = $this->tableGateway->getSql();

         if ($paginated) {
             $paginatorAdapter = new DbSelect(
                 $select,
                 $this->tableGateway->getAdapter()
             );

             $paginator = new Paginator($paginatorAdapter);
             return $paginator;
         }

         $resultSet = $this->tableGateway->select();
         return $resultSet;
     }

could you confirm what your code as :

$select = $myMapper->getSqlSelect();

?

[tasmaniski]

Thanks for replay..

I just cloned a fresh install of ZF2(skeleton app) and pass through tutorial from the web site
http://framework.zend.com/manual/2.2/en/tutorials/tutorial.pagination.html#modifying-the-albumtable

Everithing works fine, as long as you don't call the function getItem()

public function fetchAll($paginated = false)
{
    if($paginated){
        $select             = new Select('album'); //Zend\Db\Sql\Select
        $resultSetPrototype = new ResultSet(); //Zend\Db\ResultSet\ResultSet
        $resultSetPrototype->setArrayObjectPrototype(new Album());
        $paginatorAdapter   = new DbSelect($select, $this->tableGateway->getAdapter(), $resultSetPrototype);
        $paginator          = new Paginator($paginatorAdapter); //Zend\Paginator\Paginator

        //$paginator->getItem(1); // Trigger fatal error

        return $paginator;
    }

    $resultSet = $this->tableGateway->select();
    return $resultSet;
}

the same situation is on my work computer as well on my home laptop
and I am using Ubuntu with Apache.

[samsonasik]

oops, yes. I think it's actually an issue. I think on Paginator::getItem() should be changed before $page[$itemNumber - 1]:

        if (!is_array($page)) {
            $temp = array();
            foreach($page as $p) {
                $temp[] = $p;
            }
            $page = $temp;
        }

[samsonasik]

the actual issue is on Zend\Paginator\Adapter\DbSelect::getItems that need return array instead of Zend\Db\ResultSet\ResultSet

[samsonasik]

@tasmaniski I give a try at PR #6817 for it.

[UFOMelkor]

Fixed in #6817