PDOException Zf2 with Postgresql

Question

Hi I have a problem with Zend Framework 2.

File:
/home/marketplace/htdocs/vendor/zendframework/zendframework/library/Zend/Db/Adapter/Driver/Pdo/Statement.php:240
Message:
SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "users" does not exist
LINE 1: ...ELECT COUNT(1) AS "c" FROM (SELECT "users".* FROM "users") A...
                                                         ^

In my model I have

public function fetchAll($paginated=false)
{
    if($paginated) {
        $select = new Select('users');
        $select->order('id DESC');
        $resultSetPrototype = new ResultSet();
        $resultSetPrototype->setArrayObjectPrototype(new User());
        $paginatorAdapter = new DbSelect(
            $select,
            $this->tableGateway->getAdapter(),
            $resultSetPrototype
        );
        $paginator = new Paginator($paginatorAdapter);
        return $paginator;
    }
    $resultSet = $this->tableGateway->select(function(Select $select){
        $select->limit('30')->order('id DESC');
    });
    return $resultSet;
}

What is strange is that in locale server everything is working... Any suggestion where to find the problem? Thanks

UPDATE:

If I do the same query directly,

$sql = 'SELECT COUNT(1) AS "c" FROM (SELECT "users".* FROM "users") AS "original_select"';
$resultSet = $this->tableGateway->getAdapter()->query($sql);
return $resultSet;

everything is ok.

Perhaps demonstrate that you do really have a "users" table on the live server. Otherwise the message is pretty clear. — Richard Huxton
– Richard Huxton, Commented Aug 21, 2013 at 15:18
Then you are connecting as a different user, or to a different database, or the search-path is being fiddled with. — Richard Huxton
– Richard Huxton, Commented Aug 21, 2013 at 15:24

Igor · Accepted Answer · 2013-08-23 08:14:46Z

1

I found the problem.

The search-path of Postgresql was setted to another Schema and not to main schema "public"

Thanks to Richard!

answered Aug 23, 2013 at 8:14

Igor

411 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PDOException Zf2 with Postgresql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related