Search code examples
symfonydoctrinedql

Doctrine query builder - Too few parameters


I made a Doctrine query builder query and I have this error :

Too few parameters : The query defines 3 parameters but you only bound 2.

I have looked at the query and tried some refactoring but I can't find where the code is wrong.

The query :

$query = $this->_em->createQueryBuilder();
$query->select('m')
      ->from(Matiere::class, 'm')
      ->join('m.ues', 'ue')
      ->andWhere($query->expr()->eq('ue.semester', ':semestre'))
      ->setParameter('semestre', $semestre);

if (count($UEs) === 1) {
    $query->andWhere($query->expr()->neq('ue.id', ':ueSpe'))
          ->setParameter('ueSpe', $UEs);
}
else {
    $ueM = $UEs[0];
    $ueP = $UEs[1];
    $query->andWhere($query->expr()->neq('ue.id', ':ueM'))
          ->andWhere($query->expr()->neq('ue.id', ':ueP'))
          ->setParameters(['ueM' => $ueM, 'ueP' => $ueP]);
}
return $query->getQuery()->getResult();

Solution

  • $query = $this->_em->createQueryBuilder();
    $query->select('m')
          ->from(Matiere::class, 'm')
          ->join('m.ues', 'ue')
          ->andWhere($query->expr()->eq('ue.semester', ':semestre'))
          ->setParameter('semestre', $semestre);
    
    if (count($UEs) === 1) {
        $query->andWhere($query->expr()->neq('ue.id', ':ueSpe'))
              ->setParameter('ueSpe', $UEs);
    }
    else {
        $parameters[] = $UEs[0];
        $parameters[] = $UEs[1];
        $query->andWhere($qb->expr()->notIn('ue.id', ':parameters'))
              ->setParameter('parameters' => $parameters);
    }
    return $query->getQuery()->getResult();