Symfony2 - Notice: Undefined offset: 0 due to a custom Query

Question

I have this error :

"Notice: Undefined offset: 0 in C:\wamp\www\Videotheque\vendor\doctrine\lib\Doctrine\ORM\QueryBuilder.php line 240"

I am creating a video collection online. There are 2 entities : Film and Genre. In my GenRerepositorymethod, I tried to redefine the function findAll() to the number of films associated to a genre.

This is the function :

public function myFindAll()
{
    $genres = $this->_em->createQueryBuilder('g')
                        // leftJoin because I need all the genre
                        ->leftJoin('g.films', 'f')
                        ->addSelect('COUNT(f)')
                        ->groupBy('g')
                        ->getQuery()
                        ->getArrayResult();
    // $genres contains all the genres and the associated movies
    return ($genres);
}

What is the code around line 240 in `C:\wamp\www\Videotheque\vendor\doctrine\lib\Doctrine\ORM\QueryBuilder.php`? — Bailey Parker, Aug 01 '12 at 09:09
Its the definition of the method getRootAlias() : public function getRootAlias() { $aliases = $this->getRootAliases(); return $aliases[0]; } — Adrien G, Aug 01 '12 at 09:14
How about you stick a `var_dump($aliases);` in the middle there. What is the definition of `getRootAliases()`? — Bailey Parker, Aug 01 '12 at 09:19

score 6 · Answer 1 · answered Aug 02 '12 at 08:32

6

The Repository class provides the method for creating a QueryBuilder already configured for the entity so we can directly put :

$this->createQueryBuilder('g')

answered Aug 02 '12 at 08:32

Adrien G

1,086
2
14
32

score 1 · Answer 2 · answered Oct 24 '14 at 19:53

Found this issue myself and wanted to post my solution. Since you are creating a queryBuilder off of the EntityManager instead of an EntityRepository you need a from statement. The error arises when there is no from statement or if the from statement is out of order (the from needs to come before any join for it to be happy). The EntityRepository takes care of this for you when using it.

public function myFindAll()
{
    $genres = $this->_em->createQueryBuilder('g')
                        //from statement here
                        ->from('GenreEntityClass', 'g')
                        // leftJoin because I need all the genre
                        ->leftJoin('g.films', 'f')
                        ->addSelect('COUNT(f)')
                        ->groupBy('g')
                        ->getQuery()
                        ->getArrayResult();
    // $genres contains all the genres and the associated movies
    return ($genres);
}

score 0 · Answer 3 · answered Aug 01 '12 at 09:22

Try this:

public function myFindAll()
{
    $qb = $this->_em->createQueryBuilder('g');
    $qb->leftJoin('g.films', 'f')
       ->select($qb->expr()->count('f')) // Use an expression
       ->groupBy('g.id')                 // Specify the field
    ;

    $genres = $qb->getQuery()->getArrayResult();

    // $genres contains all the genres and the associated movies
    return ($genres);
}

Symfony2 - Notice: Undefined offset: 0 due to a custom Query

3 Answers3