I have a problem with my query builder. I am using symfony. What i want to acomplish: I have a given query builder, and i want to count all rows based on this query. So i worked on following solution:
$aliases = $queryBuilder->getRootAliases(); $alias = array_values($aliases); $cloneQueryBuilder = clone $queryBuilder; $from = $cloneQueryBuilder->getDQLPart('from'); $cloneQueryBuilder->resetDQLParts(); $newQueryBuilder = $cloneQueryBuilder ->select('count(' . $alias . '.id)') ->add('from', $from); $this->total = $newQueryBuilder->getQuery()->getSingleScalarResult();
However im getting an exception :
Too many parameters: the query defines 0 parameters and you bound 1 Does anyone knows how to solve it ?
setParameters should overwrite all existing parameters.
Answered By – Joshua
Answer Checked By – Timothy Miller (BugsFixing Admin)